Issue with Supplier-wise GL Balance Data in Custom Subject Area

Question

Hi Team,

I have a requirement where I need to display Opening, Debit, Credit, and Closing balances from the GL Balance Sheet along with Supplier-related information from the Supplier subject area.

When I try to bring the Supplier dimension directly into the GL Balance Sheet subject area, I receive a query error.

As an alternative, I created a custom subject area by combining the GL Balance Sheet and Supplier-related subject areas. In this setup, I can now view both Supplier Name and GL balances (Opening, Debit, Credit, and Closing).

However, the issue is that the same balance amounts are appearing for all suppliers, instead of showing the correct supplier-specific figures.

RVohra · Answer

It is tricky but see if you can make it work by using Payables subject areas like:

* Payables Invoices – Transactions Real Time
* Payables Payments – Transactions Real Time
* Procurement – Spend

From these subject areas, you can get:

* Supplier Name
* Invoice Amounts (debited from AP)
* Payments
* GL distribution details (via invoice distributions)

Otherwise use BI Publisher with SQL-Based Data Model

If you must report actual GL balances per supplier, and you're doing supplier-specific accounting in GL (e.g., using a specific segment in the COA like “Supplier” or “Party”), then:

* Check if a segment in the GL code combination (e.g., the “third party” or “supplier” segment) tracks supplier info.
* Write a custom SQL in BI Publisher that joins: GL_BALANCES, GL_CODE_COMBINATIONS, AP_SUPPLIERS if supplier segment is present in CCID

This approach is technical but gives full flexibility. you might need to refer Oracle Docs for table names.