Posts

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...
Post a Comment
Read more

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
Post a Comment
Read more

Mastering Oracle Fusion ERP Cloud with Integration GenAI

-
A Strategic Overview of Oracle’s Cloud Ecosystem for the Next Generation of Solution Architects. For More Details, Click on the Link
Post a Comment
Read more

About Oracle Integration Cloud(OIC GEN3)

-
 About Oracle Integration Cloud(OIC GEN3) Click Here : View Full Details
Post a Comment
Read more

Importance of Incremental Data in Oracle Fusion

-
 What is incremental data? Incremental Data Loads ----------------------- If you are sending employee data to a third-party payroll provider on every Friday, we don’t want to send all employees instead we only want the ones who changed current week. In this scenario, "LAST_UPDATE_DATE" column in the table plays vital role. LAST_UPDATE_DATE tells us when the record was physically saved. */ --Examples: ------------------------------- select count(1) from ( Select  papf.person_number, ppnf.FULL_NAME from  per_all_people_f papf, per_person_names_f ppnf WHERE 1=1 and papf.person_id=ppnf.person_id  and papf.LAST_UPDATE_DATE >=sysdate-7 --(Incremental) and ppnf.NAME_TYPE='GLOBAL' and sysdate between papf.EFFECTIVE_START_DATE and papf.EFFECTIVE_END_DATE and sysdate between ppnf.EFFECTIVE_START_DATE and ppnf.EFFECTIVE_END_DATE ) Result:  55 Records(Only Changed Records in current week) --------------------------------- select count(1) from ( Select  papf.person_n...
Post a Comment
Read more
-
What is the difference between Update and Correct in Oracle HCM Cloud? Update Preserves old data; creates a new row. Requires a new Effective Start Date. For the old record it will append the effective_end_date Clear history of "from" and "to." Ex: Change in status (Promotion). Need to the syntax sysdate between  Effective Start Date and  effective_end_date to get most recent records vs Correction Overwrites existing data; no new row. Keeps the existing Effective Start Date. No visible history of the change in the UI. Fixing a mistake (Typo).
Post a Comment
Read more

Oracle HCM Cloud-Real_Time

-
 Oracle HCM Cloud Real-Time Requirement:1 Click Here to View
Post a Comment
Read more