java.sql.SQLException

ORA-20100: kff_order_by(P_MDSP_ORDER_BY, INV, MDSP, 101, N, mdsp, ALL, Y) 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 2772 ORA-20100: get_kff_str(401, MDSP, 101) 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 958 ORA-20303: KFF Structure is not frozen. ORA-06512: at line 2at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)

Samebug tips1

This is a bug in version 4.1.9 and it's fixed from version 4.3.0beta and beyond.

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web14994

  • via Oracle Community by cheesewizz, 11 months ago
    ORA-20100: kff_order_by(P_MDSP_ORDER_BY, INV, MDSP, 101, N, mdsp, ALL, Y) 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
  • via Oracle Community by user1175385, 1 year ago
    ORA-20100: kff_order_by(P_ORDER_FLEX, INV, MSTK, 50228, N, MSI, ALL, Y) 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
  • via Oracle Community by Mohammed Abdul Muqeet, 11 months ago
    ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.HR_PERF_MGMT_PLAN_INTERNAL", line 4828 ORA-06512: at "APPS.HR_PERF_MGMT_PLAN_INTERNAL", line 3617 ORA-06512: at line 1at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
  • Stack trace

    • java.sql.SQLException: ORA-20100: kff_order_by(P_MDSP_ORDER_BY, INV, MDSP, 101, N, mdsp, ALL, Y) 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 2772 ORA-20100: get_kff_str(401, MDSP, 101) 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 958 ORA-20303: KFF Structure is not frozen. ORA-06512: at line 2at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191) at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1225) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3488) at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3857) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374) at oracle.apps.xdo.dataengine.DataTemplateParser.executeFlexCall(DataTemplateParser.java:2149) at oracle.apps.xdo.dataengine.DataTemplateParser.getFlexExpression(DataTemplateParser.java:2083) 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)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago
    11 times, 9 months ago
    2 times, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    15 more bugmates