CSTRINVR_XML Inventory Value Report - by Subinventory (XML) Ends With Warning (Doc ID 1554830.1)

Last updated on JANUARY 11, 2017

Applies to:

Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

12.1.3

CSTRINVR_XML module: Inventory Value Report - by Subinventory (XML) gets the following error:


[082812_115513007][][EXCEPTION] java.sql.SQLException: ORA-20100: kff_select(SI_ITEM_SEGMENT, INV, MSTK, N, MSI, ALL, Y, VALUE) raised exception.
ORA-06512: à "APPS.FND_FLEX_XML_PUBLISHER_APIS", ligne 180
ORA-06512: à "APPS.FND_FLEX_XML_PUBLISHER_APIS", ligne 242
ORA-06512: à "APPS.FND_FLEX_XML_PUBLISHER_APIS", ligne 2389
ORA-20100: cross_validate_arguments(MULTIPLE_ID_FLEX_NUM, N, ID_FLEX_NUM) raised exception.
ORA-06512: à "APPS.FND_FLEX_XML_PUBLISHER_APIS", ligne 180
ORA-06512: à "APPS.FND_FLEX_XML_PUBLISHER_APIS", ligne 242
ORA-06512: à "APPS.FND_FLEX_XML_PUBLISHER_APIS", ligne 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: à ligne 2

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at oracle.apps.xdo.dataengine.DataTemplateParser.executeFlexCall(DataTemplateParser.java:2154)
at oracle.apps.xdo.dataengine.DataTemplateParser.getFlexExpression(DataTemplateParser.java:2088)
at oracle.apps.xdo.dataengine.XMLPGEN.extractFlexExpression(XMLPGEN.java:1301)
at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:264)
at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:215)
at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:254)
at oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(DataProcessor.java:390)
at oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:355)
at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:334)
at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:294)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

[082812_115513010][][EXCEPTION] java.sql.SQLException: ORA-20100: kff_select(SI_ITEM_PSEG, INV, MSTK, N, MSI, ALL, Y, PADDED_VALUE) raised exception.
ORA-06512: à "APPS.FND_FLEX_XML_PUBLISHER_APIS", ligne 180
ORA-06512: à "APPS.FND_FLEX_XML_PUBLISHER_APIS", ligne 242
ORA-06512: à "APPS.FND_FLEX_XML_PUBLISHER_APIS", ligne 2389
ORA-20100: cross_validate_arguments(MULTIPLE_ID_FLEX_NUM, N, ID_FLEX_NUM) raised exception.
ORA-06512: à "APPS.FND_FLEX_XML_PUBLISHER_APIS", ligne 180
ORA-06512: à "APPS.FND_FLEX_XML_PUBLISHER_APIS", ligne 242
ORA-06512: à "APPS.FND_FLEX_XML_PUBLISHER_APIS", ligne 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: à ligne 2

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at oracle.apps.xdo.dataengine.DataTemplateParser.executeFlexCall(DataTemplateParser.java:2154)
at oracle.apps.xdo.dataengine.DataTemplateParser.getFlexExpression(DataTemplateParser.java:2088)
at oracle.apps.xdo.dataengine.XMLPGEN.extractFlexExpression(XMLPGEN.java:1301)
at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:264)
at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:215)
at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:254)
at oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(DataProcessor.java:390)
at oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:355)
at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:334)
at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:294)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

[082812_115513064][][EXCEPTION] java.sql.SQLException: ORA-20100: kff_select(IC_ITEM_SEGMENT, INV, MSTK, N, MSI, ALL, Y, VALUE) raised exception.
ORA-06512: à "APPS.FND_FLEX_XML_PUBLISHER_APIS", ligne 180
ORA-06512: à "APPS.FND_FLEX_XML_PUBLISHER_APIS", ligne 242
ORA-06512: à "APPS.FND_FLEX_XML_PUBLISHER_APIS", ligne 2389
ORA-20100: cross_validate_arguments(MULTIPLE_ID_FLEX_NUM, N, ID_FLEX_NUM) raised exception.
ORA-06512: à "APPS.FND_FLEX_XML_PUBLISHER_APIS", ligne 180
ORA-06512: à "APPS.FND_FLEX_XML_PUBLISHER_APIS", ligne 242
ORA-06512: à "APPS.FND_FLEX_XML_PUBLISHER_APIS", ligne 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: à ligne 2

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at oracle.apps.xdo.dataengine.DataTemplateParser.executeFlexCall(DataTemplateParser.java:2154)
at oracle.apps.xdo.dataengine.DataTemplateParser.getFlexExpression(DataTemplateParser.java:2088)
at oracle.apps.xdo.dataengine.XMLPGEN.extractFlexExpression(XMLPGEN.java:1301)
at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:264)
at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:215)
at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:254)
at oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(DataProcessor.java:390)
at oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:355)
at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:334)
at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:294)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

[082812_115513066][][EXCEPTION] java.sql.SQLException: ORA-20100: kff_select(IC_ITEM_PSEG, INV, MSTK, N, MSI, ALL, Y, PADDED_VALUE) raised exception.
ORA-06512: à "APPS.FND_FLEX_XML_PUBLISHER_APIS", ligne 180
ORA-06512: à "APPS.FND_FLEX_XML_PUBLISHER_APIS", ligne 242
ORA-06512: à "APPS.FND_FLEX_XML_PUBLISHER_APIS", ligne 2389
ORA-20100: cross_validate_arguments(MULTIPLE_ID_FLEX_NUM, N, ID_FLEX_NUM) raised exception.
ORA-06512: à "APPS.FND_FLEX_XML_PUBLISHER_APIS", ligne 180
ORA-06512: à "APPS.FND_FLEX_XML_PUBLISHER_APIS", ligne 242
ORA-06512: à "APPS.FND_FLEX_XML_PUBLISHER_APIS", ligne 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: à ligne 2

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at oracle.apps.xdo.dataengine.DataTemplateParser.executeFlexCall(DataTemplateParser.java:2154)
at oracle.apps.xdo.dataengine.DataTemplateParser.getFlexExpression(DataTemplateParser.java:2088)
at oracle.apps.xdo.dataengine.XMLPGEN.extractFlexExpression(XMLPGEN.java:1301)
at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:264)
at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:215)
at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:254)
at oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(DataProcessor.java:390)
at oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:355)
at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:334)
at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:294)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

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