Oracle AI and Analytics

Val S

Nathan CCC

Hi Val, This IS an analytics and reports question. You have come to the right place! One example of how to join payroll transactions to the general ledger (GL) using the transaction ledger accounting (XLA) is to look at the standard out of the box pre-defined analytics and reports.

Subject Area Subledger Accounting - Journals Real Time

https://docs.oracle.com/en/cloud/saas/financials/26d/faofb/Subledger-Accounting-Journals-Real-Time-SA-212.html

Go to page Manage Sessions then View Log to understand the physical SQL application database tables and views for your logical query.

Also report

/Shared Folders/Financials/General Ledger/Journals/Journal and Transaction Details Report

As you can see from the query in the data set in the data model at distribution level

If the general ledger journal is from a subledger transaction ledger accounting journal with application id 801 join on 3 columns

xla_distribution_links. source_distribution_id_num_1/2

to

PAY_XLA_EVENTS. PAYROLL_REL_ACTION_ID

PAY_XLA_EVENTS. PAYROLL_ID

and source_distribution_id_num_3

to either

1) PAY_COSTS. COST_ID "Payroll Costs"

and

2) PAY_PAYMENT_COSTS. PAYMENT_COST_ID "Payroll Payment Costs"