Oracle Apps Technical Information

1) Query up your invoice source , which user have reported Jump in number. Navigate>Setup>Invoice>Source 2) Execute the following script using your source as in step 1.   SELECT batch_source_id, org_id, name FROM ra_batch_sources_all WHERE name LIKE '<source>' ;   or use this query if you have access from database.   SELECT 'alter sequence AR.' ||seq.sequence_name|| ' nocache;' FROM ( SELECT name bsname, org_id org, 'RA_TRX_NUMBER_' ||BATCH_SOURCE_ID|| '_' ||org_id|| '_S' seqname FROM RA_batch_sources_all ) src, dba_sequences seq WHERE src.seqname=seq.sequence_name AND seq.cache_size; ORDER BY org /     3) Using the batch_source_id from the above query , execute the followingscript:   SELECT sequence_owner, sequence_name, cache_size FROM all_sequences WHERE sequence_name LIKE 'RA_TRX_NUMBER%1146%' ;     4) Execute the following:   ALTER sequence SEQ...

Syntax : ln -s $FND_TOP/bin/fndcpesr Filename Ex: ln -s $FND_TOP/bin/fndcpesr XXOSVIEW Thanks Shagul

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...

Simple and basic interface script : Step 1: /* Formatted on 2015/10/19 12:28 (Formatter Plus v4.8.8) */ INSERT INTO inv.mtl_system_items_interface             (organization_id, process_flag, item_number, description,              transaction_type, set_process_id)    SELECT 84,                                               -- organization_id              1,                                                -- process_flag                segment1,                                        -- item_number ...

This is article will help to delete Concurrent Program and Executable ------------------------------------------------------------------------------- -- delete concurrent program definition and executable from back-end ------------------------------------------------------------------------------- -- syntax: --     delete_program    (program_short_name, application_short_name) --     delete_executable (program_short_name, application_short_name) ------------------------------------------------------------------------------- DECLARE   lv_prog_short_name    VARCHAR2(240);   lv_appl_short_name    VARCHAR2(240); BEGIN    -- set the variables first    lv_prog_short_name := 'XWSHRLODKRA';     -- concurrent program short name    lv_appl_short_name := 'WSH';          -- application short name    -- see if the program exists. if found, delete ...