In this article we will look into getting in the Direct and Indirect reportees of a Supervisor using SQL Query. We assign the Supervisor on the Employment screen and they get stored in the PER_ASSIGNMENT_SUPERVISORS_F table. We will have to join the PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_M and PER_ASSIGNMENT_SUPERVISORS_F tables to get the manager information of an employee. However Fusion has a scheduled…
Have you created Excel templates to get the excel output? Do you know the pros and cons of excel templates? If you face any issues do you know how to troubleshoot them?
Do you know why the BI caching is used? If you don't know the BI Caching settings, you might end up getting old/stale data. Read through this article to know the caching settings and their importance.
Have you ever created etext template to create delimited or fixed length files? Have you faced issues with debugging the template with ????? characters on the output? Check out this article to get your questions clarified.
Do you know the functions that can be used in etext template? Have you faced issues with getting the sample functions to make them work?
In one of our previous articles, we have seen how to configure Source System Owner in Fusion.Defining Source System Owner for HDL in Fusion Source System Owner and Source System ID are the Source Keys which we use to load/update data using HCM Data Loader (HDL). HRC_INTEGRATION_KEY_MAP is the underlying base table which stores the Source Keys for all business…
We can use the below query to get the Position Hierarchy of a Position traversing up to the top level. SQL Query: SELECT hap.POSITION_CODE ,hap.position_id ,hap.name ,(SELECT name FROM HR_ALL_POSITIONS WHERE POSITION_ID = pphf.PARENT_POSITION_ID ) Parent_Position_NAME ,decode(hap.ACTIVE_STATUS, 'A', 'Active', 'I', 'Inactive') ACTIVE_Status ,pj.manager_level ,pj.name FROM HR_ALL_POSITIONS hap ,PER_JOBS_F_VL PJ ,PER_POSITION_HIERARCHY_F pphf WHERE hap.POSITION_ID = pphf.POSITION_ID AND hap.job_id = pj.job_id AND…
In this article we will look into how to create etext template. When we have a requirement to generate a fixed length or delimited output files using BI Publisher or HCM Extract we will use the e-text template to achieve this requirement. I have come across a lot of people who are new to etext template and asked me to…
We can run the BI Reports ad-hoc, or schedule them to email/FTP at weekly/daily basis. However we will explore the option of scheduling the BIP Report using SOAP webservices. SOAP WSDL: https://{hostname}/xmlpserver/services/v2/ScheduleService?wsdl Sample: https://abcd-test.fa.us6.oraclecloud.com/xmlpserver/services/v2/ScheduleService?wsdl Once we have the WSDL, we can use the SOAPUI to consume this WSDL and execute the scheduleReport request with the below payload. <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v2="http://xmlns.oracle.com/oxp/service/v2"><soapenv:Header/><soapenv:Body><v2:scheduleReport><v2:scheduleRequest><v2:bookBindingOutputOption>false</v2:bookBindingOutputOption><v2:mergeOutputOption>false</v2:mergeOutputOption><v2:notifyHttpWhenFailed>false</v2:notifyHttpWhenFailed><v2:notifyHttpWhenSkipped>false</v2:notifyHttpWhenSkipped><v2:notifyHttpWhenSuccess>false</v2:notifyHttpWhenSuccess><v2:notifyHttpWhenWarning>false</v2:notifyHttpWhenWarning><v2:notifyWhenFailed>false</v2:notifyWhenFailed><v2:notifyWhenSkipped>false</v2:notifyWhenSkipped><v2:notifyWhenSuccess>false</v2:notifyWhenSuccess><v2:notifyWhenWarning>false</v2:notifyWhenWarning><v2:repeatCount>1</v2:repeatCount><v2:repeatInterval>0</v2:repeatInterval><v2:reportRequest><v2:attributeFormat>csv</v2:attributeFormat><v2:attributeLocale>en_US</v2:attributeLocale><v2:attributeTemplate>xt</v2:attributeTemplate><v2:byPassCache>true</v2:byPassCache><v2:flattenXML>false</v2:flattenXML><v2:parameterNameValues><v2:listOfParamNameValues><v2:item><v2:name>CONTENTID</v2:name><v2:values><v2:item>INPUTCONTENTID</v2:item></v2:values></v2:item></v2:listOfParamNameValues></v2:parameterNameValues><v2:reportAbsolutePath>/Custom/SM/TEST/REPORT.xdo</v2:reportAbsolutePath><v2:sizeOfDataChunkDownload>0</v2:sizeOfDataChunkDownload></v2:reportRequest><v2:saveDataOption>false</v2:saveDataOption><v2:saveOutputOption>true</v2:saveOutputOption><v2:scheduleBurstringOption>true</v2:scheduleBurstringOption><v2:schedulePublicOption>false</v2:schedulePublicOption><v2:startDate/><v2:useUTF8Option>false</v2:useUTF8Option><v2:userJobDesc>SampleJob</v2:userJobDesc><v2:userJobName>SampleJob</v2:userJobName></v2:scheduleRequest><v2:userID>*******</v2:userID><v2:password>*******</v2:password></v2:scheduleReport></soapenv:Body></soapenv:Envelope> You can…
If the client has implemented Payroll, we have a common requirement to pull the balances in BI Report multiple times as part of third party integrations. Getting the Payroll Balance requires calling the balance package and providing the right inputs. Many of us get it wrong in writing the balances query and find it difficult to achieve it. Here is…
