gl_je_lines import references for Treasury Confirmation journals
The other day I was dealing with needing to get some additional subsidiary detail for some Payables – Treasury Confirmation journal lines and since the relationships aren’t well documented, I’ll post them here.
For journal source = ‘Payables, journal category = ‘Treasury Confirmation’, the following are what the gl.gl_je_lines reference columns include:
reference_1 = fv.fv_treasury_confirmations.treasury_confirmation_id
reference_3 = ap.ap_checks_all.check_id
reference_4 = ap.invoices_all.invoice_id
reference_5 = hr.hr_all_organization_units.organization_id
I, along with others, have run into some situations where it would have been nice to have a link to invoice_distribution_id to support detail level gl to subsidiary module reconciliation efforts, but if I remember correctly, the confirmation journal entries aren’t necessarily at that lowest level of detail.
Oracle Federal Applications 
Thanks for the tip! When I view the Treasury Confirmation lines in the database for our instance, all of the references are blank. Is there a configuration I’m missing to set references to import?
Kristen
12-Aug-10
[…] info last year on the gl_je_lines traceability for Treasury Confirmations to source transactions here. Current functionality is that the Treasury Confirmation entries are posted at the AP Invoice […]
Would your FedAdmin Install like better traceability from gl_je_lines to source PO for FV Treasury Confirmation Journal Entries? « Oracle Federal Applications
12-Aug-10
Kristen, I’ve never known anything about a config necessary to get them to show up, unless there’s somethign new. If you are referring to just looking at the je_lines from the journal forms, then those Reference fields are typically hidden from the users out of the box (but could be displayed in the je_line DFFs if desired).
You should be able to see them when querying such as the following from the DB (or similar query using Disco or some other query tool).
select l.reference_1 treasury_confirmation_id, l.reference_3 ap_check_id, l.reference_4 ap_invoice_id, l.reference_5 org_id
from gl.gl_je_lines l, gl.gl_je_headers h
where l.je_header_id = h.je_header_id and
h.je_source = ‘Payables’ and
h.je_category = ‘Treasury Confirmation’;
Larry.Baugh
12-Aug-10