Reports
Discussion List
-
"Remove content control" in Word docletIn my PDF report package, I have a Word doclet that has a report embedded as a reference doclet. If I download the Word doclet and open the report, I can see the report … -
How to export all pages on a dashboardHello, Is there any way we can export a full dashboard and it return the full table of results rather than just the rows shown on the dashboard page? Thanks, Stacey
-
Creating a database connection in Reporting Studio in EPBCSContent Hi, We tried to create a database connection in reporting studio in EPBCS. Navigation = Reporting > Explore Repository > Explore > Tools > Database Connection Ma…
-
Do I have replace report in Report Package everytime I enter data in planningHello Experts, I have a Report Package in Narrative Reporting which has a reference doclet report, which is sourced from the EPM Planning cloud. Every time I update data…
-
Excel report headers not displayed properlySummary: Content (required): Report headers are not displayed properly when downloading / bursting reports in excel format while they display just fine in PDF format. We…
-
Could please help me on to find FTE cloumn in OTBI subject areaSummary: Hi Team, We need FTE column in OTBI report, I have taken worker assignment real time but I can't find out FTE column. Any help me on . PFA. Content (required): …AjayKumar Maddipati 31 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to retrieve the OLD payroll frequency and NEW Payroll frequency in the BIPHi ALL, Kindly support me to resolve below issue: I have a requirement to retrieve the OLD payroll frequency and NEW payroll frequency in BI report. Following with other…RamkumarKadhiravan 21 views 2 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM -
SQL to retrieve fields for BI ReportSummary: Hi All Please share SQL query to fetch below details for generate bursting report. Thankyou, Ram Content (required): SQL to retrieve Employee Number, Employee N…RamkumarKadhiravan 71 views 8 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM
-
SQL for Environmental health and safetySummary: Team, Does anyone have the sample environmental health and safety BI report (SQL). Please share Content (required): SQL for Environmental health and safety SQL …
-
The user request exceeded the maximum query governing execution timeSummary: The user request exceeded the maximum query governing execution time Content (required): Hi Team, Greetings! We get error on OTBI report as 'The user request ex…Parag Hiremath 131 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Table name to get Element CategorySummary Table name to get Element CategoryContent Hi Team, Can someone help me with the table name to get the "Element Category", i was able to get this information inOT…User_2025-02-04-07-00-18-658 404 views 12 comments 0 points Most recent by Veerachari Reporting and Analytics for HCM -
Error in accessing BICC URL ending fusion pod /biacmSummary: Hi Team, We are getting error while trying to access BICC using url - fusion POD /biacm. Anyone faced similar issue, so need help in resolution of same. ADF_FAC…raban 61 views 4 comments 0 points Most recent by SiddharthDang-Oracle Reporting and Analytics for ERP
-
Absence category and absence types under this category query.I need a SQL query that returns information about the absence category and the absence types connected to this category. I would be grateful for the query you can share …Cansel Karasoy 321 views 11 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Sending Bursting pdf as an e-mail body instead of outputI have a notification work that I have prepared, the report returns table type employee data and absence detail.I can send this tabular report as a pdf output, but I wan…Cansel Karasoy 31 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
How to write a query to pull FCCS Users through a Non-COnsolidation ReportSummary: Currently we are using "select * from FCM_USERS" query to create the report. But it pulls the entire users from the LDAP. However, we want to confine the users …User_2025-03-07-06-14-34-751 121 views 11 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
AS-OF-DATE on Prompt - CURRENT_DATE_REP_OTBI-Session DateSummary: I am using CURRENT_DATE_REP_OTBI in the calendar prompt # As of date . The date is is not defaulting correctly. The session date defaults to 01-Nov-2021. While …
-
Unable to call BIP report with REST APISummary: Hi Experts I'm trying to use the REST APIs for the BIP report developed in Fusion but I'm getting not found error, please help me if I'm creating a wrong URL Be…Sharmava 271 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Is there any table/way to find the tables used (data set details) in BIP reportSummary: Is there any table/way to find the tables used (data set details) in BIP report Content (required): Hi Team, Greetings! Is there any table/way to find the table…Parag Hiremath 931 views 16 comments 0 points Most recent by HarshithDarla Reporting and Analytics for HCM
-
Looking for a Workflow transactional Report where Self Approval is enabled.Hi Team, I'm Looking for a Workflow transactional Report where Self Approval is enabled. Either the report should let me know about on which workflow rule self approval …
-
FR member search does not work for options other than NAMESummary: Content (required): Hi all We are finding few issues with FR today for a client. When we try to seach for a member using default / alias or Alias-form, we get a… -
No access privilege for subject area errorSummary: User getting this error No access privilege for subject area when trying to access OTBI Reports using Order Management – Fulfillment Lines Real Time subject are…SakshiA 41 views 4 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Extract description of lookup in OTBISummary: Content (required): Hi everyone, we are having problems extracting the value of a dff configured for the JOB. Is it possible to extract the description of the r…Gerardo Peluso 1 view 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Getting error in FRS reportSummary: Getting errors in the FRS report Content (required): Hi All, I moved one FRS report from TEST instance to PROD. When I try to run the report in PROD, I am getti…
-
FR: HTML reports preview does not display pop window to define promptSummary: Content (required): Hi all We have an issue with Fr web studio where the pop-up window to define prompt and select members for a specific prompt does not displa…
-
Looking for SQL query for Duty Role to Job Role mappingSummary: We have a couple of job roles and child duty roles and privileges assigned to the same job role. Can someone help me with SQL to fetch the same as we need to co…sailesh_cloudare 472 views 1 comment 2 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP -
Need help with querySummary: May I know what is wrong in this query Content (required): SELECT order_key, dfla.source_order_number, dfla.source_line_number, DFLA.ordered_qty using_requireme…kalyan gade 101 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
OTBI Report is not giving results.Summary: Hi Everyone! Workforce management - Worker Assignment Event Real time I am using above subject area to create a report but when i click results, i am getting " …ShawShankk 2.3K views 9 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Can we schedule a OTBI report by password protecting the output?Summary Can we schedule a OTBI report by password protecting the output?Content Hi, We have a question: Can we schedule a OTBI report by password protecting the output? …User_MC37Q 57 views 8 comments 1 point Most recent by Kimberly Nguyen Reporting and Analytics for HCM