(B) R12.1 Future Dated And Reconciled Payments Stuck With Error. (Doc ID 1519886.1)

Last updated on MARCH 15, 2017

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Goal

Why when attempting to account for Payment Matured events does the following error occur?:

 
  ERROR
  -----------------------
  95359 There is no accounted amount for the subledger journal entry line.
  Please inform your system administrator or support representative that:
  The source assigned to the accounting attribute Accounted Amount has no
  value for extract line number XXXXXX. Please make sure the source assigned
  to the accounting attribute Accounted Amount has a valid value, or assign a
  different source to this accounting attribute.
 
 
  STEPS
  -----------------------
  The issue can be reproduced at will with the following steps:
  1. Run Create Accounting
  2. Fails to account the mentioned events

 

Run the following identification query for such cases:

   SELECT distinct ac.*
   , aph.payment_history_id
   , aph.pmt_to_base_xrate_type
   , aph.pmt_to_base_xrate_date
   , aph.pmt_to_base_xrate
   FROM ap_checks_all ac,
   ap_payment_history_all aph,
   ap_system_parameters_all asp
   WHERE ac.check_id = aph.check_id
   AND aph.transaction_type like 'PAYMENT MATURITY%'
   AND nvl(aph.posted_flag,'N') ='N'
   AND ac.org_id = asp.org_id
   AND ac.currency_code <> asp.base_currency_code
   AND ac.maturity_exchange_rate IS NULL
   AND ac.maturity_exchange_date IS NOT NULL
   AND ac.maturity_exchange_rate_type IS NOT NULL;

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms