R12: Performance Issue with Create Accounting (Doc ID 763500.1)

Last updated on JULY 29, 2013

Applies to:

Oracle Payables - Version 12.0.3 to 12.0.5 [Release 12.0]
Information in this document applies to any platform.
This problem can occur on any platform.

***Checked for relevance on 29th July 2013***

Symptoms

The Create Accounting process does not complete.  The performance could vary depending on the number of users and workers.  At times the workers are stuck on a single SQL.

UPDATE xla_ae_lines_gt temp 
SET (temp.code_combination_id, temp.segment1, temp.segment2, temp.segment3, temp.segment4, temp.segment5, temp.segment6, temp.segment7,  temp.segment8, temp.segment9, temp.segment10, temp.segment11,
........
FROM xla_transaction_accts_gt seg 
WHERE seg.ae_header_id = temp.ae_header_id
.......






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