Procurement - EBS (MOSC)

MOSC Banner

Reset a Purchase Order From In Process To Incomplete

edited May 17, 2017 5:52AM in Procurement - EBS (MOSC) 6 commentsAnswered ✓

Hi Team,

I am following Doc ID 390023.1 to update a PO status using the code provided in poxrespo.sql. I am in R12.1.3 and getting the below error message. Just checked the table 'd' which is po_distributions_all and couldn't find the column AMOUNT_CHANGED_FLAG. Am I using the wrong SQL to update the PO status. We don't use encumbrance. Any help on this will be much appreciated.

ERROR at line 132:

ORA-06550: line 132, column 11:

PL/SQL: ORA-00904:
"D"."AMOUNT_CHANGED_FLAG": invalid identifier

ORA-06550: line 100, column 1:

PL/SQL: SQL Statement ignored

ORA-06550: line 239, column 12:

PL/SQL: ORA-00904:
"D"."AMOUNT_CHANGED_FLAG": invalid identifier

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center