Charge Wise Total Report Producing Incorrect Data
I am investigating a custom Oracle Fusion SCM query that calculates landed cost charges by charge name.
The query returns correct charge totals for most receipts, but for some specific receipts/POs the charge amounts are incorrect (higher than expected). The issue is not consistent across all transactions.
The calculation is:
ROUND( SUM( NVL(CRT.TRANSACTION_QUANTITY,0) * NVL(CLCC.EST_UNIT_AMT_IN_CHARGE_BU_CURR,0) ),3) AS CHARGE_TOTAL
The query joins:
RCV_TRANSACTIONS RTCMR_RCV_TRANSACTIONS CRTCML_LANDED_COST_CHARGES CLCCCML_CHARGES_TL CCB
using:
RT.TRANSACTION_ID = CRT.EXTERNAL_SYSTEM_REF_IDCRT.CMR_RCV_TRANSACTION_ID = CLCC.CMR_RCV_TRANSACTION_IDCLCC.CHARGE_ID = CCB.CHARGE_ID
Tagged:
0