Reports
Discussion List
-
Reports Relative Member of CurrentPOV -1 does not render Dec prior year if Jan is selected in POVWe have a Balance Sheet Report with the Period Dimension leveraging CurrentPOV in one column and Relative Member of CurrentPOV -1 in another column and then a variance c… -
Need a report which can provide details if any scheduled job runs and BI report run got missed.Hi Team, We have a requirement in place that if any report schedule and job schedule got skipped due to any reason then we need a BI or OTBI report by which we can track…Sanchit_Jauhari_2211 31 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to customize seeded Payment Register ReportSummary: How to customize seeded Payment Register Report Content (please ensure you mask any confidential information): Hi All, We got a requirement to add new columns i…Venkatesan 153 views 6 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
Targeted Distribution File to Send to Some Users on Same EmailSummary: Content (please ensure you mask any confidential information): I have a Targeted Distribution File that sends different department reports to multiple users. Cu… -
OTBI to show future effective datesSummary: Hi Community, Please refresh my mind: how to make the OTBI to show future dates from EFF table? Thank you, Alvaro Couto Content (please ensure you mask any conf…Alvaro Couto 31 views 1 comment 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM -
Sql query to get payroll process name Under a batch Name /Instance nameHi , I am looking for SQL table to get payroll process name currently i can get batchname/Instance name via below query : SELECT pfi.instance_name FROM pay_flows pf,pay_…Surbhigupta_88-Oracle 571 views 3 comments 0 points Most recent by Karim Ahmed Abdallah BI Publisher Learning Center -
Assistance Needed for Extracting Users from Oracle HCMSummary: I need help with extracting user data from Oracle HCM, including active and inactive users, email addresses, start dates, end dates, and associated roles. I’m e…
-
Table / View for New Features and Opt In Features?Summary: Is there a table / view that can be queried via BIP which would allow us to create a report of all of the implemented and non implemented features as seen in th…Monica Fundak 51 views 6 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to fetch Import errors for Project tasksSummary: Where Import errors for Project tasks will get stored .W e dont see them in PJF_OPEN_XFACE_REPORT table and PJF_TASK_ERRORS table after import run. Content (ple…Lakshmi Bandlamudi 221 views 7 comments 0 points Most recent by Venkat Patlola-Oracle Project Management
-
Need different font color for different Bar in Waterfall chartSummary: Need different font color for different Bar in Waterfall chart Content (please ensure you mask any confidential information): As shown in screenshot, starting b… -
FND_FLEX_VALUE_NORM_HIERARCHY is not available in fusion. Please suggest the replica table in FusionSummary: We have DWH implemented and as part of cloud transformation we are migrating from EBS to Fusion Cloud ERP. Hence, from DWH perspective, we are in process of ana…
-
Unable to access the Standard Invoice screen from the OTBI Action Link ReportSummary I am trying to navigate to the Standard Invoice Screen from the custom OTBI Report via Action LinksContent Hi , I had created a custom report with the Payable In…SandeepPaspunuri 181 views 16 comments 1 point Most recent by Joanne Heathcote Reporting and Analytics for ERP -
Rest API for Role Assignment report without Service Admin RoleWe perform Quarterly Access review on our FCCS Application, run the Role Assignment Report and send it to our reviewers. We are attempting to use an application called S…Shravan446 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Synchronize Hierarchies from EPM to ERPIn EPM, we have established a project hierarchy under an "All Projects" node, with dimensions assigned by department. Our goal is to ensure these hierarchies are accurat…
-
Unable to edit the extract in advance mode in 24D.Tried the below steps but still not able to edit the extract 1. Navigate to 'Setup and Maintenance' 2. Search - 'Manage Common Lookups' 3. Search for Lookup Type - 'ORA_…
-
How can we create a distribution list in Oracle fusion Bi publisher?I need to share a custom report with multiple users through the following steps: Schedule → Output → Destination Does anyone have any idea about configuring a distributi…
-
Sql query to print numbers between 2 column numbers when both columns are not equalSummary: Sql query when both columns are same print first column value , else if both columns are different print the series of numbers between the columns Content (plea…
-
Position Hierarchy ReportContent (required): Looking for BI report to get the current logged in person's position and the positions under his hierarchy. Version (include the version you are usin…Nivya Mathire 91 views 8 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How to Remove Subtotals from Intercompany ReportsSummary: I am looking for a way to remove subtotals from Intercompany report. Content (please ensure you mask any confidential information): We place accounts in the row…Ija Vidaurri 21 views 2 comments 0 points Most recent by Ija Vidaurri Financial Consolidation and Close -
How to get a blank output file from report bursting definition when there is no data for a month?Summary: For our client, we are extracting report output by leveraging report bursting definition which is executed through EPMautomate and output file is saved in Inbox…Harshith J Rao 81 views 9 comments 0 points Most recent by Harshith J Rao Financial Consolidation and Close
-
Document Category is salary infomration notification issue redwoodwe have DOR with Document Category, which is salary information. For this DOR, we have created a DFF. When employee submits DOR, line manager cannot see DFF values in ap…
-
Has anyone noticed random member highlighting appearing in reports in Narrative Reporting?Summary: In Narrative Reporting, we've noticed random highlighting appearing in the member rows. There have been no changes to these reports to cause this highlighting t…
-
Migrated report from FR to Reports in EPBCS. Reporting is Validating for one Sys Admin, not anotherSummary: In EPBCS we migrated our reports from 'FR' to 'Reports', but when we go in to validate the migrated reports two users are seeing different results. Both users a…
-
In Oracle Fusion HCM, eText template with UTF-8 character set converting space to special character.Hi Community, I am facing an issue in eText template with UTF-8 character set, whenever for a field if it has space as a value it's converting space to special character…
-
Limit rows displayed on template in Bi Publisher.Summary: We have a rtf contains 3 paragraphs. The second paragraph should display a maximum of 10 employees per page, and the third paragraph should be displayed on all …Salma Mohamed Salem 301 views 5 comments 0 points Most recent by NagarajuKunchala Reporting and Analytics for ERP
-
Is there a way in Narrative reporting reports to split member name and alias using functions/formulaIs there a way to split the account code and account description (similar for other dimensions with different length eg Mid/Left functions) is there a conditional format…
-
How to identify new lines in a PO through tables?Hello community, We are customizing the purchase order PDF, and in a requirement my client asks to show the new lines that have been included in a change order after the… -
FCC: Bank Holiday table in the queryHello, I would like to create a query that requires the Bank Holiday table for a custom report. However, I cannot find the name of the table. Is that table available in …