Category 81
Discussion List
-
Influencing the SQL Optimizer in SaaS ERP ApplicationsSummary We have a query that was running perfectly in our non-prod environment for month up until mid December 2020. Then it suddenly timed out and performs poorly.Conte… -
Talent Review| Succession Plan| Career Development - All in One ReportSummary This report will give employees' Performance, Talent Review, Succession and Career detailsContent If your customer wants a detailed report on Talent management w…Mani Iyer-81826 114 views 6 comments 0 points Most recent by User_2025-02-08-07-12-44-872 Reporting and Analytics for HCM -
Precedence of security roles for custom BIP reportsContent If we have 2 roles attached to the BIP report, one of them should have Read, Traverse access and another one should not have access what would be the precedence …Prajna Hegde 40 views 2 comments 0 points Most recent by Prajna Hegde Reporting and Analytics for HCM -
OTBI | Learn Module | Need an analysis to get specialization name, it's corresponding module name ,Content I am working on an OTBI report where I need to fetch specialization name, it's corresponding module name , course name, offering name, offering status, learner. …Arti P 30 views 1 comment 0 points Most recent by Nitika Arora-Oracle Reporting and Analytics for HCM -
Is Dynamic Time Series still used!?Summary DTS or not to DTSContent Hi All, I'd be interested to hear if anyone is still using Dynamic Time Series? Thanks, Mark Version 20.11.70 -
Restrict users from sending reports to external email addressesContent Hi, As we know, Oracle allows to include the email address when adding a Destination for a report output in both OTBI and BIP reports. Is there a way to restrict…Madhu Chalamalasetty 191 views 6 comments 1 point Most recent by Madhu Chalamalasetty Reporting and Analytics for ERP -
Is there a way to put a pause/hold on all the BI reports schedule in HCM and resume them after few dSummary We need to pause the schedules in PROD for few days and we don't know how many user schedule the BI/OTBI report jobs. We need to pause all the jobs at one go and…User_F89L9 95 views 7 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
UK Payslip CustomisationSummary UK Payslip CustomisationContent Hello Experts, Need your help. Can you please help if you have already done UK Payslip Customisation; Like the details of the cus…User_2025-01-30-20-59-13-989 63 views 2 comments 0 points Most recent by User_2025-01-30-20-59-13-989 Reporting and Analytics for ERP -
BPM Worklist - Approval Aging ReportSummary Report to calculate the average time it takes approver to approve a taskContent Hello, We have a requirement to build out a report/analysis to calculate the aver… -
Time Card approver details for multiple AssignmentSummary Require Approver details for each assignment hours in Tiime CardContent Hi Team, I have a requirement to get the approver details for each assignment hours in th…User_2025-02-04-13-27-19-123 22 views 2 comments 0 points Most recent by User_2025-02-04-13-27-19-123 Reporting and Analytics for HCM -
Time Card issues -Actual Period start Date DBI from Time & Labor.Content Hi Expert do you have any idea to fetch Actual Period start Date in Time & labor . I have created a new hire "XXXX" with the hire date of '02/23/2021' ( same dat…User_VR8E0 23 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Why is there no output from a scheduled OTBI report when the interactive version works fineSummary A report with csv output with parameters can be run interactively, but when scheduled no output can be found in scheduled processes, but available though e-mailC…Warren Murray 63 views 3 comments 2 points Most recent by Warren Murray Reporting and Analytics for ERP -
OTBI | Learn Module | Need an analysis to get specialization name, it's corresponding module name ,Content I am working on an OTBI report where I need to fetch specialization name, it's corresponding module name , course name, offering name, offering status, learner. … -
BIP Extensibility Training - How to Customize an RFT Report LayoutSummary This short tutorial details how to customize an RTF report layoutContent This short tutorial details how to customize an RTF report layout. You will learn how to…Neil Dickens-Oracle 565 views 8 comments 23 points Most recent by Tamer El-Tonsy - Tatonsy BI Publisher Learning Center -
Need a query for a date parameter dependent to another date parameter.Content Hello all, There's a query I need to get the month names separately with one parameter and another parameter to select a date range. The month name parameter sho…Sushan Peiris 551 views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM -
Subledger Period Close Exceptions Report query timeoutSummary SQL query time exceeds the limit (2400 sec). Stopped processing.Content Hi, just wondering if anyone has any experiences with the Subledger Period Close Exceptio…User_2025-02-10-13-18-56-927 32 views 0 comments 2 points Most recent by User_2025-02-10-13-18-56-927 Reporting and Analytics for ERP -
Invoice attachment link in OTBI analysisContent Hi, Looking to see if there is a way to provide a hyperlink in an OTBI analysis that would open up (preferably in a new window) an attachment associated with an … -
Deleting an Offering that was previously marked completeSummary I am trying to delete a duplicate record. I am unable to reset the activity through the manage activities screen and when when I try to edit it though a spreadsh… -
Frequently Changing HierarchiesSummary How to perform GAAP reporting on Legal Entity Rollups in ERP CloudContent All we have a use case, which I don't think is that unique, yet I am struggling with ho… -
How can you modifying due date for a required offering using HDL for mass learnersContent I have over 2000 learners in a required course offering and I need to modify the due date. I see I can do it one at a time, but how can I do it using a dat file … -
report of all data access set access given to usersSummary Can we get a report of all data access set access given to users, along with current access and history of terminated accessContent Can we get a report of all da…User_C3J94 45 views 2 comments 1 point Most recent by User_C3J94 Payables, Payments & Cash Management -
New layout reports sectionSummary The new release has changed the layout of the reports sectionContent Hi, I saw that on the new version 21.02.91 there was an update on the Reports section. Previ…Alberto Parisella 27 views 1 comment 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close -
Course File Path ReportSummary Need to identify the file path of all SCORM and AICC courses in Taleo Learn.Content We are transitioning content and need to identify the file path for each of t…