please run the seeded script poresreq.sql to reset the PR to incomplete stage
First of all Thanks to reply.
Updating the PR which would be in 'In complete' or 'In Progress' status is part of our design. In our integration project, legassy system would keep sending details to update PRs in EBS and PRs already would have been sent for approval. so in this case, may not be possible to apply the script poresreq.sql to reset each and every PR to incomplete stage.
If one or two PR case, we could apply the script, but our design is in such a way where there could be many PR's in 'In complete' status in a day.
I hope you understood my point.
Could you please advise on this.
Please read the MOS doc. 390023.1 for the same.
I think you should try with conversion this script into PL/SQL block using simple cursor and cursor for loop for multiple PR.
Is there a reason you are submitting the PR before all the changes are brought over? Could you interface the PR as Incomplete status and leave it at Incomplete until all the changes have interfaced and then submit it for approval...Or not even interface until all the appropriate changes have been made? Otherwise you are constantly going to be sending notifications to users that are already out-of-date/need to be retracted...and they are going to start not paying attention to them or wonder why they are constantly approving the same thing over and over.
As our application is R12.2.5 version, we can update the requisition document with the standard PO_REQUISITION_UPDATE_PUB.update_requisition though it is in 'Inprocess' status. We have tested this in application 12.2.5 version and confirming.
we don't need to bring back the status to 'Incomplete' to apply external system changes.