ERPstuff - Oracle EBS Community

First create tables to back up po_headers_all, po_lines_all po_line_locations_all and po_distributions_all.

If you use inventory then you also need to update mtl_supply as well as the following:

If you don't have inventory installed then all you need to do is:

1) Log In to SQL*PLUS as the APPS ...

when the po is finally closed you cannot do anything with it. you should only finally close a po years after everything has been transacted.

I'll update this topic with a script on how to re-open a finally closed po but it is unsupported at oracle.

(do you match to receipt in invoicing?)

thanks ...

Hi William,

have you upgraded since you were last able to change the unit price? Or applied some recent po patches. According to Oracle you should not be able to change the unit price once there had been a partial receipt or bill. (see metalink doc Note:213796.1 question 6) so you might have been ...

Oracle won't let you adjust the price once any receipt has been done because there are costs that get sent to the various accounts. If it allowed you to ajust the price, and you then subsequently reversed a receipt which had originally been costed at a lower price ... the reversal would again check ...