How to Set fields in the web adi template value list

The current version of web adi does not support user-defined value lists. However, if there is no value list, the user experience is relatively low.

Oracle web adi supports two types of value lists: drop-down menu and Standard Value List (pop-up window ). The first setting is relatively simple, and the second type requires JAVA. This chapter describes how to set the drop-down menu.

1) define VIEW:

Create or replace view FSC_INTERFACE_COLUMNS_V
Select INTG. APPLICATION_ID
, INTG. INTEGRATOR_CODE
, INTG. USER_NAME
, INTG. DATE_FORMAT
, INTC. INTERFACE_CODE
, INTC. SEQUENCE_NUM
, INTC. DISPLAY_ORDER
, INTC. INTERFACE_COL_NAME
, INTC. REQUIRED_FLAG
, INTC. DISPLAY_FLAG
, INTC. READ_ONLY_FLAG
, INTC. NOT_NULL_FLAG
, INTC. DATA_TYPE
, INTC. FIELD_SIZE
, INTC. DEFAULT_TYPE
, INTC. DEFAULT_VALUE
, INTC. VAL_TYPE
, INTC. VAL_ID_COL
, INTC. VAL_MEAN_COL
, INTC. VAL_DESC_COL
, INTC. VAL_OBJ_NAME
, INTC. VAL_ADDL_W_C
, INTC. VAL_COMPONENT_APP_ID
, INTC. VAL_COMPONENT_CODE
, INTC. LOV_TYPE
, INTC. OFFLINE_LOV_ENABLED_FLAG
, INTC. USER_HINT
, INTC. PROMPT_LEFT
, INTC. prompt_abve
From BNE_INTERFACE_COLS_vl INTC
, BNE_INTERFACES_VL INTF
, BNE_INTEGRATORS_VL INTG
Where INTC. INTERFACE_CODE = INTF. INTERFACE_CODE
And intf. INTEGRATOR_CODE = INTG. INTEGRATOR_CODE;

2) define a PACKAGE for modifying the web adi setting Variables

PACKAGE FSC_PACKAGES is

-- Author: AHUNGHUO
-- Created: 2007-9-15 16:26:50
-- Public type declarations
--####################################### #####################################
Procedure pop_interface_cols (
P_APPLICATION_ID NUMBER
, P_INTEGRATOR_CODE VARCHAR2
, P_USER_NAME VARCHAR2
, P_DATE_FORMAT VARCHAR2
, P_INTERFACE_CODE VARCHAR2
, P_SEQUENCE_NUM VARCHAR2
, P_INTERFACE_COL_NAME VARCHAR2
, P_REQUIRED_FLAG VARCHAR2
, P_DISPLAY_FLAG VARCHAR2
, P_READ_ONLY_FLAG VARCHAR2
, P_NOT_NULL_FLAG VARCHAR2
, P_DATA_TYPE VARCHAR2
, P_FIELD_SIZE VARCHAR2
, P_DEFAULT_TYPE VARCHAR2
, P_DEFAULT_VALUE VARCHAR2
, P_VAL_TYPE VARCHAR2
, P_VAL_ID_COL VARCHAR2
, P_VAL_MEAN_COL VARCHAR2
, P_VAL_DESC_COL VARCHAR2
, P_VAL_OBJ_NAME VARCHAR2
, P_VAL_ADDL_W_C VARCHAR2
, P_VAL_COMPONENT_APP_ID VARCHAR2
, P_VAL_COMPONENT_CODE VARCHAR2
, P_DISPLAY_ORDER VARCHAR2
, P_LOV_TYPE VARCHAR2
, P_OFFLINE_LOV_ENABLED_FLAG VARCHAR2
, P_USER_HINT VARCHAR2
, P_PROMPT_LEFT VARCHAR2
, P_prompt_abve VARCHAR2
);
End FSC_PACKAGES;

Package body FSC_PACKAGES is

--####################################### #####################################
Procedure pop_interface_cols (
P_APPLICATION_ID NUMBER
, P_INTEGRATOR_CODE VARCHAR2
, P_USER_NAME VARCHAR2
, P_DATE_FORMAT VARCHAR2
, P_INTERFACE_CODE VARCHAR2
, P_SEQUENCE_NUM VARCHAR2
, P_DISPLAY_ORDER VARCHAR2
, P_INTERFACE_COL_NAME VARCHAR2
, P_REQUIRED_FLAG VARCHAR2
, P_DISPLAY_FLAG VARCHAR2
, P_READ_ONLY_FLAG VARCHAR2
, P_NOT_NULL_FLAG VARCHAR2
, P_DATA_TYPE VARCHAR2
, P_FIELD_SIZE VARCHAR2
, P_DEFAULT_TYPE VARCHAR2
, P_DEFAULT_VALUE VARCHAR2
, P_VAL_TYPE VARCHAR2
, P_VAL_ID_COL VARCHAR2
, P_VAL_MEAN_COL VARCHAR2
, P_VAL_DESC_COL VARCHAR2
, P_VAL_OBJ_NAME VARCHAR2
, P_VAL_ADDL_W_C VARCHAR2
, P_VAL_COMPONENT_APP_ID VARCHAR2
, P_VAL_COMPONENT_CODE VARCHAR2
, P_LOV_TYPE VARCHAR2
, P_OFFLINE_LOV_ENABLED_FLAG VARCHAR2
, P_USER_HINT VARCHAR2
, P_PROMPT_LEFT VARCHAR2
, P_prompt_abve VARCHAR2
) IS
BEGIN
UPDATE BNE_INTERFACE_COLS_ B
Set B. REQUIRED_FLAG = P_REQUIRED_FLAG
, B. DISPLAY_FLAG = P_DISPLAY_FLAG
, B. READ_ONLY_FLAG = P_READ_ONLY_FLAG
, B. NOT_NULL_FLAG = P_NOT_NULL_FLAG
, B. DATA_TYPE = P_DATA_TYPE
, B. FIELD_SIZE = P_FIELD_SIZE
, B. DEFAULT_TYPE = P_DEFAULT_TYPE
, B. DEFAULT_VALUE = P_DEFAULT_VALUE
, B. VAL_TYPE = P_VAL_TYPE
, B. VAL_ID_COL = P_VAL_ID_COL
, B. VAL_MEAN_COL = P_VAL_MEAN_COL
, B. VAL_DESC_COL = P_VAL_DESC_COL
, B. VAL_OBJ_NAME = P_VAL_OBJ_NAME
, B. VAL_ADDL_W_C = P_VAL_ADDL_W_C
, B. VAL_COMPONENT_APP_ID = P_VAL_COMPONENT_APP_ID
, B. VAL_COMPONENT_CODE = P_VAL_COMPONENT_CODE
, B. DISPLAY_ORDER = P_DISPLAY_ORDER
, B. LOV_TYPE = P_LOV_TYPE
, B. OFFLINE_LOV_ENABLED_FLAG = P_OFFLINE_LOV_ENABLED_FLAG
Where B. INTERFACE_CODE = P_INTERFACE_CODE
And B. SEQUENCE_NUM = P_SEQUENCE_NUM;

UPDATE BNE_INTERFACE_COLS_TL T
Set t. USER_HINT = P_USER_HINT
, T. PROMPT_LEFT = P_PROMPT_LEFT
, T. prompt_abve = p_prompt_abve
Where t. INTERFACE_CODE = P_INTERFACE_CODE
And t. SEQUENCE_NUM = P_SEQUENCE_NUM;
COMMIT;
END;
Begin
Null;
End FSC_PACKAGES;

3) register the configuration file. Use create document in web adi's responsibility and select "HR integrator Settings ". The parameters are as follows:

Metadata type	UPDATE
Application abbreviation	CUX
Integrator User Name	FSC _ maintenance configurator line parameters
View name	FSC_INTERFACE_COLUMNS_V
Form name	GENERAL
API package name	FSC_PACKAGES
API process name	Pop_interface_cols
User Name	FSC_INTG_COL_INTF
Interface parameter list name	FSC_INTG_COL_PARALIST
API type	PROCEDURE
API return type

4) associate with functions and assign permissions (omitted)

5) set an independent query. Use create document in web adi's responsibility and select "HR maintenance independent query ". The parameters are as follows:

Application abbreviation	CUX
Integrator User Name	FSC _ maintenance configurator line parameters
SQLWHERE clause	Where username like $ PARAM $. CUX: UserNameLike
Name of 1st Parameters	CUX: UserNameLike
Type of 1st Parameters	Varchar2
1st parameter prompts	User Name of the Configurator

6) set Layout to display all columns (Omitted) and select any fields to be displayed and changed. If the VIEW has this field and the Procedure parameter does not, it is only used as the display content and cannot be modified.

7) set mapping, especially when the field name of the VIEW is inconsistent with the parameter name of Procedure, it must be set manually. The system automatically matches all the parameters of Procedure (the first two characters in the cropping) with the field name of the VIEW. If there is any inconsistency or special ing is required, you must manually specify it.

In this example, because the VIEW field name and PROCEDURE parameter name are identical, you do not need to change the default settings.

8) create the "FSC _ maintenance configurator line parameters" document to start setting the value list.

In the field where you want to set the value list, change the parameter from VAL_TYPE to OFFLINE_LOV_ENABLED_FLAG. Description:

Parameter Name	Parameter description	Example
VAL_TYPE	Value List data source, which is obtained from the Oracle database. Select TABLE	TABLE
VAL_ID_COL	Fields passed to program parameters	LOOKUP_CODE
VAL_MEAN_COL	Fields displayed in EXCEL	MEANING
VAL_DESC_COL	Description field	DESCRIPTION
VAL_OBJ_NAME	Name of the table in which the Value List is located	FND_LOOKUPS
VAL_ADDL_W_C	WHERE statement	LOOKUP_TYPE = 'Yes _ no'
VAL_COMPONENT_APP_ID	Application ID of a component. If you do not have strict format requirements, you can select any common component. For example, 231	231
VAL_COMPONENT_CODE	Component name. If you have no strict requirements on the format, you can select any common component. For example, OA_REVERSE_JOURNAL	OA_REVERSE_JOURNAL
LOV_TYPE	Value List type. Uniform Selection: POPLIST	POPLIST
OFFLINE_LOV_ENABLED_FLAG	Is an EXCEL worksheet available when it is edited offline?	Y

After modification, upload the file.

9) Restart APACHE and download the document input form again to see the changes.