SLA Create Accounting For TMA Is Not Finishing (Doc ID 2091192.1)

Last updated on MARCH 02, 2017

Applies to:

Oracle Trade Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Related to all of Trade Management

ACTUAL BEHAVIOR
---------------
SLA Create Accounting for Trade Management is not completing.

We submitted crate accounting process that ran for more then 20 hours and did not finished. User cancelled that run, and resubmited th same create acocunting process, using the same parameters, but still is working after 2 hours running.
Pior submissions ended okay.
According to sysadim, the status of the process is "waiting", and executing the following sql sentence:
SELECT CGL.CODE_COMBINATION_ID
FROM OZF_FUNDS_UTILIZED_ALL_B FU , OE_PRICE_ADJUSTMENTS PA , OE_ORDER_LINES_ALL OL , OE_ORDER_HEADERS_ALL OH , RA_CUSTOMER_TRX_LINES_ALL CTL , RA_CUST_TRX_LINE_GL_DIST_ALL CGL
WHERE FU.PRICE_ADJUSTMENT_ID = PA.PRICE_ADJUSTMENT_ID AND OL.LINE_ID = PA.LINE_ID AND OL.HEADER_ID = OH.HEADER_IDAND CTL.INTERFACE_LINE_ATTRIBUTE1 = TO_CHAR(OH.ORDER_NUMBER) AND CTL.INTERFACE_LINE_ATTRIBUTE6 = TO_CHAR(OL.LINE_ID) AND CGL.CUSTOMER_TRX_LINE_ID = CTL.CUSTOMER_TRX_LINE_ID AND CGL.ACCOUNT_CLASS = 'REV' AND FU.UTILIZATION_ID = :B1 AND
FU.ORDER_LINE_ID = CTL.INTERFACE_LINE_ATTRIBUTE6

Changes

 

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