Oracle Apps Technical Information

Very simple procedures can be created which have this API used in it to create and add responsibility to the user. Step 1 : Simple procedure (anonymous block) to create a new user  : DECLARE v_user_name VARCHAR2 (100) := upper(‘&Enter_User_Name’); v_description VARCHAR2 (100) := ‘NEW Test User'; BEGIN fnd_user_pkg.createuser (x_user_name => v_user_name, x_owner => NULL, x_unencrypted_password => ‘&input_password’, x_session_number => 0, x_start_date => SYSDATE, x_end_date => NULL, x_last_logon_date => NULL, x_description => v_description, x_password_date => NULL, x_password_accesses_left => NULL, x_password_lifespan_accesses => NULL, x_password_lifespan_days => NULL, x_employee_id => NULL, x_email_address => NULL, x_fax => NULL, x_customer_id => NULL, x_supplier_id => NULL, x_user_guid => NULL, x_change_source => NULL ); COMMIT; END; / SHOW ERR; The above procedure will ask for ‘User_na...

/* Formatted on 2015/11/06 17:29 (Formatter Plus v4.8.8) */ SELECT ORGANIZATION_code , secondary_inventory_name, description, status_code,        default_cost_group_name,        DECODE (quantity_tracked, 1, 'Y', 2, 'N') quantity_tracked,        DECODE (asset_inventory, 1, 'Y', 2, 'N') asset_inventory,        DECODE (depreciable_flag, 1, 'Y', 2, 'N') depreciable_flag,        DECODE (inventory_atp_code, 1, 'Y', 2, 'N') inventory_atp_code,        DECODE (reservable_type, 1, 'Y', 2, 'N') reservable_type,        DECODE (availability_type, 1, 'Y', 2, 'N') availability_type,        DECODE (planning_level, 1, 'Y', 2, 'N') planning_level,        DECODE (default_count_type_code,                1, 'Y',                2, 'N' ...

Useful Script for Oracle Shipping Network , I wrote custom function for GL Code , you may find below SELECT a.from_organization_code, a.from_organization_name,        a.to_organization_code, a.to_organization_name,  DECODE (a.intransit_type,                  2, 'Intransit',                  1, 'Direct'                 ) "Transfer Type",        (SELECT meaning           FROM apps.mfg_lookups          WHERE lookup_type = 'MTL_FOB_POINT'            AND lookup_code = a.fob_point) fob_point,        a.elemental_visibility_enabled, DECODE (a.routing_header_id,                  1, 'Standard',                  2, 'Insp...