Inventory Value Report - By Subinventory - Xml java.sql.SQLException: ORA-20100 (Doc ID 1167623.1)

Last updated on JUNE 18, 2021

Applies to:

Symptoms

Comments
--------
=== ODM Issue Clarification ===

On : 12.1.1 version, Reports Issues

When attempting to run CSTRINVR_XML module: Inventory Value Report - by Subinventory (XML)
the following error occurs.

ERROR
-----------------------
Calling XDO Data Engine...
[052610_124219572][][EXCEPTION] java.sql.SQLException: ORA-20100: kff_select(SI_ITEM_SEGMENT, INV, MSTK, N, MSI, ALL, Y, 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


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Inventory
2 Reports >
3.All >
4. Run Inventory Value Report

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the report in a reasonable time frame.

Cause

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