My Oracle Support Banner

OBIA 11g: Trial Balance Report Showing Blank for Columns - 'Debit And Credit Amount' for Entered Currency (Doc ID 2292313.1)

Last updated on JUNE 26, 2019

Applies to:

Business Intelligence Applications Consumer - Version and later
Information in this document applies to any platform.


On Oracle Business Intelligence Applications Consumer(OBIA) version,

  • In 'Trial Balance' report, added a new column - 'Currency'.
  • This Currency column refers  to "Financials - GL Balance Sheet"."Currency Tag"."Apps Common Currency Code" presentation column.
  • In GL Balance Sheet dashboard, while selecting 'Currency' prompt as "Entered Currency", then the "Trial Balance" report showing 'Blank' for 'Credit Amount and Debit Amount' columns.
  • But the same columns are returning values for 'Legal Currency'.
  • Verified the data present in Source - 'EBS' for the same columns by selecting a specific Entered currency. 

The following issue observed in the below environment:

  1. OBIA version:
  2. Modules being used: Financials - General Ledger
  3. Source System: EBS R12
  4. Dashboard: '/shared/Financials/_portal/General Ledger' --> Dashboard page: 'Trial Balance'
  5. Report Path: /shared/Financials/Analytic Library/General Ledger/Trial Balance/Trial Balance


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.