My Oracle Support Banner

"PLS-00302: Component 'DEL_REQ_LINE_CHNG_ATTACHMENTS' Must Be Declared" Error When Changing the Requisition (Doc ID 2500177.1)

Last updated on MARCH 17, 2021

Applies to:

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

Symptoms

When attempting to change the requisition, the following error occurs:

ERROR
-----------------------
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-06550: line 1, column 29:
PLS-00302: component 'DEL_REQ_LINE_CHNG_ATTACHMENTS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:764)
at oracle.apps.icx.por.reqmgmt.webui.RMBaseCO.changeOrder(RMBaseCO.java:1085)
at oracle.apps.icx.por.reqmgmt.webui.RMBaseCO.performAction(RMBaseCO.java:876)
at oracle.apps.icx.por.reqmgmt.webui.RMBaseCO.processActionForSummary(RMBaseCO.java:802)
at oracle.apps.icx.por.reqmgmt.webui.RMBaseCO.processSummaryFormRequest(RMBaseCO.java:642)
at oracle.apps.icx.por.reqmgmt.webui.ReqSummaryCO.processFormRequest(ReqSummaryCO.java:169)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:843)

..........
## Detail 0 ##
java.sql.SQLException: ORA-06550: line 1, column 29:
PLS-00302: component 'DEL_REQ_LINE_CHNG_ATTACHMENTS' must be declared
ORA-06550: line 1, column 7:
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.icx.por.changeorder.server.ChangeOrderUtil.deleteReqChngAttachments(ChangeOrderUtil.java:1242)
at oracle.apps.icx.por.reqmgmt.server.ReqMgmtAMImpl.deleteReqChngAttachments(ReqMgmtAMImpl.java:2639)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. iProcurement Responsibility ->
2. Requisition tab ->
3. Select requisition ->
4. Change Button ->
5. Error occurs

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.