Global HR
Discussion List
-
How to identify a merged person record in the Oracle Fusion HCM Cloud databaseSummary: When querying the database for person records, I want to exclude merged records from the output. How do I identify merged records in the table? Content (require… -
We need department and cost center details with effective state date in BI or OTBISummary: Hi Team, we need department and cost center details with effective state date. i tried in worker assignemnet real time but no effective start date. only two clo…AjayKumar Maddipati 35 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How to get values entered in termination transaction details?Summary: How to get values entered in termination transaction details? Content (required): Hi Team, Greetings! Termination transaction initiated by the manager or HR Sup…Parag Hiremath 293 views 9 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to identify when a Job Code was last assignedSummary: We are working on cleaning up job codes. There are many active job codes and we don't want to inactivate them until we know when the last time the job was assig…
-
Correct sorting of report in sql queryHi, I want to sort the numbered numbers in the sql query I wrote. but when I want it to be sorted as 1,2,3.., it is sorted like 1,10,11. I'm having trouble with two-digi…Cansel Karasoy 33 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Is there a way to report on changes made an employee makes to their address or number?Summary: Is there a way to report on changes an employee made makes to their address or number? Content (required): Is there a way to report on changes an employee makes…PrJohns-Oracle 30 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Query to get Transactional dataSummary: Hi Everyone, Currently, I'm working on a report, the requirement of this report is to pull the employee's current and proposed data. like the employee transferr…
-
Full-Time equivalent is not working within USING clause of a FILTER operator in OTBII have created an OTBI report using Subject area - Workforce Management - Employee Assignment real time and Full-Time equivalent i am fetching from the "Worker Assignmen…Utkarsh M 30 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Workforce Management - Worker Assignment Real Time - position Management Business UnitSummary: Which fusion table can provide value for OTBI field "Workforce Management - Worker Assignment Real Time - position Management Business Unit" ? Need to create a …Rishita 37 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to use "Replace" function in BIP Report Excel TemplateSummary How to use "Replace" function in BIP Report Excel TemplateContent Hi Experts, How to use "Replace" function in BIP Report Excel Template. Could you please sugges…Bala Kasineedi 361 views 11 comments 0 points Most recent by Kishoor_R-Oracle Reporting and Analytics for HCM
-
Embed BIP report on Employment Info Responsive UISummary: Embed BIP report on Employment Info Responsive UI Content (required): Developed a BIP report and used Assignment_id as parameter. We have placed it as Hyperlink…Kammasavala Ramadevi 111 views 3 comments 0 points Most recent by Kammasavala Ramadevi Reporting and Analytics for HCM
-
NULL value creating duplicates in UNION queryAfter adding NULL value to some columns , it is showing Duplicates in UNION query. Like: AUTHORIZATIONCODE, JOBDESCRIPTIONDATE, JOBEVALUATIONDATE.Dona Das-Oracle 15 views 1 comment 0 points Most recent by Manoj.Gupta Reporting and Analytics for HCM
-
How to call a BI report when email id is created?Summary: How to call a BI report when email id is created? Content (required): Hi All, We got a requirement to send notifications to new joiners when their work email is…Venkatesan 45 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Reporting the termination screenHi, When I terminate the employee from the My Client Groups>>Termination>> screen, I want to report the part that opens in the screenshot below. I need a sql query for t…Cansel Karasoy 24 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Report to pull out the date since a position is vacantI have a business requirement to pull out the date since when a position is vacant. Is there a way to pull this out or does someone have a report that i can plug and pla…Girish Bhatia 22 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to get the position level of a position from the top using OTBISummary: We have a requirement to get the position level of a position from the top. eg: CEO is the top position and should be at level 1, 2 directors reporting to CEO s… -
Entity Relationship Diagram between ALL PVOs in Fusion HCM ModulesSummary: Entity Relationship Diagram between ALL PVOs in Fusion HCM Modules Content (required): Dear all - can we get ERDs for All PVOs from different HCM Modules from O…Nilanjan Biswas-Oracle 917 views 2 comments 4 points Most recent by Nilanjan Biswas-Oracle Reporting and Analytics for HCM -
Unable to restrict results with workschedule filters when it is blank or non primarySummary: Issue: There are multiple subject areas combined together to generate results which is embedded in dashboard. A new change has been requested to include employe…Sowdha Murugan 37 views 7 comments 0 points Most recent by Sowdha Murugan Reporting and Analytics for HCM -
How to get - when the employee was created in the applicationSummary: Hi Everyone! Is there any way via (BIP/OTBI) to fetch when the employee was created in the application ? Version (include the version you are using, if applicab…ShawShankk 24 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Error when Combine 2 Subject AreasSummary: Hi All, I am trying to create an OTBI analysis by merging 2 Subject Areas: Worker Assignment Real Time and Person Real Time. The report will display employee wo… -
Tables to find workflow attachmentsSummary: Content (required): Hi All, how to find the workflow attachments. I used the below query but not getting any result. SELECT wat.* FROM Fusion.Hrc_Txn_Header txn…Venkatesan 169 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
How to send attachments from BI publisher?Summary: How to send attachments from BI publisher? Content (required): Hi All, We got a requirement to send a onboarding notifications for the new hired employees with …Venkatesan 29 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
Serial numbering in the reportHello, In a notification I prepared, I would like to give a serial number to the document that will be sent to the people in that month. For example, document no;01 docu…Sinem Kara 23 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
Need SQL Query to fetch the Advanced Mode Absence Duration in Absence RecordsHi Experts, Could you please help me on SQL Query to fetch the Advanced Mode Absence Duration in Absence Records. Thanks, Nagaraju.Naga raju Ibba 334 views 4 comments 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
BI Publisher Bursting Email from Company Domain IDSummary: Hello Experts, We have a requirement to trigger emails from our company domain ID (@companyname.com) while triggering emails from BI Bursting. We don't want the…Gourabh Choudhary 158 views 3 comments 0 points Most recent by Gourabh Choudhary Reporting and Analytics for HCM
-
Reporting the Career Development screenHi, I want to generate the data sql report on the My Team>>>Career Development screen. But I can't find the table where this information is kept. Can you help and share?…Cansel Karasoy 66 views 8 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Schedule Report to Run Prior Month/QuarterSummary: Currently, only a few HR members can run reports, no one outside of HR can. If they need a headcount roster or turnover, I would run the report for them. There …Ratha Sun 148 views 11 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
What can we do so that OIC applications do not use license limits?Hi, What should be done to prevent the versions created for the live and test environment from using license limits in the applications we develop in the OIC environment…Cansel Karasoy 25 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Position hierarchy report prepared from Oracle AnalysisHi, I am preparing a position hierarchy report using an analysis report. How can I find the person in the next position of a position? RegardsCansel Karasoy 56 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Control Infolet visibility on HCM Home page based on person GenderSummary: Control Infolet visibility on HCM Home page based on person Gender Content (required): how to control Infolet visibility on HCM Home page based on logged in per…Nirmal Ignatius 18 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM