Global HR
Discussion List
-
Last Date WorkedHow to pull "Last Date Worked" from Termination Info? Is there a table in BIP where we can pull this column?Ronel M 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Which view/tables to access to create a report to capture User Login IP Address?Summary Which view/tables to access to create a report to capture User Login IP Address?Content IP Address of Application user in Fusion HCM is to be captured in a repor…Setu Shah-27233 495 views 11 comments 0 points Most recent by Deshin Pillay-Oracle Reporting and Analytics for HCM -
Redwood hire an employee, can i set the Toggle(s) on/off by default?Summary: Hello, So my question is; our HR department when creating a record on Oracle for a new starter would always want to use the same screens and therefore would alw… -
Can we add a textbox (Number) as runtime parameter in OTBISummary: Hi team, Can anyone please confirm if, we can create a text box as run time parameter and we need to use that runtime parameter in one of the Column formula. Pl…Sagar Perala 31 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Need to Split Job.Job Name into 3 different fields - Primary, Secondary, TeritiarySummary: OTBI Field : "Job"."Job Name" contains values like mentioned below. I would like to split them as Primary Secondary Tertiary Unmapped Unmapped HEAD OF AGRICULTU…Pradnya_Pampatwar 21 views 7 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM -
How to get specific value from XML_DATA_CACHE columnSummary: How to get specific value from XML_DATA_CACHE column in FUSION.HRC_TXN_HEADER table ? Content (please ensure you mask any confidential information): Version (in…Shlomo Elnekave 606 views 4 comments 0 points Most recent by Shlomo Elnekave Reporting and Analytics for HCM -
Performance Rating DetailsSummary Performance Rating DetailsContent Experts, Whether HRT_RATING_LEVELS_B will have the performance rating details or some other table. Would like to know the table…VijayaBaskar Ranganathan 1.1K views 2 comments 0 points Most recent by tsrinivasreddy Reporting and Analytics for HCM -
Recruiting Custom Posting Description Fields Query / SQLHello Experts We need to fetch in a query posting descriptions, for internal and external posting, that were entered by the Manager on Job Requisition Creation > Recruit…Pedro Teixeira 207 views 1 comment 0 points Most recent by Ben Baumes-Oracle Reporting and Analytics for HCM -
How to tune archive step in Extract RunSummary: How to tune archive step in Extract Run Content (please ensure you mask any confidential information): Hi Team, Greetings! We have been observing the slowness o… -
Where can we find the latest list of all HCM PVOs to be used in BICCSummary: We want to use BI Cloud Connector to pull HCM data. Where can we find the documentation for all available PVOs supported in BICC ? Content (please ensure you ma…Soumya Suravita 386 views 6 comments 0 points Most recent by Soumya Suravita Reporting and Analytics for HCM -
Audit trial for events on some modulesfor audit purposes , can we get a log if a person export data from module, or if a user query about data ? (like the search in the person managment for employee's data)Mustafa Abu Dayeh 1 view 0 comments 0 points Started by Mustafa Abu Dayeh Reporting and Analytics for HCM -
Changes only Extract is not Picking up Terminated Employees New Hires and Promotions and TransfersSummary: Changes only HCM Extract is not Picking up some Terminated Employees, some New Hires and also some Promotions and Transfers. Please advise what could be the roo… -
How should I find the full names of the people in the approvers column in the fa_fusion_soainfra.WFTHello, I use the APPROVERS column in the fa_fusion_soainfra.WFTASK table in my report, but the username is included there. I need approvers display name information. Can…Cansel Karasoy 31 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Regions and Fields not displaying listSummary: Hi, I can able to see the difference from Front End to Back End. The Sections & Fields are not present in the backend. This issue is occurring after our P2T. Th…RamkumarKadhiravan 33 views 0 comments 0 points Started by RamkumarKadhiravan Visual Builder Studio for HCM
-
Need inputs to display Payroll Run Results based on JobSummary: Need inputs to display Payroll Run Results based on Job Content (please ensure you mask any confidential information): We need to display Payroll Run Results da…Visu 21 views 9 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Can we have multiple RTF templates as links instead of tabs in BIP report?Instead of having as tabs in case of multiple templates, we would like to have them as links in single view/screen, in one page. Attached the usual format, which we don'… -
Excel Report Errorummary: Hi experts, we are trying to upload a ready excel file as a Report, but we continue to receive the following error message when trying to view it. We have alread…Marlon Castillo Maliglig 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Issue on loading Spread Sheet loaderSummary: Hi All, I have been testing the 'Mass Assign Journeys' spreadsheet template to try to mass assign a journey for the PH entities, however I receive an error (ple…RamkumarKadhiravan 33 views 1 comment 0 points Most recent by Marius Voicu-Oracle HCM Spreadsheet Data Loader (HSDL)
-
Set up a virtual/matrix organization in Oracle HCMSummary: In our organization, there is a regular organization hierarchy showing the line manager and its department. However, as we move more into an agile way of workin…Andries 132 views 14 comments 0 points Most recent by Jordan Gariety Reporting and Analytics for HCM -
OTBI: manager with at least a direct report both based in the same countryHi everyone, Our customer has the following requirement: To retrieve the list of the manager L1 located in italy with at least a direct report Both manager and direct re…Alessandra T. 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Unable to convert date in specific formatSummary: We are fetching termination date from xml table which is fetched in string format. We need to convert date in format 'DD-MON-YYYY' which is not happening. Data …Arpit Dhalawat 12 views 2 comments 0 points Most recent by Arpit Dhalawat Reporting and Analytics for HCM -
How to report on Directly Assigned detail in AOR TemplateSummary: I'm looking to report on the Directly Assigned detail in an AOR Template Content (please ensure you mask any confidential information): I've looked in all the A… -
Line Manager Dashboard custom with Manager Name HeadcountSummary: Hello, I made a custom OTBI dashboard from the vanila Line Manager Dashboard. In that dashboard we added one prompt Manager Name that is prompted. So when we se…Ilzura Ismailhodjaeva 61 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Sending non top of stack records and later using ExtractsSummary: In the event of a change, looking for the extract to send the changed assignment and later records. Content (please ensure you mask any confidential information… -
Absence Daily BreakdownWe have a daily absence breakdown report built using the subject area Workforce Management - Absence Calendar Details Real Time. SQL code attached. https://us.v-cdn.net/… -
Oracle HCM Value Sets Rest APIHi, I want to create a record for value set using Oracle Rest Api information.I found this API for this How should I use the ValueSets_Id information, which is the param… -
hide weekly working hours on employment info pageSummary: hide weekly working hours on employment info page Content (please ensure you mask any confidential information): I am looking to hide the following section on t…DanWoodward 83 views 6 comments 0 points Most recent by Stacey Williams Visual Builder Studio for HCM -
How to Hide sections by VBS for My spotlight redwood pageSummary: We recently enabled my spotlight redwood page in our lower instance. After discussing with business, they requested to hide the payroll, salary sections which a…Harika Sravani 311 views 4 comments 1 point Most recent by Jesper Jakobsen Visual Builder Studio for HCM -
Is it possible to create a position or department with a name longer than 240 charactersWhen creating a position or a department, a maximum of 240 characters can be entered in the Name field. Is it possible to make configurations that allow me to enter more?Francesca L 23 views 3 comments 0 points Most recent by John Rhodes-Oracle Visual Builder Studio for HCM