RMA Receipts For Inventory Error With ORA-01405: Fetched Column Value Is NULL (Doc ID 1392363.1)

Last updated on NOVEMBER 23, 2015

Applies to:

Oracle Inventory Management - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Symptoms

==== ODM Issue Clarification ====

On : 12.1.3 version, Inventory Transactions

When attempting to do a standard receipt and RMA receipt,
the following error occurs.

 

ERROR

---------------------------
ORA-01403: no data found:20
[22-DEC-11 14:35:21] po.src.rvtp.rvtii.RVTII.C.3003: RVTII:076 result 0

[22-DEC-11 14:35:21] po.src.rvtp.rvtii.RVTII.C.3003: ORA-01405: fetched column value is NULL

[22-DEC-11 14:35:21] po.src.rvtp.rvtii.RVTII.C.3013: RVTII:076 OE COGS API returned Error Cannot derive Chart of Accounts Id for 392 from Organization definitions

[22-DEC-11 14:35:21] po.src.rvtp.rvtii.RVTII.C.3013: ORA-01405: fetched column value is NULL

[22-DEC-11 14:35:21] po.src.rvtp.rvtii.RVTII.C.3031: RVTII:076A concat_segs:

[22-DEC-11 14:35:21] po.src.rvtp.rvtii.RVTII.C.3031: ORA-01405: fetched column value is NULL

 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Go into  INV responsibility
2. Navigate to Transactions>Receiving Transactions
3. Enter receipt quantity and click on SAVE button
4.check debug logfile and find some error message

Cause

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