Reports
Discussion List
-
XML-22002: (Fatal Error) Error while processing include XSL fileSummary: We are getting the error XML-22002: (Fatal Error) Error while processing include XSL file (xdoxsl:///Custom/Human Capital Management/HR/SUBTEMP.xsb?loc= en-GB) … -
In which table has the name format components storedSummary: Hi Team, We need a table where the name format components stored, Tasks: Manage Person Name Formats - HR_NAME_FORMATS I need the table for name format component… -
HCM Position extract from EPBCS not generating records in HCM view extractWe have downloaded the HCM extract from EPBCS and uploaded the extracts to HCM. When we run data extract for Position in HCM, there is no data being generated in HCM. We… -
Number field not displaying correctly on RTFSummary: I have a RTF created with the BI Publisher Add-in and is sent as a PDF email notification through a bursted BIP report. There is a number field on the RTF, that… -
Procure-to-Pay RT subject area - approver nameSummary Procure-to-Pay RT subject area - approver nameContent I am attempting to update my existing P-to-P reports to leverage the P-to-P RT subject area; this subject a… -
SQL query to create list of values for past 24 monthsSummary: I've been searching and attempting to create a List of Values to be used in a Data Model for a report to make the parameter selection dynamic year over year ins… -
Query to get Fusion Workflow ApprovalsHello, Is there a query where i can get all pending approvers for a transaction, not only the current assignee? I was able to identify the current assignee using the bel…Osama_Mo 3.6K views 10 comments 1 point Most recent by Ruma Bhatnagar-Oracle Reporting and Analytics for HCM -
BIP report to extract all JR approval flow stepsSummary: BIP report to extract all JR approval flow steps Content (please ensure you mask any confidential information): Hello experts, my customer requirement is to ext… -
How to pass system date in subject line of email notification when scheduling an Ess jobSummary: I am scheduling ESS job set, our requirement is to print system date in email notification subject line and attachment name. How to configure dynamic date (Sysd…VasanthaFusion90 41 views 1 comment 0 points Most recent by VasanthaFusion90 Reporting and Analytics for ERP -
Error changing ReportsWhen trying to change the report from the custom folder, the following error appears:Matheus Vitorelli 11 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
ReportService API appears to be deprecated or marked as obsolete in the April 25B update.Summary: As part of the April 25B Patch activity, we noticed that the ReportService API (/xmlpserver/services/v2/ReportService?wsdl) deprecated or obsolete?. Could you p…Chaitanya2324 122 views 2 comments 1 point Most recent by Sridhar Gupta Yerram-Oracle Reporting and Analytics for ERP -
Issue with Currency Scaling in Narrative Reporting for Custom Currency (HKD_M)Hi Team, We have created a currency member called HKD_M which is scaled by 1/1,000,000 from HKD. And we have successfully convert the number is FCCS. But in Narrative Re… -
Merge and Center does not match as expected in excel exportSummary: When the report is exported to excel from NR, the header "QTD" is showing as left aligned while in the application, the report preview shows correctly as center… -
Is there something similar to srw.abort_program in Fusion ERP bip reportIn Oracle report writer one could abort the report using SRW.ABORT_PROGRAM Built in. Is there similar built in in FUSION ERP BIP Report? -
In which table has the information of Mail Stop in Legal Reporting Unit AddressesSummary: Hi, In which table has the information of "Mail Stop" in Legal Reporting Unit Addresses under the setup Manage Legal Reporting Unit. We checked in below tables … -
Pivot table is not working in OTBI report with 2 subject areas, columns are not working properlySummary: Pivot table is not working in OTBI report with 2 subject areas, columns are not working properly as per the pivot table layout. Created a report with subject ar…Elavarasan S 11 views 5 comments 0 points Most recent by Elavarasan S Reporting and Analytics for HCM -
Where can I find HCM Extract user entity to database lineage mapping?Where can I find HCM Extract user entity to database lineage mapping? -
Overdue Task Report in Journey ChecklistsSummary: Overdue Task Report in Journey Checklists Content (required): Hi All, Greetings! we are trying to check the exact data for the terminated employees with checkli…Parag Hiremath 121 views 13 comments 0 points Most recent by Ashraya_SN-Oracle Reporting and Analytics for HCM -
Planning - The report generation has failed. Error executing query. The number of cells exceeds theSummary: .we have an issue with a report bursting export that we have configured and been sending since last year. since April and May this year . the export of data has… -
Formula Error with Exponential CalculationSummary: Content (please ensure you mask any confidential information): Hi Experts, I'm encountering an error when implementing this exponential formula in my report: Fo… -
Oracle BI report for account hierarchyI am trying to create a oracle BI report for account hierarchy, but I'm a bit stuck. I used the code below but get a message of missing right parentheses. SELECT LEVEL A… -
Management Report Page # vs Book Page #Summary Conflicting functions for displaying page numbers in reports and booksContent I am converting FR reports into Narrative Reporting Management Reports. Books do no… -
How to remove processed PO change orders from monthly subledger exception reportSummary: We have a few PO's that are showing up on the subledger exception report monthly but the change orders against them have been processed. How do you get them rem… -
We are getting an error on migrating Financial reports to Reports.Summary: We are getting an error below on migrating Financial reports to Reports. Grid "Grid1" data row 01 references the property name "Intercompany Account" in express…User_LY017 15 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
where to find the database connection manager in FRS workspaceHi, I am trying to get the database connection definition and details for FRS report, however i can't find the database connection manager in 23D. I do see the Essbase a…nehayadav86 11 views 2 comments 0 points Most recent by Prasanna Villari BI Publisher Learning Center -
Formula Returning -1 Instead of Error for Empty Data CalculationSummary: Content (please ensure you mask any confidential information): Hi Experts, I need help troubleshooting a formula issue in my report. Issue: Formula: Column B / … -
I have to create a actual vs budget amount report for revenue and expense accounts in OTBI.Summary: I have to create a actual vs budget amount report for revenue and expense accounts in OTBI. I have used GL balances real time subject area. The columns selected… -
How can we bring Approval status into FR reportsSummary: How can we bring Approval status into FR reports Content (please ensure you mask any confidential information): How can we bring Approval status into FR reports…SubramaniKalimuthu 11 views 1 comment 0 points Most recent by ApOK Financial Consolidation and Close