Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 282 Oracle Analytics and AI News
- 59 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Need solution to create an OTBI report to find AHCS Subledger Entry's Line level information
HI All,
I am working on AHCS/FAH module and need to create an OTBI report to fetch the Line level details for a transaction loaded to Oracle using AHCS template. The data which is visible from Review Subledger Entries—> View transaction—> Line details, should be fetched.The report should have the option to populate the Line file columns and the associated data, with the main information of transaction number and Ledger at the least. Is it possible? Kindly suggest.
Answers
-
Hi,
In your analysis or data model for a report in OTBI write SQL to query this subject area
This will give you the subledger transaction ledger accounting XLA journal header and lines.
This may or may not give you the transaction data you need from the child subledger transaction tables. For example, it does have transaction number and some other key attributes depending on the transaction type.
Subledger Accounting - Journals Real Time
Also review the out of the box pre-defined report which may have the transaction details you are looking for
Oracle Fusion Cloud Financials
Using Analytics and Reports for Financials G17698-01 25AFor example
Financials/General Ledger/Account Analysis/
General Ledger Journal and Subledger Transaction Mapping Report
0
