OTBI
Discussion List
-
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 216 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 22 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. 22 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 507 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. 252 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 Started 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 11 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 171 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 61 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… -
Goals related OTBI report-Location dependencySummary: Hi, I have created OTBI report for performance goals , for the people who don't have location , in my report it is showing goals are not created even though the… -
Procurement ReportingSummary: Our organisation needs to provide reports from the system such as below and I'm wondering if anyone has created any reports or knows of any seeded reports that …Stuart 1 view 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management -
OTBI - Accounting status of paymentHi! Is there another column available in the OTBI report that exclusively indicates the Accounting status of payments? We'd like to display whether the payment is "Accou…Anne Nicole 34 views 1 comment 0 points Most recent by SATYA123-Oracle Payables, Payments & Cash Management