gl_je_lines import references for Treasury Confirmation journals

Posted on 22-May-09. Filed under: Uncategorized | Tags: , |

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.

Advertisements

Make a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

3 Responses to “gl_je_lines import references for Treasury Confirmation journals”

RSS Feed for Oracle Federal Applications Comments RSS Feed

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?

[…] 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 […]

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’;


Where's The Comment Form?

Liked it here?
Why not try sites on the blogroll...

%d bloggers like this: