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

Last updated on AUGUST 04, 2016

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information 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

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 hundreds of Community platforms