Inventory Value Report - By Subinventory (XML) ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS" (Doc ID 2136718.1)

Last updated on MAY 31, 2016

Applies to:

Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.
Inventory Value Report - By Subinventory (XML)

Symptoms

On : 12.1.3 version, Reports Issues

When attempting to Inventory Value report - by Subinventory, the following error occurs.

ERROR
-----------------------
[120115_095027154][][EXCEPTION] java.sql.SQLException: ORA-20100: kff_select(IC_ITEM_PSEG, INV, MSTK, N, MSI, ALL, Y, PADDED_VALUE) raised exception.
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 180
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 242
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 2389
ORA-20100: cross_validate_arguments(MULTIPLE_ID_FLEX_NUM, N, ID_FLEX_NUM) raised exception.
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 180
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 242
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 616
ORA-20232: MULTIPLE_ID_FLEX_NUM and ID_FLEX_NUM arguments are not passed properly. Valid combinations are : (MULTIPLE_ID_FLEX_NUM = Y) OR (MULTIPLE_ID_FLEX_NUM = N AND ID_FLEX_NUM = NOT NULL).
ORA-06512: at line 2

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Inventory Value report - by Subinventory
2. check the log file

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