Note: 11835268: ARCAOAB 'Assign Cash Application Work Items' ends in error ORA-06502: PL/SQL: NUMERIC

(Doc ID 1354458.1)

Last updated on JUNE 05, 2018

Applies to:

Oracle Receivables - Version: 12 and later   [Release: 12.0 and later ]
Oracle Financials Common Modules - Version: 12.0.6 and later    [Release: 12.0 and later]
Information in this document applies to any platform.


Setup cash application work Queues.
Run "Assign Cash Application Work Items" concurrent program.

ARCAOAB module: Assign Cash Application Work Items

Current system time is 22-FEB-2011 09:42:15


**Starts**22-FEB-2011 09:42:16
**Ends**22-FEB-2011 09:46:15
Start of log messages from FND_FILE
ar_cao_assign_pkg.assign_work_items (+)
Operating Unit : 249
Receipt Date From : 2010/12/01 00:00:00
Receipt Date To : 2011/02/22 00:00:00
Customer Profile Class :
Max Workers : 5
Worker Number :
Request ID93918838
Request ID93918840
Request ID93918841
Request ID93918842
Query :SELECT acr.cash_receipt_id, hca.cust_account_id, hcsu.site_use_id, nvl(hcp1.profile_class_id, hcp.profile_class_id) profile_class_id,, acr.org_id, acr.currency_code, decode(acr.status, 'UNID', ABS(aps.amount_due_remaining), 0) unidentified_amount, decode(acr.status, 'UNAPP', ABS(aps.amount_due_remaining), 0) unapplied_amount, null,null,null,null,null,null,null,null,null,null FROM ar_cash_receipts acr, hz_cust_accounts hca, hz_cust_site_uses hcsu, hz_locations hl, hz_party_sites hps, hz_cust_acct_sites hcas, ar_payment_schedules aps, hz_customer_profiles hcp, hz_customer_profiles hcp1 WHERE acr.pay_from_customer = hca.cust_account_id(+) AND acr.customer_site_use_id = hcsu.site_use_id(+) AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id(+) AND hcas.party_site_id = hps.party_site_id(+) AND hps.location_id = hl.location_id(+) AND acr.cash_receipt_id = aps.cash_receipt_id AND acr.type = 'CASH' AND acr.cash_appln_owner_id IS NULL AND acr.status IN('UNAPP', 'UNID') AND hca.cust_account_id = hcp.cust_account_id(+) AND hcp.site_use_id IS NULL AND hcsu.site_use_id = hcp1.site_use_id(+) and mod(acr.cash_receipt_id,5) = decode( 5, 0, acr.cash_receipt_id, mod(0,5)) AND acr.org_id = 249 AND acr.receipt_date >= trunc(to_date('2010/12/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS')) AND acr.receipt_date <= trunc(to_date('2011/02/22 00:00:00', 'YYYY/MM/DD HH24:MI:SS'))
Number of records: 576
Invoking Rule Engine
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
End of log messages from FND_FILE

"ORA-06502: PL/SQL: numeric or value error: character string buffer too small"

Running the above SQL directly in SQL*plus gives no errors

/* $Header: ARCAOAB.pls 120.0.12010000.7 2010/03/02 06:46:27 rviriyal noship $*/
/*$Header: FUNXTMRULENGINB.pls 120.19.12010000.9 2010/03/09 07:06:45 rviriyal ship $ */
[$Header: 120.2.12010000.2 2008/09/05 14:41:38 tthangav ship $


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