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

Last updated on MAY 20, 2024

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.