Unable to Perform RMA Deliver Transaction - Cannot Derive Chart of Accounts Id for XXX From Organization Definitions (Doc ID 2955729.1)

Last updated on JUNE 20, 2023

Applies to:

Symptoms

When attempting to do Receiving Transactions for RMA order
the following error occurs.

ERROR
-----------------------
Entering OE_Flex_Cogs_Pub.Start_process :
ENTERING OE_SYS_PARAMETERS.VALUE
Going to get the value for ONT_COGS_SOURCE_LINE_FOR_RMA
ENTERING OE_SYS_PARAMETERS_PVT.VALUE
Parameter value fetched from table.
 PARAMETER VALUE:
LEAVING OE_MSG_PUB.ADD
Exiting OE_Flex_Cogs_Pub.Start_process :
ORA-01403: no data found:20
[08-JUN-23 06:09:19] po.src.rvtp.rvtii.RVTII.C.3027: RVTII:076 result 0
[08-JUN-23 06:09:19] po.src.rvtp.rvtii.RVTII.C.3027: ORA-01405: fetched column value is NULL
[08-JUN-23 06:09:19] po.src.rvtp.rvtii.RVTII.C.3037: RVTII:076 OE COGS API returned Error Cannot derive Chart of Accounts Id for XXX from Organization definitions

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Inventory responsibility
2. Attempt to complete deliver transactions

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.