'You Have Encountered An Unexpected Error' Attempting to Open Requisition Approval Notification (Doc ID 2890096.1)

Last updated on JULY 30, 2024

Applies to:

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

Symptoms

On : 12.1.3 version, Approvals - Req, PO

Approvers are unable to open Requisition Approval Notification.

The following error occurs when user attempts to open the notification from homepage worklist

ERROR
-----------------------
You have encountered an unexpected error. Please Contact the System Administrator for assistance.

Stack error shows the following exception details:

Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT prl.requisition_header_id,
       prl.requisition_line_id,
       prl.line_num AS LINE,
       msi.concatenated_segments AS ITEM_NUMBER,
       prl.item_revision,
       prl.item_description AS DESCRIPTION,
...
at oracle.apps.icx.por.wf.webui.ReqLinesNotificationsCO.processRequest(ReqLinesNotificationsCO.java:110)
## Detail 0 ##
java.sql.SQLException: ORA-04063: package body "APPS.PO_POAPPROVAL_INIT1" has errors

Attempting to compile the package, fails with the errors below:

Steps to reproduce:
1. Log in as approver
2. Click the notification in worklist
3. Error occurs

Changes

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

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

'You Have Encountered An Unexpected Error' Attempting to Open Requisition Approval Notification (Doc ID 2890096.1)

Applies to:

Symptoms

Changes

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!