When Supplier Do Po Acknowledge, Error Happened: You Have Encountered An Unexpected Error (Doc ID 2289935.1)

Last updated on JULY 25, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Supplier Acknowledgement Issues

When attempting to acknowledge the PO by supplier, the following error occurs.

ERROR
-----------------------
You have encountered an unexpected error, please contact the system administrator for assistance.

DETAILED ERROR
--------------------------
Exception Details.
 oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-04063: package body "APPS.PO_CHG_REQUEST_PVT" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.PO_CHG_REQUEST_PVT"
ORA-06512: at line 1
.......................................
## Detail 0 ##
java.sql.SQLException: ORA-04063: package body "APPS.PO_CHG_REQUEST_PVT" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.PO_CHG_REQUEST_PVT"
ORA-06512: at line 1
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.pos.changeorder.server.ChangeOrderAMImpl.validateCancelRequest(ChangeOrderAMImpl.java:416)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
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.pos.changeorder.webui.ViewOrderControlsCO.processRequest(ViewOrderControlsCO.java:270)

STEPS TO REPRODUCE
--------------------------------------
The issue can be reproduced at will with the following steps:
1. Create a PO using Purchasing Responsibility
2. Supplier logs into iSupplier Portal Full Access
3. Try to acknowledge the PO

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms