Procurement - EBS (MOSC)

MOSC Banner

Reset stuck PO Documents using sql or Concurrent program?

edited Jul 4, 2020 5:00AM in Procurement - EBS (MOSC) 6 commentsAnswered

Good Morning:

  Background: We have repeated occurrences of PO /Release/Requisition getting stuck due to multiple reasons. We were advised to use a script to reset data and place the PO document in INCOMPLETE status.

However, I noticed there is a concurrent program available.

<sorry should have mentioned our environment earlier; here it is:> We are in RDBMS : 11.2.0.4.0, Applications : 12.2.5

Question is,

  will this Patch 14766231: In Oracle Purchasing, create a new concurrent program for reset Purchasing documents , do the same thing as done by poxrespo.sql / poresrel.sql / poresreq.sql ?( MOS # 390023.1 - How To Reset a Purchase Order or Requisition From In Process or Pre-Approved To Incomplete/Requires Reapproval For Isolated Cases (

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center