ERPstuff - Oracle EBS Community

Hi All,
A Req, PO and receipts is created for $150.
However the amount billed is $125.
Now I would like to change the Receipt amount to $125 from $150 by returning $25 which is not allowing me to do that.
System is not recognizing the recipt or PO number.
Note: PO is finally closed.
Appreciate your early relpy.

hi abbas,,how ru... i could undestand u r quey... u do one thing ..in the po call the recipt of amount 150...and cancell it..then u create the 125 ..

Hi Abbas,
If that is the case u just raise the Debit memo to that extent.

Regards,

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
Tracy

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 user
sqlplus apps/pwd

2) Find PO_HEADER_ID:

select PO_HEADER_ID
from PO_HEADERS_ALL
where SEGMENT1 = '';

3) Update CLOSED_CODE from FINALLY CLOSED to CLOSED:

a)
update PO_HEADERS_ALL
set CLOSED_CODE = 'CLOSED'
where PO_HEADER_ID =
and CLOSED_CODE = 'FINALLY CLOSED';

commit;

b)
update PO_LINES_ALL
set CLOSED_CODE = 'CLOSED'
where PO_HEADER_ID =
and CLOSED_CODE = 'FINALLY CLOSED';

commit;

c)
update PO_LINE_LOCATIONS_ALL
set CLOSED_CODE = 'CLOSED'
where PO_HEADER_ID =
and CLOSED_CODE = 'FINALLY CLOSED';

commit;

d)
delete from PO_ACTION_HISTORY
where OBJECT_ID = &OBJECT_ID
---object_id is the po_header_id
and ACTION_CODE = 'FINALLY CLOSE';

commit;

4) Navigate to the Purchase Order Summary form. Query the PO.
On the toolbar, select Special > Control. Open the PO.
==============================================
Ive used this script without a problem.
remember review the note though if you have inventory fully installed you need to also update mtl_supply.

Once you have fixed the PO get the users to understand that finally closing a PO is not recommended until you're sure there will never be anything more to action on the PO. (we don't finally close ours for 3 years ..... )

can you let me know if this helped.

Tracy