General Transactional Reporting (OTBI)
Discussion List
-
User limited to 33 report loads in Report Job HistoryHello, We have a user that is being limited to only 33 report loads in job history. This is the only user that has reported this behavior and the behavior differs when t… -
Repeat Column Headers in BI Publisher Excel TemplatesSummary Repeat Column Headers in BI Publisher Excel TemplatesContent Hello Everyone, I have a requirement to repeat column headers in BI publisher excel templates when t… -
Do we have Manager Country field available in OTBI?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable): -
Which Subject area & folder to use to extract Manager Hierarchy fields (upto level 10) correctly?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
List of BPM PVOs available in Fusion or accessible through OTBISummary: Would like to know the list of available OTBI PVOs which hold BPM related information to be able to cater to some reporting scenarios - for e.g. - how long does…
-
R13.x Deprecated and New BI View ObjectsSummary This posting includes R13 deprecated Business Intelligence View Objects (BIVOs) that are unavailable for extraction using BI Cloud Connector (BICC) in Oracle App…
-
how to enable dff in otbi report?Summary: I am trying to enable dff in otbi anlaysis. even though i run the schedule on Import Oracle Fusion Data Extensions for Transactional Business Intelligence dff's…
-
is it possible to compare Person Number (Colleague) with Manager Person Number (Supervisor)?Summary: Can we compare Person Number with Manager Person Number dynamically (for all records in a report) to analyze if listed Supervisor is actively present in Person …
-
The content is blocked contact the site owner to fix the issue. OTBISummary: We have created a custom report using SQL based data model and gave permissions to the user for running it. But, they are receiving this error when trying to ru…
-
OTBI Dashboard Record Count MismatchHi Team, We have built a dashboard and that has a record count to count the number of rows. We could see the record count shows different numbers for people with differe… -
Report containing all the agent(s) I have definedSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
SQL/report to get the list of consultants (not having Person ID)We are looking for a user/role report that list users firstname/lastname/email and roles. The report we have only lists if they are linked to a person record. We have co… -
how to remove HTML markup from columns of an OTBI reportSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Not able to see budget amounts in Fusion OTBI AnalysisSummary: Content (required): I had uploaded Budget amounts using FBDI and it is appearing in Account Monitor also in General accounting dashboard. But while creating ana…
-
OTBI Usage and Performance Dashboard SampleSummary OTBI Usage and Performance Dashboard SampleContent Real Time OTBI Usage & Performance * Two subject areas are available in 20D to monitor OTBI usage and performa…
-
How to use subject area Workforce Learning - Learning Records Real TimeSummary: Workforce Learning - Learning Management Real Time is going to get decommissioned soon, how to use Workforce Learning - Learning Records Real Time subject area … -
we need subject area in career and peoformance for performance Connect ConversationsSummary: Hi Team, we need to track the career and peoformance>peoformance>connect conservation >Performance Document Name related columns in OTBI any one have any idea h… -
Filter out Employee RatingSummary: I have created a report that has the field Rating Level Name but it includes both Employee and Manager Rating Level Content (required): I how do I identify whic… -
Matrix Manager field not showing up values as recorded in myHRSummary: When I try to include Manager Type field into the report & look at options (for Matrix Manager) - don't see Matrix Manager option to pick. Can you let me know h…
-
Tenure calculation in OTBISummary: Used Current_Date function & Enterprise Seniority Date field to calculate Tenure (in a separate field) however the result is not accurate (its showing value zer…
-
how to compare Person Number with Manager Number fieldSummary: I would want to apply a condition to know if Colleague is present in Manager Name field or not. How do we compare the Person Number field with Manager Person Nu…
-
duplicay coming for each employee due to each employee have showing multiple mangersSummary: Hi Team, In below screen shot we have taken employee name and manger name, but same employee has two line mangers coming that is the issue facing in the report.…
-
When we creating the otbi report that time showing as UI but some times showing dff nameSummary: Hi Team, when we create the OTBI report that columns shown as as per ui but in some time showing as dff name directly in report. PFA Thanks, Ajay Content (requi…
-
How to customize the banner - color and logo on OTBIContent Did anyone tried customize the banner - color and logo on OTBI. At time business users are confused between PROD and non-PROD environments. If we have a color ba…
-
Pie Chart does not return all itemsSummary: Table results not displayed in Pie Chart Content (required): We have a table that is ranked and everything ranked above 10 is grouped under the reason name 'Oth…
-
which subject area varaible pay plan details have in OTBI ?Summary: Hi Team, we need varaible pay plan details in OTBI report so mayi know which subject arae avilable ? Thanks In Adavance. Content (required): Version (include th…
-
oracle cloud HCM OTBI Dynamic File Name and TitleSummary: Output File naming :-YYYY-MM-DD – [Business Unit] – [Last Name], [First Name} [Incident Event Type] Title: Safety Incident Report for [Incident Number] [Inciden…
-
when I using matrix manger columns list I'm unable to find Top manger type mail IdSummary: Hi Team, I'm using worker assignemnet real time subject area in that we need to fecth the performnace manger name , number and email so we are filetr out from t…
-
Where To Find Overtime Approval FieldsHi all, I'm building a report within OTBI that pulls back all overtime submissions by employee. For the most part, this works great, but I've been asked to include the m…
-
Adapting Previously Used SQLSummary: Amending a BIP Report we have that's not pulling the correct results back Content (required): Hi all, Apologies if this is the wrong place to ask. I've been ask…