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)

Oracle Community | cheesewizz | 4 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    eBS Behaviour became slow

    Oracle Community | 4 years ago | cheesewizz
    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)
  2. 0

    [052111_121233777][EXCEPTION] SQLException encounter while executing data

    Oracle Community | 6 years ago | oracle_developer
    java.sql.SQLException: ORA-06550: line 2, column 36: PLS-00302: component 'P_LOCAL_LEDGER' must be declared ORA-06550: line 2, column 1: PL/SQL: Statement ignored ORA-06550: line 3, column 36: PLS-00302: component 'P_PERIODE' must be declared ORA-06550: line 3, column 1: PL/SQL: Statement ignored
  3. 0

    xml ERROR

    Oracle Community | 5 years ago | 927548
    java.sql.SQLException: ORA-06550: line 2, column 22: PLS-00302: component 'P_MODULE' must be declared ORA-06550: line 2, column 1: PL/SQL: Statement ignored ORA-06550: line 3, column 22: PLS-00302: component 'P_STATUS' must be declared ORA-06550: line 3, column 1: PL/SQL: Statement ignored ORA-06550: line 4, column 22: PLS-00302: component 'P_ITEM_ID' must be declared ORA-06550: line 4, column 1: PL/SQL: Statement ignored
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ava.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character

    Oracle Community | 6 years ago | EBSDBA
    java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APPS.WSH_WSHRDXCP_XMLP_PKG", line 239 ORA-06512: at line 4at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
  6. 0

    Significance of FND_JDBC_PLSQL_RESET

    Oracle Community | 6 years ago | user10088255
    java.sql.SQLException: ORA-20101: ORA-06512: at "APPS.XXAP_APXINAGE_XMLP_PKG", line 302 ORA-06512: at line 4at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)

  1. balintn 11 times, last 4 months ago
  2. Cafecanudo 2 times, last 5 months ago
18 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. 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()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.execute
    1. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
    2. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
    3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    5. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
    6. oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)
    7. oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)
    8. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1225)
    9. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
    10. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3488)
    11. oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3857)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
    12 frames
  3. oracle.apps.xdo
    JCP4XDODataEngine.runProgram
    1. oracle.apps.xdo.dataengine.DataTemplateParser.executeFlexCall(DataTemplateParser.java:2149)
    2. oracle.apps.xdo.dataengine.DataTemplateParser.getFlexExpression(DataTemplateParser.java:2083)
    3. oracle.apps.xdo.dataengine.XMLPGEN.extractFlexExpression(XMLPGEN.java:1301)
    4. oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:264)
    5. oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:215)
    6. oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:254)
    7. oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(DataProcessor.java:390)
    8. oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:355)
    9. oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:334)
    10. oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:294)
    10 frames
  4. oracle.apps.fnd
    Run.main
    1. oracle.apps.fnd.cp.request.Run.main(Run.java:157)
    1 frame