My Oracle Support Banner

Reset Script poxrespo.sql Fails With Error ORA-6550: line 276, column 37: PL/SQL: ORA-904: "PO_RESET"."PO_HEADER_ID": invalid identifier (Doc ID 2791573.1)

Last updated on JULY 15, 2021

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

After applying Patch 30887486:R12.PO.B that delivers PO Reset script poxrespo.sql (Ref.: <Note 390023.1>) version 120.0.12010000.10, the following errors occur attempting to reset PO documents:
ERROR
-----------------------
Error report -
ORA-06550: line 276, column 37:
PL/SQL: ORA-00904: "PO_RESET"."PO_HEADER_ID": invalid identifier
ORA-06550: line 249, column 3:
PL/SQL: SQL Statement ignored
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run script poxrespo.sql 120.0.12010000.10 using sqlplus or sqldeveloper
2. The error above 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.