ORA-01422 Error When Runing Brazil Post Batch Program (ARCABP)
(Doc ID 2210652.1)
Last updated on MAY 20, 2024
Applies to:
Oracle Receivables - Version 12.2 and laterOracle Financials for the Americas - Version 12.2 and later
Information in this document applies to any platform.
Symptoms
When executed post batch program (ARCABP), received the following error:
We check the following query in the package jl_ar_receivable_applications
SELECT loc.city,
loc.state,
arps.org_id
INTO x_city,
x_state,
x_org_id
FROM hz_locations loc,
Hz_cust_acct_sites ad,
Hz_party_sites pty,
Ra_customer_trx ract,
Hz_cust_site_uses rasu,
Ar_payment_schedules arps,
jl_br_ar_collection_docs dc
WHERE dc.payment_schedule_id = x_payment_schedule_id
AND arps.payment_schedule_id = dc.payment_schedule_id
AND ract.customer_trx_id = arps.customer_trx_id
AND rasu.site_use_id = ract.bill_to_site_use_id
AND ad.cust_acct_site_id = rasu.cust_acct_site_id
AND ad.party_site_id = pty.party_site_id
AND loc.location_id = pty.location_id;
This query returns multiple records.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |