AP Create Accounting Issue

Issue :

• Issue in Create accounting in Payable and got following error :
  An internal error has occurred in the program xla_ap_acct_hooks_pkg.main. Technical problem : Error encountered in product API for extract
  ORA-01403: no data found occurred in
  AP_Accounting_Pay_Pkg.Do_Pay_Accounting<- AP_SLA_PROCESSING_PKG.EXTRACT
  with parameters (&PARAMETERS)

Solution :

if following query return any row go and apply datafix : Doc ID 802929.1

•  SELECT distinct c.check_id , p.check_id correct_check_id
  FROM ap_checks_all c,
  ap_invoice_payments_all p,
  iby_docs_payable_all dp
  WHERE dp.calling_app_doc_unique_ref1 = p.check_id
  AND dp.calling_app_doc_unique_ref4 = p.invoice_payment_id
  AND c.payment_id = dp.payment_id
  AND c.check_id <> p.check_id AND dp.org_id = c.org_id