Reports
Discussion List
-
Static/Reference Variable does not work for embedded reference doclet reportI have a Report Package which has a management report as an embedded reference doclet. I want to use static/reference variables in this embedded reference doclet but I'm… -
Report for Equal Pay Registration Certificate in IllinoisSummary: Has anyone built a report for the Equal Pay Registration Certificate now required in Illinois? Attached is the template we were provided, which is missing quite…Melissa Gettman 14 views 1 comment 0 points Most recent by Jeremy Miller-Oracle Payroll and Global Payroll Interface (GPI) -
produce cost centres from 2 area onto one reportSummary: extracting table tables onto one report Content (required): I'd like to be able to validate the date between cost centres show in "Departments" in HCM vs " Cost…Jeanette.Spalding 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Custom report to see who is listed as Read Only AccessSummary: Hi, Our Audit team would like a security report that lists everyone we have setup for READ ONLY access under Manage Administrator Profile Options Content (requi…Darrin N 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Financial Reporting Report failing after dimension uipdateSummary: Hi everybody, i have a quite complex P&L report with a lot of aggregation that takes 20 seconds to open. After a db refresh due to dimension update (about 6 dim… -
Core HR Seeded report.Summary: Hi Expert, Does anyone one have core hr seeded report path, where I can see all seeded report. If possible, please share the document. Thank you! Content (requi…Mohammad Afghan 51 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Learning item access group -BIP table to fetch Person Number List details for Learning access groupSummary: I am working on one BIP report where I am fetching one column to learning access group members using Person Number List options. In which table the person numbe…Kamini Kaushik-Oracle 41 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
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 21 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 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 128 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 403 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 63 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 313 views 11 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM