GLPPOS Experiencing Performance Issue (Doc ID 292610.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Oracle General Ledger - Version 11.5.9 to 11.5.10.2 [Release 11.5.9 to 11.5.10]
Information in this document applies to any platform.
Executable:GLPPOS - Posting

Symptoms

You are trying to run the Posting Process in General Ledger and the process is taking a very long time to complete.

As per the trace file the problem statement is:

SELECT substrb(c.SEGMENT1||'-'||c.SEGMENT2||'-'||c.SEGMENT3||'-'||c.SEGMENT4||'- '||c.SEGMENT5||'-'||c.SEGMENT6||'- ||c.SEGMENT7,1,49), p.entered_dr, p.entered_cr, p.result_code,l.description,c.code_combination_id
FROM gl_code_combinations c,gl_bc_packets p
,gl_lookups l
where p.ussgl_link_to_parent_id = :p2
AND c.code_combination_id = p.code_combination_id
AND p.result_code between 'F00' and 'F30'
AND p.result_code = l.lookup_code
AND l.lookup_type = 'FUNDS_CHECK_RESULT_CODE'
ORDER BY p.code_combination_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