Need solution to create an OTBI report to find AHCS Subledger Entry's Line level information

Question

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.

Nathan CCC · Answer

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

https://docs.oracle.com/en/cloud/saas/financials/25a/faofb/Subledger-Accounting--Journals-Real-Time-SA-41.html

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 25A

GL https://docs.oracle.com/en/cloud/saas/financials/25a/ocuar/oracle-transactional-business-intelligence-reports-for-gl.html#Overview

XLA https://docs.oracle.com/en/cloud/saas/financials/25a/ocuar/oracle-fusion-subledger-accounting-predefined-reports.html

For example

Financials/General Ledger/Account Analysis/

General Ledger Journal and Subledger Transaction Mapping Report

https://docs.oracle.com/en/cloud/saas/financials/25a/ocuar/general-ledger-journal-and-subledger-transaction-mapping-report.html#s20049390