Create Accounting Performance Issue - Sub Ledger Entries are Posted at Cost Component Level rather than at Total Item Cost Level

(Doc ID 2026413.1)

Last updated on JULY 02, 2015

Applies to:

Oracle Process Manufacturing Financials - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Subledger Accounting

ACTUAL BEHAVIOR
---------------
 
Create Accounting Performance Issue due to large volume of data in the gmf_xla_extract_lines table as Entries are posted at Cost Component Level.

EXPECTED BEHAVIOR
-----------------------
Create Accounting should get completed in reasonable duration of time.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1.Execute the OPM Accounting Pre-processor and post the the data at Cost component level.

2. Execute the Create accounting.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:


Due to this issue, users cannot understand how to reduce the volume of data processed so that create Accounting would get completed more quickly and the volume of data stored would be reduced.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms