Category 81
Discussion List
-
Emergency contact OTBI analysisHi Guys i am trying to create an OTBI to show employees with emergency contacts and the contact details of them too. I have tried using the subject area 'Workforce Manag…Jeevan Loyal 20 views 6 comments 0 points Most recent by Jeevan Loyal Reporting and Analytics for HCM -
Is there possibility to disable Things to Finish tile on homepage of Oracle Fusion RedwoodSummary: want to check possibility to disable Things to Finish tile which came with update on Redwood theme on homepage of Oracle Fusion for specific user. We want to di…
-
What particular role or privilege needed to gain access to Manage Report Jobs page?Summary: What particular role or privilege needed to gain access to Manage Report Jobs page as well as the list of scheduled report jobs? Here's the example: -
OTBI Report on Seniority Rule ValuesSummary: Can we report on the values associated with a given seniority date rule using OTBI? Content (please ensure you mask any confidential information): I'd like to c…Monique 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Sign On Bonus Effective Date ReportWe have a OTBI Sign On Bonus report that runs based on hire date. I'm looking to update this report to pull based on Sign On Bonus Effective date instead. However, when …Nicole A. 14 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
HRT_PERSON_PERF_RATINGS_V shows all performance ratings not just talent ratingsSummary: When querying the HRT_PERSON_PERF_RATINGS_V table, values from incomplete performance documents will show. How do we otherwise restrict this table to show only … -
Issue with getting a cloud HCM custom Cheque report to run using its custom templateI have created a custom Cheque report, data model and template to process employee pay checks. The problem I am having is finding a way to have the custom report point t…
-
Poor Query Performance of CMP_ASG_SALARY_VSummary: A simple query on this view runs 40+ minutes. We are experiencing poor performance with the CMP_ASG_SALARY_V HCM view. When doing a simple SELECT statement with…TC 63 views 5 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Purge task is missingSummary: We are creating a report to fetch archived and purged tasks details , after purging the checklist , task name are missing . Content (please ensure you mask any …
-
Employment Contract Real Time Subject Area Not Returning any recordsSummary: Employment contract Real time subject area not returing any value when a column from "Employment Contract Details" is added. Content (please ensure you mask any…Samir Patro 21 views 9 comments 0 points Most recent by Keerthi Chinthapatla Reporting and Analytics for HCM
-
How can I change the default aggregation rule (such as sum) in the Default Aggregation Rule settingSummary: I need to change the default (sum) through default simple without sum and it isn't working in OTBI using the Worker Assignment Event Real Time SA. Thanks Conten…ClaudiaManea 12 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to enter the 'Export' Action in a DashboardSummary: How to enter the 'Export' Action in a Dashboard Content (please ensure you mask any confidential information): Hi, we created a Dashboard, based on an OTBI Repo…Barile Alberto 63 views 2 comments 0 points Most recent by Francisco Barrios Reporting and Analytics for HCM
-
Course Completion ReportSummary: Looking for something similar to what we see in the Learners section of a course/transcript. I'm able to build off of completed activities, but when an offering…
-
A bip query is running very long timeBelow query is running for a long time in production and eventually timing out when with the filters but without the filter is running and fetching some data. It was wor…
-
Query to Retrieve Complete List of Roles and Inherited Privileges in Oracle Fusion ERP CloudSummary: Query to Retrieve Complete List of Roles and Inherited Privileges in Oracle Fusion ERP Cloud Content (please ensure you mask any confidential information): I wo…
-
cannot add descriptive flexfield to Skill and qualification OTBI reportSummary: Hi all, I am creating a Data model report on OTBI to extract all info related to a section in Skill and Qualifications: I was able to retrieve all sections name…Silvia Stangarone CAI 2 views 1 comment 0 points Most recent by Mark Stoker Reporting and Analytics for HCM
-
Inaccessible columnSummary: This report is to fetch the personal contribution of an user. It is working file for everyone but one user. She is getting an error which is attached. I have tr…
-
Employees Missing in Compensation – Salary Details Real Time when using Matrix Manager FieldsSummary: Using Compensation – Salary Details Real Time , I’m experiencing an issue where employees drop from the report when matrix manager fields are added. For example…Mike Wulf 24 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Missing users from ASE_USER_LOGIN_INFO tableSummary: Missing users from ASE_USER_LOGIN_INFO table Content (please ensure you mask any confidential information): As far as I know this table stores login information…Stefano_Mazzocca 47 views 4 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Need table for Provider setting values for the task Configure Candidate Experience CAPTCHA ProviderSummary: Hi Could you please help me out to find the table where the information for Provider setting values in the task Configure Candidate Experience CAPTCHA Provider …
-
SQL query to retrieve employee business titleSummary: Content (please ensure you mask any confidential information): Hello experts, I need to retrieve the employee Business Title. Do you have a query to share to re…Valerio Curzi 273 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
XSLT Template Add Day to DateSummary: XSLT Template Add Day to Date, There is a date to which we need to add two business days (excluding weekends) and display in the output. in XLST Template only. …
-
how to fix #VALUE! error in excel templateSummary: i am using DATEVALUE function to convert text to date in excel template.However incase of blank date i an getting #VALUE!. Can anyone please help to reslve the …minati_behera-Oracle 11 views 3 comments 0 points Most recent by MJ Surel Reporting and Analytics for HCM
-
Need to display all workflow completed transactions as well as approver detailsSummary: Need to display all completed transactions as well as approver details Content (please ensure you mask any confidential information): We have a requirement to d…
-
Is there a table that store calculated time in time cardHello, I would like to ask whether this information is stored directly in a specific table or if it is derived through a calculation. Kindly advise. I've seen this view …
-
Time card approval history tables in Oracle HCM CloudWhat are the table names that store approval information for Time and Labor? Looking for timecard approvers names, dates and times as well as the status of the timecard.
-
Fast Formula retrieving Date formatSummary: Hello experts, we built the following formula to retrieve a date to be used in compensation plan in date custom field. However, when testing it the attached err…
-
How to pass person id from redwood page to Value setSummary: How to pass person id from redwood page to Value set Content (please ensure you mask any confidential information): Hi all, We created a value set to fetch late…
-
How to fetch a BIP based extract to source Approver1, Approver2 details based on Transaction SummaryThe management has requested for Approver1 and Approver2 details for all the transactions for Process name "Approve Job Requisition" within Oracle fusion. We could not f…Aashish Choyal 26 views 5 comments 0 points Most recent by Aashish Choyal Reporting and Analytics for HCM
-
Recruitment Candidate Question and Answers OTBI Report StructureSummary: I have been trying to change the layout of my OTBI report to have the candidate questions per column with their answers per row to avoid having multiple rows pe…GabrielaGilchrist 3 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM