Oracle Communities

Oracle Analytics and AI

Child Item

Scheduled Reports - General Ledger Reporting

Is there a report in Scheduled Reports that will pull General Ledger to Subledger data with part numbers? I need to be able to tie transactions from the GL to individual parts for a variety of purposes, but I am unable to do so due to lack of information.

Find more posts tagged with

Fusion AI Data Platform

Accepted answers

Ashish-Oracle

@J Shafer This forum is dedicated to FDI (Fusion Data Intelligence) product. Can you please confirm which Product are you using here? If it is Fusion or OTBI then you may have to reach out to the respective communities for more accurate responses.

https://community.oracle.com/customerconnect/

https://community.oracle.com/products/oracleanalytics/categories/otbi

From FDI point of view you can refer the list of OOB reports provided in the below url

https://docs.oracle.com/en/cloud/saas/analytics/24r4/faiae/prebuilt.html#GUID-7E232638-CFB9-4BC3-8D1B-6B627BDA4560

All comments

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/24347/scheduled-reports-general-ledger-reporting

Hi,

Please take a look into the following doc which will provide the list of OOTB Reports.

https://docs.oracle.com/en/cloud/saas/financials/25a/faugf/general-ledger-and-subledger-accounting-reports-for-emea.html#General-Ledger-Reports

Hope this help.

Cheers,

J Shafer

Thank you for providing that list of reports, but I am afraid none of them are appropriate for the type of data I am looking to include.

I need a report that ties part number/item number transactions to the General Ledger for balancing those accounts. Our inventory accounts do not tie to the inventory valuation in Oracle Fusion and we cannot fix them if we do not know what inventory is sitting in which account. Due to the restrictions that Oracle has placed on exporting data from the front-end reports (Review Transactions) we no longer have access to the information we need to build reporting in a proper manner.

Ashish-Oracle

https://community.oracle.com/customerconnect/

https://community.oracle.com/products/oracleanalytics/categories/otbi

From FDI point of view you can refer the list of OOB reports provided in the below url

https://docs.oracle.com/en/cloud/saas/analytics/24r4/faiae/prebuilt.html#GUID-7E232638-CFB9-4BC3-8D1B-6B627BDA4560

J Shafer

We have Oracle Fusion. I was unaware this was a different product. It is very confusing trying to navigate within the website; so many products have similar names.

Ashish-Oracle

@J Shafer No probs. I have provided you the community urls in my last update.