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

Last updated on MARCH 01, 2023

Applies to:

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

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