Oracle EBS Concurrent Program Vs Fusion ESS Jobs ((Enterprise Scheduler Jobs)

Oracle EBS Concurrent Program Vs Fusion ESS Jobs ((Enterprise Scheduler Jobs)


Hi Friends, In this post we will discuss about Oracle Fusion Concurrent Programs that is ESS jobs in Fusion.

We all know that , In Oracle E-Business suit we have concurrent programs , to register our Reports , PLSQL procedures , Packages and Host and Sql Loader Script. We use Concurrent Program in Oracle EBS r12 to run our reports and packages and Host and SQL loader Scripts. But in Fusion , We don't have concurrent programs , We have ESS jobs in Oracle Fusion to run our BIP reports , PLSQL scripts and other things.

In R12 , we put reports in Application TOP and then select that Application during Creating Concurrent Programs But in Oracle Fusion , We don't put Reports in Application Top but Create BIP Reports in Specific Path of the standard Given Path by Oracle in Fusion and Then use this Path in ESS Jobs registration then ESS job will access this report by this path.

We creates parameters in Concurrent Job and then attach value set in these parameters to provide lost of value selection to the users during runtime But in Oracle fusion , We have parameters in Oracle Fusion and we can also create Parameters in Oracle Fusion ESS jobs but in Fusion , We Don't attach Value set to ESS jobs parameter but We attach List of Value to Parameters. In Oracle Fusion , List of Value and Value set are two different -2 Terms and Objects. But in Oracle Fusion , We cannot Create custom List of Value (Table Type) to ESS jobs parameters. In Fusion Oracle has provided , standard VO (View Object) and on the basis of View Object(VO) , we create List of Values and attach List of List of Value to Parameters.

if you found this post helpful and you liked it then follow this blog to get notifications for the upcoming posts.

ESS Job Registration Window :-

In Oracle apps R12 , We run concurrent Programs as a Concurrent Request but in Oracle fusion We runs ESS jobs as a Schedules Processes.


Schedules Processes Example:-

 

Oracle Fusion Roles : Detailed Discussion on Oracle Fusion Security roles

Oracle Fusion Roles : Detailed Discussion on Oracle Fusion Security roles

     
Oracle has provide these four Types of roles.

• Abstract role
• Job roles
• Duty roles
• Data roles

For example:- Procurement manager has procurement job roles in oracle fusion but to perform his procurement job he has to perform some duties and that come under duty roles. and this procurement manager can also employee so he have employee role also and that is abstract role.

Abstract role:-

Abstract role not related to any specific his or her Job. We can say abstract role are those which user need to perform his other duties beside his job roles. It means User need to perform the task associated with the duties of work not related to his particular job.

Abstract roles also inherit duty roles.


Job Roles :-

Job roles are a type of enterprise role which is specific to your job in your company.

Job roles inherit duty roles that one person need to perform the tasks associated with the duties of the job. Job roles are not assigned entitlement to access functions directly. You change job roles by changing their hierarchy of inherited abstract and duty roles. Job roles may inherit other job roles, abstract roles, and duty roles.


Duty Roles :

Duty roles are a type of application role. The reference implementation contains predefined duty roles.

For example, the Accounts Payable Manager job role inherits the Approving Payables Invoices Duty role.

Duty roles provide access to the application functions that users require to perform the tasks associated with the duty.

Data Roles :


Data roles are a type of enterprise role. This kind of roles to provide data access or grants. It may inherit abstract, duty or job roles

The access is explicit because the grant is defined based on the needs and data of the enterprise.



If you want to see Other OAF Related Posts , Please visit Below URL.https://rpforacle.blogspot.in/2013/03/oaf_10.html



If you want to see  Oracle Fusion Related Posts , Please visit Below URL.

https://rpforacle.blogspot.in/2018/01/oracle-fusion-learning-tutorial.html

If you want to Learn Oracle Workflow Builder, Please visit Below URL.

https://rpforacle.blogspot.in/2018/01/oracle-workflow-learning-tutorial-1.html

 

ESS Job Security in Oracle Fusion : How we can assign ESS Job access to Specific User in Fusion

ESS Job Security in Oracle Fusion : How we can assign ESS Job access to Specific User.

In friends , In this post I will show you step in Oracle Fusion to assign ESS job Access to Fusion Users.

In Oracle r12 , we create Request Group and then assign Concurrent program to the request group and then as per the responsibility we assign request group to Responsibility and in the last assign responsibility to users so in the end user can only run those reports which are assigned to his responsibility request group.


In Fusion , This Request Group structure is Totally changed. In Fusion We did not create request group to assign Reports. Here in Fusion we pronounce report as a ESS job , so fusion , create Privileges to each ESS job and then we assign ESS job to roles and then in the end we assign roles to Fusion User.


I am sharing you the steps for that.

As per Oracle Metalink Note Doc ID 2251561.1


Create the ESS job using the task Manage Custom Enterprise Scheduler Jobs for ...
For example using task 'Manage Custom Enterprise Scheduler Jobs for Payables and Related Applications' create ESS job
Display Name: 'Rel12 Custom ESS Job – Testing'
Name: XXRel12CustomESS
Path: Rel12

Run the ESS job 'Import User and Role Application Security Data'

Verify that the privilege 'Rel12 Custom ESS Job – Testing' have been created using the Security Console

if you found this post helpful and you liked it then follow this blog to get notifications for the upcoming posts.

For jobs created before Rel12 the privileges created in APM are not migrated automatically. Users need to edit the job definition which will create the privilege for that job. Then run ESS job 'Import User and Role Application Security Data' to see the privileges in Security Console.

 

 

 

 

Using same Security Console create a custom job role and add the privilege 'Rel12 Custom ESS Job – Testing' as function security policy

 

 

 

 

 

 

 

 

 

Assign the created job role to an user

Run again the ESS job 'Import User and Role Application Security Data'

Login as the user who has the given privilege and in Scheduled Processes schedule the new job created

 

Report Triggers in Fusion BIP Reports

Before and After Report trigger in Fusion BIP Reports.

Hi Friends, In this post I will explain you the Fusion BIP report triggers, How we can use these trigger in Fusion.

We all knows that in Oracle Report 10g , we use Report triggers to create dynamic where condition in our reports. We create bind variables in the report and set where conditions to these bind variables based on the input parameter values and then reference this variable in report query. This is really an very important feature.

But in Fusion BIP reports , Oracle has only given two report triggers that is :

2 Types of Report Triggers in Fusion BIP Reports

before Data
After Data

To implement this , first we will create a parameter p_where_clause to create dynamic where condition

Now we will create a before data Trigger. For that we need to create a DB Package first. All the parameters defined in the report must be defined In the package specification as global variable.

Complete Tax Setups in Oracle Fusion

The Logic I am going to use is , If P_VENDOR_NAME paramters is null then where condition will set  like P_WHERE_CLAUSE= 'AND 1=1'

CREATE OR REPLACE PACKAGE XX_FUSION_REPORT_TRIGGER
IS

P_VENDOR_NAME VARCHAR2 (100);
P_WHERE_CLAUSE VARCHAR2 (1000);

FUNCTION before_data
RETURN BOOLEAN;
END XX_FUSION_REPORT_TRIGGER;

CREATE OR REPLACE PACKAGE BODY XX_FUSION_REPORT_TRIGGER
IS
FUNCTION before_data
RETURN BOOLEAN
AS
BEGIN
IF (P_VENDOR_NAME IS NULL)
THEN
p_where_clause := ' AND 1=1';
ELSIF P_VENDOR_NAME IS NOT NULL
THEN
p_where_clause := ' AND upper(a2.vendor_name) like ''%'||UPPER(:P_VENDOR_NAME)||'%'' ';
ELSE
p_where_clause := NULL;
END IF;
RETURN TRUE;
EXCEPTION
WHEN OTHERS
HEN
RETURN FALSE;
END;
END XX_FUSION_REPORT_TRIGGER;

if you found this post helpful and you liked it then follow this blog to get notifications for the upcoming posts.

Before Report Trigger.

Use the package name in the Oracle DB Default Package.

Move the Package name with procedure from Available function to Event Trigger as below.




Now set the Where Clause lexical parameter  to your Main report query.

If you want to see Other OAF Related Posts , Please visit Below URL.https://rpforacle.blogspot.in/2013/03/oaf_10.html



If you want to see  Oracle Fusion Related Posts , Please visit Below URL.

https://rpforacle.blogspot.in/2018/01/oracle-fusion-learning-tutorial.html

If you want to Learn Oracle Workflow Builder, Please visit Below URL.

https://rpforacle.blogspot.in/2018/01/oracle-workflow-learning-tutorial-1.html