Category 81
Discussion List
-
Absence update history not availableSummary: Currently when the employee update the existing absence record and submit it, the back end does not hold both the data on the absence entry table. Unfortunately…Sobitha Venkatraman 4 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM -
Data isn't retrived due to special character in Business Unit promptSummary: Hey, We have an issue with our Performance dashboard. The dashboard is based on OTBI analysis reports and the Performance subject area. One of our BU was create…Markovich Chen 22 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to identify C-Suite leader in headcount reportI'm trying to add a column that will identify our C-Suite leaders for each employee in headcount report. C-Suite leader would be the CEO - 1 or whomever is the top-most …S. Johnson 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
What is a variable formula that uses the standard working hours converting our analysis to days?Summary: What is the formula that we can use for our Absence Analysis that will use "standard hours" (which isn't always 8 for us, sometimes it's 24, sometimes 7.25 etc)…MissHeidiJ 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Absence Report CalendarSummary: Hello Experts I have been tasked to develop a Calendar Report that looks like the attached as the screenshot system will be replaced soon. I am uncertain how at… -
SQL How to get point information for questions at manage activities -> (i) information -> ViewSQL How to get point information for questions at manage activities -> (i) information -> View Content (please ensure you mask any confidential information): Version (in…
-
Query to get department from PAY_COSTS tableSummary: Need to link the department to the PAY_COSTS table. How can I link the department (organization_id) to the PAY_COSTS table through other tables? Content (please…luke.syv8 1 view 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Reporting and Analytics for HCM
-
url enrollement link otbiSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to retrieve data from excel dataset into Fast formula?Summary: How to retrieve data from excel dataset into Fast formula? Content (please ensure you mask any confidential information): I have this data model with excel base…
-
Unable to add table or link to a oracle analytics deliversWe have the next análisis with the next details: this is the text in the notificatión: [u] Hola, @2 [/u][br/] Recuerda que debes registrar tus vacaciones en la plataform…
-
need sql query / table name to get system ip and host name Against transactionsSummary: i need to get system details against each transaction. ex: some one created 1 transaction then need to know through which system it got created (system ID , hos…Eswaraiah.chikkala 33 views 1 comment 0 points Most recent by Alexandru Dicu-Oracle Fusion Applications Administration
-
I am unable to find out the table which stored the frequency of the workflow remindersI am unable to find out the table which stored the frequency of the workflow reminders in oracle hcm fusion.Kindly let me know if any one is aware of the sameUser_NQOB7 3 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Oracle HCM Fusion Cloud - Data Retention and Back-up on License Contract expirationOur Oracle HCM Fusion Cloud License is about to expire ; we have decided to move to an alternative HCM Solution Provider; could someone please guide on the documentation…ARUNGTA 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Mail notification sending limitSummary: Hi Experts, Using Oracle Fusion HCM Cloud, is there a limit on the maximum number of people a BIP report can be sent using bursting? Regards, Sumit Upadhyaya Co…Sumit Upadhyaya 30 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Flow Ess job definition running long time.Hi, We have created a flow which will execute HCM Extract, While we ran the Flow it taking too long time, but separately if I run that Extract it is completing with in s…Kiran Kollamsetti 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Dynamic Fields Not Fetching in Journeys Report for Tuition Reimbursement TaskDear Oracle Community, I'm seeking assistance with a report issue I'm encountering in the Core HR module. I've created a report and linked it with a data model for the "…
-
Is there any report code for identifying special characters within a field?Summary: Currently some of our addresses contain commas or other special characters. Is there a way to identify these records within OTBI? Content (required): Address Li…Mark Stoker 23 views 3 comments 0 points Most recent by Robert-Jan H. Reporting and Analytics for HCM -
Requisition Template ReportSummary: Hello - We are looking to create a report which shows all jobs and the requisition template they are associated to based on the Job Details section. We are not …Shanna Oppenheim 112 views 19 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
OTBI Formula to pull two months data for automated reportSummary: OTBI Formula to pull two months data for automated report Content (required): Hi we have a task to automate the report which pulls termination for the current a… -
How to retrieve 'Exempt from Long Term Care' associated with Washington tax card from backend table?Summary: I am trying to locate 'Exempt from Long Term Care' linked to the Washington Regional Tax Card in the backend table, but I cannot find the base name in the backe…Swapna Udaiyar 62 views 7 comments 0 points Most recent by Gabriela Ichim-Oracle Reporting and Analytics for HCM
-
Unable to test Connection while using SFTP serverSummary: Hi Team, While is try to add a new connection with SFTP server, by giving all host, port , username and pwd and try to establish connection , it is getting fail…Dhilipkumaar-Oracle 52 views 2 comments 0 points Most recent by Dhilipkumaar-Oracle Reporting and Analytics for HCM -
How to retrieve audit reporting details concerning attachments like f.ex. Document of RecordsHi, Our client would like to have an Audit Report that generates the creation, update or deletion info of a Document of Record (with related user data of course; resp. w…
-
We looking Variable pay plan details in OTBI for which subject area need to use ?Summary: Hi Team, May I know which subject area need to use for Variable pay plan details as per below screen shot. Variable pay plan details: Content (please ensure you…AjayKumar Maddipati 12 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Employee details at the time of the absenceI would like to report on the worker details at the time of the absence. If for example an employee changed department today, the absence from last year would show the d…NusratB 33 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Worker Data Load (HDL) TIPS requiredSummary: Need a checklist while loading Worker data Content (please ensure you mask any confidential information): Hello Everyone, I'm new to loading HCM data, including…Lucky Sharma 22 views 1 comment 0 points Most recent by Madalina Danis-Support-Oracle HCM Data Loader (HDL) -
I am looking for the field.Summary: Hi, I am looking for the column/field of "Does not meet the required criteria for the role" in ORC. Content (please ensure you mask any confidential information…Robb 62 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Query to get Requisition Template name in ORCHi, I have requirement to get Requisition Template name from Basic Information. navigation --> My Client Group - Hiring - Requisition (number) - Details - Basic Informat…Rajdeep Chavda 235 views 10 comments 0 points Most recent by YASHWANTH GOWDA H R Reporting and Analytics for HCM
-
Analysis of employees assigned performance goals and not assigned performance goals for a goal plan?I have created an analysis using the Workforce Goals - Goals Status Overview Real Time subject area. I have selected the following subject areas and applied filters (scr…Adrian Clarke 52 views 2 comments 0 points Most recent by Adrian Clarke Reporting and Analytics for HCM -
How to default the Location of Logged In User in Dashboard PromptSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Narendar Rao Naineni 22 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
View object cannot be found for HCM table PER_POSITION_EXTRA_INFO_FWe were using the oracle mapping document "Rel13_23D_BICC_HCM_Database_Mapping_with_ViewObjects.xlsx". Looking for the corresponding VO for table PER_POSITION_EXTRA_INFO…Ian Cosinas 92 views 3 comments 1 point Most recent by Chandra Chappidi Reporting and Analytics for HCM