Manage Transmission Configurations To do the setups related to payments.

Accounts Payable Payment Supervisor role for creating payments

Accounts Payable Specialist for creating invoices


Transmission Configuration to configure the server details.

Communicate Purchasing Documents to send the emails


Disable the profile option at the site level.

Here is the navigation:
1. Setup and Maintenance
2. Search 'Manage Administrator Profile Values', & click.
3. Enter 'Control Supplier Communication' in the field 'Profile Display Name'
4. Click on that record in the search result
5. Change Profile value to 'Disable' at the 'Site' Profile level.
6. Save and Close.
7. Sign out and sign back in.

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