Why OTBI Isn’t Showing Your CoA (And How to Fix It Fast)

Written by

leebriggs

in

, ,

Introduction

One of the most common frustrations in Oracle Fusion OTBI reporting occurs when Chart of Accounts segments fail to appear correctly within subject areas. Organizations often expect all configured segments to appear automatically, only to discover that OTBI displays only limited dimensions or incomplete hierarchy information.

Fortunately, this issue is usually caused by missing configuration steps related to hierarchy flattening, BI-enabled segments, flexfield deployment, or BI metadata synchronization.

This guide walks through the key Oracle Fusion OTBI configuration steps required to correctly expose Chart of Accounts segments and hierarchies within OTBI subject areas.

Watch the Webinar

Understanding OTBI Subject Areas

Out of the box, Oracle Fusion OTBI subject areas typically display three mandatory Chart of Accounts segments:

  • Balancing Segment
  • Cost Center Segment
  • Natural Account Segment

These dimensions are required within Oracle General Ledger.

Additional Chart of Accounts segments may appear automatically if organizations used Rapid Implementation during initial setup. However, manually configured environments often require additional OTBI configuration steps before custom segments become visible.

Step 1: Flatten Your Account Hierarchies

One of the most important configuration steps is hierarchy flattening.

For each Chart of Accounts segment:

  1. Ensure one hierarchy version is active
  2. Navigate to Actions
  3. Select Flatten
  4. Select Column Flattening

This process denormalizes hierarchy relationships so OTBI can query parent-child relationships more efficiently.

Hierarchy flattening should be rerun whenever hierarchy maintenance occurs.

Without flattening:

  • hierarchy rollups may fail
  • reporting structures may appear incomplete
  • OTBI performance may degrade

Step 2: Publish Account Hierarchies

After flattening hierarchies, organizations must publish hierarchy data.

Publishing makes hierarchy metadata available to Oracle reporting tools including:

  • OTBI
  • SmartView
  • Financial Reporting Studio

Failing to publish hierarchies often prevents reporting dimensions from appearing correctly.

Step 3: Create Segment Labels

For non-qualified Chart of Accounts segments, organizations must create segment labels.

This configuration step maps Oracle flexfield segments into BI reporting structures.

A critical requirement is the BI Object Name format.

For General Ledger segments, BI Object Names must follow this exact naming convention:

  • Dim – GL Segment1
  • Dim – GL Segment2 through Dim – GL Segment10

This naming syntax is extremely sensitive.

One common issue occurs when Microsoft Word or PowerPoint automatically converts:

  • en dash (-)

into:

  • em dash (—)

Oracle requires the standard en dash format.

Incorrect character formatting can prevent OTBI configurations from functioning correctly.

Budgetary Control Differences

Budgetary Control configurations differ from General Ledger configurations.

Unlike General Ledger:

  • Budgetary Control has no mandatory segments
  • only 10 BI dimensions are available
  • naming conventions use XCC instead of GL

Budgetary Control BI Object Names must use:

  • Dim – XCC Segment1
  • through
  • Dim – XCC Segment10

Organizations should carefully plan Budgetary Control segment usage because only 10 dimensions are available.

Step 4: Assign Labels to CoA Segments

Once labels are created:

  1. Navigate to Manage Structures
  2. Edit the Chart of Accounts structure
  3. Assign newly created labels to the appropriate segments

This connects Oracle flexfield structures to BI reporting metadata.

Step 5: Enable BI and Attach Hierarchies

Next, organizations must verify that each segment is:

  • BI Enabled
  • associated with a hierarchy

Navigate to:

Manage Structure Instances

Then:

  1. Edit the structure instance
  2. Verify BI Enabled is checked
  3. Attach the appropriate hierarchy

Without these settings, segments may fail to appear inside OTBI subject areas.

Step 6: Deploy the Flexfield

After configuration changes are completed:

  1. Navigate to Manage Chart of Accounts Structures
  2. Select Deploy Flexfield

Deploying the flexfield pushes configuration changes into Oracle Fusion metadata structures.

Organizations frequently miss this step, causing reporting configurations to remain unavailable.

Step 7: Run Required Scheduled Processes

Two critical scheduled processes must be executed after configuration changes.

Create Rules XML File for BI Extender Automation

Navigate to:

Scheduled Processes → Schedule New Process

Run:

Create Rules XML File for BI Extender Automation

Parameter:

  • Essbase Application = your Chart of Accounts

Wait for this process to complete fully before proceeding.

Import Oracle Fusion Data Extensions for Transactional Business Intelligence

Next run:

Import Oracle Fusion Data Extensions for Transactional Business Intelligence

Parameter:

  • ERP

This process may take significant time to complete depending on environment size.

Even empty environments may require approximately one hour.

Subject Areas Affected

Once configurations are completed successfully, additional segments become available across multiple Oracle Fusion subject areas.

Affected Financials subject areas include:

  • General Ledger – Journals Real Time
  • General Ledger – Transactional Balances Real Time
  • Payables Invoices – Transactions Real Time
  • Receivables – Transactions Real Time
  • Receivables – Receipts Details Real Time

Additional Procurement and Projects subject areas may also expose new dimensions.

Fixed Assets Configuration Differences

Fixed Assets configurations behave differently from General Ledger configurations.

Key Asset Flexfields include:

  • CAT# for Asset Category
  • LOC# for Asset Location
  • KEY# for Asset Key

Unlike General Ledger:

  • hierarchy flattening is not required
  • hierarchy publishing is not required

Organizations should understand these differences before attempting to troubleshoot Fixed Assets OTBI issues.

Common OTBI Configuration Mistakes

Common OTBI configuration issues include:

  • hierarchy flattening not completed
  • hierarchy publishing skipped
  • BI Enabled not checked
  • incorrect BI Object Name formatting
  • flexfields not deployed
  • scheduled processes not executed
  • incorrect segment label assignment

Most OTBI reporting visibility issues trace back to one or more of these configuration gaps.

Final Thoughts

Oracle Fusion OTBI reporting relies heavily on proper Chart of Accounts configuration, hierarchy management, flexfield deployment, and BI synchronization.

When configurations are performed correctly, organizations gain significantly improved reporting flexibility across:

  • General Ledger
  • Payables
  • Receivables
  • Procurement
  • Projects
  • Budgetary Control

Understanding the relationship between Oracle flexfields, hierarchies, BI metadata, and scheduled processes is critical for building scalable Oracle Fusion reporting environments.

Related Oracle Topic Hubs

About Afternoons With ACEs

Afternoons With ACEs provides practical Oracle Fusion implementation expertise from Oracle ACE Professionals Lee Briggs and Thomas Simkiss.

Sessions focus on:

  • enterprise ERP best practices
  • Oracle Fusion implementation strategy
  • reporting and analytics
  • SmartView
  • OTBI
  • testing and governance

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

More posts