OTBI
Discussion List
-
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 506 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
-
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…
-
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 23 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 12 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. 22 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 63 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 32 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 2 views 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 31 views 1 comment 0 points Most recent by SATYA123-Oracle Payables, Payments & Cash Management
-
user unable to expand filter section in dashboardSummary: User unable to expand the filter section in a custom dashboard to enter his search criteria Content (please ensure you mask any confidential information): hi, I…Catherine Abi Samra 21 views 11 comments 0 points Most recent by Catherine Abi Samra Reporting and Analytics for HCM -
OTBI Payment Dashboard ErrorsSummary: Error Codes: OAMP2OPY:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P:OI2DL65P Error during query processing (SQLExecDirectW). State: HY000. Code: 10058. [NQODBC] …larachalak 240 views 1 comment 0 points Most recent by Lucy Cui-Oracle Payables, Payments & Cash Management
-
OTBI-Learning-Is there a way to report on who specifically took the action to Withdraw the learner?Summary: OTBI - Learning Module - Is there a way to report on who specifically took the action to Withdraw the learner or who assigned the Learning item to the learner? …Harish Malik 44 views 3 comments 0 points Most recent by Harish Malik Reporting and Analytics for HCM -
Home or Work email address depending on termination statusSummary: Hi I'm building an analysis which contains both current employees and employees who have left within the last 60 days (established using a filter on termination… -
Termination count is not showing correctly in OTBI reportSummary: Termination count is not showing correctly in OTBI report Content (please ensure you mask any confidential information): Hi All, We are developing a HR dashboar…Venkatesan 25 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Floater Days not updated with Absence Calendar Details Real TimeHello, I built a report with 'Workforce Management - Absence Calendar Details Real Time' subject area to include Vacations, Floater days; xml attached. I completed Float…