(B) R12.1 Future Dated And Reconciled Payments Stuck With Error.
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.
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;
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