Reporting and Analytics
Discussion List
-
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 25 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Need to hide a sheet when no Data Exists in Excel Mutilsheet Excel Template ReportHello I created a Data Model with multiple data sheets in Oracle Cloud BI. I have also created a multisheet Excel Template. The template is working fine but i want to hi…Bobba Anil 35 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Actually our dev leads asking for read only access to BI report on Prod instanceActually our dev leads asking for read only access to BI report on Production instance and we need to restrict them to query our salary , compensation, Performance relat…poornima_kole 26 views 2 comments 0 points Most recent by Swapnil Kashid Reporting & Analytics for Fusion Service
-
Oracle query to get values on 9 box grid for a person in HCM fusion talent review meeting reportOracle query to get values on 9 box grid for a person in HCM fusion talent review meeting reportDeepeeka Nath 43 views 4 comments 0 points Most recent by Neno Kolonich Reporting and Analytics for HCM
-
SQL Query to get the details of the Roles and its inherited rolesSummary: Hi Fellow Developers, We have a requirement to create a BIP report to fetch the details of the Roles and its inherited roles. I tried using the "ASE_ROLE_VL" bu…Dhilip Kumar P. 222 views 9 comments 1 point Most recent by Jun Ye-Support-Oracle Applications Security
-
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 0 comments 0 points Started by Abhisek Kanungo Reporting and Analytics for HCM
-
Need to schedule the ESS Job set in fusion to run on 1st business day of the month.We have a scenario where we need to run the ess job set on 1st business day of each month . is there any way apart from user schedule where we need to manually update th…
-
NOT ALL ROLES are covered in Fusion Report "User and Role Access Audit Report"Hi everyone, just a question regarding the Scheduled Process: "User and Role Access Audit Report", do you know why some roles are not included in this report? ie "Applic…Lia Naga 17 views 1 comment 0 points Most recent by Cătălin Hurjui-Support-Oracle Reporting & Analytics for Fusion Service
-
How do I join PersonAM_PersonAddressPVO with PersonPVO in BICC extracts?How do I join PersonAM_PersonAddressPVO with PersonPVO in BICC extracts? There is no column with matching values.
-
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 2.4K 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 36 views 1 comment 0 points Most recent by IpsitaGhosh-Oracle Human Capital Management
-
Report to fetch employees that have not setup goalsHi, Does anyone have below- Report to fetch employees that have not setup goals (100% weight enforcement) for the goal plan applicable for current review period.Shyam Rajbhar 12 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
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…
-
How to update the timezone in reports?Hi, I have my time zone set at the user preference level. However when I run the seeded Trial Balance Report, the time is wrong on the output (showing UTC): How to corre…OConsHD 15 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting and Analytics for ERP
-
How can we migrate BIP scheduled jobs (Definitions) from one env to another env?Hi, We are refreshing multiple lower instances for go-live, and during this process, the BIP schedule jobs are not being migrated from the source to the target instance.…Praveen_Paul_raj 49 views 4 comments 0 points Most recent by Swapnil Kashid Reporting & Analytics for Fusion Service
-
How can I grant "GL users" access to the seeded "Payables Trial Balance Report"?We have a requirement in which "GL users" can generate the seeded "Payables Trial Balance Report" on their own to expedite their tasks. How can we configure this in Orac…Arsen Guevara-CITCO 42 views 4 comments 0 points Most recent by JohnG Reporting and Analytics for ERP -
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…
-
hcm - document of records - flex fields and attachmenthcm - document of records - I NEED TO GET THIS SAME FIELDS TO BE AVAILABLE IN DOCUMENT OF RECORDS APPROVAERS AND IN EMAIL AS ATTACHMENT -
General Ledger Journal Entry Database InquiryHi Oracle Experts, I have a question regarding the General Ledger Journal Entry report. Could you please clarify if the field JRNL_Effective_Date refers to the journal c…
-
Creating a Business Unit-Specific Lead and Opportunity Dashboard in Oracle FusionHi Community, I'm working on creating a dashboard in Oracle Fusion CX Sales to provide insights into lead and opportunity performance for specific business units. My goa…User_5FJ4I 76 views 5 comments 0 points Most recent by Sheela Pai-Oracle Reporting & Analytics for Sales
-
How to know what live agents are available and online for chatSummary: We have deployed Web Chat for Service with Oracle Digital Assistant integration and different queues based on the country. We would like to know what are the li…Calin Pavel 45 views 6 comments 0 points Most recent by Corey Brew-Oracle Reporting & Analytics for Fusion Service -
REST API for FDI Fusion Data IntelligenceIs there a REST API available for FDI (aka FAW)? We have a requirement to initiate an incremental refresh of the FDI data after a specific event in an OIC orchestration.…
-
Oracle Fusion BI Publisher - Pivot table - Dynamically derive headerSummary: Hi All, We have a requirement where we have to calculate opening balance of a fund(GL_CODE_COMBINATIONS.SEGMENT6) from GL balances and pivot it to the fund name…Surya Chandaka 34 views 1 comment 0 points Most recent by Anca A-Oracle Reporting and Analytics for ERP
-
Is it possible to create a security context in oracle cloud?I want to create that combo in oracle cloud: define a role with a security context that I create and security context valueACNROMA2023 42 views 4 comments 0 points Most recent by HimanshuSetia123 Reporting & Analytics for Fusion Service
-
How to define a custom field which its LOV is dependent on another field in the formSummary: Custom field added to form should hold LOV based on a query dependent on another field in the form Content (please ensure you mask any confidential information)…Michal Shaked 97 views 3 comments 0 points Most recent by Amr Hassan Reporting & Analytics for Fusion Service
-
Archive/Unarchive permission to My folders onlySummary: BI Administrator role generally gives archive/Unarchive access to entire catalog. Here the requirement is for few users, we would need archive/Unarchive permiss…Karthik Soundarapandian1 34 views 3 comments 0 points Most recent by Karthik Soundarapandian1 Reporting & Analytics for Fusion Service
-
Help on finding out the right PVOs...Hi, I'm trying to pull HCM data through data augmentation (FDI) and I'm struggling a bit. I'm trying to have a report with all the legal employer information (name, tax …Lauriane Massin Whitaker 28 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Need to trigger Custom ESS job rather than standard ESS job for sending Dunning LettersIn the Collections menu, under the customer profile, there is an option called "Strategies." Within this, there is a "Tasks" section with options like "Soft Reminder" an…