Analytics
Discussion List
-
I need a sql report to pull employees who has changes with there department on specific yearHello Experts, do you have some reports that will pull the data of an employee who has changes with their department, Much appreciate to someone will share Thanks,Joliver Caangay 31 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
How can i register for oracle support i want to get oracle weblogic patches?How can i register for oracle support i want to get oracle weblogic patches? -
Hide Reject Button only in Performance Goal Approval Workflow Email NotificationsHi, We need to populate only Approve and Request info buttons in workflow email and remove Reject button. Thanks, Chetanpuja suryanarayana 41 views 1 comment 0 points Most recent by InaNotra-Oracle Performance Management -
Need to Create a OTBI analysis for Helpdesk reporting on Agents who update the SR severitySummary:How to get the old severity and New severity values updated by a given agent in the report from Help desk subject areas. I do not see this attributes in any subj…veere 41 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
We need a query to retrieve the AR remittance batch approver's name and approval date.Hi All, We need to retrieve the batch approver name and approval date for a remittance batch. Is there an existing table, column, or query that can provide these details…nehayadav86 12 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections -
Report - send notifications to usersHi together, We have following requirement from our customer: They want to have one report, where they can check (based on security level through AOR) which notification…Katharina_Seidenfuß 11 views 0 comments 0 points Started by Katharina_Seidenfuß Reporting and Analytics for HCM -
Logic used in Long wait on Agent reportSummary: The description given for "Long wait on Agent" is as below, but I wanted to know the exact logic. Like the report will pull report if the agent havent logged in… -
can we delete a new load plan from the ODI console and synchronize BIACM with the old load plan?More Details: We are facing an issue in BIACM where the "Generate" button was clicked by mistake, causing the generation process to be stuck and showing an "in progress"… -
How can I get a list of all the resources created in the system for the helpdesk?Summary: Is there a method to get a list of all the resources? Content (please ensure you mask any confidential information): Version (include the version you are using,… -
How I can fetch licence details, which stored against employee’s job profile?if employee has multiple assignments, and I want to get licence detail of assignment then how I can fetch by using sql. I wrote the sql query to fetch all licences which… -
Are there APIs for Fusion Data Intelligence?Summary: The most frequently asked question that I face from customers is 'How do I get my data out of ADW, as I already have a data warehousing strategy?' While during …Ksimmy200 21 views 1 comment 0 points Most recent by Will Paddock -Support-Oracle Reporting & Analytics for Fusion Service -
Supported File Format for OCI Document Classification Model?Hi Everyone, I have a question, Currently OCI Document Classification model support below format for input: PDF, PNG, JPEG, TIFF If i have files in txt, word document, c… -
How to fetch the time period for fetching the salary details of the employeesSummary: I am working on a query to fetch the period name as per the payroll name selected from the LOV as parameter to fetch the salary details of the employees . I am …Tuhinaa Nanda 84 views 3 comments 0 points Most recent by Will Paddock -Support-Oracle Reporting and Analytics for HCM -
Can we display the count in the graph while creating dashboard?Hi Team, I was trying to create a dashboard so what happening is if u out the cursor in the graph the counts are coming. So is it possible to display the counts in the t…Abhisek Kanungo 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
OCI streaming - message filter & best practicesSummary: OIC streaming Use Case Implementation - Message Selection and Best Practices Content (please ensure you mask any confidential information): I am looking to impl… -
oci cli to display summarized usage and costI have been playing around with oci usage-api usage-summary request-summarized-usagescommand for quite some time to get a report of total usage of each service, unit, co… -
performance tile DescriptionSummary: When we drag the mouse above some graphs we can see the analysis name description with more information. We would like to know how can we enable this feature to… -
Oracle BIP Report Job ends in error: ORA-56733: logical I/O limit exceededWe have a customized report that when is scheduled ends in error: ORA-56733: logical I/O limit exceeded. What's weird is that when we run the report via the catalog with…User_APIIU 89 views 3 comments 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
Is it possible in one report Bursting and ad hoc running possibleIs it possible to create one report where Bursting setup will ensure that the report is distributed to the correct recipients as specified, whenever it is run on an ad h…Sangeetarani Padhi 31 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
RTF Template output alignment issue with Outlook appHi Team, We have recently created a welcome letter using an RTF template, which includes a logo at the top followed by the details in the email body. When we check the o…Rakesh Bahadur Thapa 71 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
What is the impact of not Assign Financial Categories to the Natural AccountsOne of the prerequisites for implenting a reporting tool such as OTBI and FDI , is to assign financail categories to the natural accounts. What is the impact on not doin… -
In OCI Data Flow, I cannot "Create sample application"Summary: I have followed the setup tutorial as pre-requisite. But I still see the error notification in top right Looks like something went wrong. Please make sure that … -
Reporting on Primary Contacts in OTBISummary: How can we join the CRM/Help Desk - Case Management Real Time (or Help Desk - HR Service Requests Real Time) subject area to another person based/Workforce Mana…Ben Gill 73 views 4 comments 0 points Most recent by Pallavi-Bhosale Reporting & Analytics for Fusion Service -
We need to update the #average headcount, #leavers, period start and period end headcount with OTBIWe need to Modify headcount columns in an Annual Turnover dashboard page. We need to update/review the #average headcount, #leavers, period start headcount, and period e… -
How to create custom PVO and add it in BICCSummary: How to create custom PVO and add it in BICC Content (required): How to create custom PVO and add it in BICC Version (include the version you are using, if appli…Vivek Gautam 3.5K views 7 comments 1 point Most recent by Surendra Majeti Reporting & Analytics for Fusion Service -
sql to fetch organizations or departments based on business unitHi Team, We are trying to write sql to fetch all organization or departments for a business unit. But we dont know how to link organizations to business unit. To tell yo…RamNarayan-Oracle 314 views 1 comment 0 points Most recent by IpsitaGhosh-Oracle Human Capital Management -
Service Time per Ticket - Report (Classic HR Help Desk)Hi all, We need a Report to calculate the time between the ticket's opening date and closing date and time, considering customer calendar (Considering work hours and exc… -
BIP RTF template need Freestyle Script fontHi Everyone, I have a requirement to create an PDF document with employee name like signature. (who signed electronically) We want to use different font which will look …Naveen Jayaraman 21 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
sql query to get the Legislative Info and Associated Profiles associated with job in oracle fusionI need to fetch job code, job name ,Overtime Status under Legislative Info and details of Associated Profiles associated with job in BIP reportAnjali_Kumari4121 625 views 1 comment 0 points Most recent by GowriTatikonda Reporting and Analytics for HCM -
Oracle Fusion OCI Console user login reportSummary: Oracle Fusion OCI Console user login report Content (please ensure you mask any confidential information): We have recently migrated our Oracle Fusion HCM insta…