OTBI
Discussion List
-
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 385 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 321 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 23 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 41 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 11 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…
-
OTBI - Issue while submitting Custom report - Asset Cost DetailSummary Error while selecting parameters for Custom OTBI report which was copied from Asset Cost Detail reportContent Error while selecting parameters for Custom OTBI re…User_2025-02-04-10-47-46-258 42 views 1 comment 0 points Most recent by Priya_Ananda Reporting and Analytics for ERP -
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
-
Restore saved OTBI analyses after user name changeHi guys, One of the HR Users of the customer married last weekend. So her name changed, as well as her username changed. On the old user name she stored some analyses in…Katharina_Seidenfuß 35 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Unable to get requisition number value when combining with assignment subject areaSummary: Please find the report catalog , unable to see the value for Requisition number. I'm combining below three subject areas and for Recruiting I'm using Number of …
-
Need of PO 'first approved date' in the OTBI subject area to extract the dataPlease guide me where we can find in report “PO first approved date”. Because the current reporting is completely wrong since it is always giving the “PO last approved d…