OTBI
Discussion List
-
How can the seeded compensation dashboards below for managers be customized?Can anybody suggest the right way to edit these seeded dashboards and do the customization based on our company needs. The need is to Add/ remove parameters Add/ remove …Sameeksha MN 11 views 3 comments 0 points Most recent by Sameeksha MN Reporting and Analytics for HCM -
Position Occupancy ReportHi All, We have noticed that seeded Position Occupancy Report is not working as expected. Incumbent Headcount for all the positions is showing null though there are incu…
-
Expenses - Expense Transactions Real Time "The specified criteria didn't result in any data.I am facing same issue not able pull expense details from Expenses - Expense Transactions Real Time " Subject area. Only details from Employee folder are populating. if … -
Logical SQL With Dashboard PromptSummary: Hi - I am trying to build a logical SQL report that displays paycheck information along with current salary as an outer join from Compensation subject area. The…
-
Best Practices: OTBI Compensation - Compensation Stock Details Real Time subject areaSummary: This is part of a series for best practice tips to use in your cloud environments, created by Oracle BI and Product Management. Roles and Privileges Compensatio…Gail Langendorf-Oracle 11 views 1 comment 2 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to embed Analysis in Dashboard?Summary: Custom Analysis exits Dashboard after run Content (required): I have a custom analysis and a custom dashboard: When run from user side it appears like this: 2 q… -
Are the Information template DFFs used in Purchase Requisitions, reportable?Summary: Are the Information template DFFs reportable? We are using Information templates that are tied to Smart forms, and those smart forms are used to create requisit…
-
OTBI Receivable transactions- Real Time- Trying to get the warehouse/ship from detailsHi Team, Trying to create OTBI Report using Receivables transactions Real time. We need to add warehouse/ship from organization details for each of the invoice line. Una…Garima Arora-Oracle 21 views 1 comment 0 points Most recent by Garima Arora-Oracle Reporting and Analytics for ERP
-
Finding Special Handling field in FDISummary: I'm working on some reporting for a client, and one of the Metrics I need to create requires a filter on the Special Handling field. However, this field doesn't…
-
To report performance document status related information and rating detailsSummary To report performance document status related information and rating detailsContent Hi , Planning to build a report to show performance document status of a pers…Phani S-Oracle 179 views 7 comments 1 point Most recent by Pavan Kumar Thummalapalli Reporting and Analytics for HCM
-
How to use "Combine results based on union, intersection, and difference operations?Summary: I don't understand how to use it. Whenever I add my 2 subject areas and then the fields, I don't know what to do after that. I need additional fields that are n…
-
Create BI report from supply planning tableSummary: Hello, I was looking for source tables to create OTBI report from Tables and Views for SCM > Planning common, My objective is replicate the table view attached …Diego Zegarra 31 views 4 comments 7 points Most recent by Diego Zegarra Supply Chain Planning and Collaboration -
performance tile DescriptionSummary: When we drag the mouse above some graphs we can see the analysis name description with more information. We would like to know how can we enable this feature to…
-
Error codes in OTBIWhen we want to view the OTBI report, I get this error: Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE…
-
Need to get distribution curve to work when count is 0I am trying to create a distribution curve for performance ratings. It looks good when there is a count >0 for each rating but when there is a 0 count for Unsatisfactory…
-
Where can I find the Specialization Description to add to my Specialization_Courses report?I can't find the description field to add to my report using the subject area Learning Records Real Time. Is this field in another subject area? Specialization Descripti…Lisa Marchand 33 views 2 comments 0 points Most recent by Lisa Marchand Reporting and Analytics for HCM
-
Need to give access to run OTBI purchasing reportsSummary: We were having a issue where a user is not able to run any OTBI reports created under custom/procurement/purchasing. We don't want to give any purchasing role/a… -
Prompt LOV restriction in OTBI according to user Business unit data accessSummary: We are trying to restrict the prompt LOV which returns BU names that currency configured in the system. But we want that when a particular user will try to run …Baishakhi 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Consolidated List of OTBI and BI Publisher Reports Posted (9 December 2014)Content The following is the list of published OTBI and BI Publisher reports between 15 October 2014 and 9 December 2014: * Fusion Benefits: Dashboard for Costs and Tota…Julian Challenger-Oracle 278 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Analysis - How do you select the gross earnings for the max Date Paid per employee?Summary: We are able to get a list of gross earnings for each worker per pay date but we only want to SELECT the gross earnings associated with the max check date (Date …
-
My ledger currency and reporting currency is different.Summary: Need a report from Oracle cloud financial module that provides month end FX rates. Content (please ensure you mask any confidential information): My ledger curr…PiyushRathi1234 32 views 3 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to report on the last person who updated an invoice prior to it being validated?Summary: Have a need to report on AP clerk invoice count metrics and would like to know of a field other than Last Updated By to determine who was responsible for proces… -
Schedule of Expenditures of Federal Awards (SEFA)Summary Attempting to built the SEFA report using the Projects - Cross Subject Area Analysis - Real Time subject area.Content Report requirements include: Accounting Yea…Meredith Bickell 236 views 7 comments 2 points Most recent by User_5C630 Reporting and Analytics for ERP -
Table / View for New Features and Opt In Features?Summary: Is there a table / view that can be queried via BIP which would allow us to create a report of all of the implemented and non implemented features as seen in th…Monica Fundak 41 views 6 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to find Invalid transactions showing in "Inventory transaction pending" infotileSummary: Content (please ensure you mask any confidential information): Inventory Transaction Infotile showing 5 transaction as shown below. Since it can not be drilldow…
-
Performance Document Manager Overall rating doesn't apear within OTBI reportSummary: The issue arises with the rows displaying employee answers: the Manager Overall Score appears as “NA” instead of the actual score. Subject Area: Workforce Perfo…Peleg Puzaylov-Oracle 61 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM