Last updated on MAY 08, 2015
Applies to:Oracle Payables - Version: 12.0.2
This problem can occur on any platform.
Create Accounting, XLAACCPB, XLAACCUP
--The Upgraded Invoice and Payment events are upgraded and accounted OK.
--The Payment Canceled event created AFTER the upgrade is not accounted.
Symptom 2: In R12, the Create Accounting process shows a 95359 error for Payment Canceled events created for upgraded payments.
Line Error Number Error Message
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 214814. 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 TO REPRODUCE THE PROBLEM:
1. Find an upgraded payment
2. Void the upgraded payment.
3. Submit the Create Accounting process and note the Payment Canceled event is not accounted or is accounted with a 95359 error.
QUERY TO IDENTIFY POTENTIAL PROBLEM DATA WITH THIS ISSUE:
from xla_events xe, xla_events xe2
where xe.application_id = 200
and xe2.application_id = 200
and xe.entity_id = xe2.entity_id
and xe.event_type_code = 'PAYMENT CREATED'
and xe2.event_type_code = 'PAYMENT CANCELLED'
and xe.upg_batch_id is NOT NULL
and xe2.upg_batch_id is NULL;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms