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!

Cancel Invoice with status 'selected for payment'

Discussion in 'Oracle Financials' started by abe123, Mar 12, 2012.

  1. abe123

    abe123 Active Member

    Messages:
    6
    Likes Received:
    1
    Trophy Points:
    65
    Hi all,

    I was had trouble with Payment Process Request, when process is complete that invoices selected is not shown.
    Now I want to cancel selected invoice but the status is : Selected for payment,
    how can i return back that status to : validated , which that status (validated) I can cancel that invoice.

    Thanks for help
     
  2. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Abe123,

    Always mention the version of R12 you are on.
    The issue you mention is because of an Oracle Bug 10186377
    Steps to Resolve should be
    1. Check the version numbers you are currently running for the following files:
    For R12.0:

    iby patch/115/sql ibydapib.pls 120.141.12000000.78
    iby patch/115/sql ibydapis.pls 120.50.12000000.22

    For R12.1:
    iby patch/115/sql ibydapib.pls 120.160.12010000.57
    iby patch/115/sql ibydapis.pls 120.60.12010000.12

    Get this from your DBA

    If you are on a lower version then download the following patches (no Password)
    R12.0: unpublished Patch 9781541:R12.IBY.A.
    R12.1: unpublished Patch.9781541:R12.IBY.B.

    Get you dba's involved. Check the prerequisites from the Readme and apply in a test instance.
    Then retest the issue before migrating to your production environment.

    If you are practising on vision then forget it and understand its an oracle bug .
    Ramji
     
  3. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    I have uploaded a document. Kindly refer to that . It is called all functional and technical aspects of Payment processing Requests. You should get a clear idea of how to react to each situation once you are clear about the process flow.
    Thanks
    Ramji
     
  4. abe123

    abe123 Active Member

    Messages:
    6
    Likes Received:
    1
    Trophy Points:
    65
    hi Ramji,

    Sorry if I'm late to respond :)

    I Try to update table ap.ap_payment_schedules_all use this query :

    update ap.ap_payment_schedules_all
    set checkrun_id =''
    where invoice_id in (
    '610483',
    '611467',
    '611451',
    '611499',
    '611463')
    and checkrun_id ='45681'

    and this is work properly, the status invoice back to validate and so I can cancel that invoice..:D
     
    soumya.parhi likes this.
  5. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Abe,

    This is a data fix. For a long term fix the only option is the patches. You do not want to keep doing this daily :)
    cheers
    Ramji
     
  6. abe123

    abe123 Active Member

    Messages:
    6
    Likes Received:
    1
    Trophy Points:
    65
    Hi Ramji,

    You are right, this is datafix,but I think payment process (PPR) is work properly in my Application.
    This issue is raise couse human error in payment process (create payment) , I didn't save before next process in payment process (create single payment), thats why in my Invoices status is 'selected for payment'.

    Thanks