Payables & Cash Management

Get Involved. Join the Conversation.


    Heena Jesani
    Payables Period Close Exceptions Report not displaying any...
    Topic posted August 21, 2019 by Heena JesaniRed Ribbon: 250+ Points, last edited August 21, 2019, tagged Financials, Payables, Period Close / Reconciliation 
    56 Views, 3 Comments
    Payables Period Close Exceptions Report not displaying any data
    Payables Period Close Exceptions Report is not displaying any data eventhough the Payables period cannot be closed

    Hi Folks,

    We are facing an issue when trying to close payables period, the Close Payables Accounting Period program ends in warning with "AP_UNACCT_TRXS_EXISTS - Unaccounted Invoices and/or payments". However the Payables Period Close Exceptions report ends in Error with no data in it. 

    When trying to run the report from Scheduled Processes work area, it runs successfully however there is still no data in it.

    We are on 19C. Has anyone faced this issue? Appreciate your inputs if you have also faced this or were able to resolve it.




    • Karthikeyan Sukumar

      This is not 19C issue.

      May be there are invoice lines exist without distribution.Can you run the below SQL and check.

      ​If you found any invoices without distribution then correct those validate again or delete the invoice is not required.

      SELECT ap_invoices_pkg.get_posting_status(ai.invoice_id) posting_flag
      WHERE AI.SET_OF_BOOKS_ID = <&ledger_id>
      AND AI.GL_DATE BETWEEN to_date('<&yyyy-mm-dd>', 'YYYY-MM-DD') and
      to_date('<&yyyy-mm-dd>', 'YYYY-MM-DD')
      AND ap_invoices_pkg.get_posting_status(ai.invoice_id) != 'Y';



    • Phil Nibert

      We had a similar issue with one of our AP closes and resolved it by running the AP sweep transactions to sweep any unaccounted AP transactions to the next month.