My Oracle Support Banner

R12:AP:Future Dated And Reconciled Payments Stuck With Error. (Doc ID 1519886.1)

Last updated on FEBRUARY 26, 2019

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.


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

  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.
  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;


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.