Oracle Applications Blog

SET SERVEROUTPUT ON BEGIN    fnd_user_pkg.addresp (username         => 'USERNAME',                          resp_app         => 'SYSADMIN',                          resp_key         => 'SYSTEM_ADMINISTRATOR',                          security_group   => 'STANDARD',                          description      => 'DESCRIPTION',                          start_date       => SYSDATE,                          end_date         => ...

Due to introduction of Online Patching, Post 12.2.x version, there are certain steps to be followed while creating Custom Table. 1. For new table creations - after creating the table in custom schema execute below script to generate edition view and synonym for it in APPS schema. exec AD_ZD_TABLE.UPGRADE('xxcust_schema','xxcust_Table'); 2. For table alterations - after running the DDL run below script to regenerate the edition view for synchronizing any table changes. exec AD_ZD_TABLE.PATCH('xxcust_schema','xxcust_table') 3. Table grants must be done through API to avoid invalids. exec AD_ZD.GRANT_PRIVS('SELECT','xxcust_table,'xx_role') 4. To view objects in all editions, add "_ae" to the data dictionary views select * from user_objects_ae; 5. To update seed data tables in Patch edition, execute prepare command. example:  exec ad_zd_seed.prepare('WF_MESSAGES');  The prepare Procedure will creat...

SELECT LEVEL,                   LPAD (' ', (LEVEL-1)*3)||prompt,                   Description     FROM  fnd_menu_entries_vl fme  WHERE  prompt IS NOT NULL        AND grant_flag='Y'       AND NOT EXISTS (SELECT 1                      FROM fnd_resp_functions frf,                           fnd_responsibility_vl frv                     WHERE frv.responsibility_id = frf.responsibility_id                       AND frf.application_id = frv.application_id                       AND frf.rule_type='M'                  ...

SELECT fu.user_name                "User Name",        frt.responsibility_name     "Responsibility Name",        furg.start_date             "Start Date",        furg.end_date               "End Date",             fr.responsibility_key       "Responsibility Key"   FROM fnd_user_resp_groups_direct        furg,        fnd_user                   fu,        fnd_responsibility_tl      frt,        fnd_responsibility         fr  WHERE furg.user_id             =  fu.user_id    AND furg.responsibility_id   =...

Below Script displays the list of Responsibility to which the concurrent Program is attached SELECT frt.responsibility_name,   frg.request_group_name,   frgu.request_unit_type,   frgu.request_unit_id,   fcpt.user_concurrent_program_name FROM  fnd_Responsibility fr,   fnd_responsibility_tl frt,   fnd_request_groups frg,   fnd_request_group_units frgu,   fnd_concurrent_programs_tl fcpt WHERE  frt.responsibility_id = fr.responsibility_id   AND  frg.request_group_id = fr.request_group_id   AND  frt.language = USERENV('LANG')   AND  fcpt.language= USERENV('LANG')   AND  frgu.request_group_id = frg.request_group_id   AND  fcpt.concurrent_program_id = frgu.request_unit_id   AND  fcpt.user_concurrent_program_name = '&conc_program_name' ORDER BY 1,2,3,4

Below Script is used to reset password from Back-end SET SERVEROUTPUT ON; DECLARE    v_user_name          VARCHAR2 (30) := UPPER ('USERNAME');    v_new_password   VARCHAR2 (30) := 'Password123';    v_status                  BOOLEAN; BEGIN    v_status := fnd_user_pkg.ChangePassword (username      => v_user_name,                                                                          newpassword   => v_new_password);    IF v_status = TRUE    THEN       DBMS_OUTPUT.put_line ( 'The password reset successfully for the User:' || v_user_name);       COMMIT;    ELSE       D...

Creating this Blog to Post Oracle Application features, its ability to support Business Process.