Receipts Workbench Issue: No Results in Cash Application Work Queue and Errors - ORA-00936: Missing Expression (Doc ID 1591285.1)

Last updated on JUNE 08, 2016

Applies to:

Oracle Receivables - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

You have created a Cash Application Owner and have run the "Assign Cash Application Work Items" program, but when you search for a customer name (or simply use you user name as the default name) and press “Go” in the Cash Application Work Queue, no results appear.

Steps to Reproduce:
Responsibility:  Receivables
Navigation:  Setup > Receipts > Cash Application Owner Assignment
1. Verify that a Cash Application rule is created and assigned to Cash Application owner.
2. After the rule is assigned to the owner, run the concurrent process 'Assign Cash Application Work Items'
3. Verify that the above program completed successfully.
4. Cash application work queue shows no results.

The logfile for ARCAOAB module: Assign Cash Application Work Items shows the following errors:

ar_cao_assign_pkg.assign_work_items (+)
Operating Unit : 82
Receipt Date From :
Receipt Date To :
Customer Profile Class :
Max Workers :
Worker Number :
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, hl.country, 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,1) = decode( 1, 0, acr.cash_receipt_id, mod(0,1)) AND acr.org_id = 82
Number of records: 6
Invoking Rule Engine
ORA-00936: missing expression

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