My Oracle Support Banner

Personalization 'WHEN-VALIDATE-RECORD' is not triggered in the inter-org transfer form (INVTTMTX) (Doc ID 2736568.1)

Last updated on DECEMBER 13, 2020

Applies to:

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

Symptoms

Personalization 'WHEN-VALIDATE-RECORD' is not triggered in the inter-org transfer form (INVTTMTX).
*The same issue occurs for subinventory transfer.

Trigger Event: WHEN-VALIDATE-RECORD
Trigger Object: INTERORG_XFER


EXPECTED BEHAVIOR
If the entered number within the below query the user should be able to continue by Transaction Lines otherwise the personalization should stop him by error message "The entered SO number not exist" but unfortunately the personalization is not working

select distinct ORDER_NUMBER
from oe_order_headers_all hd,
  oe_order_lines_all lin
where hd.header_id = lin.header_id
and lin.FLOW_STATUS_CODE = 'AWAITING_SHIPPING'

STEPS
1. Inventory > Transactions > Inter org transfer > Enter container number

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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