Reports
Discussion List
-
ORC - Candidate Details Report with phone numberSummary: Looking for the column or field phone number that has both country code area code and phone number rather than displaying it in separate columns In the UI, its …ikc 31 views 3 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Table for BPM Worklist vacation periodNeed a query for BPM Worklist vacation period Rules. Which table stores the below information.Aishwarya Somvanshi 81 views 2 comments 0 points Most recent by Vijaya Sekhar A-Oracle Reporting and Analytics for HCM
-
Open a PDF in a new App or Quick actionIt is necessary to create an APP or Quick action that redirects to a PDF that the client provided us. I'm using the sandbox structure tool. But there is no option to upl…Brandon Martin-Oracle 13 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI - Checklist Questionnaire ReportingSummary OTBI Reporting on HR Checklist QuestionnaireContent Hello, Did any one try out OTBI report on Checklist questionnaire in 20C update. I have tried one, I am able …Urvashi Jain-160544 529 views 30 comments 2 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
We need OTBI column name in Absence as per below image to get leave applied dateSummary: We need OTBI column name in Absence as per below image Type is Adjustment. Content (please ensure you mask any confidential information): Version (include the v…AjayKumar Maddipati 11 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How to change the Query Time Out value in BI Published reportHi, How do we change the "Query Time Out" value in BI Published report It is available in Properties of the report data model , however maximum limit is 180000 and if i …Preeti Khondre 33 views 8 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
BI Table with ActivityAttemptId or the ActivityAttemptNumberSummary: Hi, I need to load LearningRecordActivityAttemptV3 object. To use LearningRecordActivityAttemptV3, I need to uniquely identify the rows to update using either t…Camilla Crescenzi 15 views 1 comment 0 points Most recent by Vishnu Vardhan Raju Reporting and Analytics for HCM
-
Version controlSummary Version control for OTBIContent Is there any preferred version control software for OTBI and BI Publisher code? Thanks
-
What is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' table to extract data from BICC to oacsSummary: What is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' table to pull data from BICC to OACS Content (please ensure you mask any confidential information): Version (inclu…Navadeep.Chowdavarapu 22 views 2 comments 0 points Most recent by AnujGupta_Tom BI Publisher Learning Center
-
we wants to fetch changed attribute detail in OTBI as per below screenSummary: Hi Team, we wants to fetch changed attribute detail in OTBI as per below screen so which subject area need to use ?. Thanks, Ajay Content (please ensure you mas…AjayKumar Maddipati 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Which table stores the data from plans and plan types tab?Hi Team, I am trying to fetch the data from plans and plan types tab which is under below navigation: Benefits Administration > Plan Configuration > Program Name > Basic…Saurabh_Mharolkar 22 views 2 comments 0 points Most recent by Thiru-Oracle Benefits-Oracle Reporting and Analytics for HCM
-
In Salary report midpoint and comp ratio but report showing wrong when Grade code changedSummary: Hi Team, have direct column in salary report, midpoint and comp ratio but report showing wrong when Grade code changed . please any on help me on ? PFA. Thanks,…AjayKumar Maddipati 21 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
User Last Login Date ReportSummary Need to report on User Last Login DateContent Hi All, I am looking for a way on how can I report for User Last Login Date using BI Publisher. I tried using the F…Nep Manas 6.3K views 22 comments 2 points Most recent by Ashraya S.N Reporting and Analytics for HCM -
hcm infoletSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Joe Hiltner-Oracle 12 views 0 comments 0 points Started by Joe Hiltner-Oracle Reporting and Analytics for HCM -
BI Reports are not displaying to tag them in Link or Image section in DashboardSummary: Hi Team, We are creating the Dashboard. Unfortunately, we were encountering that BI reports are not showing to add them in the Link or Image sections in the das…Dasari Dileep 11 views 4 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Building Scalable Payroll Balance Reports in OTBISummary This document provides guidance to OTBI report developers on how to build scalable reports for reporting on Fusion Payroll balances.user714053-Oracle 210 views 4 comments 4 points Most recent by Divyalakshmi Krishnamoorthy Reporting and Analytics for HCM
-
what is difference between CMP_ASG_SALARY_V and cmp_salary ?Summary: Hi Team, what is difference between CMP_ASG_SALARY_V and cmp_salary because of still cmp_salary showing corrctly of cs.COMPA_RATIO and cs.RATE_MID_AMOUNT column…AjayKumar Maddipati 26 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Exclude 'Days Suspended' in Recruiting Dashboard Time to Hire data?Summary: Exclude days suspended in Recruiting Dashboard 'time to hire' metrics Content (please ensure you mask any confidential information): Our client wishes to exclud… -
How to fetch Reason value from ORC in BI reportSummary: Hello Experts, Need your help in pulling a field called reason found in ORC module. PFA the screenshot of the field i want pulled. I am aware this field is pres…Jithin Mathews 31 views 3 comments 0 points Most recent by Ted Wayne County Consultant Reporting and Analytics for HCM
-
Getting error -ORA-01840: input value not long enough for date formatSummary: I am getting error in BI report due to below line of code. Error - ORA-01840: input value not long enough for date format to_date(:sdt,'yyyy-MM-dd')
-
Unable to get required currency format in Excel outputSummary: this is the tag we are using to get amount column in US format. we are able to get it in PDF output but not in excel. Content (please ensure you mask any confi…Nalsoft Pvt Ltd 22 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Is Project Number for AP available in General Ledger or Subledger Accounting Subject AreaGood Day Experts, Is project number field for AP available in General Ledger or Subledger Accounting Real Time subject area? Just like the PO Number for AP where I can g…
-
SQL to fetch the history ratings from talent profilesSummary: Hi, Could any help me with the SQL Query or table names to fetch the ratings from the talent profile. Navigation: Me>career and performance>skills and qualifica…
-
How to suppress aggregated column in order not to repeat its values for every rowsSummary: Suppress aggregated column value Content (please ensure you mask any confidential information): Is it possible to suppress the value of aggregated column in ord…JMLMIII 42 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI report should drill to show the courses that are part of the specialisation.Hi, We need assistance with an OTBI analysis where clicking on a specific specialization should redirect to another analysis that displays the courses included in that s…Saurav R-Oracle 23 views 0 comments 0 points Started by Saurav R-Oracle Reporting and Analytics for HCM
-
Join in OTBI is not removing data where joining two subject areas.Summary: When joining two subject area's the data is not removing information in one of the subject areas. Content (please ensure you mask any confidential information):…Max W 14 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Sql to find t4 information of employee (like tax year and boxes information etc)Summary: Dear exports, Any one have sql/otbi report to pull the information exist in canada t4 slip? Please suggest Content (please ensure you mask any confidential info…Rama123-Oracle 11 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
How to suppress values in OTBI?I've created an analysis under User System Usage subject area. I'd like to suppress the values like on what I've drawn below: Though I've already configured it to the co…