Step 1: Create Database Function
CREATE OR REPLACE FUNCTION APPS.XXBEX_GEN_BATCH_NUM
(
p_organization IN VARCHAR2
,p_item IN VARCHAR2
,p_order_number IN VARCHAR2
,p_parent_batch IN VARCHAR2
,p_pack_number IN VARCHAR2
)
RETURN VARCHAR2
Step 2: Open Forms Personalization
Step 3: Forms Personalization - Action
To call the Function
