6 Replies Latest reply: May 7, 2012 9:26 PM by Ashish_Inda_99 RSS

    'No control for this document' error when canceling the PO

    Ashish_Inda_99
      Hi,

      When trying to cancel a standard PO in incomplete state then error 'No control for this documet'. PO document type too checked but access is set to "Full".
      Want to cancel the PO. Please help. This issue is for oracle 11i.

      Inda
        • 1. Re: 'No control for this document' error when canceling the PO
          Mahendra
          930231 wrote:
          Hi,

          When trying to cancel a standard PO in incomplete state then error 'No control for this documet'. PO document type too checked but access is set to "Full".
          Want to cancel the PO. Please help. This issue is for oracle 11i.

          Inda
          You can't cancel a PO if it is in incomplete status...only thing you can do is place that on a hold..after placing that too u can't cancel it...so workaround would be approve it and cancel it..:)

          HTH
          Mahendra
          • 2. Re: 'No control for this document' error when canceling the PO
            Ashish_Inda_99
            OK. Thanks.

            Now if PO is in prcess in the login of some user in hierarchy who will approve it.
            But when seen in notification and searched it is not found. But if PO is queried through PO summary and its status is checked through workflow oprtion below action history it sholws notification.
            But again it can not be modified. why? Please explain.

            930
            • 3. Re: 'No control for this document' error when canceling the PO
              Mahendra
              930231 wrote:
              OK. Thanks.

              Now if PO is in prcess in the login of some user in hierarchy who will approve it.
              But when seen in notification and searched it is not found. But if PO is queried through PO summary and its status is checked through workflow oprtion below action history it sholws notification.
              But again it can not be modified. why? Please explain.

              930
              you mean to say..PO is in process...by checking the summary u can see the approver name..but the user who has to approve..haven't received notification??

              Mahendra
              • 4. Re: 'No control for this document' error when canceling the PO
                Ashish_Inda_99
                Yes. PO is in process and shows in bucket of next person. But next person when open notification do not find the PO. But if PO summary is open with his login id and too>see PO through workflow is open then we can able to open notification but not in notification window. Why? Please help.
                • 5. Re: 'No control for this document' error when canceling the PO
                  Abdul Raheem
                  Hi,

                  I have also face similar issue,the reason is stuck in workflow process,u need to change the status in process to required approval then u will find the po in approver notification, then approver can approve and status will be changed in process to approved the n u can do further steps as per ur requirement.I will give u the query to change the status from back end....

                  1.SELECT hr.NAME,
                  poh.segment1,
                  poh.revision_num,
                  poh.wf_item_type,
                  poh.wf_item_key,
                  authorization_status,
                  poh.po_header_id
                  FROM
                  po_headers_all poh,
                  hr_all_organization_units hr
                  WHERE poh.org_id = hr.organization_id
                  AND poh.segment1 = 15837(give ur po no. here)

                  2. update po_headerS_all
                  set AUTHORIZATION_STATUS='REQUIRES REAPPROVAL'
                  WHERE AUTHORIZATION_STATUS='IN PROCESS'
                  AND segment1=15837


                  In first step u will find the po status then in next step u need to update the status...

                  after executing with above steps u can get the po in approver notification summary
                  then he can approve the po.

                  Hope this will help u

                  Regards
                  Abdul
                  • 6. Re: 'No control for this document' error when canceling the PO
                    Ashish_Inda_99
                    Hay Abdul,

                    But where to run this script. If user make any small change on PO by opening it through tools>PO workflow then too it goes in requires re approval and he/she need to approve it.

                    So how this work.

                    Ashish