Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
Where to find Currency Conversion Rates used in a Compensation Plan?Summary: Hi all, I have a compensation plan (CMP_PLANS_B) with a specific PLAN_ID. I want to retrieve the currency conversion rates used for this plan, which were upload… -
Maximum report data size for offline (scheduled) reports value changeSummary: Maximum report data size for offline (scheduled) reports value change Content (please ensure you mask any confidential information): Hi Team, Greetings! How do … -
Department Set Name/CodeSummary: We have a requirement to include the Department name, Department Set name/code to a project details BIP report we are able to find what table holds the departme… -
Is it possible to report on Interview Requests?Summary: Is it possible to report on Interview Requests? I've seen the post linked below, which I thought was asking the same question, but the answer appears to be dire… -
How to get the XML data for TimecardApprovalNotificationReport seeded reportSummary: Hi Experts, we have a requirement to get the XML data out of the TimecardApprovalNotificationReport to troubleshoot how data is displayed in the report, does an…
-
Display Value for Time Entry Layout Component fieldSummary: Display Value for Time Entry Layout Component field Content (please ensure you mask any confidential information): Hello, I have a time entry layout component o…
-
I need to create an analytic in OTBI To identify what work schedule is assigned to employeesI am trying to create a simple analytic in OTBI to show all employee names, their assignment numbers and the names of the assigned Work Schedule for each assignment. It …
-
Embedded Reports not loading 1st time opening the screensSummary: Embedded Reports not loading 1st time opening the screens Content (required): Hello We have 2 embedded reports in the absence screens which are not loading on t…
-
Employee/Person Addresses not visible in per_addresses_f tableSummary: We have loaded Employee/Person Home Addresses data using HCM HDL file and the load was successful. I can see the data in the table per_person_addr_usages_f but …
-
SQL query to retrieve employee location country nameSummary: Content (please ensure you mask any confidential information): Hello experts, we need a query to retrieve the employee location country name but below it extrac… -
organization seniority date on multiple contractsSummary: How can I report on the Org Seniority Date when person has more than 1 contract Content (please ensure you mask any confidential information): Hello Has anyone … -
Unable to bring max effective date record in a report while using an EIT flex fieldSummary: In a report with 2 subject areas, columns are not working properly. Subject Areas used: Worker Assignment Real time and Person Real time Created a report with s… -
Missing HcmTopModelAnalyticsGlobalAM.OrgAttributesDFFBIAM.FLEX_BI_OrgAttributesDFF_VIWe don't see HcmTopModelAnalyticsGlobalAM.OrgAttributesDFFBIAM.FLEX_BI_OrgAttributesDFF_VI in BICC offering though it is available HCM PVO mapping document. How do we ge…
-
XML-22002: (Fatal Error) Error while processing include XSL fileSummary: We are getting the error XML-22002: (Fatal Error) Error while processing include XSL file (xdoxsl:///Custom/Human Capital Management/HR/SUBTEMP.xsb?loc= en-GB) …
-
In which table has the name format components storedSummary: Hi Team, We need a table where the name format components stored, Tasks: Manage Person Name Formats - HR_NAME_FORMATS I need the table for name format component…
-
Can i get a list of reports from Catalog in OTBI?Summary A client has requested a report showing names and location of all reports available in OTBI (including custom reports). How can i get such a report? Content (ple…
-
Number field not displaying correctly on RTFSummary: I have a RTF created with the BI Publisher Add-in and is sent as a PDF email notification through a bursted BIP report. There is a number field on the RTF, that…
-
How to Encrypt and Send BIP report output from oracle HCM cloudSummary: There is a need to Encrypt a BIP report output to 3rd party through SFTP. Please let us know the possibility and how to accomplish it ? Does BIP provide any def…
-
Query to get Fusion Workflow ApprovalsHello, Is there a query where i can get all pending approvers for a transaction, not only the current assignee? I was able to identify the current assignee using the bel…
-
BIP report to extract all JR approval flow stepsSummary: BIP report to extract all JR approval flow steps Content (please ensure you mask any confidential information): Hello experts, my customer requirement is to ext…
-
Extract future task assignment in transaction approval flowHello experts, I know that we have the ability to query current and past approvers for an approval transaction (hrc_txn_data / fa_fusion_soainfra.WFTASK), but is there a…
-
PER_PERSON_SECURED_LIST_V showing own recordsSummary: Hi, We have some reports created with PER_PERSON_SECURED_LIST_V one employee is from a country A with AoR from country B, on person management the employee cant… -
Error changing ReportsWhen trying to change the report from the custom folder, the following error appears:
-
Add custom font to OTBI reportsSummary Can we add custom fonts to OTBI reports?Content I did upload a ttf file and created font mapping in Administration page but the font is not reflected in the OTBI… -
Employee Connection - Colour bar represents assignment typeSummary: My Organization chart page displays yellow bar for contingent workers and blue bar for employee assignments type. I do not see this colour bar feature on connec…
-
How can I display user chosen from and to dates in OTBI?Is there way to show the dates a user has selected in the output of the report? Date run can be shown in the title, but I want the user to enter a from and to date and t…
-
In which table has the information of Mail Stop in Legal Reporting Unit AddressesSummary: Hi, In which table has the information of "Mail Stop" in Legal Reporting Unit Addresses under the setup Manage Legal Reporting Unit. We checked in below tables …
-
Pivot table is not working in OTBI report with 2 subject areas, columns are not working properlySummary: Pivot table is not working in OTBI report with 2 subject areas, columns are not working properly as per the pivot table layout. Created a report with subject ar…
-
Overdue Task Report in Journey ChecklistsSummary: Overdue Task Report in Journey Checklists Content (required): Hi All, Greetings! we are trying to check the exact data for the terminated employees with checkli…
-
What is the OTBI Subject Area to get data from PER_LOCATION_LEG_F tableSummary: Which Subject Areas should i use to get the details from PER_LOCATION_LEG_F table. Should we need to any process to add those fields to the Subject Areas ? Cont…