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!

AR/AP Netting Batch - How to Update a Netting Batch Stuck in Clearing Status

Discussion in 'Oracle Financials' started by nanan.rubio, May 7, 2013.

  1. nanan.rubio

    nanan.rubio Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Philippines
    Hello great minds!:)

    Issue here on AR/AP Netting Batch - How to update a netting batch stuck in Clearing status? Settle Netting Batch errors out due to a memory or table space error. ORA-04031: unable to allocate 256 bytes of shared memory ("shared pool","unknown object","PCursor","kglob" )
    ORA-06510: PL/SQL: unhandled user-defined exception.

    But since the memory space issue has been fixed already, How do we proceed with the Netting procedure with its status "Clearing"? The invoices are locked, and no payment and receipt were created as a result. Please help us out? Thanks!
     
  2. nanan.rubio

    nanan.rubio Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Philippines
    Is there a workflow background process perhaps for this specific transaction to accelerate it to Complete Status, thus, updating the netting batch with a Payment and Receipt record as a result of the netting. :) inputs please anyone? thanks thanks..