My Oracle Support Banner

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

Last updated on DECEMBER 04, 2019

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.


When executed post batch program (ARCABP), received the following error:


We check the following query in the package jl_ar_receivable_applications

  INTO x_city,
  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.


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

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