SLA Create Accounting For TMA Is Not Finishing
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.
On : 12.1.3 version, Related to all of Trade Management
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:
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
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