Thanks Michael for sharing this. I have a similar scenario where a set of projects were aligned to a wrong Rate Matrix. I need to change the Rate matrix and do the WIP adjustment. Since the transactions are large in volume, manual adjustment from UI is not feasible so I am trying the script shared by you. I have updated the script to support the oracle database.
But I am getting the below error -
Ora-20240:Ora-20240:Ora-20240:Ora-20240: A Rate Matrix could not be found, or Rate Matrix found was unable to match the transaction data.
Ora:06512 - at "schema_name.REV_PRC_ADJWIPMODXFERXACTION", at line 456...
I am calling the procedure REV_PRC_ADJWIPMODXFERXACTION
REV_PRC_ADJWIPMODXFERXACTION(
V_TRANSNO,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
'M',
NULL,
1,
dWIPTransDate,
cWIPClntCode,
cWIPProjId,
cWIPCharge_Code,
cWIPResource_Code,
cWIPInputType,
cWIPTransactionClass,
iTransferStatus,
iAdjustXactionNo,
iAdjustNumber,
cOutErrorMessage,
'en',
NULL,
NULL,
NULL,
0,
NULL,
NULL,
NULL,
NULL
)
Any thought on this ?