OTBI
Discussion List
-
How to get one object from a string in OTBI ReportsHi Team, We have a requirement where would like to get a particular object from a string which has _ in it. Example: This the string we have in one column Evaluation_OLC…Malla Pratibha 21 views 1 comment 0 points Most recent by Bharat Agrawal Reporting and Analytics for HCM -
Changes reportSummary All changes for specified fields in date rangeContent Hi, Is there a report that shows all changes in period: ID Name Effective Date Old Department New Departmen…Mike Borghoff 84 views 7 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
How to find the OTBI report last run history?Summary: Hi All, Need to find the history of the OTBI report last run, user-wise. Content (please ensure you mask any confidential information): Version (include the ver…Haripriya 53 views 3 comments 0 points Most recent by Bharat Agrawal Reporting and Analytics for HCM -
Subject Area for Organization AttributesSummary Subject Area to display attributes from hr_all_organization_unitsContent We deployed few attributes at PER_ORGANIZATION_UNIT_DFF under Manage Organization Struct…Amitabha 211 views 7 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Dynamically logos of the different legal employer dynamically in BIPSummary: I am trying to display the logos of the different legal employers dynamically on my BI report. I created a SubTemplate folder where I store the logos The Sub Te…Consultant Ian 23 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM -
Are infolets unsupported with 24A?Summary: I heard that starting with release 24A, that the support for infolets is discontinued. Is that correct and if so, is there similar functionality that can be use…A.J. 91 views 7 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Order by phase in Recuiting OTBI ReportSummary: Hi everyone, I tried to sort the phase in recruiting but it doesn't work can anyone tell me why? and what is the solution to sort the phase?
-
Embedded content for dashboardSummary: Embedded content for dashboard Content (please ensure you mask any confidential information): Hello experts, we would like to have a page in oracle that allows …Oriana L. 21 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
Approach to retrieve the value "5000009" from the string 01-4211002-00000000-0000-CH10-0000-5001044-Summary: I used the below, but it is giving syntax error. Can some one please assist and provide me corrected query SUBSTRING( "GL Account"."Concatenated Segments", LOCA… -
Is there any available CFO and payables dashboard in reports and analytics?Summary: Is there any available CFO and payables dashboard in reports and analytics? Content (required): Version (include the version you are using, if applicable): Orac…Zeinab Nabil 61 views 3 comments 0 points Most recent by Mirza Muhammad Mohsin Baig Payables, Payments & Cash Management
-
OTBI - Locating 5th occurrence of character using substring and locateSummary Several fields have been migrated into one field and need to split into separate columns into OTBIContent Several fields have been migrated across as one field s…Mark Stoker 504 views 12 comments 0 points Most recent by Mark Stoker Reporting and Analytics for HCM
-
pending worker record not fetching in OTBISummary: Content (please ensure you mask any confidential information): Hello, We are creating a report to fetch the checklist task values from the configurable form fil…Aishwarya_15 71 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Standard report for Oracle journeysSummary: Standard report for journeys Content (please ensure you mask any confidential information): Hello experts, does anyone know if there are standard reports delive…Oriana L. 251 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
not able to create group by function for date columnSummary: not able to create group by function for date column in OTBI Content (please ensure you mask any confidential information): Version (include the version you are…Kirish Kumar Venkatesan 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is any schema recording the order in which it is discarded?Summary: Is any schema recording the order in which it is discarded? I need the information about who discarded the draft order and the time. Version (include the versio…
-
Need to remove ‘0’ percentages from Rising star program participant by Ethnicity graphGood Day All! We are facing one issue in a Customer created Dashboard Report. Dashboard is created to show the Rising star program participants by Ethnicity graph. we ha…Bindu Janoti-Oracle 1 view 0 comments 0 points Most recent by Bindu Janoti-Oracle Reporting and Analytics for HCM -
Report for ESS and MSS TrasactionSummary: Need Report for ESS and MSS Trasaction Content (please ensure you mask any confidential information): Hi All We need to fetch all ESS and MSS transactions Versi…
-
OTBI Workforce Management absence entitlement case real timeSummary: How do you report out of this subject area. We have added the Job and duty roles and yet the subject area doesn't return any detail. Its as if the entire subjec…Kevin Robertson 21 views 3 comments 0 points Most recent by Kevin Robertson Reporting and Analytics for HCM
-
Can I create a dashboard using multiple Oracle BI Publisher reports ?Can I create a dashboard in Oracle BI Publisher that combines data and visualizations from multiple BI Publisher reports? Specifically, I'd like to include graphs and ba…
-
OTBI report retrieving Base Salary amount and Annual Salary amountSummary: Content (please ensure you mask any confidential information): Hello experts, do we have a standard OTBI to retrieve Base Salary and Annual Salary amount? If so… -
Report to show Document Types enabled for B2B Communication for each Supplier and its Supplier SitesSummary: Under OTBI subject area "Supplier - Supplier Real Time", I am unable to find and add Associated Collaboration Documents for each Supplier Site. I can only add w…Ruthvik Ramesh-IH 21 views 6 comments 0 points Most recent by Ruthvik Ramesh-IH Reporting and Analytics for ERP
-
Sample OTBI report to track compensation plan approvalSummary: Content (please ensure you mask any confidential information): Hello experts, is there a sample OTBI report to track compensation plan approval status? I notice…Valerio Curzi 11 views 1 comment 0 points Most recent by Andreea_Nuck-Oracle Reporting and Analytics for HCM
-
How can I access the standard OTBI dashboard: Time Card Details DashboardSummary: I want to access the standard OTBI dashboard Time Card Details Dashboard to view the current and existing timecards. However, although I have the required roles…Nicolas Vahman 172 views 3 comments 0 points Most recent by Karthik Chockalingam-Oracle Reporting and Analytics for HCM
-
Data access workforce management - worker assignment real timeSummary: I have reviewed Roles Requirement to access all employees data using Subject Area "Workforce Management - Worker **** and seem to have a similar issue at hand. …Sigrid B. 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Estimated End Date associated with an Absence - OTBISummary: I am having trouble getting the Estimated End Date associated with the absence to pull into an OTBI report. Is there a way to pull in this value? Content (pleas…
-
What would the formula to convert decimal to hours be?We're creating a new infolet in OTBI for users to see their flexi balance, however it currently displays the balance in decimal (e.g. 30.8, 1.2, etc.) when we need it to… -
Where can we find BackGround Check Comments in OTBI?Summary: We built a OTBI report using Recruiting - Recruiting Real Time SA and not able to get BackGround Check comments but we get it using custom BI report. Content (r…Praveen D 64 views 6 comments 0 points Most recent by Amit Mundlye-27103 Reporting and Analytics for HCM
-
Areas of Responsibility OTBISummary: I tried to create a simple analysis in OTBI using the subject area Workforce Management - Areas of Responsibility subject area but it didn't result any data. Pl…Hazel De Castro 31 views 10 comments 0 points Most recent by Amit Albalak Reporting and Analytics for HCM
-
OTBI Dashboard not reflecting the analysis dataSummary: When certain parameters are used in a dashboard, a couple columns return null values. The raw analysis does include data for these columns. This just started oc…