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 FEBRUARY 01, 2018

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!

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