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 OCTOBER 10, 2018

Applies to:

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

Symptoms

On Oracle Business Intelligence Applications Consumer(OBIA) 11.1.1.9.1 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: 11.1.1.9.1
  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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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