My Oracle Support Banner

Transactions Workbench: Customer Name Selected in Transaction Window Error - FRM-40735 ORA-01403 ORA-06502 (Doc ID 1547507.1)

Last updated on JULY 10, 2020

Applies to:

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


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


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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?

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