Reports
Discussion List
-
IFTHEN function in Report not working with division in the false parameterSummary: Following formula function not working in the report, IfThen(IsMissing([B]),0,[A] / [B]). Need help Content (please ensure you mask any confidential information… -
Agents and RecipientsSummary: Does anyone know how I can get a list of Agents and recipients out into a report? Content (please ensure you mask any confidential information): I need to get a… -
How to customize Subledger Period Close Exception ReportSummary: How to customize Sub-ledger Period Close Exception Report Content (required): Ledger Set Parameter to be added to the report. when i'm trying to edit datamodel,…Lydia Jayasingh 219 views 8 comments 0 points Most recent by Vinoth_BI Reporting and Analytics for ERP
-
Smartview Report HsgetValue to retain data when it is openedSummary: Smartview Report HsgetValue to retain data when it is opened by the user who does not have Oracle connection Content (please ensure you mask any confidential in…
-
COUNT function is not working for Table Object in EPM Planning ReportsSummary: COUNT function doesn't seem to be working in EPM Planning report while using the Table Object. The report is showing the task status from Task Manager. Content … -
Would there be a solution for the headers to appear as text in Excel in EPM Reports?Summary: We are migrating our reports from Financial Reports (FR) to Reports in EPM. The headers appear as images in Excel, which is a pain. It worked fine in FR. You've…
-
In EPM Reports the header appears as an image in Excel. Is it possible to display it as text?We have converted our FCCS reports to Reports and we are facing some issues. Our business team has a requirement to generate the reports in Excel and PDF and upload them… -
“Connection is either null or invalid” Error Only for HR Specialist (Custom Role)Summary: We have a BI Publisher report in the Custom folder. When I run the report using my implementation user, it works correctly and generates output. But when we log…Raghavendra M 44 views 5 comments 0 points Most recent by Abbas Sibai Reporting and Analytics for HCM -
Dyanmic Deep Link in OTBISummary Need to identify mechanis to have dynamic deep links in OTBIContent Hi There, We have developed around 15 reports in OTBI having a deep link embeded in each of t…Sahil_Makhiza 517 views 27 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP
-
Supplemental Data Manager Report Fails After Migration/Cloning with errorHi Team, We have created several Non-Consolidation Reports for Supplemental Data Manager (SDM), and they work correctly in the source environment with the generated repo…rahul shinde 66 views 2 comments 0 points Most recent by rahul shinde Financial Consolidation and Close
-
Negative numbers, positive numbers and Percentages do not align properlyPlease refer the screenshot below. the numbers do not properly align and this is mostly the problem for negative numbers in brakets. The align prefix and suffix have bee…
-
Planning Reports Bursting is failing overnightSummary: We have always had Reports bursting overnight without issue, however the last two nights we are getting failure notices where it looks like it is losing connect…
-
How can i suppress report parameter by hardcoding the valueSummary: How can i suppress report parameter by hardcoding the value Content (please ensure you mask any confidential information): How can i suppress report parameter b…Tapas_Sathua 31 views 1 comment 0 points Most recent by James McBride Reporting and Analytics for ERP -
Calculate formula based on Hidden columns from top level memberWe have a requirement where we for Balance sheet we are calculating a column that says if it is above threshold or not for each row. This calculation takes place on basi…
-
Preview Offer didn't show Draft Watermark while previewing the offerSummary: Content (please ensure you mask any confidential information): Dears , I added Draft Watermark to the rtf file and while trying to preview the offer the draft w…Beshoy Hakim-Oracle 15 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Draft WaterMark missing while previewingSummary: Content (please ensure you mask any confidential information): Dears , I am working on adding DRAFT watermark on rtf file , it working offline while testing on …Beshoy Hakim-Oracle 27 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Is it possible to realize OTBI analysis to extract manager different from line manager data?Summary: Possibility to realize OTBI analysis to extract manager different from line manager data? Content (please ensure you mask any confidential information): Hello, …Caterina Ruggiero 24 views 2 comments 0 points Most recent by Baskaran Sambandam Reporting and Analytics for HCM
-
How to convert English language to Arabic in rtf templateSummary: how to convert below English text into Arabic language and split it into two lines in rtf template. Example input text: "EIGHT HUNDRED FIFTY-SIX BAHRAINI DINARS…SireeshaJaladi 632 views 3 comments 0 points Most recent by SaiRevanth Reporting and Analytics for ERP
-
Query to find fusion user details with their rolesI need to create a BI report which retrieves user information like user_id,username , email of the users along with their role information like role_id,role_common_name,…
-
Canceled report job is still runningSummary: Hi all, We have canceled a report's schedule job but for some reason the report is still being generated and sent to the users. If we check the Manage Report Jo…Maria Dantas 47 views 7 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Custom heading in reports issue.We would like the top-row member to stay as a custom heading, while the zoomed-in members use the default headings. We have already tried conditional formatting, but it …DebajyotiRay 38 views 2 comments 0 points Most recent by Ramith Attravanam Financial Consolidation and Close
-
Manage Audit Policies -> AUDIT_CHANGE_BIT_MAP_Content Helo, I have activate the audit of assignment object : Navigator > Setup and Maintenance > All Tasks > Name : Manage Audit Policies> Search > Go To task > Audit …User_2025-01-25-01-33-46-269 629 views 6 comments 0 points Most recent by Rashmi05 Reporting and Analytics for HCM -
How to get Phone number, Email Address, Home Address and Bank details old values using BIP ReportSummary How to get Phone number, Email Address, Home Address and Bank details old values using BIP ReportContent Hi Team, We are creating new HCM BIP Report to Fetch the…User_2025-02-01-06-07-07-886 872 views 9 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
OTBI Dashboard and Reports for ExpensesSummary An OTBI dashboard with a series of drillable reports for ExpensesContent The attached catalog files can be imported into an ERP Cloud instance to create a dashbo…Andy Gough 4.6K views 31 comments 31 points Most recent by Lionel Rajesh Devanbu Reporting and Analytics for ERP -
which duty roles would give access to BI Publisher Report which queries these tablesHello All, We want to give access to a custom role to a BI Publisher Report that queries these tables: per_periods_of_service ppos , per_assignment_secured_list_v paam ,… -
How to enable password for P60 Document with date of birthSummary: We are trying to password protect the Oracle P60 document with employee's Date of Birth. The XML doesn't have the Date of Birth tag. Can we modify the seeded Da…