How to handle multiple parameters in BIP :

(period_name IN(:P_PERIOD)
OR '2'             IN (:P_PERIOD
  ||'2'))

Query to get the approval details in Fusion:

SELECT DISTINCT WF.ASSIGNEESDISPLAYNAME "Approver Name",
  PRHA.REQUISITION_NUMBER "Requisition Number",
  WF.TITLE Description,
  SUBSTR(WF.ASSIGNEES, 1 ,INSTR(WF.ASSIGNEES, ',', 1, 1)-1) "Approval Pending with SSO",
  BU.BU_NAME "Business Unit Name"
FROM FA_FUSION_SOAINFRA.WFTASK WF,
  PO_ACTION_HISTORY PAH,
  POR_REQUISITION_HEADERS_ALL PRHA,
  FUN_ALL_BUSINESS_UNITS_V BU
WHERE PAH.IDENTIFICATION_KEY = WF.IDENTIFICATIONKEY
AND WF.STATE                 ='ASSIGNED'
AND WF.IDENTIFICATIONKEY LIKE 'REQ_%'
AND ASSIGNEES           IS NOT NULL
AND WORKFLOWPATTERN NOT IN ('AGGREGATION', 'FYI')
AND COMPONENTNAME        ='ReqApproval'
AND PAH.OBJECT_ID        = PRHA.REQUISITION_HEADER_ID
and PRHA.REQ_BU_ID       = BU.BU_ID
AND SUBSTR(WF.ASSIGNEES, 1 ,INSTR(WF.ASSIGNEES, ',', 1, 1)-1) = NVL(:SSO,SUBSTR(WF.ASSIGNEES, 1 ,INSTR(WF.ASSIGNEES, ',', 1, 1)-1))
and PRHA.REQUISITION_NUMBER = NVL(:REQNUM,PRHA.REQUISITION_NUMBER)
AND BU.BU_NAME                = NVL(:BUNIT,BU.BU_NAME)

HCM - "HCM_OLTP"."Connection Pool"

CRM - "CRM_OLTP"."Connection Pool"

FIN and PROC - "FSCM_OLTP"."Connection Pool"

How To Create A Report with Direct Database Query in OTBI/OBIEE Analysis, Who Can Access Direct Database Query (Doc ID 2141412.1)

After deploying and changing the DFF and hierarchies i n Fusion we need to run below program to synchronize the changes.

Import Oracle Fusion Data Extensions for Transnational Business Intelligence 

How to find the user audit information :

User and Role Access Audit Report 
Report Type:  User Name 
User Name:  Reproducible User 
Data Security Policies (checked)

Fusion R13 Main Change in Jobs:

 From R13 18A the new name of the tasks to manage custom jobs are:

• Enterprise Scheduler Job Definitions and Job Sets for Human Capital Management and Related Applications
• Enterprise Scheduler Jobs for Customer Relationship Management and Related Applications
• Enterprise Scheduler Jobs for Financial and Supply Chain Management and Related Applications

Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications

• Tables related to this Job:
• ESS_REQUEST_HISTORY
• SQL to gather notification parameter details
• select NAME, DATATYPE, VALUE
• from FUSION.ESS_REQUEST_PROPERTY
• where requestid=**
• and name like 'pp%'