How Payable Invoices related Reconciliation and Currencies Data is stored in Oracle Apps R12

We will find the tables involved in storing the Reconciliation and Currency Data related to the Payable INVOICE ( Invoice_id = 166014 ). All the queries given in this post and their related posts were tested in […]

Bank Statement Upload and Reconciliation in Oracle Cash Management

Following are the key programs that are used to load and Import Bank Statement into Oracle. Bank Statement Loader Run SQL*Loader- BAI2 Load Bank Statement Data Bank Statement Loader Execution Report Bank Statement Import & […]

Difference between Cleared, Unreconciled, Reconciled, and Void?

Void: We’ll take the easiest one first “Void”. This of course means that the check is no longer valid and will not be going through your bank. Unreconciled: The next one is Unreconciled. This […]

Voiding Reconciled Payment

Issue: The payments are made against the invoices in the payment manager screen. These payments have been cleared but the payment status is shown as reconciled. Now I want to void the payment but cannot […]