Credit Memo Workflow Fails With 'ARP_CMREQ_WF.FindReceivableApprover' -- Arcmreq/50 Ora-01403: No Data Found Or 'User FND_RESP|AR|RECEIVABLE_ROLE|ST does not exist' (Doc ID 363984.1)

Last updated on APRIL 24, 2023

Applies to:

Symptoms

When attempting to create a credit memo the first time from a dispute in iReceivables it stucks during approval with following error:

"Error in Workflow ARCMREQ/50 ORA-01403: no data found ORA-01403: no data found".
The error occurs in 'ARP_CMREQ_WF.FindReceivableApprover'.

or

'User FND_RESP|AR|RECEIVABLE_ROLE|ST does not exist'

STEPS
The issue can be reproduced at will with the following steps:
1. iReceivables responsibility
2. Query any invoice
3. Add a dispute against this invoice and click submit.
==> approval process is invoked and sends a notification to the collector and then to the final approver/receivable role.
After this it fails with one of the above error messages depending on the version you are on.

This never worked and you are trying to use this functionality the first time. 

Changes

New implementation of iReceivables Dispute Functionality

Cause

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