Reports
Discussion List
-
Dashboard prompt returned error (Failed to load (Odbc driver returned an error SQLExecDirectW).)Content Hello All, Currently I am using SQL Results option to populate value of a dashboard prompt called "Module Name".I am using below SQL code for this : actual colum…Janardhana Kondaveeti 26 views 6 comments 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM -
OTBI Analysis: Using TIMESTAMPADD to derive last day of the month based on Period Name in Subject ArContent Hello There, I have an OTBI analysis for Subject Area: "General Ledger - Balances Real Time". The analysis has a column "Time"."Accounting Period Name" OR "Time"… -
Custom Labels of OTBI are getting changed automaticallyContent Hi I have customized labels names of the parameters used in OTBI reports But somehow those customized labels are changing to it's initial name automatically This…Dhajani Perera 39 views 2 comments 1 point Most recent by Sushan Peiris Reporting and Analytics for HCM
-
Standard TRCS Financial Reports (FR) in the Next Generation Reporting formatSummary Will the standard TRCS Financial Reports (FR) be available for download from the Oracle Cloud Marketplace in the Next Generation Reporting format?Content There a…
-
deep link to reportSummary deep link to reportContent Hi, We are trying to deep link to report in OBI report. below is the link we copied from the browser address bar:…Nizar Kassam 202 views 5 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
Report results pull in journals 1 hour prior to parametersSummary User selects date greater than 3/10/2021 at 12PM, yet the report results is pulling in journals with a timestamp 1 hour prior to set parameterContent User select…User_2025-02-05-22-11-22-331 28 views 1 comment 1 point Most recent by User_2025-02-05-22-11-22-331 Reporting and Analytics for ERP -
Table to get BI Report Template and Data Model DetailsSummary Table to get BI Report Template and Data Model DetailsContent Hello, In EBS, we had XDO tables which stored BI Report and Data Definition details. Do we have any…Vinay Gharge 1.2K views 3 comments 2 points Most recent by SimonTomey Reporting and Analytics for ERP -
How to navigate from OTBI report to Absence Record Entry page in Edit modeSummary There is no Deep Link available to navigate to Absence Record page in Edit Mode using Absence Entry ID. Want to know if there is any way to open the Absence Reco…User_UM4C6 52 views 2 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
New Generation Next Reports - Security - EPM CloudSummary User role does not have access to new kind of reporting in PBCSContent I migrated a FR report to Reports and when a user role tried to open the new report. He ha… -
How to use Flexfield feature at BIP data model?Content Hi, Are there any document about BIP data model flexfield feature? I hope the feature make me easy to query AFF info when I create custome BIP report. ThanksTsubasa Kokubu-Oracle 56 views 4 comments 2 points Most recent by Anil Kola-Oracle Reporting and Analytics for ERP
-
Change ESS Job Description while submitting it from BIPSummary Change ESS Job Description while submitting it from BIPContent In Cloud, we can submit the ESS Job from BIP using "ESS_RUNTIME.set_submit_args" procedure. Is the…Vinay Gharge 42 views 0 comments 1 point Most recent by Vinay Gharge Reporting and Analytics for ERP
-
how to extract sql query in data modelSummary how to extract sql query in data modelContent Hi, I wonder if there is any way to extract SQL Query in Data Model using table/web service/etc. Regards, Suyoung V…Suyoung 37 views 3 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
HDL Error ReportingSummary HDL Error ReportingContent Hi Experts, Does anyone have user friendly error reports for HDL Loads. Because PBL is deprecated, we are looking for a good reporting…Rahul Bedia 98 views 8 comments 1 point Most recent by Suma Raghavendra Reporting and Analytics for HCM
-
What roles needed to let custom HR Specialist Role able to open any report or analysis?Content What roles needed to let custom HR Specialist Role able to open any report or analysis? and what controls reports and analysis data security? BI consumer Role? B…Walid Hamdy 58 views 5 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM
-
OTBI Report showing multiple Parent Position Codes for a recordSummary Display the current parent position code in the OTBI analysisContent I have an OTBI analysis that is using Workforce Management - Worker Assignment Real Time and…User_2025-02-04-08-51-08-912 35 views 8 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Number of days a requisition is suspendedSummary Asking if it is possible to calculate the number of days a requisition is suspended (regardless of the number of times it is suspended) in OTBIContent Hello ever…Tom John Bontoyan 58 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Personal Payment MethodSummary Is it possible to report on personal payment method when this is blankContent Hi, please can someone confirm if it is possible to identify in a OTBI report when …Helen Tilling 138 views 4 comments 0 points Most recent by User_2025-02-08-06-26-45-662 Reporting and Analytics for HCM
-
tables that stores the submission of BI Publisher reports which are not scheduledSummary tables that stores the submission of BI Publisher reports which are not scheduledContent Hello, Are there any tables that stores the submission of BI Publisher r…
-
Conditional format image - The file type is invalid, only .png .jpeg .jpg .gif and .bmp files are suContent I am trying to add a image if a condition holds true but I am getting this error message trying to upload an image. I confirmed the image format I am trying to u…User_2025-02-10-08-27-16-805 10 views 6 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
HDL - Element Entry IDContent Hello, I'm trying to update recurring element entries but am not sure where to find the ElementEntryID so that we can refer the HDL to a specific element entry. …
-
How to calculate the total cost of a ProjectSummary How to calculate the total cost of a ProjectContent In calculating the cost of a Project, I normally used the Committed and Projects Cost. Is this the best optio…
-
Geography Municipalities ExtractionContent Hello Guys, We need to create a report in order to extract Geography Municipalities data, where could we find this information? Best Regards, GiuseppeGiuseppe Iacono 23 views 0 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for ERP -
Inventory Reconciliation with GL - ReportContent All - I have a requirement to show the Inventory Reconciliation with GL and I see two OOB reports (Costing balances and Inventory Valuation) to satisfy the requi…Hari Thyagaraj 59 views 2 comments 0 points Most recent by Ahmed Eldemerdash Reporting and Analytics for ERP
-
OCI – ERP Analytics: What's New And What's Next On The ERP Analytics Roadmap, 27 April 2021, 9 a.m.Content Submit your questions for the OCI – ERP Analytics: What's New And What's Next On The ERP Analytics Roadmap session to have them answered during the live event. P…mauricio -Oracle 31 views 0 comments 2 points Most recent by mauricio -Oracle Reporting and Analytics for ERP -
In which table is the issued by field for license and certificate for talent profileSummary issued by field for license and certificateContent In which table I can see the full entry for issued by field for license and certificate ? I can only see the a…
-
How to Embed a BIP Report with Prompts on a DashboardSummary How to Embed a BIP Report with Prompts on a DashboardContent Hi All, I have an existing custom Missing Time Cards report which is built using a custom SQL refere…Vinay Soni 250 views 4 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
how to default the date parameter in BIP report with sysdate-1 hourSummary how to default the date parameter in BIP report with sysdate-1 hourContent Hi All, Could any one help me in defaulting the date parameter in BIP report with an h…User_2025-02-06-09-41-56-955 427 views 4 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM