Sample Reports
Discussion List
-
SCM reportingSummary Custom reports builtContent Our customer is using SCM and is not very pleased with the seeded reports in Oracle. Reports they are looking for are for example the…User_2025-01-28-02-43-26-951 157 views 6 comments 5 points Most recent by Mirza Muhammad Mohsin Baig Reporting and Analytics for SCM -
Not able to print parameter values in BIP report, using if condition in Excel rtf templateUsing if condition in excel template had validated values if parameter is null , should return all as values selected is ALL, see below All But when i am populating spec…Shahid Qureshi 72 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Is there an audit/ query that we can use to pull the list of reports that uses a particular columnSummary: Hello SMEs, We are trying to get a list of reports that are currently pointing or exporting a specific column. Content (please ensure you mask any confidential …AprilleLyn 124 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to configure an additional Input parameter in Account Analysis Report XLAAARPTHello, We have a requirement to add additional department type Input parameter as a filter in BI Account Analysis Report XLAAARPT. This report is being run through the E…Sushmitha G 145 views 6 comments 0 points Most recent by Sushmitha G Reporting and Analytics for ERP
-
OTBI Dashboard Prompt: Year, Quarter,MonthSummary: Need help on OTBI Dashboard Prompt: Year, Quarter, Month with Variable Content (please ensure you mask any confidential information): We are working on a custom…Mohan Murali P-Oracle 61 views 1 comment 0 points Most recent by Mohan Murali P-Oracle Reporting and Analytics for HCM
-
We developed BI reports in English but user wants based on local Language how to show data ?Summary: HI We developed BI reports in English Language but user wants based on local Language need to show data ? if user from arbic from need to show arbic and if user…AjayKumar Maddipati 1 view 1 comment 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
ORC Offers Transactions Report but need to add Requsition Number in BI it is possible ?Summary: Hi Team, ORC Offers Transactions Report but need to add Requsition ID in BI it is possible ? if how can i add this , I'm new to ORC. PFA of query. https://us.v-…AjayKumar Maddipati 101 views 24 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
OTBI report to fetch goal plan and its goalsHello, I'd like to create an OTBI report to fetch all the goal plans created and goals associated directly to each goal plan - even if goal plans and goals have not been… -
Where to find Warning limit and Error limit for the fusion tablesSummary: Greetings of the day.. Please share the information where we can find Warning limit and Error limit for the fusion tables Content (please ensure you mask any co…
-
CDM: Unable to find hierarchy fields in Fusion back end tablesHello, In a requirement we are creating hierarchy in CDM through the import management. We are required to create a report based on the fields in the import Hierarchy an…
-
Can we build a BIP report for the child processesCan we build a BIP report for the child processes that are run after after load interface file for import.Shalini S 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
How to fetch the Covered Levels of a Subscription using querySummary: How to fetch the Covered Levels of a Subscription using query Content (please ensure you mask any confidential information): How to fetch the Covered Levels of …Neelesh Varma 22 views 3 comments 0 points Most recent by Manoj Kumar-Support-Oracle Reporting & Analytics for Sales
-
Links to how to videos for OBTI builds for Learning ONLYSummary: Does anyone have any links to videos showing how to build OBTI analysis for reporting out different topics for Learning (Training and Development). Content (req…
-
we have given the row num in select statemnt but we need row count also ?Summary: Hi we have given the row num in select statemnt but we need row count also ? need row count=2 ? Content (please ensure you mask any confidential information): V…AjayKumar Maddipati 11 views 7 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
We have ORC Offers Transactions Report but need to add country column for below query ?Summary: Hi Team, We have ORC Offers Transactions Report but need to add country column for ? Content (please ensure you mask any confidential information): select a.OBJ…AjayKumar Maddipati 21 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Identify Headcount and FTE by Dept and Job AND Display Number of Open Requisitions by Dept and JobSummary: Requirement is a report showing active headcount and FTE by Dept by Job AND # of open job requisitions (Filled Date is null) AND # open FTE. Is this possible? Y…JHaden3 51 views 4 comments 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Need Outstanding Check Report in Oracle fusionSummary: Hello, We are looking for a report that shows payments that were issued but have not cleared the bank account yet. Is there any report already available in Orac…Sushmitha G 275 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Audit Report for Oracle backup Log in Oracle fusionSummary: Hello, We are looking for report where the Oracle system backs up all data, libraries, applications, and user profiles daily/on a regular basis. Is there any re…
-
How to Link a Column in OTBI to a Parameter Based on Conditions?Hello, I am working on a report in Oracle Transactional Business Intelligence (OTBI) and I need some help with linking a column to a parameter based on conditions. Speci…Omran Zeaiter 21 views 6 comments 0 points Most recent by Omran Zeaiter Reporting and Analytics for ERP
-
We need termination reson column but how to link with any table ?Summary: We need termination reson column but how to link with any table ? PER_ACTION_REASONS_TL Thankss, Ajay Content (please ensure you mask any confidential informati…AjayKumar Maddipati 21 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
In BIP template how can i get columns printed by and printed on ?Summary: Hi Team, we have BIP template how can i get columns printed by and printed on ? Thanks, Ajay Content (please ensure you mask any confidential information): Vers…AjayKumar Maddipati 11 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to get Risk Code value in BIP Custom ReportSummary: We are developing a customer report and we need a column called Risk Score. The value we may need is similar to this 'Any value between 1 – 69 is high risk and …Dhanusia 1 view 1 comment 0 points Most recent by Augustin Aravind-Oracle Reporting and Analytics for ERP
-
How to create a new KPISummary: How to create a new KPI Content (please ensure you mask any confidential information): Hi Team, How to create a new KPI reports for Finance? Could anyone guide …Venkatesan 1 view 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
subject area to get "in error time card details" in otlSummary: we are creating a report to get in error tome card details. Currently we are using "Workforce management - Reported Time Cards Real Time" subject area, here all…Gali Sujana 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
We need citizenship column in BIP querySummary: Hi Team, We unable to find the citizenship column and we checked on per_citizenships table also . any one help me on ? Thanks, Ajay Content (please ensure you m…AjayKumar Maddipati 61 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
With below sub query i'm getting error is ORA-01427: single-row subquery returns more than one rowHI Team, when i sepeartely run the below sub query is working fine but when i run the total below query I'm getting single-row subquery returns more than one row. how to…AjayKumar Maddipati 41 views 9 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Different Checklist IDSummary: Checklist_ID is always equals to Task_ID for the task associated with the particular checklist. do there is some cases where it can be different, please help. C…Yashpal_Mahto 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Allocation percentage for resources in the projectSummary: Hi everyone, We're looking to gather details on project resources, specifically allocation percentages. It's important that these resources are currently assign…