ERP ESS - ESS job with parameters using Lookup

Usecase: Here, we will create a lookup for invoice source and then link to ess job parameter and then run the ess job to invoke the BI report.

Steps to follow:

1. Tools >> Reports and Anlytics >> browse catalog >> create data model >> create two LOVs for source and invoice number >>create 2 parameters and link to the LOVS >> Create data set >> go to data tab and test >> save as sample data >> create report
2. My enterprise >> Setup and Maintenance >> golbal search with Manage Common Lookups >> create lookup : XXSOURCE_LOOKUP , module: Toolkit>> add lookup codes like ISP, ERS.
3. Search with Manage Enterprise Schedule >> Manage List of Values sources >> application name: application Toolkit , LOV source name: Common Lookup , LOV Source definition name: oracle.apps.fnd.applcore.lookups.modelpublicView.CommonLookupPVO
4. Manage Job Definitions >> provide ESS job details. >>create paramter P_source and assign page element as Choice list. LoV source : Common Lookup
5. Link the lookup with the parameter. Default value: 'XXSOURCE_LOOKUP'.
6. Tools >> Scheduled Processes >> schedule new process >> XXDEMO_ESS_JOB TAB >>> select values and submit

Detailed screenshots:

ERP ESS - SECURING an ESS job

Usecase: 

By default, when we create an ESS job, its not available for submission for all the users. Here, we will see how to provide priviledges to an user so that the user can submit the ess job from the erp scheduled processes section.

Steps to follow:

1. Submit new process: "Import User and Role Application Security Data" which will create the ess job priviledge
2. Security console >>create new role >> for example , XXDEMO_ESS_JOB_ROLE and Role category: Common - Job roles >> add Function Security policy >> add the XXDEMO job to role >> add the user to this role >> save
3. Scheduled processes >> submit new process >> Retrieve Latest LDAP Changes 
4. Now the user can submit the ESS job from scheduled processes.

Detailed Screenshots:

ERP BI - How to call OIC rest integrations from BI report

Usecase: Here, we will show how to invoke OIC rest integrations using BIP Report.

Note: This approach only supports XML response.

Here, we will use Get verb and feed a emp id as input  from BI reprot and get xml response status.

Implementation steps:

1. Create a rest connection and create a application integration where configure the rest trigger as below
1. Verb: get
2. EmpId as Query parameter
3. Upload XSD for response
2. Go to ERP Administration >> create a http connection data source and provide details as below
1. Data source name
2. Service protocol: https
3. Server : oic instance or host name
4. Port: 443
5. Session timeout: 500
6. Username and password
7. Add below roles under security
1. BI Administrator Role
2. BI Author Role
3. BI consumer Role
4. BI system role
8. Create data model
9. Create a parameter as P_empId
10. Create data set as  HTTP xml feed and provide details as below
1. Name
2. Select data source
3. Provide URL suffix
4. Method: Get
5. Add parameter
11. Go to data tab and view to test and save data as sample
12. Create report and test

Detailed screenshots:

Reference for more details:

https://docs.oracle.com/middleware/12212/bip/BIPDM/GUID-593CA9CB-B822-47C1-BDF0-962F4A5EBAA1.htm#BIPDM498

BI report - How to secure your pdf report output | dynamic method

Usecase: Here, we will see how to secure your pdf file with dynamic method.

Steps to follow:

Open the RTF template >> File >> Info >> Properties >> Advanced Properties >> custom tab >> add following two properties:

Name : xdo-pdf-security  value: true

Name: xdo-pdf-open-password value: {DATA_DS/G_1/SUPPLIER_NUMBER}

Then save >> upload to BI report >> view list and select pdf format >>  view report.