Personalization for Receiving Transactions Summary(RCVRCVRC) Causes ORA-1403, FRM-40735

(Doc ID 2334513.1)

Last updated on DECEMBER 08, 2017

Applies to:

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

Symptoms

Actual Behavior
The following error occurs when customer applied the form personazation on Receiving Transactions Summary form (RCVRCVRC)
ORA-01403: no data found
FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exeption ORA-06502

Steps
1. PO(N)Receiving > Receiving Transactions Summary
2. Add the form personalization and apply, save it
Example:
Function Name: RCV_RCVRCVRC
Trigger Event: WHEN-NEW-FORM-INSTANCE
Actions:
10: Property:
Object Type: Block
Target Object: LINES_FOLDER
Property Name: DEFAULT_WHERE
Value:
EXISTS(
/* String to let personalized DEFAULT_WHERE length longer */
SELECT
'12345678901234567890123456789012345678901234567890123456789012345678901234567
890123456789012345678901234567890123456789012345678901234567890123456789012345
678901234567890123456789012345678901234567890123456789012345678901234567890123
4567890123456789012345678901234567890123456789012345678901234567890' FROM
DUAL
)
3. PO(N)Receiving > Receiving Transactions Summary
Find Receiving Transactions
Item tab
Result: Headers is selected
Enter the PO number or Receipt number, click Find
4. Click Transactions button
-> The error occurs

If Result: Transactions is selected in step3, the error does not occur.

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