Sample Reports
Discussion List
-
Manage Administrator Profile Values ReportSummary: We are trying to Fetch the Module Name (Meaning) Can anybody Please advise for fetching the Module Name of Manage Administrator Profile Values Content (please e…MilanMohanty 254 views 2 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Query to get delayed payroll flowsSummary: Query to get delayed payroll flows - the ones which did not start on scheduled time Content (please ensure you mask any confidential information): Hi Team, Gree…Parag Hiremath 11 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
Query to Retrieve All Privileges and Roles for All RolesSummary: We want to know the query/tables that will allow us to retrieve all Roles details including the assigned Functional and Aggregate Privileges Content (required):…Aahiri_Sarma 20.1K views 22 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Account Analysis for Contra Account Standard Report - CustomizationHi , I have copy this standad report to my custom location . Now i want to add two more columns in this report. 1- Transaction Number ( Which is comming from subledger i…Jasir133341 144 views 2 comments 0 points Most recent by Nasir Iqbal Reporting and Analytics for ERP -
Hi experts , is there any SQL query to get policies, privileges, and application of a user roleSummary: Need assistance to build a SQL query to get security console details of a user role. Content (please ensure you mask any confidential information): Version (inc…Tharushi Sathsarani 72 views 1 comment 1 point Most recent by Kishore Padala-Support-Oracle Applications Security
-
How to restrict Inventory Items or On hand data based on User data access role in BIP Reports?Hi All, We have a requirement to restrict the Inventory Items or On-hand data based on User data access role Org assignments through BIP Reports. Currently, we have buil…Nagaraju Vandavasi 21 views 5 comments 0 points Most recent by Nagaraju Vandavasi Reporting and Analytics for SCM
-
Termination Dates and Payroll Data Query or ReportHi So looking for a query/DM or report that I can edit/update to show termination details and payroll data combined? Basically, I have been asked to create a report to b… -
How to convert PERIOD NAME to Date data type?Hi I am using Between operator in Period Name and it is not working. Period Name is a Varchar type. How to convert it into Date data type so i can use between operator i…Khushi 82 views 6 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Open Purchase Orders & Goods Received Not Invoiced reportsSummary Various OTBI reports showing Open Purchase Orders & Goods Received Not InvoicedContent Import the attached catalog files into your environment using the "Unarchi…Andy Gough 2.4K views 19 comments 14 points Most recent by Khalid Mahmood Reporting and Analytics for ERP -
In BI Report we have date parameters when we apply morethan one year we get time exceeds errorSummary: Hi Team, Hope all are doing great! In Onbaording BI Report we have date parameters when we apply more than one year we get time exceeds error if we apply less t…AjayKumar Maddipati 103 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
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 158 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 77 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 121 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 146 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 26 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 55 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 272 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…