OTBI
Discussion List
-
Help Finding Training "Start Date" Field or Table in Oracle DBWe’re trying to report learner states as Not Started, In Progress, Completed, and Past Due. Currently, we can only show Not Completed, Completed and Past Due reliably. T… -
Incorrect Invoice Amount when using OTBI "Payables Invoices - Transactions Real Time"Summary: Incorrect Invoice Amount when using OTBI "Payables Invoices - Transactions Real Time" Content (please ensure you mask any confidential information): Hi - has an…
-
OTBI Data Security Not Aligning with HCM UI Security ProfileDear Team, We have a business user who has been assigned a security profile that restricts access to view only employees within a specific AOR or Legal Entity. This secu… -
OTBI to fetch adjusted service dates from Work relationshipSummary: Hi everyone, We are trying to fetch the adjusted service date field from the employee work relationships page service dates section through OTBI. Can anyone sug…Prabha_112 163 views 2 comments 0 points Most recent by Rana Ritesh Kumar Reporting and Analytics for HCM
-
How to Add Menu to run custom report in Action>Create document of Manage order in fusion sales orderRequirement : Need to Run Custom Sales order report by adding extra menu to Manage order —> Create Document. Attaching screenshot for reference.
-
Sample Report: Workforce Compensation Budget Subject AreaSummary Workforce Compensation Budget Subject Area by levelContent Workforce Compensation Budget Subject AreaThis is part of a series of sample reports to use in your cl…Gail Langendorf-Oracle 397 views 15 comments 2 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How do you filter on the results of another OTBI analysis in combination with a date prompt?Summary: I want to be able to split workers who are paid and unpaid and break them down by age, BU etc etc. Those who are paid may have additional assignments as non-wor…Diane G123 31 views 9 comments 0 points Most recent by Kayla Malecki Reporting and Analytics for HCM
-
Salary details are not getting fetched for Subject area Recruiting-recruiting real timeSummary: I have seeded compensation manager role with required duty role Compensation Transaction Analysis Duty and Compensation Transaction Analysis but still i am not …Rajib_Samanta 334 views 20 comments 0 points Most recent by Jacqueline Mellonas Reporting and Analytics for HCM -
Help finding the audit product id for middleware applicationsIn order to call the API endpoint /fscmRestApi/fndAuditRESTService/audittrail/getaudithistory you have to pass "product". The products for regular fusion modules are eas…
-
Procurement Procure to Pay Real Time and Invoice Line Amount from Payables Invoices - Transactions RSummary I am combining 2 subject areas Procurement Procure to Pay Real Time and Payables Invoices - Transactions Real Time. I don't get an error but I get an invoice Lin… -
what is the expected behaviour in total balance of a parent, if hierarchy is changedSummary: We have a scenario of Hierarchy change. and we need to know what balance should show in the parent level before hierarchy change and after the change Content (p…
-
SUBSTRING function to separate multiple Valid GradesSummary We are trying to separate each valid grade into a separate columnContent When pulling job codes and valid grades, all valid grades are in one cell. We would like… -
Labelling issue for Percentage Bar graphSummary: My client has created Graphs for OTBI report data as part of requirement and what we see in one of our Percentage bar graphs is we are not getting the expected …Mamatha P-Oracle 22 views 8 comments 0 points Most recent by Mamatha P-Oracle Reporting and Analytics for HCM
-
How too identify actual hours spent by each employee on each Work Order Operations from OTL/PayrollHow too identify actual hours spent by each employee on each Work Order Operations (WIP). Where to get what employee is charged how many hours on what elements (Payroll … -
Scheduling OTBI report to store report output daily in sharepoint locationSummary: Scheduling OTBI report to store report output daily in sharepoint location where user can access directly instead of downloading it seperately from report Conte…
-
please suggest database tables/how to calculate Available to reserve and Available to transact QtySummary: We want to fetch Available to reserve and Available to transact Qty based on lot details from the database tables. Can you please suggest the database tables/ho…KOTTHURI ASHOKBABU 42 views 2 comments 0 points Most recent by BalaKadapa Reporting and Analytics for SCM
-
How Did You Map Natural Accounts to Financial Categories in Oracle Fusion ERP for FDI?Good Day, I've reviewed some related posts but none that directly address my question, so posting below. Here at WellSpan we're implementing Oracle FDI this fall and end…Jared Custer 13 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle General Ledger & Intercompany -
OTBI report with export where it shows only 2 Lakh 50 thousand records in export at maximumCX Sales: In OTBI Analytics, there is currently a record extraction limit of 250,000 records. This restriction is not meeting our reporting requirements in certain cases…Rohan Bhadani 31 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Linking a Dashboard with an InfoletWe have a PPM Dashboard and multiple reports are linked to that dashboard through a HTML script. This PPM dashboard is mapped with the PPM Infolet using 'Link Detailed R…
-
Payables Invoices - Transaction Real TimeSummary: Extracting AP Data and PO status as well Content (please ensure you mask any confidential information): When selecting the required columns like invoice #, date…Ravi Upadh 11 views 0 comments 0 points Most recent by Ravi Upadh Payables, Payments & Cash Management
-
Matrix Manager HDL Load shows new manager in UI but not in OTBISummary: We completed an HDSL load of new Matrix Manager assignments for employees. The UI shows the new manager but the OTBI report does not. Reflect the update. Is the…
-
How to hide embedded dashboard setting and help link and create custom dashboard styleContent Hi All, I have embedded a dashboard adding dashboard link to webpage content on the Oracle cloud hcm homepage. 1) I have added "PortalPages" to the link, however…Punam Roy Karmokar 85 views 8 comments 0 points Most recent by Punam Roy Karmokar Reporting and Analytics for HCM -
Oracle Cloud PPM - Reporting period for Project Performance ReportHello Team, As in Oracle EBS Projects we have option to set the Reporting Period separately to generate performance reports for that/up to month. Do we have similar feat…
-
OTBI report timed out for specific Period onward even data count is similarWe are facing issue with a OTBI report that's part of a dashboard. The user runs the report exclusively through this dashboard. It has been working fine since last one y…Abhishek_Kumar_DTV 12 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Context PO DFF does not appear in OTBI - PO real time subject areaSummary: We have a context DFF at the PO Header, and I am unable to see those DFF's in the OTBI Report (Procurement- PO Real Time). Is there any way to allow the OTBI so…diego m schenquerman 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
How to know who delete some reports in OTBIA folder containing reports has disappeared from my environment, and we want to know if it was accidentally deleted by a user or where the folder is located.Roy1823 31 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
OTBI Agent Returns 25,001 RecordsSummary OTBI Agent Returns 25,001 RecordsContent I created an OTBI analysis. Then, I created an agent that runs the analysis. I schedule the agent and request the format…Daniel McMillian 97 views 7 comments 4 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM