Analytics
Discussion List
-
How to call a query or data of one particular data model to another data model.We have a requirement to get gross salary details in many BI Reports. We need to know that is there any feasibility to call one data model related data in another data m…Nalsoft Pvt Ltd 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How to Resync Arabic Hijrah Calendar in Oracle FusionWe are experiencing discrepancies in the dates within Oracle Fusion, specifically with the 'Arabic Hijrah calendar'. leading to issues with reports using Hijri Date. The…KirolosMagdy 121 views 2 comments 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How do i create custom infolets and add to the Redwood HR Help Desk Dashboard PageSummary: we would like to create our own infolets to display on this page but cant figure out how to do that .. we would also like to remove these delivered infolets Con… -
jl_br_ar_collection_docs is empty in oracle cloudThe Table jl_br_ar_collection_docs is empty in oracle cloud. Does anyone know how this table gets populated? This table is being used for Brazil Boleto report which can … -
Hi, Can somebody assist how to join external data source into subject area in Oracle Analytics CloudHi, Can somebody assist how to connect to external data source into subject area in Oracle Analytics Cloud - FDI?Priya Parthiban 21 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Getting the data in un-structured formate in excel file while extracting the dataSummary: Hi Team, We are trying to export the data for IBY_SYS_PMT_PROFILES_VL in excel format and we are getting in un-structured formate. Means some rows data are not … -
How to burst BI Publisher reports that use PL/SQL Procedure call?I've used the following PL/SQL code: DECLARE TYPE REFCURSOR IS REF CURSOR; XDO_CURSOR REFCURSOR; L_DATA_CLOB CLOB; BEGIN L_DATA_CLOB := L_DATA_CLOB ||'' ||'SUCCESS' ||''…Isaac_s 91 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle BI Publisher Learning Center -
OCI's Performance Hub causes authorization errors.I enabled database management (basic management) for BaseDB in OCI using the DBSNMP user and checked the performance hub and got an error that I need to grant the approp… -
how to link Absences table with work force scheduling table in oracle fusionI am looking for a query which list employee work schedule including leaves. Any suggestion on how to join absences module with work force module tables -
New update multi-language for some table in oracle fusion in Jan 2025Hi Everyone, I noticed that some data tables have been updated with additional languages since Jan 14th 2025 in Oracle Application Cloud. Could you provide information a… -
Customize Career Development Report not workingGreetings team! The customize feature in BI Publisher for the 'Career Development Report', that is available in the Oracle HCM Cloud application in Person Spotlight > Ca… -
PER_ROLES_DN_VL table showing Duty Roles N or Null valuesHi Team, Greetings! We have encountered an issue while querying the PER_ROLES_DN_VL table for values in the DUTY_ROLE field. The table is only showing 'N' or NULL values…Bhuvaneswari Konduri-Oracle 97 views 0 comments 0 points Started by Bhuvaneswari Konduri-Oracle Reporting and Analytics for HCM -
How does my Data Analyst run case mgmt/HRHD reports?Summary: I'm having a hard time having my Data Analyst pull data from case management and help desk. The service catalog doesn't even appear for him. He has both Case Ma… -
NEW EPBCS Instance CreationPlease let me know how much time it will take for Oracle to make new EPBCS instance online. Also is there a way to expediate this? -
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 42 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 11 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 83 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…