1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to change the status from pre-approved to incomplete

Discussion in 'Oracle Apps Technical' started by erp.narendrag, Oct 6, 2012.

  1. erp.narendrag

    erp.narendrag Forum Expert

    Messages:
    108
    Likes Received:
    17
    Trophy Points:
    655
    Location:
    India
    Hi frnds,

    purchase order is stuck in pre-approved status , next approver not getting the notifications in notification summary
    now user asked to change the status from pre-approved status to incomplete, could you please provide the script for this issue


    Regards,
    Narendra
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    May be this was hierarchy problem. Better try to resolve the hierarchy problem and then try to re-order it.
     
  3. a_kamalraj

    a_kamalraj Forum Advisor

    Messages:
    121
    Likes Received:
    23
    Trophy Points:
    280
    YOu can change to Incomplete from Pre-Approved by following Below Steps

    1. Login into server PO_TOP/Sql
    2. There are few .sql files in which one .sql file if you run it will ask for which PO status needs to be changed you can provide input and change the status
     
  4. mramadhani

    mramadhani Active Member

    Messages:
    27
    Likes Received:
    3
    Trophy Points:
    185
    Location:
    Dar Es Salaam
    This is not a good ideas guys.......try to thing on limit authority...if forward PO to the person who has no authority for Approval on PO...it will change the status to be Incomplete otherwise in-process.

    Please think on it....
     
  5. sivaramakrishna.d

    sivaramakrishna.d Active Member

    Messages:
    61
    Likes Received:
    6
    Trophy Points:
    160
    Dear ,

    I too faced the same issue.
    We raised an SR with oracle and he gives us the solution.
    please follow the note 390023.1

    This will help you.If this doesn't work out ask ur DBA to apply patch 9707155 and try the above note 390023.1

    Siva Ram
     
  6. chinky

    chinky Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    1. Retry the workflow
    2.I have used the attached script and it works ID 390023.1
     
  7. a_kamalraj

    a_kamalraj Forum Advisor

    Messages:
    121
    Likes Received:
    23
    Trophy Points:
    280
    The Above mentioned note also does the same what i mentioned.

    These scripts allow the user to resubmit the document for approval by resetting the authorization status when documents are stuck in 'In-Process' or 'Pre-Approved' statuses. The scripts are:
    •poxrespo.sql - to reset Standard, Blanket, Planned and Contract purchase orders
    •poresrel.sql - to reset Blanket and scheduled releases
    •poresreq.sql - to reset Internal and purchase requisitions

    In order to obtain the scripts apply the proper patch. The scripts will be available in the $PO_TOP/sql directory.