Reports
Discussion List
-
Can we change sign of accounts based on rules in EPRCS?Summary: Need crete a report with base level accounts where signage change required based on Account Number . Account starting with 1 Series -> + Ve 2 Series -> - ve and…AlokPriyadarshi-Oracle 25 views 3 comments 0 points Most recent by AlokPriyadarshi-Oracle Narrative Reporting -
User ID impersonation to Data sourceSummary: User ID impersonation to Data source Content (required): When we are creating NR reports, we are giving Datasource connection hardcoded with Administrator Crede… -
Display multiple selected Prompt Members in Report Text HeaderOur report is set up to allow a user to run a report for one or multiple members of an Attribute dimension (the "Section" attribute dimension.) This is accomplished usin…
-
Change alias on the sender email IDContent Currently, when scheduled reports are received, they come from planning-test-[zone name] . Is it possible to change the alias (planning-test-[zone name]) to some…
-
there are a function or conditional that allow merge names to don't repeat?Summary: Guys, I'm creating a table where the intercompany dimension must be in a column and I'm using the level 0 function. The point is that I don't want the name of t… -
Change of Owner in Catalog FoldersSummary: What are all the actions that trigger the change of ownership for folder, sub folder and reports under it? Please explain in what all cases "System Account" is …
-
Find and Replace PROD path reference in extractsSummary: Find and Replace PROD path reference in extracts Content (required): Hi Team, Greetings! We have multiple extracts with reference to Production path on SFTP or … -
"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 36 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 144 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 408 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 62 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 328 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 272 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 945 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…