My Oracle Support Banner

WHEN-VALIDATE-RECORD Trigger is Not Firing On the Form HZ Locations (CSIHZLOC.fmb) (Doc ID 1349488.1)

Last updated on JULY 14, 2020

Applies to:

Oracle Asset Tracking - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Support Codes

WHEN-VALIDATE-RECORD Trigger is not firing on the Form HZ Locations (CSIHZLOC.fmb)

Steps to Reproduce:

Responsibility: Asset Tracking Super User
Navigation: Setup -> Define Location

1. Enter Country, Address1, Address2, Address3
2. Place the cursor on the "Location Code" column
3. Personalize the form HZ Locations (CSIHZLOC.fmb) using following steps
    a. Go to help -> Diagnostics -> Custom Code -> Personalize
    b. Select Trigger Event 'WHEN-VALIDATE-RECORD'
        Trigger Object -> HZ_LOCATIONS
        Processing Mode -> Not in Enter Query Mode
    c. Click on Actions Tab
        Object Type  -> Item
        Target Object  -> HZ_LOCATIONS.CLLI_CODE
        Property Name  -> VALUE
        Value -> :HZ_LOCATIONS.ADDRESS1||:HZ_LOCATIONS.ADDRESS2|| 
                        :HZ_LOCATIONS.ADDRESS3
      d. Save the form
      e. Close the form
4. Open the form and test the functionality

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
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.