Transactions Workbench: Customer Name Selected in Transaction Window Error - FRM-40735 ORA-01403 ORA-06502
(Doc ID 1547507.1)
Last updated on APRIL 04, 2025
Applies to:
Oracle Receivables - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
Attempting to select a customer in the Transactions form and receive the following error:
ORA-01403: no data found
--------------------------------------------------------------
FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-06502.
This is due to the sql below.
This sql is found at ARXTWMAI_FOLDER_CUST_BILL_ADDR (ARXTWMAI.pld),get_default_bill_to_addr:
If combination of LOC.ADDRESS3 || CHR(44) || CHR(32) || LOC.ADDRESS4 || CHR(44) || CHR(32) || LOC.CITY || CHR(44) || CHR(32) || NVL(LOC.STATE, LOC.PROVINCE) || ' ' || LOC.POSTAL_CODE || CHR(32) || T.TERRITORY_SHORT_NAME does exceed 240 bytes, then this error occurs.
With the Japanese or other countries, characters used obtain 3 bytes per char. Therefore 240 bytes can be exceeded easily.
Steps to reproduce:
Responsibility: Receivables
Navigation: Transactions > Transactions
Go To: Bill to Customer Name > Query Name
Click on Next with tab key or LOV selection
Error occurs
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 |
| Cause |
| Solution |
| 1. Bug Summary |
| 2. Fixed Files |
| 3. Recommended Patches |
| 4. Solution Steps |
| Still Have Questions? |
| References |