Global HR
Discussion List
-
How can I export list of delivered reports for fusion HCM?Summary: Where can I find list of core delivered reports for fusion HCM modules. Content (please ensure you mask any confidential information): Version (include the vers… -
Name of the table that stores the 'Location Based Access' infoSummary: Hi, I'm trying to figure out the table name that stores the 'Location Based Access' info. Navigation: FA → Tools → Security Console → Administration → Location …ganapathysundaramd-Oracle 6 views 0 comments 0 points Started by ganapathysundaramd-Oracle Reporting and Analytics for HCM -
Fast Formula doesn't return expected valueSummary: Content (please ensure you mask any confidential information): Hello, we built the following FF where we should retrieve value from two different value sets. If…Valerio Curzi 21 views 3 comments 0 points Most recent by A_R-Oracle Reporting and Analytics for HCM -
Overall Summary and Rating in Document of RecordsSummary: Does anybody tried to bring the Overall Summary and Rating details from Performance to a Document of Record? Is it feasible to add those in a DFF? Content (plea…GeorgianaB. 6 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
HCM Transformation Fast Formula : Getting all Metadata for AssignmentWe are trying to develop Worker.dat which will include Workterm and Assignment Metadata why We are able to get all the required fields metadata for worker but somehow as…Ajitabh Kumar-Oracle 29 views 2 comments 0 points Most recent by User_VB3A0 Reporting and Analytics for HCM
-
SYSTEM_PERSON_TYPE not updated to CANCELED_HIRE after Cancellation of work relationshipSummary: We used to get the employees whose work relationship is cancelled after Hire (from Pending Worker to Employee conversion) by querying the 'per_person_type_usage…Sujay Bhowmick 49 views 6 comments 0 points Most recent by Awadhendra Tripathi Reporting and Analytics for HCM
-
Guidance on OTBI Report for Transaction Summary by RegionSummary: OTBI Report for Transaction Summary by Region Content (please ensure you mask any confidential information): Hello Experts, We have a requirement to extract tra…Vasanthakumar Ravi 8 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Physical Signature Example Report for JourneysSummary: In release 24B, Journeys introduces the ability for Physical Signatures to be captured in the Native Electronic Signature task types. Additionally, Native eSign… -
Help Needed: Retrieving Current Address for a Legal EntityHi Everyone, I'm trying to retrieve the current address for a Legal Entity, but I'm facing challenges in identifying the correct tables and joins. Context: I understand …
-
Enterable Calculation Values on Calculation Cards - Query/ReportSummary: Enterable Calculation Values on Calculation Cards - Query/Report Content (required): Hi Team, Greetings! Does anyone have the report or query to extract the dat…Parag Hiremath 100 views 6 comments 1 point Most recent by Ankammarao Reporting and Analytics for HCM -
SQL query to fetch number of direct reportees to a line managerSummary: I want to build a BI report where I need to fetch the count of direct reportees to the Line Manager. Content (please ensure you mask any confidential informatio…Tamseel Aijaz 30 views 1 comment 0 points Most recent by Robinson Ng Reporting and Analytics for HCM
-
Based on the parameter year i should get the data based on that year i should get the data.lets say the paramter is audit_year = '31-12-2021' the requirement is something that we should get the data based on the parameter i.e i should get the person record bas…
-
Payroll Flow - BI Report - Bursting - Not generating output file.Hi folks, I'm generating a payroll report and pushing it on SFTP using bursting. Template, filename and path is derived via bursting .This report is attached to a Payrol…
-
Report dashboard prompt showing error - ACIOA5LNSummary: Report dashboard prompt showing error - ACIOA5LN Content (required): One of the working BI report which uses dashboard prompt, suddenly stopped working and show…Swati U 2.3K views 17 comments 1 point Most recent by Aaron Epstein-261578 Reporting and Analytics for HCM
-
Chetana Pawar 700 views 2 comments 0 points Most recent by Maheswar Reddy Reporting and Analytics for HCM
-
notification received is Redwood Users Delegation RolesSummary: Content (please ensure you mask any confidential information): The notification received is Redwood Users Delegation Roles. I need to know the OTBI path for thi… -
Object Validation Rule for Salary Adjustment Percentage not supporting as expected.Summary: Object validation rule for Salary business object is triggering for conditions where Salary.Adjustment Percentage should generate error message. Condition is se…Gaurav Bhagwandas Bhojwani 18 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Learning items with learning outcomes assigned are not displayedLearning items with learning outcomes assigned are not displayed. In the front we can see data according to this but not in OTBI. Using the "Workforce Learning - Learnin…User_DA2EL 15 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM
-
BIP publisher email unable to send to icloud candidate emailSummary: Hi, we are using BIP jobs to trigger emails to new hires based on task completion in journeys and recently BIP email is getting failed to deliver to icloud doma…
-
Default View Reports and AnalyticsHello all - We're currently looking for a way to default the displayed folders application and user wide when navigating to Reports and Analytics from the home page. Doe…Samantha_Kellstrom 16 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Manager information regarding the last active assignment of inactive employeesHello, In Oracle HCM system, the manager information of the employees who left the job is emptied, therefore the managers of the inactive employees are empty in my repor…Cansel Karasoy 15 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report that identifies when an employee becomes a manager of peopleSummary: Is there a way to build an report that will identify when an employee (non-manager) becomes a manager (people leader). We utilize the "Working as a Manager" fie…S. Johnson 20 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Employee Length of service (LOS) sql query based on Hire Date/Rehire Date in fusion hcmHello Team, I need a sample Employee Length of Service (LOS) SQL query based on hire date/rehire date in Fusion HCM to use outbound integration for one of my customers. …Janardhana K 41 views 1 comment 0 points Most recent by Janardhana K Reporting and Analytics for HCM -
What privilege or configuration is needed to ensure the user could view Demographic Info it in OTBI?Summary: Content (please ensure you mask any confidential information): One user can see PER_PERSON_LEGISLATIVE_DFF on the screen but not in OTBI, while another user can…
-
how to personalize / customize all Oracle HCM notifications - my changes are not showingSummary: Customer requirement is to personalize all HCM notifications for users. The requested changes are the following: - place their logo in all HCM workflow notifica…Katarina Bartova-Oracle 9 views 1 comment 0 points Most recent by Katarina Bartova-Oracle Reporting and Analytics for HCM
-
What table stores the extended lookup code name for Visas and Permits?Summary: I am trying to build a DM for Visa and Permit notifications. What table stores the extended lookup code name for visas and permits? I would assume there is a ta…Luke.Findex 16 views 5 comments 0 points Most recent by Ketan-Oracle Reporting and Analytics for HCM -
Document of Record : Salary Certification - QR code generationSummary: We have a requirement from the customer to generate a salary certificate letter from Oracle Fusion HCM that includes approval. The letter must include an auto-g…
-
How to report on details held in Past Incumbents section of Position DetailsSummary: We need to add some of the fields held in 'Position Details' into an existing report but cannot find within any tables columns that correspond to the fields vis…
-
Query to get Vacation Rules informationSummary: Query to get Vacation Rules information Hi, We need to create a report for vacation rules for all employees in the system and I know that there is a seeded repo…Kiran345 353 views 14 comments 0 points Most recent by Deepak Kumar Dev-Oracle Fusion Applications Administration
-
How to fetch Cost Center Details which are mapped at Department LevelContent Hi Team, In our organisation we mapped Cost Center at Department level. How to fetch those cost center details. If anyone have SQL query please help me. I tried …User_2025-02-05-04-17-04-394 6.2K views 13 comments 0 points Most recent by Boying Reporting and Analytics for HCM