Category 81
Discussion List
-
Guidance to optimize OTBI HCM Cross-SA Reports having static report filters1- Some Cross subject area reports may be costly in terms of response time, if they are not designed correctly. It is always recommended to use (i) at least one common d…Abhishek Dixit-Oracle 144 views 2 comments 4 points Most recent by UdayrajSingh Reporting and Analytics for HCM -
Report Date Parameters needed START: (First_Day of Last month) END: (Last_Day of Last_month)Summary: Hi Forum: I'm looking to use below to accomplish General tab for Scheduling a report START: Last_Day(ADD_MONTHS(SYSDATE,-2))+1 First_day END: Last_Day(ADD_MONTH… -
How to gather data of update interest tab from all employees?Summary: We need to create a report which shows all the data user has entered in Update interest page. Basically we want to gather employee interest so that recruiter ca…Vaidehi Desai 16 views 2 comments 0 points Most recent by Vaidehi Desai Reporting and Analytics for HCM -
No results if no filter is appliedSummary: Hi, We have an HR role with access to a compensation OTBI report. In order for the results to be displayed, HR must filter by at least one BU. However, if I ass…
-
how to call BIP report using REST webserviceSummary: I want to get the BIP report output using REST webservice REST API for Oracle BI Publisher - Run report I have followed oracle doc and this Run Oracle BI Publis…KetanChavan 376 views 10 comments 0 points Most recent by Catherine Alequin Reporting and Analytics for HCM -
How to get Employees Annual Performance score in OTBI reporSummary: How to get Employees Annual Performance Overall Score rating in OTBI report. Content (please ensure you mask any confidential information): Version (include the…Ramani K 8 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
ORA-64203: Destination buffer too small to hold CLOB data after character set conversion.Summary: How to solve ORA-64203: Destination buffer too small to hold CLOB data after character set conversion. Content (please ensure you mask any confidential informat…Stefano_Mazzocca 109 views 3 comments 0 points Most recent by User_FR8AH Reporting and Analytics for HCM -
SQL query to Backend table for Filtered List under Learning ManagementSummary: Hi Team, We need a backend table or SQL query to get Filtered Lists in Learning Management module. Navigation: My Client Groups → Show More → click Filtered Lis…
-
Time card details based on payroll flow - Load Time Card BatchesHi Expects, Requirement : Need to fetch time card details based on payroll flow - Load Time Card Batches. basically OTL report , based on payroll flow parameter. when we…Rajdeep Chavda 75 views 6 comments 0 points Most recent by Om Shukla-Oracle Reporting and Analytics for HCM
-
Hide Schedule and Job option from reportSummary: Hide Schedule and Job option from report Content (please ensure you mask any confidential information): Hello experts, does anyone know how to hide the followin… -
Looking for the Checklist Task Sequence in the Workforce management Checklist Real TimeSummary: Looking for the Checklist Task Sequence field in the Subject Area Workforce Management - Checklist Real Time Content (required): We are looking to add the Check… -
REST API to get worker assignment historySummary: How to fetch Worker Assignment History details using REST API Content (please ensure you mask any confidential information): The requirement is to fetch Worker …
-
extract element type id from xml cacheSummary: How to extract element type id from xml cache: When I try to extract the value , it is always throwing error : extractValue(value(ElementEntry), '//ElementTypeI…
-
Comment Column is splitting into multiple rows in Excel outputComment Column is splitting into multiple rows in Excel output for online BI template.
-
Building an OTBI report using OTL data. Can't find Project RoleSummary: We are building an OTBI report to show all timecard entered for the week. We are project based company so our timecards include Project and task information, in…Anjula Mittal 27 views 3 comments 0 points Most recent by John Finnegan-Oracle Reporting and Analytics for HCM
-
Query to get interview details for a job requisition using BI ReportSummary: Hello Team, I am trying to get interviewer details (Interviewer person number and email address) using below query but I am not getting the right results. Can a…
-
Custom BIP reports - Security access to view scheduled job outputsSummary: Hi All, We have 5 custom BIP reports, which are shared via scheduling to 5 different groups of people in our organization. We are not sending the output via ema… -
Need Privilege to Edit or Add Location Details (Building, Floor etc) on Assignment PageSummary: Hello Team, We’re looking to identify the exact security privilege required to edit or add Location Details (Building, Floor, Office Number, Mail Stop) using th… -
How to change the week start daySummary: Hello Experts, I created an Analysis and i see the Calendar Week Start Date is Sunday, but the customer need set to Monday. And this impact on the number of wee…
-
Unable to restrict OTBI data based on legal entitySummary: While attempting to create any OTBI analysis from HCM subject areas, we are encountering an issue where the data is not being limited to a specific legal entity…
-
How to fetch the survey section from Performance DocumentHello Experts, Does anyone know where in the tables to fetch the Survey section from performance document? Please Help! TIA
-
Element HDL Template Generator ReportSummary OTBI report to generate sample files to create Payroll Elements using HDL Content Introduction: This report provides sample files to create Payroll Elements usin…Kaushik R-Oracle 9.7K views 127 comments 35 points Most recent by Lava Somepalli-Oracle Reporting and Analytics for HCM -
Human Capital Management - Transaction Administration Real Time subject area not workingSummary: We have a report reuqirement to fetch all workflow transactions whether completed or failed, and for failed transactions we need to populate th eissue title, is…Velidi Supraja 7 views 0 comments 0 points Started by Velidi Supraja Reporting and Analytics for HCM
-
Query/table information to obtain issue description from transactions that end in errorSummary: need a way to report on Issue description, Resolution and Number from transactions that end in error. Content (required): When a transaction ends in error there…PrashanthGanji 302 views 11 comments 1 point Most recent by Velidi Supraja Reporting and Analytics for HCM -
Action link for learningSummary: Need guidance to create action link for course learning report. I have made a learning report where course related columns are present, e.g. learning item name,…
-
Performance Calibration Module data in OTBI?What Subject Area is this data stored in? I'm specifically trying to extract the Calibrated rating. I've found all other data in our module setup with the exception of t…tim.glasheen_1073872 25 views 4 comments 0 points Most recent by tim.glasheen_1073872 Reporting and Analytics for HCM
-
SUBJECT_ID context in HRQ_QSTNR_PARTICIPANTS in case of use for Feedback CenterSummary: Hello, I'm building BIP report which should show Feedbacks from Feedback center where customer uses the questionnaire. I have SQL which returns me all questions…Martin Smid-Oracle 16 views 1 comment 0 points Most recent by Martin Smid-Oracle Reporting and Analytics for HCM
-
From which table can I check the scheduled report job?Hi, Which hcm table can I query to view the history of my scheduled report? I want to get the last run date of the report job from this table. I will be grateful if you …Cansel Karasoy 890 views 16 comments 0 points Most recent by AMIT KUMAR YADAV Reporting and Analytics for HCM -
Dynamic Date Prompts and SQL Setup for OTBI Workforce ReportSummary: Assistance needed with creating a dynamic OTBI report that allows users to enter date ranges for Assignment Details Effective Start Date and Assignment Details …ReiV 25 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Which table contains 'Collaborator' for Oracle Recruiting CloudSummary: Which table contains 'Collaborator' for Oracle Recruiting Cloud Content (please ensure you mask any confidential information): Hi, we would like to have a BI Re…Barile Alberto 22 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM