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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

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

Solutions on the web

via Oracle Community by 927548, 1 year 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
via Oracle Community by user10869897, 1 year ago
ORA-06550: line 2, column 28: PLS-00302: component 'P_CHECKRUN_NAME' must be declared ORA-06550: line 2, column 1: PL/SQL: Statement ignored ORA-06550: line 3, column 28: PLS-00302: component 'P_START_DATE' must be declared ORA-06550: line 3, column
via Oracle Community by MyOAF, 4 months ago
ORA-06550: line 12, column 25: PLS-00302: component 'P_ORDER_BY_TXT' must be declared ORA-06550: line 12, column 1: PL/SQL: Statement ignored
via Oracle Community by Beauty_and_dBest, 5 months ago
is invalid ORA-200 ORA-06512: at "APPS.APP_EXCEPTION", line 72 ORA-06512: at "APPS.XLA_EXCEPTIONS_PKG", line 110 ORA-06512: at "APPS.XLA_EXCEPTIONS_PKG", line 289 ORA-06512: at "APPS.XLA_EXCEPTIONS_PKG", line 162 ORA-06512: at "APPS.XLA_CREATE_ACCT_RPT_PVT", line 288 ORA-06512: at line 4
via Coderanch by Ravi Majety, 11 months ago
ORA-21700: object does not exist or is marked for delete ORA-06512: at "BusLogic ", line 99 ORA-06512: at line 1
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
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.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)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
58 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.