Sample Reports
Discussion List
-
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 -
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 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
-
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 -
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
-
Hello experts, do you have the SQL query to get the list of employees and their HR representativesHello experts, Do you have the SQL query to get the list of employees and their HR representatives? Regards, Hazel
-
Foreign key Column & Foreign Table for GL_JE_ACTION_LOG table using HISTORY_IDWe are not able to find the join for GL_JE_ACTION_LOG using HISTORY_ID field. I can able to see in Oracle Docs that HISTORY_ID is the Unique Identifier assigned to user …
-
Join required between exm_expenses and pjc_exp_items_all tablesHow do I join from exm_expenses and pjc_exp_items_all tables in Fusion. Do I need to join through other tables also to get this link? Thanks Scott
-
Fetch a SQL for requisition Progress SummaryAnyone please help me to fetch a Progress Summary details in ORC.Gowri Perumal 23 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Not able to add Budget Values(amount) column in FRS Report.We have an FRS Report for Profit & Loss Account where the accounted values are reflected. We have a requirement to add Budget Values also in the FRS, but we have tried e…Jagjit Singh Arora 36 views 4 comments 0 points Most recent by Jagjit Singh Arora Reporting and Analytics for ERP
-
Oracle BIP Report Excel template output displaying Number values as TextHi, We have created the new custom BIP Report with Excel template and when we download the report output into Excel, then all Number values are displaying as text, these…Nagaraju Vandavasi 23 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Compare 2 Versions of BIP Report between 2 different instances in Oracle FusionHi All, We're exploring options to compare two versions of a BI Publisher (BIP) report, including both the data model and report definition, to identify changes between …Pooja K-Oracle 61 views 4 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting and Analytics for ERP
-
Best way to create reports from Oracle General Ledger data?What's the recommended approach for building custom reports from Oracle General Ledger data.I'm building a custom periodic trial balance report in Oracle. I need to incl…Omran Zeaiter 21 views 4 comments 1 point Most recent by Jagdish Kumar Arora General Ledger & Intercompany
-
Possibility to combine multiple rows into one cell in Oracle SQL data base.Summary: I have a query regarding the possibility to combine multiple rows into one cell in Oracle SQL data base. We have tried STRING_AGG, LISTAGG and WM_CONCAT, but no…Lizy Lazaro 15 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Security and AOR Report: Inactive Assignment Locations IssueWe created a Security and AOR report that provides person roles and areas of responsibility. The expected result is when a user runs this report he should able to see al…Niranjan_1190 31 views 1 comment 0 points Most recent by Niranjan_1190 Reporting and Analytics for HCM
-
Is it possible to zip multiple template layout outputs from a single report into a single file?I'm looking to understand if there is a way to consolidate multiple template layout outputs from a single report into a single zipped file. If anyone has experience with…Omran Zeaiter 21 views 2 comments 1 point Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service
-
Iam trying to customize the existing standard Supplier Balance Aging ReportIam trying to customize the existing standard Supplier Balance Aging Report where i want to same and export sample data by inputting parameters against the same data mod…Mr.Bilal 41 views 4 comments 1 point Most recent by Balaji Badrinarayanan Reporting and Analytics for ERP
-
How to restrict Inventory Items or On hand data based on User data access role in BIP Reports?Hi All, We have a requirement to restrict the Inventory Items or On-hand data based on User data access role Org assignments through BIP Reports. Currently, we have buil…Nagaraju Vandavasi 22 views 5 comments 0 points Most recent by Nagaraju Vandavasi Reporting and Analytics for SCM
-
How to convert PERIOD NAME to Date data type?Hi I am using Between operator in Period Name and it is not working. Period Name is a Varchar type. How to convert it into Date data type so i can use between operator i…Khushi 52 views 6 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
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-Support-Oracle Reporting & Analytics for Fusion Service
-
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,…
-
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-Support-Oracle Reporting & Analytics for Fusion Service
-
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 21 views 6 comments 0 points Most recent by Omran Zeaiter Reporting and Analytics for ERP
-
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 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle 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
-
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 11 views 1 comment 0 points Most recent by Srilatha S-Oracle Reporting and Analytics for HCM
-
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 …