UOM Conversion

A unit of measure conversion is a mathematical relationship between two different units of measure. For example, 12 Each = 1 Dozen. If you want to transact items in units of measure belonging to classes other than their primary UOM class, you must define conversions between the base units of measure in different UOM classes.

API for UOM Conversion

Method 1:

DECLARE lv_conv NUMBER; --converted quantity BEGIN -- lv_conv := inv_convert.inv_um_convert( item_id => 494031, organization_id => 9932, PRECISION => 5, from_quantity => 40, -- source quantity from_unit => 'DZ', to_unit => 'EA', from_name => NULL, to_name => NULL); -- IF lv_conv = -99999 THEN -- raise_application_error ( -20101, 'Error!! No UOM Conversion rule exists'); -- END IF; dbms_output.put_line('Converted Quantity lv_conv: '|| lv_conv); END; /

Function would return -99999 if no UOM conversion defined for given parameters in UOM conversion setup.


Method 2:
There is one other overloaded function which has only 3 parameters item_id, from uom and to uom

Function Signature:

FUNCTION inv_um_convert( p_item_id IN NUMBER, p_from_uom_code IN VARCHAR2, p_to_uom_code IN VARCHAR2) RETURN NUMBER;

Example:

SELECT msi.segment1, msi.primary_uom_code, 'DZ' AS second_uom, inv_convert.inv_um_convert (msi.inventory_item_id, 'DZ', msi.primary_uom_code) AS conversion FROM mtl_system_items_b msi WHERE msi.segment1 = 'MANGOES';

More about UOM Conversion:http://docs.oracle.com/cd/E18727_01/doc.121/e13450/T291651T291797.htm

select * from MTL_UOM_CONVERSIONS

FNDLOAD

Form Personalization:

FNDLOAD apps/V6wLB4lh 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct XHL_IBOM_FP.ldt FND_FORM_CUSTOM_RULES function_name=ICR01USR_F

FNDLOAD apps/V4yOC2lb 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XHL_IBOM_FP.ldt

Concurrent Program:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XHXXXXX_CP.ldt PROGRAM APPLICATION_SHORT_NAME="XXXX" CONCURRENT_PROGRAM_NAME="Xxxxxxx"

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

Request Group:
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct XHLMBRATRPKG_RG.ldt REQUEST_GROUP REQUEST_GROUP_NAME="OPM GMD Request Group" APPLICATION_SHORT_NAME="GMD" REQUEST_GROUP_UNIT UNIT_TYPE="P" UNIT_APP="XXXX" UNIT_NAME="XHXXXXX"

FNDLOAD apps/password O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XHLMBRATRPKG_RG.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

Data Definition and Associated Template :
FNDLOAD apps/apps O Y DOWNLOAD  $XDO_TOP/patch/115/import/xdotmpl.lct XHXXXXX_DD_DT.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='XXXXL' DATA_SOURCE_CODE='XHXXXXXX' TMPL_APP_SHORT_NAME='XXXXl' TEMPLATE_CODE='XHXXXXX'

Datadefination and Associated Template(sub templates)  :
FNDLOAD apps/Z0uNE9le 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XHLEPOFP_DD_DT.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME="XXHL" DATA_SOURCE_CODE="XHLEPOFP"
FNDLOAD apps/apps 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XHLMBRATRPKG_DD_DT.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

RTF Upload Script:
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps  -DB_PASSWORD $1 -JDBC_CONNECTION $2:$3:$4 -LOB_TYPE 'TEMPLATE_SOURCE'  -APPS_SHORT_NAME XXHL -LOB_CODE XHXXXXX -LANGUAGE en -TERRITORY US -XDO_FILE_TYPE RTF  -FILE_CONTENT_TYPE 'application/rtf' -FILE_NAME XHXXXL.rtf -CUSTOM_MODE FORCE

Lookup :
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XXCUST" LOOKUP_TYPE="XX_LOOKUP_TYPE"


FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

Data Definition and Multiple Template :

FNDLOAD apps/xxxxx 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XHLPEPORCN_dd_dt.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=XXHL DATA_SOURCE_CODE=XHLPEPORCN

Lexical Parameter Validation in After Parameter Trigger In Report Builder

if :P_CATG_FROM is  null and :P_CATG_TO is  null  then

                :LP_CATEGORY  :=  'and  1=1 ';

    elsif :P_CATG_FROM is not null and :P_CATG_TO is null then

                :LP_CATEGORY := 'and mc.CATEGORY_CONCAT_SEGS >= :P_CATG_FROM';

    elsif :P_CATG_FROM is null and :P_CATG_TO is not null then

                :LP_CATEGORY := 'and mc.CATEGORY_CONCAT_SEGS <= :P_CATG_TO';

    else

                :LP_CATEGORY  := 'and mc.CATEGORY_CONCAT_SEGS BETWEEN :P_CATG_FROM AND  :P_CATG_TO';   

                end if;

Convert Clint Time zone

SELECT TO_CHAR
          (hz_timezone_pub.convert_datetime
                     (fnd_profile.VALUE ('SERVER_TIMEZONE_ID'),
                      NVL (fnd_profile.value_specific ('CLIENT_TIMEZONE_ID',3842
--                                                       fnd_global.user_id
                                                      ),
                           fnd_profile.VALUE ('SERVER_TIMEZONE_ID')
                          ),
                      TO_DATE (   TO_CHAR (:p_date,
                                           'DD/MON/YYYY'
                                          )
                               || ' '
                               || TO_CHAR ((SYSDATE), 'HH24:MI:SS'),
                               'DD-MM-YYYY HH24:MI:SS'
                              )
                     ),
           'DD-MON-YYYY HH24:MI:SS'
          ) expiry_date
  FROM DUAL