Venky DevMastery

Mastering Parameters in Oracle Fusion BI Publisher: Mandatory, Optional, and "All" Logic When building Data Models in Oracle Fusion, how you handle parameters determines the user experience and report performance. Here is the definitive syntax guide: 1. Mandatory Parameters Use this when a value must be provided for the report to run. Syntax: AND column =:parameter Example: AND Person_Number = :p_Person_Number 2. Optional Parameters (The "All" Logic) Use this to allow users to leave a field blank or select "All" to see all records. Syntax (Recommended):  AND (:parameter IS NULL OR column = :parameter) Example: AND (:p_Person_Number IS NULL OR Person_Number = :p_Person_Number) Note: Using NVL is common but can be slower on large datasets as it may bypass indexes. 3. Multi-Select Parameters Use this when the user can select multiple values from a list. Syntax: AND (column IN (:parameter) OR 'All' IN (:parameter)) Example: AND (Person_Number IN (:p_Pe...

 Oracle Fusion BIP: Customizing Seeded Reports the Right Way When a client asks to see only specific columns in a Standard/Seeded BIP Report, you have two main paths.  Choosing the right one depends on whether you want to change the View  or  the Engine. Option 1: Create a Custom Layout (Recommended) This is the "cleanest" approach. You keep the standard logic but change the visual output The Move: Create a new Layout (RTF/Excel/Online) using only the required columns from the existing Seeded Data Model. Why it wins: It’s low maintenance. Since you’re still using the seeded Data Model, you benefit from any logic updates Oracle pushes during quarterly patches. Best for: When the data is already there, you just want it to look tidier. Option 2: Customize the Data Model This is a deeper "under the hood" change. The Move: Copy the seeded Data Model to the Custom folder, edit the SQL script to remove unwanted columns, and link it to a new report/layout. Why it w...

 Problem: On FBDI Customer Import Excel XLSM template, The Button 'Generate CSV File' Not Working. Solution1: On same Excel XSLM template: From Ribbon>View>Macros>View Macros>GenCSV>Run button.  Solution2: On Excel XLSM template, Go to the Developers Tab>Click on Macros>Choose GenCSV>Click on Run button. After the CSV file is generated, right click on the file>Choose Compress To>Zip Folder. Solution3: On Excel XLSM template> Right click > Properties Under General tab, below there will be an option- 'Unblock'. Enable this.

 REST Web Service  ================= Rest Resources Resources would have 5 end-points(methods) usually.  Ex: Create a Bank Read-Get a/all Banks Update Bank Delete a Bank Fusion Navigation for managing Banks  Setup and Maintenance Tasks Global Tasks Manage Banks Get All Banks  /fscmRestApi/resources/11.13.18.05/cashBanks https://fa-eubg-saasfademo1.ds-fa.oraclepdemos.com/fscmRestApi/resources/11.13.18.05/cashBanks Get a specific Bank  https://fa-eubg-saasfademo1.ds-fa.oraclepdemos.com/fscmRestApi/resources/11.13.18.05/cashBanks/{BankPartyId} Create a Bank  https://fa-eubg-saasfademo1.ds-fa.oraclepdemos.com/fscmRestApi/resources/11.13.18.05/cashBanks patch  Update  https://fa-eubg-saasfademo1.ds-fa.oraclepdemos.com/fscmRestApi/resources/11.13.18.05/cashBanks/{BankPartyId} Put https://fa-eubg-saasfademo1.ds-fa.oraclepdemos.com/fscmRestApi/resources/11.13.18.05/cashBanks/{BankPartyId} Delete  https://fa-eubg-saas...

How to run BI Publisher (BIP) report via SOAP UI  ===================================== Step-by-step instructions ------------------------- Step1: Locate WSDL URL. Every Oracle Fusion instance follows a standard URL pattern for the BIP SOAP service. Take Fusion instance URL https://fa-eubg-saasfademo1.ds-fa.oraclepdemos.com/ Append the following path to it: xmlpserver/services/ExternalReportWSSService?WSDL Full URL to run BIP report in Fusion from SOAP UI: https://fa-eubg-saasfademo1.ds-fa.oraclepdemos.com/xmlpserver/services/ExternalReportWSSService?wsdl Phase 2: Setting up SOAP UI Open SOAP UI. Click on File > New SOAP Project. Or Click on SOAP Project Name:"BIP_Run_Test01" Paste the URL which constructed in Step1. Click OK. This will load all available operations (runReport, scheduleReport,submitReport.. etc.). Phase 3:  Choose runReport and click on Request1 In the next window, click on Auth, Enter Fusion instance User Name and password. Step4: Constructing the runRepo...

Create a Location using REST API in Oracle Fusion HCM Cloud Answer: Click Here   Practical: Watch on YouTube