Cannot Close Payables Period Even When There is Nothing in The Exception Report

Problem:

Cannot close Payables period 

After running create accounting and sweeping transactions, still unable to close a Payables period.

The exceptions report is empty.

Steps To Reproduce:

1. Navigate to payables resp and try to close the period

2. No exceptions are reported and the period cannot be closed

Cause:

Function get_unposted_transactions in AP_PERIOD_CLOSE_PKG
 is returning 'Y' even though there are no transactions

This issue has been identified and clarified through Bug 9509700 - UNABLE TO CLOSE PERIOD EVEN WHEN THERE IS NOTHING IN THE EXCEPTION REPORT

 

Solution:

This issue has been fixed in the files:
For 12.0   apprdclb.pls   120.0.12000000.26  
For 12.1   apprdclb.pls   120.9.12010000.14    

To implement the solution, please execute the following steps:
1. Download and review the readme and pre-requisites for the following:

For R12.0   patch 9509700:R12.AP.A

For R12.1   patch 9509700:R12.AP.B

2. Ensure that you have taken a backup of your system before applying
the recommended patch.

3. Apply the patch in a test environment.

4. Confirm the following file versions:
    For 12.0   patch/115/sql/apprdclb.pls   120.0.12000000.26  
    For 12.1   patch/115/sql/apprdclb.pls   120.9.12010000.14
You can use the commands like the following:
       strings -a $AP_TOP/filename |grep '$Header'

5. Retest the issue.

6. Migrate the solution as appropriate to other environments.