Default value for importing flex fields through WebADI

This small example shows how you can make the following as default options for the WebADI uploads :-

Import Flex fields : by default it should be enabled for all the uploads.

Import Flex fields without validation : by default is should be enabled for all the uploads.

Steps :-

1. Goto System Administrator > Application > Function.

2. Search for the following function using CTRL+F11 : "BNE_CREATE_DOCUMENT"

3. Go to the "Form" tab on the form functions window.

4. Put the following value in the parameters text box : bne:page=BneCreateDoc&bne:validation=True&bne:import=True&bne:importFlex=IMPORTNOVALIDATION

5. Save the changes and you are done. Now whenever you upload the WebADI template, you will find the default option is set to Import Flexfields and without validations.



Key flexfield (KFF) validation in custom webadi template

I executed the following steps to  accomplish the validation of key flexfields :-

Step1 :- In the main procedure for the custom integrator, added a column which is not a table mapped column before registering the integrator. This column will only be present in the layout.Eg:- segment_name.

Step2 :- Updated the following columns of the bne_interface_cols_b for column(segment_name) mentioned in step1 using the update api present in the package BNE_INTERFACE_COLS_PKG.

LOV_TYPE='STANDARD',

OFFLINE_LOV_ENABLED='Y',

VAL_OBJ_NAME='oracle.apps.bne.integrator.validators.BneAccountingFlexValidator',

GROUP_NAME='TEST',

OA_FLEX_CODE='GL#' (code of KFF),

OA_CONCAT_FLEX='N'(to keep values in separate column on upload)

VAL_TYPE='KEYFLEX',

VAL_COMPONENT_CODE='OA_FLEX',

VAL_COMPONENT_APP_ID='231',

OA_FLEX_APPLICATION_ID='101'(application id of KFF),

DATA_TYPE=null,

UPLOAD_PARAM_LIST_ITEM_NUM=null

Step3 :- Updated the bne_interface_cols_b  for the child fields or table mapped fields for which the column created in step1 is parent using the package BNE_INTERFACE_COLS_PKG.Columns which should be updated :

DISPLAY_FLAG='N',

GROUP_NAME='TEST' (one created for parent),

VAL_TYPE='KEYFLEXSEG'.

Step4: Created the layout using Oracle WebADI responsibility and added the parent column in the layout. After  downloading the webadi, the parent column was an LOV(KFF) validated field and the data from the LOV(KFF) will be mapped to the child table mapped columns on upload.