Reporting and Analytics
Discussion List
-
Not able to print parameter values in BIP report, using if condition in Excel rtf templateUsing if condition in excel template had validated values if parameter is null , should return all as values selected is ALL, see below All But when i am populating spec…Shahid Qureshi 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Oracle Reporting & Analytics for Fusion Service -
Need PVO's for below Tables for BICC ExtractSummary: Need PVO's for below mentioned tables for BICC Extract: 1) gl_coa_tree_versions_aggr_dtls 2) hr_operating_units 3) gl_seg_val_hier_rfNiharika Paramkusam-Oracle 11 views 1 comment 0 points Most recent by Radhika Abhyankar-Oracle Reporting & Analytics for Fusion Service -
Need Information on Fusion tables related to REST APISummary: Would like to know which fusion tables are used to pull data for REST API /fscmRestApi/resources/11.13.18.05/projectPlanDetails. Content (please ensure you mask…Prashant L 11 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to download .PDF attachment from Contract through BIP report in fusionDears, We have a requirement to download .pdf attachment from contract. How we can download the above attachment (24000065-1 (1)نسخة التوقيع.pdf) from BI report. Thanks,…
-
Oracle Fusion Expense Report Attachment in a ReportIs it possible to provide link or access to the attachment uploaded to Expense Report within a BIP or OTBI report?
-
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. 34 views 3 comments 1 point Most recent by Kishore Padala-Support-Oracle Applications Security
-
Portuguese language conversionHi, We have a requirement to convert Receipt amount in words to PORTUGUESE language. How can we achieve this? Is there any possible way in BIP or rtf template? Regards, …Anusha DP 21 views 1 comment 0 points Most recent by Radhika Abhyankar-Oracle Reporting & Analytics for Fusion Service
-
Can we build a BIP report for the child processesCan we build a BIP report for the child processes that are run after after load interface file for import.Shalini S 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Oracle Reporting & Analytics for Fusion Service
-
Which table stores the below candidate profile email options.Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Aishwarya Somvanshi 11 views 2 comments 0 points Most recent by Aishwarya Somvanshi Reporting and Analytics for HCM
-
Fusion OTBI Subject Receiving - Purchase Receipts Real Time No ResultsSummary: Fusion OTBI Subject Receiving - Purchase Receipts Real Time No Results The specified criteria didn't result in any data. Content (please ensure you mask any con…Ploy 11 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting and Analytics for SCM
-
How to Link a Column in OTBI to a Parameter Based on Conditions?Hello, I am working on a report in Oracle Transactional Business Intelligence (OTBI) and I need some help with linking a column to a parameter based on conditions. Speci…Omran Zeaiter 22 views 6 comments 0 points Most recent by Omran Zeaiter Reporting and Analytics for ERP
-
Fusion Analytics warehouseWe have a requirement to get the count of employees Saudization wise. it means, if the employees Nationality is Saudi Arabia then employee comes under Saudi else other. …Nalsoft Pvt Ltd 11 views 2 comments 0 points Most recent by Radhika Abhyankar-Oracle Reporting & Analytics for Fusion Service
-
Is there any drop down option to have FRS reportBusiness is expecting to have FRS for Balance sheet. So expectation is to restrict the balance sheet values only to only Intercompany segment (Member) or Sub Account seg…Hemanth Buccapatnam Tirumala 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
How to add a VB script to Oracle FRS reportNeed to add a VB script to Oracle FRS report to enable a macro step after downloading the excel output.Fredrick Ignatius 13 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
What is the PVO for Currency and FND Valuesets in BICC?Need PVO details to create BICC extracts for below objects. • Fnd Value sets: We need to list the unique segment values for Chart of Accounts. Those are stored in value …Sreeram Tadepalli 21 views 2 comments 0 points Most recent by Sreeram Tadepalli General Ledger & Intercompany
-
How to get Risk Code value in BIP Custom ReportSummary: We are developing a customer report and we need a column called Risk Score. The value we may need is similar to this 'Any value between 1 – 69 is high risk and …Dhanusia 1 view 1 comment 0 points Most recent by Augustin Aravind-Oracle Reporting and Analytics for ERP
-
Different Child Data Set fields are not coming in Interactive format of BIP Report.I have modified the Data model of Compensation Report to increase the report performance in Oracle HCM Cloud (Fusion) After making different data sets, linking by parent…Bindu Janoti-Oracle 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Employee Contract Extended data filter needed in OTBI ReportHi Team, I have a requirement to extract employees whose contracts are going to end in the next 60 days. For this, I have added the filter below, and it is working as ex…Viswarupachari 13 views 1 comment 0 points Most recent by Srilatha S-Oracle Reporting and Analytics for HCM
-
Hide Catalog menu item in Catalog BarBusiness users need to be restricted to access to entire catalog while executing reports. We have given page entries for reports to execute. So we thought to hide the me…SurendraPB 11 views 2 comments 0 points Most recent by Radhika Abhyankar-Oracle Reporting & Analytics for Fusion Service
-
Fast Formula of Type HCM Data Loader does not loop to LINEREPEATNO = 2Summary: Hi Intelligentsia, With reference to development of Fast Formula of type HCM Data Loader i am unable to loop to LINEREPEATNO 2 or the else part after LINEREPEAT…Abdulrahman2k 21 views 1 comment 0 points Most recent by Raghavendra M Payroll and Global Payroll Interface (GPI)
-
How we can invoke multiple templates/Grids in FRS reporting based on the input parameters ?how we can invoke multiple templates in FRS reporting based on the input parameters. Unfortunately, we have not found any functionality to invoke multiple templates like…Vikas Prajapati 21 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to add Header and footer in Each group of E-text Template ?I have e-text fixed base position template in which I want to add header and footer in each group of template. I made variable in SQL query but my requirement is not ful…Malik_Umer 12 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting & Analytics for Fusion Service
-
Payment Approval HistorySummary: We need the payment approval history data to capture the approvers at template level Content (please ensure you mask any confidential information): Hello Team -…Samarpit 32 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting and Analytics for ERP
-
Helpdesk Requests that have Journeys assigned to them on an OTBI**This post was created as part of a How to Service Request (SR) Release: [Version] 11.13.24.04.0 Summary of the question: Can we identify Helpdesk Requests that have Jo…Bodhisattwa Mukherjee-Oracle 1 view 2 comments 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting & Analytics for Fusion Service
-
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 21 views 0 comments 0 points Started by Surya Chandaka Reporting and Analytics for ERP
-
Join for sales order tables and Transfer order tables to bring transfer priceSummary: Hi All, I am trying to bring the Transfer Price of Sales orders of type Transfer orders. Please let me know the joins for Sales order tables and Transfer order …
-
Is there a simple way to create a report based on Service request, Work Order and Debrief?we are working to create a report that will include information from the Service request and all the work that was done by the engineer. the entity structure we need (or…Boaz Hayon-Oracle 1 view 3 comments 0 points Most recent by Radhika Abhyankar-Oracle Reporting & Analytics for Fusion Service -
Can Custom PVO be created on any Table or Query for BICC?Summary: Can Custom PVO be created on any Table or Query for BICC? Content (please ensure you mask any confidential information): If seeded PVOs are not matching to our …Sreeram Tadepalli 21 views 1 comment 0 points Most recent by Radhika Abhyankar-Oracle Reporting & Analytics for Fusion Service
-
Error while promoting SME on FAWHi all, I'm facing an issue while trying to promote SME from my DEV FAW instance to me PROD instance… FYI : I've completed the latest upgrades of both instances (same la…Lauriane Massin Whitaker 11 views 1 comment 0 points Most recent by Radhika Abhyankar-Oracle Reporting and Analytics for HCM
-
What are the PVO's for IBY Tables for BICC ExtractCan someone please help me with PVO's that can be used for below tables for pulling data through BICC Extract. Tables : gl_coa_tree_versions_aggr_dtls, IBY_EXT_PARTY_PMT…Niharika Paramkusam-Oracle 21 views 3 comments 0 points Most recent by Radhika Abhyankar-Oracle Performance Management