AP Payment status showing unprocessed in oracle apps

AP Payment status showing unprocessed in oracle apps

 

1>>> Check account status unprocessed ,it showing period exception reports

 

2>>> Check invoices status is accounted or not.

3>>> Check tools accounting it is transfer to GL or not.

Note :- run script this only for invoice accounted and xla accounted only problem in payment window account status is unprocessed then run this script

 

Step1:- run query find out unprocessed flag with check id

Note:- check id taken window help

edit apps.ap_payment_history_all  where check_id=xxxxx

step2:- based on above query we can find out xla_event id  then run script check posted flag ok then run update command if it no don’t run this script

 

edit  apps.xla_events where EVENT_ID=xxxx

UPDATE apps.ap_payment_history_all

SET posted_flag = ‘Y’

WHERE CHECK_ID IN (xxxx)

AND org_id = 117

AND posted_flag <> ‘Y’;

 

UPDATE apps.AP_INVOICE_PAYMENTS_all

SET ACCRUAL_POSTED_FLAG = ‘Y’, POSTED_FLAG = ‘Y’

WHERE CHECK_ID IN (xxxxx)

AND org_id = 117

AND ACCRUAL_POSTED_FLAG = ‘N’

AND POSTED_FLAG = ‘N’

 

Thank you.

Chandra sekhar reddy chamala.