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:
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.