OTBI
Discussion List
-
What is the OTBI Subject Area to get data from PER_LOCATION_LEG_F tableSummary: Which Subject Areas should i use to get the details from PER_LOCATION_LEG_F table. Should we need to any process to add those fields to the Subject Areas ? Cont…Jagdish Varadraj 1 view 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Supplier site id details with APIWe have a requirement to get the largest existing supplier site ID for a given supplier and procurement BU, as well as a lookup value that is stored in Saas Lookups. We … -
V3 seniority date multiple seniority date in OTBI IssueSummary: We just upgraded from V1 to V3 seniority dates and tried to update existing OTBI reports with the new dates. Have no issue replacing if the report is pulling ju…
-
UCM Bursting not working for Fixed Assets Seeded ReportSummary: Issue in UCM Bursting for Seeded FA report Content (required): Hi, We are trying to create bursting for seeded FA What-If Depreciation Analysis Report to push o…Vaigu_27 64 views 1 comment 1 point Most recent by Dinesh Krishna Mamilla Reporting and Analytics for ERP
-
Can anyone please share OTBI dashboards for procurement?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Sample Report: Project Financial Management Cloud: Project Budget vs. ActualSummary This dashboard displays Budget details for a specific project.Content The attached sample dashboard displays budget vs. actual cost and commitment details for a …Dustin Grabowski-Oracle 1.2K views 23 comments 11 points Most recent by HarshitBa Project Management -
Missing folder in BI Catalog under Custom/Human Capital Management - Reports and AnalyticsHi Team, One of the folder "Talent Management" is missing under /Shared/Custom/Human Capital Management/ and we could not replicate what happened to the folder and when?…
-
I have to create a actual vs budget amount report for revenue and expense accounts in OTBI.Summary: I have to create a actual vs budget amount report for revenue and expense accounts in OTBI. I have used GL balances real time subject area. The columns selected…
-
Validation Status from AP InvoiceSummary: I am creating the Data Model of our BIP Report and I need to find out which field from what table should I use as Validation Status. Content (please ensure you …
-
Report on Auto-Provisioned RolesSummary: We are looking for a way to report on which of our security roles are auto-provisioned vs. manually provisioned. Does anyone know of a subject area that has thi…Karlie Backman 164 views 7 comments 1 point Most recent by Felix_fei Reporting and Analytics for HCM -
OTBI Report shows wrong annualized salary and annualized full-time salarySummary: OTBI Report shows wrong annualized salary and annualized full-time salary Navigation Tools Reports and Analytics Catalog Created OTBI report based on "Compensat…Vincent T 22 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Candidate Marital status and extra information reportSummary: Candidate Marital status and extra information report Content (required): Candidate Marital status and extra information report Version (include the version you… -
Need to have Inventory Location details in the OTBi reportSummary: Hello, We have a requirement where we need to have all the Location Name, Code and ID in one of the report. But I am umable to find it in the Inventory subject …Krupesh Joshi 22 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
OTBI reportOTBI reportVineet Srivastava Graviton 21 views 1 comment 0 points Most recent by Erick.B Reporting and Analytics for ERP
-
SQL Query to Extract Accurate Last Login Date for Active Users in Oracle Cloud SCM PlanningDear Oracle Experts, We are seeking assistance in generating a report from the PROD environment that provides a list of all active users across the following Oracle Clou…Nagaraj A 77 views 2 comments 0 points Most recent by Nagaraj A Supply Chain Planning and Collaboration
-
Modify Actual Effort in hoursSummary: Can the "Actual Effort in Hours" field be modified after a training has been completed?: I am very confident that this EE did not spend 2300 hours to complete t…
-
How to Generate a Dynamic template based on the assigned Business UnitSummary: Hi Experts, I am seeking assistance regarding a specific requirement from our client. The client has expressed a need to create a document that is customized ac…
-
Capturing the Learning outcome from the Learning Record Real Time subject area- OTBISummary: Content (required): hi there, we have as learning outcome a custom certificate. The certificate has a name, issued by field and issued date. I wonder if this ca…Bobby Jourdan 31 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Audit report to capture critical events of user activitySummary: Hi Everyone, One of our clients is looking for the reports that show logons, access attempts, and data modifications. Does any seeded report exists in the Oracl…Mahamood Sk 32 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany
-
Goal library extractionHi to all, do you know if there is a possibility to extract all the goals entered by the HR on the Goal Library? Is there an OTBI area? Thanks in advance, Best Regards, …
-
Request for Guidance on Managing DEI Attributes in OTBI Analysis Following Executive Order 14151In response to the Executive Order 14151, "Ending Radical and Wasteful Government DEI Programs and Preferencing," signed on January 20, 2025, our Compliance team is work…SwatiSharma 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
SQL query to display Purchase Category hierarchySummary: SQL query to display Purchase Category hierarchy Content (required): For anyone who might find this useful, I've written a SQL to pull the Purchase Category hie… -
Convert this filter to SQLSummary: Convert this filter to SQL does not function Content (please ensure you mask any confidential information): I try to using 'Convert this filter to SQL' function…
-
How Receivables Begin Balance is calculated for Receivables to Ledger Reconciliation Summary Report?Summary: How Receivables Begin Balance is calculated for Receivables to Ledger Reconciliation Summary Report? In the Receivables to Ledger Reconciliation Summary Report …