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"
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
Our Requisition OTBI analysis is having many values Requisition Number Requisition Title Requisition Status Hiring Manager Full Name Recruiter Full Name am able to see values for all. When am passing Prompt(Hiring Manager Full Name or Recruiter Full Name) am not able to see the data. Am sure we have values/data for passed…
Hi Experts, We are using Oracle BI Publisher Email Bursting to distribute reports via email. Currently, one of our bursting outputs generates a report of approximately 20 MB, and we are trying to understand whether there are any size limitations that could impact email delivery. Scenario: Report Delivery Method: Email…
Team, We have a requirement to select below PVOs HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfileItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfilePVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentTypePVO Do we have any documentation around these?
We have a requirement of enabling OTBI report in Purchase Requisition Redwood page similar to classic UI.How can that be done?
