Oracle Fusion HCM Cloud/EBS (HCM, Financial): SYSTEM ADMINISTRATOR and APPLICATION DEVELOPER

How to make a Concurrent Program WAIT untill completion of another Concurrent Program execution?

How to enable the MOAC parameter “Operating Unit” for a Concurrent Program in Oracle EBS R12

Disable the EBS Application

Creating a read only Responsibility
How to Make Responsibility Read Only in Oracle Apps
Read-only-responsibility-in-oracle
How to compile CUSTOM.pll in R12, below is the command.

BEGIN
   IF event_name = 'WHEN-NEW-FORM-INSTANCE'
   THEN
      IF fnd_profile.VALUE ('USER_NAME') = '<USER_NAME>'---------- disable by zaib
      THEN
         BEGIN                                       -- Begin Query Only Mode
            COPY ('Entering app_form.query_only_mode.', 'global.frd_debug');
            COPY ('YES', 'PARAMETER.QUERY_ONLY');
            app_menu2.set_prop ('FILE.SAVE', enabled, property_off);
            app_menu2.set_prop ('FILE.ACCEPT', enabled, property_off);
            formname := NAME_IN ('system.current_form');
            blockname := get_form_propery (formname, first_block);

            WHILE (blockname IS NOT NULL)
            LOOP
               IF (GET_BLOCK_PROPERTY (blockname, base_table) IS NOT NULL)
               THEN
                  SET_BLOCK_PROPERTY (blockname,
                                      insert_allowed,
                                      property_false
                                     );
                  SET_BLOCK_PROPERTY (blockname,
                                      update_allowed,
                                      property_false
                                     );
                  SET_BLOCK_PROPERTY (blockname,
                                      delete_allowed,
                                      property_false
                                     );
               END IF;

               blockname := GET_BLOCK_PROPERTY (blockname, nextblock);
            END LOOP;
         END;                                           -- End Query Only Mode
     END IF; ---------- disable by zaib
   END IF;
END;

VALUE SET NULL VALUE IN ORACLE APPS
Bind Variables
Values and Value Sets
Load flex values for value set using API in oracle Apps
Value sets create through FND FLEX VAL API
Api to assign values to the independent value set 2013-10-17
API to Delete Values in Value Set
Descriptive Flexifield API
How to add custom validations to Value set
Value Set ---> Special Value Set in Oracle Apps

PROFILE Setting

Set Org Context in Oracle Apps 11i and R12
Initialize Apps in Oracle Applications
When to use MO_GLOBAL.INIT and MO_GLOBAL.SET_POLICY_CONTEXT.
Getting Ledger ID in R12
R12:How MOAC enviornment is setup programmatically
Profile Options in Oracle Application Object Library

Custom Profile

Steps to create custom Profile Option
How to Create Custom Profile Option in Oracle App?
How to create custom profile option in oracle app
Query to Find Profile Option Values
Query for custom profile value for user of a responsibility
SQL Query To Find Profile Options Values Set At Different Levels

Check EBS Version

SQL> select release_name from apps.fnd_product_groups;

RELEASE_NAME
————————————————–
12.2.2

Legal Entity Setup

Intercompany Setups

Disable DFF Attributes

How to make DFF fields read only
Conditional enabling (Flexfields) and hh24:mm value sets
Make DFF Segment readonly through Security Rules

Create a “SPECIAL” type value set.

Application Developer > Application >> Validation >> Set

Value Set Name = “XX_READ_ONLY”

Validation Type = “Special”

Edit Information

Edit > FND SQL “BEGIN NULL; END;”

Validate > FND SQL “BEGIN NULL; END;”

Save Work

Oracle EBS Forms Personalization: Calculating an Item Value

Register Custom Table and Columns

AD_DD Package: Oracle Table Registration
Script to register and unregister Custom Tables and Columns

Register Report

Create a menu function to launch a concurrent request , request group and a request set

Call Concurrent Program from responsibility Menu

How to call a Concurrent Program from a Special Menu Item

Debug Mode

How to enable debugging for Concurrent Managers

VPD on Custom Tables

How to Achieve R12 Multi Org for Custom Table

Using Virtual Private Database in E-Business Environments

What Is Oracle Virtual Private Database?

MO Profile issues

no data in mo_glob_org_access_tmp

Oracle Applications Multiple Organizations Access Control for Custom Code

When to use MO_GLOBAL.INIT and MO_GLOBAL.SET_POLICY_CONTEXT.

exec mo_global.init('AR');

exec mo_global.set_policy_context ('S',&ORG_ID);

Concurrent program Attached with Responsibility

Query To Find Concurrent Program Attached To a Responsibility

Query to get All Active Users and their Active Responsibilities

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 frgu.request_group_id = frg.request_group_id

AND fcpt.concurrent_program_id = frgu.request_unit_id

AND frt.LANGUAGE = USERENV ('LANG')

AND fcpt.LANGUAGE = USERENV ('LANG')

AND fcpt.user_concurrent_program_name = :conc_prg_name

ORDER BY 1, 2, 3, 4

Users Attached with Responsibilities

SELECT furgd.user_id, fu.user_name, fu.start_date user_effective_date,

furgd.responsibility_id, frv.responsibility_name,

furgd.responsibility_application_id, fav.application_short_name,

fav.application_name, furgd.start_date resp_start_date,

furgd.end_date resp_end_date,

(SELECT full_name

FROM per_people_x ppx

WHERE ppx.person_id = fu.employee_id) active_emp_name

FROM fnd_user_resp_groups_direct furgd,

fnd_user fu,

fnd_responsibility_vl frv,

fnd_application_vl fav

WHERE furgd.user_id = fu.user_id

AND frv.responsibility_id = furgd.responsibility_id

AND furgd.responsibility_application_id = frv.application_id

AND furgd.responsibility_application_id = fav.application_id

=====================================================

Concurrent Program with User Parameter

SELECT furg.user_id, furg.responsibility_id,
       furg.responsibility_application_id, 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,
       fnd_concurrent_programs fcp,
       fnd_user_resp_groups_direct furg
WHERE 1 = 1
   AND furg.user_id = :p_user_id
   AND fcp.concurrent_program_name = :p_con_name
   AND furg.responsibility_id = frt.responsibility_id
   AND frt.LANGUAGE = USERENV ('LANG')
   --
   AND frt.responsibility_id = fr.responsibility_id
   AND frg.request_group_id = fr.request_group_id
   AND frgu.request_group_id = frg.request_group_id
   AND fcpt.concurrent_program_id = frgu.request_unit_id
   AND fcpt.LANGUAGE = USERENV ('LANG')
   AND fcpt.application_id = fcp.application_id
   AND fcpt.concurrent_program_id = fcp.concurrent_program_id;

=====================================================

Concurrent Program with Operating Unit and User

SELECT   furg.user_id, furg.responsibility_id,
         furg.responsibility_application_id, hou.organization_id,
         fu.user_name, frt.responsibility_name, furg.start_date,
         furg.end_date, fr.responsibility_key, fa.application_short_name
    FROM fnd_user_resp_groups_direct furg,
         applsys.fnd_user fu,
         applsys.fnd_responsibility_tl frt,
         applsys.fnd_responsibility fr,
         applsys.fnd_application_tl fat,
         applsys.fnd_application fa,
         apps.fnd_profile_option_values fpov,
         apps.hr_organization_units hou,
         apps.fnd_profile_options_vl fpo
   WHERE furg.user_id = :p_user_id
     AND fa.application_id = 240
     AND furg.user_id = fu.user_id
     AND furg.responsibility_id = frt.responsibility_id
     AND fr.responsibility_id = frt.responsibility_id
     AND fat.LANGUAGE = USERENV ('LANG')
     AND fa.application_id = fat.application_id
     AND fr.application_id = fat.application_id
     AND frt.LANGUAGE = USERENV ('LANG')
     -- AND UPPER(fu.user_name) = UPPER('Jagadekar') -- <change it>
     AND (furg.end_date IS NULL OR furg.end_date >= TRUNC (SYSDATE))
     AND (fu.end_date IS NULL OR fu.end_date >= TRUNC (SYSDATE))
     --
     AND fr.responsibility_id = fpov.level_value
     AND fpov.profile_option_value = TO_CHAR (hou.organization_id)
     --
     AND fpo.profile_option_id = fpov.profile_option_id
     AND fpo.user_profile_option_name = 'MO: Operating Unit'
ORDER BY 1, 2;

=========================

SELECT   frv.responsibility_name, fpov.profile_option_value org_id, hou.NAME
    FROM apps.fnd_profile_options_vl fpo,
         apps.fnd_responsibility_vl frv,
         apps.fnd_profile_option_values fpov,
         apps.hr_organization_units hou
   WHERE hou.organization_id = :p_org_id
     AND frv.application_id = 240
     AND fpov.profile_option_value = TO_CHAR (hou.organization_id)
     AND fpo.profile_option_id = fpov.profile_option_id
     AND fpo.user_profile_option_name = 'MO: Operating Unit'
     AND frv.responsibility_id = fpov.level_value
ORDER BY frv.responsibility_name

=========================

Query to find ORG_ID attached to a responsibility

SELECT fpov.profile_option_value, fr.*
FROM applsys.fnd_profile_option_values fpov, applsys.fnd_profile_options fpo, applsys.fnd_profile_options_tl fpot, applsys.fnd_responsibility_tl fr
WHERE 1 = 1
   AND fpo.profile_option_name = fpot.profile_option_name
   AND fpo.profile_option_id = fpov.profile_option_id
   AND fr.responsibility_id(+) = fpov.level_value
   -- AND fr.responsibility_id = :$PROFILES$.RESP_ID
   AND fpot.profile_option_name = 'ORG_ID'
   AND fpov.profile_option_value = '1011' -- Operating Unit ID
   AND fr.LANGUAGE = USERENV ('LANG')
   AND fr.application_id = 660 -- Application Id
   AND fr.responsibility_name LIKE '%Super%User%';

Change Application Password from backend

declare
a varchar2(100);
begin
a:=fnd_web_sec.change_password('USERNAME','PASSWORD');
dbms_output.put_line ('a...'||a);
end;
Note: if a= 'Y'. Password changed successfully