Intransit Value Report (XML) Completing Multiple Errors: java.sql.SQLException: ORA-20100: kff_select(ITEM_SEGMENT, INV, MSTK, N, CUR_MSIVL, ALL, Y, VALUE) raised exception (Doc ID 1481987.1)

Last updated on NOVEMBER 20, 2016

Applies to:

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

Symptoms

When you execute CSTRITVR_XML module: Intransit Value Report (XML) the following errors occurs : 

[070612_040653281][][EXCEPTION] java.sql.SQLException: ORA-20100: kff_select(ITEM_SEGMENT, INV, MSTK, N, CUR_MSIVL, 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 2

Intransit_Value_Report__XML__130712.xml = Parsing Error: no element found

Caused by: oracle.xdo.parser.v2.XPathException: Error in expression: './/:CF_ZERO_AMT_INV = 'N''.
Caused by: org.xml.sax.SAXParseException: <Line 6, Column 1>: XML-20210: (Fatal Error) Unexpected EOF.
Caused by: org.xml.sax.SAXParseException: <Line 8, Column 1>: XML-20210: (Fatal Error) Unexpected EOF.

XML Parsing Error: no element found

<?xml version="1.0" encoding="windows-1252"?>

<?xml-stylesheet href="Intransit_Value_Report__XML__130712_files/intl.css" type="text/css"?>
<parsererror xmlns="http://www.mozilla.org/newlayout/xml/parsererror.xml">XML Parsing Error: no element found
Location: http://usnedsapp08.integralife.com:8004/OA_CGI/FNDWRR.exe?temp_id=2169046324
Line Number 8, Column 1:<sourcetext>^</sourcetext></parsererror>

 

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