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

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 web11310

  • via Oracle Community by oracle_developer, 1 year ago
    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
  • via Oracle Community by praneeth, 1 year ago
    ORA-06550: line 2, column 12: PLS-00302: component 'P_LOB' must be declared ORA-06550: line 2, column 1: PL/SQL: Statement ignored ORA-06550: line 3, column 12: PLS-00302: component 'P_DIV_FROM' must be declared ORA-06550: line 3, column 1: PL/SQL
  • via Oracle Community by 927548, 11 months ago
    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
  • Stack trace

    • 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 at 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.XMLPGEN.executeTriggers(XMLPGEN.java:650) at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:262) 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
    131 more bugmates