To setup a foreign key reference, open
.Description of Page
Enter an easily recognizable FK (foreign key) Reference code and Description for the table.
Enter the name of the Table whose primary key is referenced. After selecting a Table, the columns in the table's primary key are displayed adjacent to Table PK Sequence.
Use Navigation Option to define the page to which the user will be transferred when they press the go to button or hyperlink associated with the referenced entity. Refer to Navigation Information Is Dynamically Derived for more information on how this is used.
The Info Program Type indicates whether the default program that returns the standard information description is Java or Java (Converted), meaning it was converted into Java.
Use Info Program Name to enter the Java class / program name.
Refer to Information Description Is Dynamically Derived for more information on the info program is used.
Use Context Menu Name to specify the context menu that appears to the left of the value.
Use Search Navigation Key to define the search page that will be opened when a user searches for valid values on a user interface that is a fixed page. Refer to Search Options for more information.
Use Search Type to define the default set of search criteria used by the Search Navigation Key's search page.
Use Search Zone to define the search zone that opens when a user searches for valid values when the foreign key reference is configured as an input field on a portal based page. Refer to Search Options for more information.
Use Search Tooltip to define a label that describes the Search Navigation Key's search page.
Where Used
Follow this link to open the data dictionary where you can view the tables that reference CI_FK_REF.
Copyright © 2007, 2016, Oracle and/or its affiliates. All rights reserved. Documentation build: 2.5.2016 10:21:45 [T1_1454696505000]