How to Change the check number in oracle apps : How to Update the AP check Number in Oracle apps

How to Change the check number in oracle apps : How to Update the AP check Number in Oracle apps

In this post , We will be discuss about how we can change the check number in oracle apps. We can update or change the check number already used in the Payments. I will share the sql script to update the check number in the Oracle apps payments. For example , If any reason our payment has been voided , in Oracle apps but our check number is created. Now we want to reuse that check number for another payment. To reuse that check number again , we need to change the Voided check number so that the next payment will again use the same check number. To change the check number for the voided payment in oracle apps we need to use this below script.

 

Using this below script to Update the AP check Number in Oracle apps

Step1:- AP Payments check number stored in these below tables in oracle apps.

 

1.AP_CHECKS_ALL

2.IBY_PAYMENTS_ALL

3.IBY_USED_PAYMENT_DOCS

 

 

 

Script to Update the AP check Number in Oracle apps

For Example , The Voided Check Number is '33445' and we want to re-use this check number again , so to re-use this check number we need to use this below script.

Script 1:-

 

update ap_checks_all

set check_number='33445999999'

 

where check_number in (33445)

 

Script 2:-

 

UPDATE IBY_PAYMENTS_ALL

set PAPER_DOCUMENT_NUMBER ='33445999999'

where PAPER_DOCUMENT_NUMBER in (33445)

Script 3:-

UPDATE  IBY_USED_PAYMENT_DOCS

SET USED_DOCUMENT_NUMBER ='33445999999'

WHERE USED_DOCUMENT_NUMBER  in (33445)

 

After These all the steps , We can use the check number '33445' in oracle apps.

 

 

How to Change the check number in oracle apps : How to Update the AP check Number in Oracle apps