ResetDynamicFormPanel is a function that can be used in the Client Side UI Rule to dynamically render a form panel based on runtime data.

ResetDynamicFormPanel

 

ResetDynamicFormPanelRule

Syntax

ResetDynamicFormPanel('Item Id', 'Model Variable Name')

Example

ui(
	InitModel('someModelVariableName', 'OrderLineDFF'), 
	SetModelValue('someModelVariableName', 'dffcontext', #{OrderLines.context}), 
	InvokeQueryService('someModelVariableName', 
		callback( null  /* user is already notified with the error message popup */ , 
			ui(
				ResetDynamicFormPanel('OrderLinesDFFPanel1', 'someModelVariableName'),
				ResetDynamicFormPanel('OrderLinesDFFPanel2', 'someModelVariableName'),
				ResetDynamicFormPanel('OrderLinesDFFPanel3', 'someModelVariableName')
			)
		)
	)
)

Where OrderLineDFF is a Data Source with the following attributes

itemId (Not required) Will be autogenerated with the itemId of the FormPanel + "_" + viewAttribute
viewAttribute Used to set the view attribute value of the generated field
dataType (optional) N for NumberField, D for DateField, else a TextField will be rendered
valueSetId (optional) If specified, a ComboBox will be rendered with Combo DataSource FNDFlexValues with value attribute "flexvalue", display attribute "flexvaluemeaning" and with a where clause of #flexvaluesetid# = valueSetId
fieldLabel Used to update the Field's label
emptyText (optional) Used to set the Field's empty text
maxLength (optional) (Number) Used to set the Field's max length property
minLength (optional) (Number) Used to set the Field's minimum length property
allowBlank (optional) (Y/N) If N, the field will become a mandatory field
visible (optional) (Y/N) If N, the field will be hidden

OrderLineDFF DataSource can be defined on top of the following view to dynamically render the Order Lines DFF Form Panel based on the DFF definition in Oracle EBS.

CREATE VIEW OE_ORDER_LINE_DFF_V
(
   dff_context,
   field_label,
   view_attribute,
   allow_blank,
   flex_value_set_id
) AS
     SELECT   s.descriptive_flex_context_code dff_context,
              s.end_user_column_name field_label,
              LOWER (REPLACE (s.application_column_name, '_', '')) view_attribute,
              DECODE (s.required_flag, 'Y', 'N', 'Y') allow_blank,
              s.flex_value_set_id
       FROM   fnd_descr_flex_col_usage_vl s
      WHERE   s.application_id = 660 
        AND s.descriptive_flexfield_name = 'OE_LINE_ATTRIBUTES' 
        AND s.enabled_flag = 'Y' AND s.display_flag = 'Y'
   ORDER BY   DECODE (s.descriptive_flex_context_code, 'Global Data Elements', '0', s.descriptive_flex_context_code)
      , s.column_seq_num;

Location

101 California Street, Suite 2710
San Francisco, CA 94111


440 N. Wolfe Rd.
Sunnyvale, CA 94085


Office 11, 5th Floor, Building 9,
Mindspace IT Park
Hyderabad 500081

p: +1 (844) AT CloudIO (844-282-5683)
f: +1 (650) 300-5247 | e: sales@cloudio.io
© 2009, 2017 CloudIO Inc. | Terms of Use | Privacy Policy