ESS JOB AND ESS JOB VALUE SET ( LOV ) FOR BI REPORTS

 

DOCUMENTATION ON

ESS AND ESS JOB SET FOR BI REPORTS

Table of Contents

1.       WHAT IS ESS JOB.. 1

2.       PRE REQUISTS. 2

3.       PARAMETERIZED ESS JOB REPORT. 4

4.       SCHEDULE NEW PROCESS. 6

 

 

1.   STEPS TO CREATE CUSTOM ESS JOB

1.    WHAT IS ESS JOB

 

ESS Stands for Enterprise Scheduler Job. Once the report is developed we can register it as an ESS, Users can submit the ESS job from the Schedule process screen. Also, the ESS job can be invoked in asynchronous mode from Web Services and using an ERP adapter in OIC.

In Fusion applications ESS jobs can be run on demand and as per schedules. These jobs are analogous to concurrent programs in Oracle EBS applications. There are many ESS jobs that are delivered as part of Fusion applications, and users can also create and run ESS jobs. The best part of ESS jobs in fusion is that they can be created very quickly following simple steps. In this post let me consider running a Cloud BI report that was already created by me. The reason behind considering Cloud BI report is that these reports are supported on many different kinds of data sources, for instance they are supported with JDBC, JNDI, File, LDAP, OLAP, Web Services and HTTP.


2.    PRE REQUISTS

·                     Oracle Fusion SaaS Instance

·                     Report and Data Model placed in shared folders or my folders.

There are 2 types of reports:

·                     SIMPLE ESS JOB REPORT

·                     PARAMETERIZED ESS JOB REPORT

 

1.     SIMPLE ESS JOB BI REPORT

1.      Login into Oracle SaaS, navigate to Tools > Reports and Analytics. Once the page is opened click on Browse Catalog and then the analytics page will be opened. Navigate the report and test if works as expected. Now, let’s copy the report path which is required while creating the ESS Job, Click on Schedule as shown in the below screenshot and copy the report path.

  



                                     

2.      Navigate to the Fusion home page and open the Setup and Maintenance page as shown in the below screenshot. On the next page click on Tasks and Search

 


 

3.      Search Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications as shown in the below screenshot:

 

 



4.      On the next page, Click on + as shown in the below screenshot to create a new ESS job:


 

5.      Provide all the necessary details as shown and click on Save and Close

(i)     Display Name: Enter a user-defined name for the extract. This name is displayed under Scheduled Processes

(ii)   Name: Specify an alphanumeric name without spaces and special characters. This name is used for the ESS Job Name in Data Integration application options.

(iii) Path: Specify the path where to save the ESS job. This path is created as a subfolder of /oracle/apps/ess/custom. For example, if you specify test, then the ESS Job path is /users/imp_user/Test

(iv) Job Application Name: Select FscmEss

(v)   Job Type: Select BIPJobType

(vi) GREEN colour marked details are necessary and YELLOW are optional

Report ID: Specify the report path of the custom report defined in the Creating the BI Publisher Report (Refer to Step 1).

 

Enable submission from Scheduled Processes: Check to enable. This option enables you to invoke the job manually and troubleshoot it in case of a data mismatch

 

2.     PARAMETERIZED ESS JOB REPORT

6.      To make LIST OF VALUES Click on Manage List Of Value Source
7.      If u already created lov then search with this.

·         Application Name : Application ToolKit

·         User List of Values Source Name : Enter a User Defined LOV Name

 

 

 

 

 

2.      If you want to Create New Lov then follow this steps:

 

·         Click on (+)

 

 

·         Application name:- application toolkit

User list of values source name:- give used defined LOV name

Description :- user defined description

LOV type :- user defined (ex:- CCC_INV_001_LOV_01)

Query :- write user defined query for the LOV parameter which u have written in the data module for the BI Report

 

 

·         Save and close.

 

3.      In Manage Job Definations

·         Go to parameters click on (+).

·         Parameter name :- parameter name which is given in bi report (p_invoice_num).

·         Data type :- select required data type for the parameter.

·         Page element :- if it does’nt have any type of list of values select text box as shown in the below figure.

·         Page element :- If it having any list of values select LIST OF VALUE

List of value source :- give list of value name

(ex:- CCC_INV_001_LOV_01)

·         Attribute :- select LOV column

·         Display Attribute :- shift LOV column

·         Tool tip text :- it’s just like an reminder not necessary

·         Click check box if it is mandatory parameter

 

·         If you want to create another parameter choose option save and create another one.

2.   EXECUTE ESS JOB

3.    SCHEDULE NEW PROCESS

1.                  Go to TOOLS > SCHEDULE PROCESS > SCHEDULE NEW PROCESS

2.                  Select job > in that

Name :- ESS JOB NAME > ENTER > OK

 

 

 

 

 

 

 

3.                  Give required PARAMETERES shown in the below picture.

 

 

4.                  Note this process id number

 

 

5.                  If process is succeeded

 


6.                  Click on YOUR ESS JOB in process Details

 

7.                  Click on republish to get report

Comments

Post a Comment

Popular posts from this blog

opaque schema xsd (standard file used in OIC)

 opaque schema xsd (standard file used in OIC) You can use an opaque schema in a stage file action Read File or Write File operation without concern for a schema for the file.   The only condition is that whatever is sent to the opaque element in the opaque schema must be base64-encoded data.  or in other words  it is used to decode base64 files Save the below xml as  opaqueschema.xsd  file and then you can use it in the integration. <?xml version = '1.0' encoding = 'UTF-8'?> <schema targetNamespace="http://xmlns.oracle.com/pcbpel/adapter/opaque/" xmlns="http://www.w3.org/2001/XMLSchema" > <element name="opaqueElement" type="base64Binary" /> </schema>
Read more

DOCUMENTATION ON SANDBOX and PERSONALIZATION

Image
DOCUMENTATION ON SANDBOX PERSONALIZATION Prepared by VAMSI GOVATHOTI ROLE: ORACLE APPS TECHNICAL CONSULTANT Contents A) What is a Sandbox? 2 B) Purpose of Sandboxes 2 C) Key Features 2 D) Why Use Sandboxes? 2 1. How to Customize (Enable or Disable) the Fields/Components in the Sandbox 6 2. How to Enable Direct Access from User Interface (UI) to the Desired Destination using an URL 9 3. How to Create “Role Based Access control” to particular Fields / Components 13 4. ‘More Tasks’ Tab to be renamed to 'Create' on Purchase Requisitions page. 18 5. By using Application Composer making field required in sand box 23 6. Personalization by using application composer 27 A) By using Application Composer creating new field in sand box 27 B) Creating of currency field with fixed choice list 32 C) Creating of currency field with dynamic choice list. 36 7. Creating a button in sand box 40 8. Creating a global function for runtime mess...
Read more

SQL,PLSQL interview practice and DSA patterns

 --=============sql=========================== --How to find duplicate records with the number they are duplicated? select job,count(*) from emp group by job; --Write a Query to select to the Nth highest salary from a table? select min(sal) from (select  sal from emp order by sal desc) where rownum < 3;   --Can Dual table be deleted or dropped or altered or inserted? select round(123.45) from dual; --it cant be deleted or dropped or altered or inserted --List the emps in dept 20 whose sal is > the avg sal of deptno 10 emps? select * from emp where deptno = 20  and sal>(select avg(sal)from emp where deptno = 10); --List the empno, ename, sal, dname of all the 'Mgrs' and 'Analyst' working in NEWYORK, --DALLAS with an exp more than 7 years without receiving the Comma Asc order of Loc? select empno,ename,sal,dname from emp,dept where emp.deptno= dept.deptno and  loc in('NEWYORK', 'DALLAS') and job in ('manager','analyst')and trunc(mo...
Read more