OTBI
Discussion List
-
Need to schedule a BI Publisher report to run on Business Day2Summary: Need to schedule a BI Publisher report to run on Business Day2 Content (required): How to schedule a BI Publisher report to run on Business Day2 from schedule p…User_2025-02-11-23-30-56-074 21 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri General Ledger & Intercompany -
Is there a way in OTBI and/or BIP to automatically push a scheduled report to SharePoint?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Nigel Wiltshire-Oracle 51 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Calculated Field in OTBIHi, I have created OTBI report based on custom object in which I have field called Start Date and Number of months. I need to display calculated field called End Date wh…Mohammed Rafi 111 views 11 comments 6 points Most recent by Shivakumar Ayyanagowdar-Oracle Reporting & Analytics for Sales -
Workforce Succession Management - Talent Pools Real Time Subject AreaSummary Reporting on Talent Pools through OTBIContent Has anyone had any luck reporting on Talent Pools through this subject area? I have been unable to get any results.…User_2025-01-28-08-47-04-905 34 views 2 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Payables to Ledger ReconSummary: Payables to Ledger Recon Content (required): Are there any improvement in this report, for, instance to add approvers or reviewers. How to treat differences ari…CraigX 11 views 1 comment 0 points Most recent by Alexandra Leanca-Oracle Payables, Payments & Cash Management
-
Replicate Data in FusionSummary: We are looking for a tool or an app that can help us extract data from Oracle Fusion (Financials/SCM). Content (required): We currently create BIP reports to ex…sanjam1130 11 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
The new year budget is fewer COA segments from the last year budgetSummary Is there any problem when The new year budget is fewer COA segments from the last year budget,Content is there any problem when The new year budget is fewer COA …Yasmin Kennedy 35 views 6 comments 1 point Most recent by Kamal Ibrahim-Oracle General Ledger & Intercompany -
Need help on Logical SQL with Inner JoinSummary Need help on Logical SQL with Inner JoinContent Hi Experts, Does any one has a sample logical sql where inner join has been used.Sreedharan-Oracle 42 views 6 comments 0 points Most recent by User_2025-02-12-14-08-01-540 Reporting and Analytics for HCM -
Filters on multiple SA are not workingSummary: We are trying to create a new OTBI analysis, where we have a requirement to pull both the Worker assignment details and the person VISA details. So we used Work…
-
previous Phase/State - recruitmentSummary: Is there a way of creating a OTBI analysis to show current Phase/State and previous Phase/State Content (required): We would like to create a report which shows…Mitch_123456 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
on-going resignations report - reporting on approvalsHello, could somebody please tell me how to extract this information from Fusion HCM, either as an OTBI or a BIP report? The business requirements: - we are using the jo…Geraud Andreux 62 views 4 comments 0 points Most recent by Geraud Andreux Reporting and Analytics for HCM
-
General Questions on Reports Data SecuritySummary: Content (required): Also, I need to know if a user has 2 Roles: 1. HR Specialist Custom Job Role assigned to 'View all people' data security profile 2. HR Analy…Walid Hamdy 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report used in another ReportContent I have built a report that pulls a list of employee numbers based on a specific set of filters. I then have another report that pulls data based on the employees… -
Absence Attachment in Report OutputSummary Absence Attachment in Report OutputContent Hi All, I have a requirement in which i have to display absence attachment content in report output for each employee.…nitin Sharma 65 views 5 comments 2 points Most recent by Gretchen_Atienza Reporting and Analytics for HCM
-
From where to get (table name) the value of Candidate Type When Applying field.Summary: From where to get the value of Candidate Type When Applying field.Content (required): Version (include the version you are using, if applicable): Code Snippet (…Awadhendra Tripathi 1.5K views 2 comments 0 points Most recent by Awadhendra Tripathi Reporting and Analytics for HCM
-
How to Add Sort Order to Table or GraphContent This document explains how to •Add a ‘sort order’ column to an OTBI report•Add the ‘sort order’ column to Table or Graph view•Hide the ‘sort order’ column on a P…User720640-Oracle 113 views 5 comments 10 points Most recent by Tsubasa Kokubu-Oracle Reporting and Analytics for HCM -
Does the Supplier Transaction Reports Dashboard can be generated for all SuppliersSummary: Does the Supplier Transaction Reports Dashboard can be generated for all Suppliers Content (required): Hello The procurement manager wants to review the perform…Cesar Saveedra 21 views 2 comments 0 points Most recent by martingabriel Kinovisques Supplier Management
-
Cash Advance ApproverSummary: I need to add in the Approver for a Cash Advance into a custom report. Please can someone advise where in the database I might get it and wondered if anyone mig…
-
Concat string values in OTBI/BI AnswersSummary: Concat string values in OTBI/BI Answers Content (required): Is there a possibility to have a function like listagg for strings in OTBI/BI Answers?Yves Chassein 431 views 4 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Learning Records Real Time Report cannot add Hire Date field without rendering an errorSummary: Content (required): Since the Learning Management - Learning Real Time Assignment Subject area has been deprecated, we've been directed to use 'Learning Records…Ivy__Valverde 11 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
OTBI and pulling yesterdaySummary: Hi All, I must admit I am pretty bad with dates in OTBI. I am attempting to build a report that will pull something entered the day before. Content (required): …User_2025-02-10-15-06-52-222 111 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Fetching single latest row per person in logical SQLSummary Fetching single latest row per person in logical SQLContent Hi Team, I need to fetch Top row for a person and am using assignment real time subject area.. But, i…SM-Oracle 96 views 9 comments 0 points Most recent by Manoj B. Cheruvathoor Reporting and Analytics for HCM
-
Latest Assignment Row in OTBISummary: How to get the latest assignment row in OTBI Report Content (required): I am looking to develop a OTBI report to fetch the latest effective row in assignment. C…Manoj B. Cheruvathoor 323 views 4 comments 0 points Most recent by Manoj B. Cheruvathoor Reporting and Analytics for HCM
-
OTBI Report to identify the populationSummary: Our client has asked that I share a report that identifies the population. Is there anyone who knows how I'll be able to do it? Could you please send me a sampl…Hazel De Castro 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
ORC: Candidate EIT info Reporting via OTBI Subject AreasSummary: Can we extract ORC Candidate EIT info via OTBI Subject Areas? Content (required): Can we extract ORC Candidate EIT info via OTBI Subject Areas? What will be the…Bhaskar Konar 71 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM