OTBI
Discussion List
-
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 -
OTBI Report for AP Invoice HoldsSummary Sample OTBI report for ERP Cloud providing a list of AP Invoices on HoldContent Sample OTBI Report for ERP Cloud: AP Invoices on Hold This report provides a list…Andy Gough 2.1K views 17 comments 22 points Most recent by cdreyer.de Reporting and Analytics for ERP -
Usage of Prompt's "contains any" for both upper case and lower caseSummary: Usage of Prompt's "contains any" for both upper case and lower case Content (please ensure you mask any confidential information): Hi Experts, I am using subjec… -
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 11 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 31 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 235 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 -
Specialization Progress ReportSummary: Hello, My company is in the middle of implementation for Oracle HCM Cloud and I work closely with the Learning module. We would like to create a report to show … -
progress status in course offering - reportingIn the offering of a course, learners progress is shown i.e 2/3 Where is this field in the reports section? I can find everything else but this. -
Creating Receipts from ASNsSummary: We are going to start having our suppliers sending us ASNs for products we order. We had some questions from the Buyers perspective on how to create receipts fo… -
Unable to access the Standard Invoice screen from the OTBI Action Link ReportSummary I am trying to navigate to the Standard Invoice Screen from the custom OTBI Report via Action LinksContent Hi , I had created a custom report with the Payable In…SandeepPaspunuri 181 views 16 comments 1 point Most recent by Joanne Heathcote Reporting and Analytics for ERP -
Supplier bank country field in OTBI reportSummary: Supplier bank country field not found in "Supplier-Supplier Real Time" OTBI Subject area Content (please ensure you mask any confidential information): Version …Sharmava 41 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Supplier Management -
BI Reports are failing with error as Could not connect to OBI Presentation ServiceSummary: BI Reports are failing with error as Could not connect to OBI Presentation Service Content (please ensure you mask any confidential information): Hi Team, Greet…Parag Hiremath 158 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to Get SupplierId in Oracle Procurement OTBI ReportHow to Get SupplierId in Oracle Procurement OTBI Report -
Total earnings inaccurate based on positions in Gross Earnings ReportI created an OTBI report include employees' 'Name', 'Position' and 'Gross earnings'. For prompt of time range, I use 'Pay period start date' and 'Pay period end date'. A…Yiming Xiong 11 views 4 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
How to display Active employees count month wiseSummary How to display Active employees count month wiseContent Is there any way on calculating employee count by month in OAC. The starting point is an Employees table …Saptadip 421 views 6 comments 1 point Most recent by Lakshmi Devi Bathala Reporting and Analytics for HCM -
Supplier account balance confirmationHi Team, We need to confirm open balances with suppliers per specific date. Is there any standard report available that shows all outstanding/unpaid invoices per supplie… -
Position Grade Code and Position Grade Name not being populated in OTBIHi all, We have an issue that the Position Grade Code and Position Grade Name is not being populated in OTBI. The only field that is populated is "Valid Grades" and this…