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.*
FROM ap_checks_all ac,
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