Category 81
Discussion List
-
Example Feedback Report query for BI Publisher based on Feedback requests and Questionnaire tablesSummary: Our requirement is to generate a report based on feedback requests and questionnaire (eg. Annual Performance Feedback) tables. Manager will submit Feedback Requ…MadhuLekkala 59 views 2 comments 0 points Most recent by MadhuLekkala Reporting and Analytics for HCM -
I need to retrieve a list of all data roles and job roles associated with a given privilege.When querying by privilege name, I want to capture all the corresponding data roles and job roles linked to it. I attempted using the tables ASE_PRIVILEGE_VL and ASE_PRI… -
Some Employee missing of the Reports on certain dateSummary: I want to explain the issue we encountered. On December 10, the HR team uploaded a change affecting all employees in a specific department, effective December 1…Lucas B Maciel 21 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Query Regarding Adding a Secured List Table to Oracle BI Data ModelSummary: Query Regarding Adding a Secured List Table to Oracle BI Data Model Content (please ensure you mask any confidential information): Hello, I am working on a BI d…
-
Is it possible to find deleted checklist details?Summary: Is it possible to find deleted checklist details? Content (required): Hi All, For one employee, one check list has been assigned and deleted by someone. I verif…
-
How is Business_Group_Id in PER_ALL_PEOPLE_F a foreign key to HR_ORGANIZATION_UNITS which is a view?How does the BUSINESS_GROUP_ID column in the PER_ALL_PEOPLE_F table function as a foreign key to the HR_ORGANIZATION_UNITS view, given that the view is not a physical ta…Aryan Yadav 27 views 3 comments 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Actual Termination Key Date?Client is saying The ActualTerminationKeyedDate is a column in the "per_periods_of_service" table. We don’t see from our side the termination_key_date from "per_periods_…Ronel M 3 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management -
Copying OTBI reports in bulkSummary: Copying OTBI reports in bulk Content (please ensure you mask any confidential information): Hi Team, Greetings! There is a requirement to copy multiple OTBI Rep…Parag Hiremath 13 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
OTBI Analysis, Payroll - Calculation Cards Real Time - PAE - How do I show each linked assignment?Summary: I'm trying to create an analysis to report on employee Calculation Cards using Payroll - Calculation Cards Real Time and in the case of employees with multiple …Julie Searles 66 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
how long data can store fa_fusion_soainfra.wftask this tableSummary: Need information about this table how long data will be store Content (please ensure you mask any confidential information): Version (include the version you ar…Nagendra Chitra-Oracle 45 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
Unable to fetch the State, County and City values through "Payroll - Calculation Cards Real Time"Summary: Unable to fetch the State, County and City values through "Payroll - Calculation Cards Real Time" subject area Content (please ensure you mask any confidential …
-
Is there a way we can use embedded reports for custom error messagesWe have a requirement to have an error message to validate entries in a standard field in Learning module. As far as we have checked, there are no autocomplete rules ava…
-
Passing the parameter at run time from the URLI am creating a BIP report and want to pass parameters from the URL. For example, I have a report with a parameter for Assignment ID. When I open the report, it should l… -
How can I create a JSON file using BI PublisherSummary: How can I create a JSON file using BI Publisher Content (required): I want to create a JSON file using BI Publisher. I am able to generate the JSON format in th…Viju George 1.6K views 8 comments 1 point Most recent by Swati epari Reporting and Analytics for HCM
-
In BI Publisher scheduled report how to disallow using Email Destination while retaining burstingSummary: Can BI Publisher scheduled reports be setup to disallow using Email Destination (either enterprise wise or certain user roles) while at the same time retaining …Jbgood 12 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Opportunity Marketplace Out of the Box ReportingSummary: Opportunity Marketplace Out of the Box Reporting Content (please ensure you mask any confidential information): Are there any out of the box reporting for Oppor…
-
How to make bold font in a custom formulaSummary: Using subject area WFM Worker Assignment Real Time, field Worker/Address Line 4. Is there a way to modify this formula to show 'MISSING' in bold red text? CASE …
-
BI report does not open in android devicesWe have a third party payroll integration and we have a report so that payroll outputs can be pulled from self service. When this report is opened from the mobile applic…Ömer Vardar 35 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
I was trying to create a report to pull employees, excluding the managersHow to pull employees using OTBI and to exclude managers who are also an employee. please share ideas thanks.Joliver Caangay 22 views 2 comments 0 points Most recent by Joliver Caangay Reporting and Analytics for HCM
-
How to show only specific folders in Reports and Analytics Catalog?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Wil Mendiola 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
unable to get the assignment details for pending worker from checklist real time subject areaHello Team, while running the report from checklist real time subject area the orgainzation hierarchy levels are showing null and also all the attributes for assignment …Shivam Naugraiya 4 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Oracle query to get values on 9 box grid for a person in HCM fusion talent review meeting reportOracle query to get values on 9 box grid for a person in HCM fusion talent review meeting reportDeepeeka Nath 57 views 4 comments 0 points Most recent by Neno Kolonich Reporting and Analytics for HCM
-
BI Report Time card details - Calculated details by earned dateSummary: Team we have a requirement to fetch all the details available in the timecard. (Calculated details by earned date) - Screenshot attached. I am using the below q…
-
Editing PersonHeader subtemplateHello. I'm trying to customize the PersonHeader subtemplate and is already in the Shared Folders/Custom/Human Capital Management/ Workflow Notifications. But when I chan…Maria Cristina L. San Jose 61 views 2 comments 0 points Most recent by Luis Villagomez - IMMI Reporting and Analytics for HCM
-
Journey's comments section data is missing in OTBI reportJourney's comments section data is missing in OTBI report Step 1 - We have created a journey. Employee will be able to use the Journey. Employee is able to enter the com…Challa Ramya-Oracle 13 views 2 comments 0 points Most recent by Diana Mitrovski Reporting and Analytics for HCM
-
Seeking documentation to code for HR Org hierarchySummary: Hello All, I see that Fusion utilizes the following tables to manage HR organizations and their hierarchies: - HR_ALL_ORGANIZATION_UNITS_F (internal CDEE_FSCM_O…
-
Which table stores job link from ORC Career SiteSummary: I am trying to find table which stores job requisition link from career site. Content (please ensure you mask any confidential information): Version (include th…HCM_Rahul 28 views 1 comment 0 points Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace
-
How to customize the sub template for Termination Report?Summary: How to customize the sub template for Termination Report? Content (required): Hi All, How to customize the sub template for Termination Report? Where I can find…Venkatesan 31 views 4 comments 0 points Most recent by Luis Villagomez - IMMI Reporting and Analytics for HCM
-
Is there a way to monitor the performance of an environment via a dashboard somewhere?We would like to be able to monitor the performance of, in particular, our live environment and I cannot find anyway to be able to do this without needing to raise an SR…SGrady 114 views 17 comments 1 point Most recent by Garrett Reynolds-Oracle Reporting and Analytics for HCM