R12: AR: When Attempting to Create a Refund for a Receipt the Following Error is Given: "Value entered is not valid for current field"
(Doc ID 3050395.1)
Last updated on OCTOBER 14, 2024
Applies to:
Oracle Receivables - Version 12.0.0 and laterInformation in this document applies to any platform.
Symptoms
When attempting to create a refund for a receipt the following error occurs:
Value entered is not valid for current field.
Going to Help > Diagnostics > Display Database Error shows:
FRM-40212: Invalid value for field REFUND_PARTY_NAME
The trace file shows the query not returning any rows:
PARSING IN CURSOR #140213768903240
SELECT p2.party_name, p2.party_number, p2.party_id FROM hz_parties p2 WHERE ( UPPER(PARTY_NAME) LIKE :1 AND (PARTY_NAME LIKE :2 OR PARTY_NAME LIKE :3 OR PARTY_NAME LIKE :4 OR PARTY_NAME LIKE :5)) AND ( p2.party_id IN (SELECT p.party_id FROM hz_parties p, hz_cust_accounts ca WHERE p.party_id = ca.party_id AND ca.cust_account_id = :6 UNION ALL SELECT /*+ ordered PUSH_PRED(pr) */ pr.related_party_id FROM hz_cust_accounts ca2, ar_paying_relationships_v pr WHERE ca2.party_id = pr.party_id AND ca2.cust_account_id = :7 AND sysdate BETWEEN NVL(pr.effective_start_date,sysdate) AND NVL(pr.effective_end_date,sysdate) ))
END OF STMT
EXEC #140213768903240
FETCH #140213768903240: r=0
SELECT p2.party_name, p2.party_number, p2.party_id FROM hz_parties p2 WHERE ( UPPER(PARTY_NAME) LIKE :1 AND (PARTY_NAME LIKE :2 OR PARTY_NAME LIKE :3 OR PARTY_NAME LIKE :4 OR PARTY_NAME LIKE :5)) AND ( p2.party_id IN (SELECT p.party_id FROM hz_parties p, hz_cust_accounts ca WHERE p.party_id = ca.party_id AND ca.cust_account_id = :6 UNION ALL SELECT /*+ ordered PUSH_PRED(pr) */ pr.related_party_id FROM hz_cust_accounts ca2, ar_paying_relationships_v pr WHERE ca2.party_id = pr.party_id AND ca2.cust_account_id = :7 AND sysdate BETWEEN NVL(pr.effective_start_date,sysdate) AND NVL(pr.effective_end_date,sysdate) ))
END OF STMT
EXEC #140213768903240
FETCH #140213768903240: r=0
Steps to Replicate:
- From a Receivables Responsibility navigate to Customers -> Relationship Manager
- Create a Relationship between two customers
- Go to Transactions -> Transactions
- Create an invoice for the supplier being sure the Paying Customer is the related customer
- Go to Receipts -> Receipts
- Create a receipt for the invoice created
- Go to Customers -> Relationship Manager
- End date the relationship between the two customers
- Go to Receipts -> Receipts
- Attempt to create a refund and the error will appear
Changes
A relationship between two customers was end dated.
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |