ResetFormPanel is a function that can be used in Client Side UI Rule to get a dynamic form panel based on some data value. e.g You can have the address entry form render dynamically based on the country selection

ResetFormPanel

ResetFormPanelJapan

 

Reset Form Panel

Syntax

ResetFormPanel('Item Id', 'Model Variable Name', Use View Attribute (boolean))

Example

ui(
  InitModel('someModelVariableName', 'AddressStyles'), 
  SetModelValue('someModelVariableName', 'territorycode', #{Addresses.country}), 
  InvokeQueryService('as', 
    callback( null  /* user is already notified with the error message popup */ , ResetFormPanel('formPanelItemId', 'someModelVariableName'))
  )
)

Where AddressStyles is a Data Source with the following attributes

itemId This should match the itemId of the field within the FormPanel
fieldLabel (optional) 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

AddressStyles DataSource can be defined on top of the following view to dynamically render the Address Form based on the Address flexfield definition in Oracle EBS.

CREATE VIEW ADDRESS_STYLES_V
(
   TERRITORY_CODE,
   FIELD_LABEL,
   ITEM_ID,
   ALLOW_BLANK
)
AS
     SELECT   t.territory_code,
              s.end_user_column_name field_label,
              'ea'
              || DECODE (
                    s.application_column_name,
                    'POSTAL_CODE',
                    DECODE (t.territory_code,
                            'US', 'USPOSTALCODE',
                            'POSTALCODE'),
                    REPLACE (s.application_column_name, '_', '')
                 )
                 item_id,
              DECODE (s.required_flag, 'Y', 'N', 'Y') allow_blank
       FROM   fnd_descr_flex_col_usage_vl s, fnd_territories_vl t
      WHERE   s.application_id = 222
              AND s.descriptive_flexfield_name = 'Remit Address HZ'
              AND s.descriptive_flex_context_code =
                    NVL (t.address_style, 'POSTAL_ADDR_DEF')
              AND s.enabled_flag = 'Y'
              AND s.display_flag = 'Y'
   ORDER BY   t.territory_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