Posts

HSDL vs HDL

  What are the differences between HDL and HSLD in Oracle HCM Cloud? HSDL Vs   HDL HCM Spread Data Loader   HCM Data Loader We need to install the ADFdi Plug-on Excel   No need to install ADFdi Plug-in User Friendly   It is not user-friendly A normal consultant can fill in the data in Excel <50,000 records   Technical expertise is required to prepare the DAT file >50,000 records If we load more than  50,000 records then we may encounter problems like: Excel stopped working Session Time-out   We can load unlimited records. We will prepare .DAT file We will just fill the data in the Excel sheet If any errors occur, we can fix it in the same Excel sheet.   We have to check the error logs and then we n...

Mastering Parameters in Oracle Fusion BI Publisher

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

 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...

'Generate CSV File' Not Working in Oracle Fusion FBDI template

 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 in Oracle Fusion to manage Banks

 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 BIP Report in Oracle HCM Cloud

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

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