R12: Workflow Background Process Performance: RA_CUSTOMER_TRX_LINES_ALL (Doc ID 752533.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

Oracle Order Management - Version 12.0.4 and later
Information in this document applies to any platform.

Symptoms

On 12.0.4:
After upgrading the RUP4, Workflow Background Process has a performance issue.
In previous tkprof files the most expensive sql:
SELECT COUNT(1)
FROM
RA_CUSTOMER_TRX_LINES_ALL RCTL WHERE RCTL.INTERFACE_LINE_CONTEXT = ORDER   ENTRY' AND RCTL.LINE_TYPE = 'LINE' AND RCTL.INTERFACE_LINE_ATTRIBUTE6 = 
TO_CHAR(:B1 )


Changes

Upgraded from 12.0.2 to 12.0.4.

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