My Oracle Support Banner

Revenue Account Is Not Fetching In The SLA (Doc ID 2434360.1)

Last updated on AUGUST 13, 2018

Applies to:

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

Symptoms

Revenue Account is not Fetching in the SLA

Problem Description
----------------------------
Revenue Account derivation is not correct with Multi Operating setup.


The SLA view which used to pull all the data for Accrual posting is : OZF_XLA_ACC_HEADER_V
The revenue account is coming as below from the above view.

DECODE(OXA.event_type_code,'INVOICE_DISCOUNT', (
  CASE
  WHEN (SELECT PARAMETER_VALUE
  FROM OE_SYS_PARAMETERS_ALL
  WHERE PARAMETER_CODE = 'OE_DISCOUNT_DETAILS_ON_INVOICE'
  AND ORG_ID = SYSPARAM.ORG_ID) = 'Y'
  THEN
  (SELECT CGL.CODE_COMBINATION_ID
  FROM OE_PRICE_ADJUSTMENTS PA ,
  OE_ORDER_LINES_ALL OL ,
  RA_CUSTOMER_TRX_LINES_ALL CTL ,
  RA_CUST_TRX_LINE_GL_DIST_ALL CGL
  WHERE UTIL.PRICE_ADJUSTMENT_ID = PA.PRICE_ADJUSTMENT_ID
  AND OL.LINE_ID = PA.LINE_ID
  AND CTL.INTERFACE_LINE_ATTRIBUTE6 = TO_CHAR(OL.LINE_ID)
  AND CTL.INTERFACE_LINE_ATTRIBUTE11 = TO_CHAR(PA.PRICE_ADJUSTMENT_ID)
  AND CGL.CUSTOMER_TRX_LINE_ID = CTL.CUSTOMER_TRX_LINE_ID
  AND CGL.ACCOUNT_CLASS = 'REV'
  AND CTL.INTERFACE_LINE_CONTEXT = FND_PROFILE.VALUE('ONT_SOURCE_CODE')
  AND ROWNUM = 1
  )
  ELSE
  (SELECT CGL.CODE_COMBINATION_ID
  FROM OE_PRICE_ADJUSTMENTS PA ,
  OE_ORDER_LINES_ALL OL ,
  RA_CUSTOMER_TRX_LINES_ALL CTL ,
  RA_CUST_TRX_LINE_GL_DIST_ALL CGL
  WHERE UTIL.PRICE_ADJUSTMENT_ID = PA.PRICE_ADJUSTMENT_ID
  AND OL.LINE_ID = PA.LINE_ID
  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 UTIL.ORDER_LINE_ID = CTL.INTERFACE_LINE_ATTRIBUTE6
  AND CTL.INTERFACE_LINE_CONTEXT = FND_PROFILE.VALUE('ONT_SOURCE_CODE')
  AND ROWNUM = 1
  )
  END ) , NULL ) REVENUE_ACCT_CCID


Since the profile OE_DISCOUNT_DETAILS_ON_INVOICE is not Y, so the else part of the query is firing.


Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.