Cancel the PO when there is change request exists

    To implement the solution, please execute the following steps:

1. Ensure that you have taken a backup of your system before applying the recommended solution.

2. Run the following scripts in a TEST environment first:

Script#1

---------

UPDATE po_headers_all

SET authorization_status = 'APPROVED', approved_flag = 'Y'

WHERE po_header_id = 10481132;

commit;

Script#2

---------

UPDATE po_line_locations_all

SET approved_flag = 'Y'

WHERE po_header_id = 10481132

AND po_release_id IS NULL

AND approved_flag = 'R';

commit;

Script#3

--------

UPDATE po_action_history

SET action_code = 'NO ACTION',

note = 'This is updated for Bug 5471980 '

WHERE object_id = 10481132

AND object_type_code = 'PO'

AND action_code IS NULL;

commit;

Script#4

---------

UPDATE po_change_requests

SET request_status = 'REJECTED',

change_active_flag='N'

WHERE

(

(DOCUMENT_TYPE='REQ'AND DOCUMENT_HEADER_ID='10635161')

OR

(DOCUMENT_TYPE='PO'AND DOCUMENT_HEADER_ID='10481132')

)

AND REQUEST_STATUS NOT IN ('ACCEPTED', 'REJECTED')

AND INITIATOR = 'REQUESTER';

commit;

Script#5

--------

UPDATE po_requisition_headers_all

SET change_pending_flag = NULL

WHERE requisition_header_id = 10635161; ----------Requisition Header Id

commit;

3. Once the scripts complete, confirm that the data is corrected.

4. If you are satisfied with the results, issue a commit.

5. Confirm that the data is corrected when viewed in the Oracle Applications.

6. If you are satisfied that the issue is resolved, migrate the solution as appropriate to other environments.