Reset a Purchase Order From In Process To Incomplete
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