ORA-01422 Error When Runing Brazil Post Batch Program (ARCABP) (Doc ID 2210652.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Receivables - Version 12.2.4 and later
Oracle Financials for the Americas - Version 12.2.1 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.

Cause

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