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%'

Query to get PO and Receipts details in fusion

SELECT pha.segment1 PO_NUMBER,
  PHA.START_DATE,
  pha.creation_date po_creation_date,
  pha.end_date,
  pha.APPROVED_FLAG,
  PersonName.FULL_NAME buyer_name,
  ps.vendor_name,
  pss.vendor_site_code site_name,
  PLA.line_num,
  pla.UNIT_PRICE,
  pla.QUANTITY,
  pla.UOM_CODE po_line_uom,
  pla.UNIT_PRICE* pla.QUANTITY lineValue,
  'Receipt details Start' receipt_details,
  RSH.RECEIPT_NUM,
  rsl.LINE_NUM receipt_line_number,
  rsh.RECEIPT_SOURCE_CODE,
  rsh.SHIPPED_DATE,
  rsh.EXPECTED_RECEIPT_DATE,
  rsl.QUANTITY_SHIPPED,
  rsl.QUANTITY_RECEIVED,
  rsl.QUANTITY_DELIVERED,
  rsl.QUANTITY_RETURNED,
  rsl.QUANTITY_ACCEPTED,
  rsl.QUANTITY_REJECTED,
  rsl.UOM_CODE,
  rsl.ITEM_DESCRIPTION,
  rsl.SHIPMENT_LINE_STATUS_CODE,
  rsl.COMMENTS,
  rct.TRANSACTION_TYPE,
  (SELECT meaning
  FROM FND_LOOKUP_VALUES_TL
  WHERE LOOKUP_CODE =rct.TRANSACTION_TYPE
  AND lookup_type   = 'RCV_TRANSACTION_TYPE'
  and language='US'
  ) TRANSACTION_TYPE_meaning,
  rct.TRANSACTION_DATE
FROM RCV_SHIPMENT_HEADERS RSH,
  RCV_SHIPMENT_LINES RSL,
  PO_HEADERS_ALL PHA,
  PER_PERSON_NAMES_F_V PersonName,
  PO_LINES_ALL pla,
  PO_LINE_TYPES_B,
  POZ_SUPPLIERS_V ps,
  POZ_SUPPLIER_SITES_V pss,
  RCV_TRANSACTIONS rct
WHERE RSH.SHIPMENT_HEADER_ID    =RSL.SHIPMENT_HEADER_ID
AND RSL.po_header_id            =PHA.po_header_id
AND PersonName.PERSON_ID        =PhA.agent_id
AND pla.po_header_id            =PHA.po_header_id
AND PO_LINE_TYPES_B.line_type_id=pla.LINE_TYPE_ID
AND pla.PO_LINE_ID              =rsl.PO_LINE_ID
AND pha.VENDOR_ID               =ps.vendor_id
AND pss.VENDOR_ID               =ps.vendor_id
AND rct.SHIPMENT_HEADER_ID      = RSH.SHIPMENT_HEADER_ID
AND rsl.SHIPMENT_LINE_ID        =rct.SHIPMENT_LINE_ID