Reports
Discussion List
-
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 489 views 25 comments 0 points Most recent by NeenaS25 Reporting and Analytics for ERP -
is there way to hide Page Options - Edit dashboard - we have access it through work areaSummary: Dear exports, We have created work area and provided below static url of the dashboard link to access the report. The manger's are able to see the ritNow, the c…Rama123-Oracle 11 views 2 comments 0 points Most recent by Rama123-Oracle Reporting and Analytics for HCM -
Can I speed up the search for people who successfully completed a course?Summary: I need to generate a list of who's completed a specific course. I don't care how often they've completed it - I just need to know if they've got at least one su… -
Note Summary - NR reportIn NR, I need to create a report that allow users to input notes by region and/or entity and then summarized those notes into one report for analysis - Would Gen AI Note… -
Absence Plan Use report via OTBII need to create an Analysis report in OTBI (I am new to this so I have not yet able to create reports etc) that will show employees sickness absence and the days used a…Julie Searles 304 views 7 comments 0 points Most recent by Gillian Kilbride Reporting and Analytics for HCM -
How to suppress negligible rows/columns when scaling to millions in NR?Context – We have used a custom dimension (Future 1) and conditional formatting to scale data to millions in Narrative Reporting. Based on the Future 1 selection, data i… -
Offer Accepted Date and Offered Date returns an errorSummary: When we try to add the fields to our OTBI report Offer Accepted Date and Offered Date we received an error. We have tried to apply what the following post says … -
Unable to modify JobOfferLetterDM as it is giving the error ORA-01719.Summary: I would like to add the candidate's preferred language column in the OfferRecipient data set Cand.CAND_PREF_LANGUAGE_CODE but when saving the data model, it thr… -
Add Business unit parameter to Global Payroll Register & Periodic Payroll Register ReportSummary: We have a requirement to include Business Unit as an additional parameter in the Payroll Flow (Extract) to allow report generation based on BU selection. If any… -
OTBI to fetch adjusted service dates from Work relationshipSummary: Hi everyone, We are trying to fetch the adjusted service date field from the employee work relationships page service dates section through OTBI. Can anyone sug…Prabha_112 161 views 2 comments 0 points Most recent by Rana Ritesh Kumar Reporting and Analytics for HCM -
SQL query to get the child department of a parent department from the department hierarchy in BIPI have written below query where I have hardcoded Organization id for which I want to fetch the child departments from department hierarchy in BIP report but the query i…Anjali_Kumari4121 114 views 3 comments 0 points Most recent by B Casla Reporting and Analytics for HCM -
Narrative Reporting - Header- Entity Currency DisplayIn Narrative Reporting, I'm trying to display a entities assigned currency from the "Entity Currency" field in FCCS in the header of a report. I cannot figure out the sy… -
Help finding the audit product id for middleware applicationsIn order to call the API endpoint /fscmRestApi/fndAuditRESTService/audittrail/getaudithistory you have to pass "product". The products for regular fusion modules are eas… -
Procurement Procure to Pay Real Time and Invoice Line Amount from Payables Invoices - Transactions RSummary I am combining 2 subject areas Procurement Procure to Pay Real Time and Payables Invoices - Transactions Real Time. I don't get an error but I get an invoice Lin… -
Insert Tables with Oracle GL Connection in Narrative ReportsSummary: Insert Tables with Oracle GL Connection in Narrative Reports Content (please ensure you mask any confidential information): We have Oracle GL connection and I a… -
how to get read only access to reports and analyticsSummary how to get read only access to reports and analyticsContent Hi Team - I need to grant only read access to Reports and Analytics page...With this grant,the user s… -
How to hide Page Options while accessing by managers Fusion Cloud HCMHi Team, Could you please to hide below Page Options (Edit dashboard, other options in it) while accessing by managers in Fusion Cloud HCM BIP.Chanikya Neelam-Oracle 1 view 0 comments 0 points Started by Chanikya Neelam-Oracle Reporting and Analytics for HCM -
Exempt from State Income Tax Withholding Report QuerySummary: Exempt from State Income Tax Withholding Report Query Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there an existing re… -
Ability to view the output of BIP reports run by other users in Scheduled Processes.Hi Team, Is it possible to view the output of BIP reports run by other users from the Scheduled Processes tab without the BI Admin role? I assigned the necessary data se… -
I can't locate my report in OAS agentSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Query/BI Report - Pay Elements Paid Past Term DateHi I am looking for a query/BI report that will show me pay elements that have been processed and paid past the employee's termination date. I tried searching the commun… -
Error loading XML: Not valid at the top level of the documentSummary: Content (please ensure you mask any confidential information): Hi there We have started getting this error in NR: Data refreshes correctly, but we do not unders… -
BI Publisher not working in MS Word, and how can I fix it?I downloaded BI Publisher to work on an RTF template, but every time I try to open MS Word, it crashes and becomes unresponsive. The issue resolves only when I remove th… -
Write a sql query to fetch average number of learning days per employeeSummary: Write a sql query to fetch average number of learning days per employee (includes all formal learning). Content (please ensure you mask any confidential informa… -
How to get estimated revenue from all active leases for future yearSummary: Customer has a requirement to know the Estimated Revenue from Active Leases for Future periods. Content (please ensure you mask any confidential information): I… -
OTBI - Issue while submitting Custom report - Asset Cost DetailSummary Error while selecting parameters for Custom OTBI report which was copied from Asset Cost Detail reportContent Error while selecting parameters for Custom OTBI re…User_2025-02-04-10-47-46-258 43 views 1 comment 0 points Most recent by Priya_Ananda Reporting and Analytics for ERP -
How to run out of the box intercompany report in FCCS using substitution variables?Summary: We need to run the out of the box intercompany report in FCCS using substitution variables for year and period in the POV. Content (please ensure you mask any c… -
Resolution Issues in PPT Report PackageSummary: Font/Text resolution issue in PPT Package for MR Reports Content (required): We created a PPT Report Package and embedded some MR reports Grids and Charts, Most… -
Why is the waterfall chart in Oracle EPM not showing the desired data points?When building a report in oracle EPM. We are experiencing issues developing a waterfall chart not showing the desired data points, however the data points are can be dis…