In this section, we will see how to create BIP report with dependent parameters in fusion. Let us create sample BIP report with two parameters: Navigation—-> Tools—>Reports and Analytics Go to Browse Catalog—>New —–>Data Model. Create SQL Query to create Data Model. Go to Diagram—->SQL Query. Give Name, Data Source and Type of SQL as […]
How to Schedule BIP Report with EMAIL Delivery with Zip Attachment
In the last section, we have seen how to schedule BIP report with email delivery. While sending output to destination, we can send the output in Zip format. To send output in Zip format, we need to enable below checkbox while scheduling BIP report. Now let us submit this schedule BIP report. Here we can […]
How to Schedule BIP Report with EMAIL Delivery
BIP scheduling is used to run the BIP report at specified intervals. We can have different delivery options for BIP report scheduling like EMAIL, FTP, or UCM (CS), FAX, web folder, printer. In this section, we will see how to schedule BIP report with email delivery option. Let us create sample BIP report for AP […]
How to use login ID session variable in Oracle BI publisher report (System Variables)
We can use information about current user in BIP report data model using system Variables. The user information is stored in system variables as shown below: System Variable Description xdo_user_name User ID of the user submitting the report xdo_user_roles Roles Assigned to user submitting the report. Example: XMLP_ADMIN_XMLP_SCHEDULER. xdo_user_report_oracle_lang Report language from user’s account preferences. […]
How to Download and Install ADFDI for Oracle Fusion
In this section, we will see how to download and install ADFDI for Oracle Fusion in local desktop. ADFDI stands for Application Development Framework Desktop Integration. ADFDI is integrated with MS excel to fetch and upload data to Oracle Fusion application. To use ADFDI with excel, we need to setup ADFDI in local desktop. To […]
Lightweight Directory Access Protocol (LDAP)
Lightweight Directory Access Protocol (LDAP) LDAP Stands for Lightweight Directory Access Protocol (LDAP) directory. All user accounts information is maintained in LDAP directory. LDAP also holds information about roles provisioned to users. During Implementation, any existing information about users and their roles must be copied from LDAP directory to Oracle Fusion application tables. As part […]
Role Based Access Control (RBAC) in Oracle Fusion
Role Based Access Control (RBAC) Oracle Fusion Security is based on Role Based Access Control model. Role based Access control defines who can do what on which functions or sets of data under what conditions. In Role Based Access Control, we provide users with roles which are assigned access privileges to protected resources. There are […]
How to Hide Quick Action Items in Oracle Fusion Page
In this section, we will see how to hide Quick Action Items in Oracle Fusion Page. Let us consider below Quick Action Items under Procurement section. Here we need to hide Suppliers (New) item Under Procurement. Let us create new sandbox and navigate to Structure. Navigate to Procurement as shown below: Click on Procurement. Click […]
Difference Between File Adapter and FTP Adapter in OIC
Below are differences between File Adapter and FTP Adapter in OIC: File Adapter FTP Adapter File adapter is used to read files from On-premises or private cloud (Private/internal network only (behind firewall)) FTP Adapter is used to read files from Remote FTP/SFTP server. File Adapter Supports below Operation:(A) Read File(B) Write File(C) Delete File(D) List […]
Customer-Trading Party Creation using SOAP API
Follow below SOAP API for creating customer-Trading Party: (A) Create Location: Use Below SOAP API WSDL and Payload to create Location: SOAP WSDL: https://fa-xxx-xxx-saasfaxxx.fa.ocs.oraclecloud.com/foundationParties/LocationService?WSDL Method: https://fa-xxxx-xxx-saasfaxxxx.fa.ocs.oraclecloud.com:443/crmService/FoundationPartiesLocationService Payload: <soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”http://xmlns.oracle.com/apps/cdm/foundation/parties/locationService/applicationModule/types/” xmlns:loc=”http://xmlns.oracle.com/apps/cdm/foundation/parties/locationService/” xmlns:par=”http://xmlns.oracle.com/apps/cdm/foundation/parties/partyService/” xmlns:sour=”http://xmlns.oracle.com/apps/cdm/foundation/parties/flex/sourceSystemRef/” xmlns:loc1=”http://xmlns.oracle.com/apps/cdm/foundation/parties/flex/location/”> <soapenv:Header/> <soapenv:Body> <typ:createLocation> <typ:location> <loc:Country>US</loc:Country> <loc:Address1>1 Test address11</loc:Address1> <loc:City>Columbia</loc:City> <loc:PostalCode>29210</loc:PostalCode> <loc:State>South Carolina</loc:State> <loc:CreatedByModule>HZ_WS</loc:CreatedByModule> </typ:location> </typ:createLocation> </soapenv:Body> </soapenv:Envelope> Location is created now. […]