Category 385
Discussion List
- 
             Prebuilt Fusion Service Analytics report list - ClaritySummary: Hoping the community are able to provide some clarity around the prebuilt reporting delivered for NextGen HR Help Desk and Case Management. I've reviewed the Pr…Simon Kaplun 21 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service Prebuilt Fusion Service Analytics report list - ClaritySummary: Hoping the community are able to provide some clarity around the prebuilt reporting delivered for NextGen HR Help Desk and Case Management. I've reviewed the Pr…Simon Kaplun 21 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
- 
             Grand Total FormatingHi. I added a Grand Total row to my report, but the values are not formated. I thought it would make perfect sense for the grand total to follow the format of the column…Vitor Nakamura 51 views 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Sales Grand Total FormatingHi. I added a Grand Total row to my report, but the values are not formated. I thought it would make perfect sense for the grand total to follow the format of the column…Vitor Nakamura 51 views 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Sales
- 
             function to return fast formula return variabledo we have any function / package in hcm that we can use in BI query to retrieve the return values from a Fast Formula. Like we have one for value sets (pay_ff_functions…Parul_prabhat 12 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM function to return fast formula return variabledo we have any function / package in hcm that we can use in BI query to retrieve the return values from a Fast Formula. Like we have one for value sets (pay_ff_functions…Parul_prabhat 12 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
- 
             Looking for linkage details for some of the Fusion HCM PVOsBelow is the list of PVOs which are missing in Rel13_24C_BICC_HCM_Database_Mapping_with_ViewObjects. If anyone happen to have these details please share. Hcmtopmodelanal…Vineeta Agarwal-Oracle 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM Looking for linkage details for some of the Fusion HCM PVOsBelow is the list of PVOs which are missing in Rel13_24C_BICC_HCM_Database_Mapping_with_ViewObjects. If anyone happen to have these details please share. Hcmtopmodelanal…Vineeta Agarwal-Oracle 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
- 
             How to get what are all the Permissions assigned to the report for xdo file and xdm filesHow get what are all the Permissions assigned to the report for xdo file and xdm files through back end (sql script or rest services)UdayKuditipudi 91 views 7 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting & Analytics for Fusion Service How to get what are all the Permissions assigned to the report for xdo file and xdm filesHow get what are all the Permissions assigned to the report for xdo file and xdm files through back end (sql script or rest services)UdayKuditipudi 91 views 7 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting & Analytics for Fusion Service
- 
             Extract name field from transaction console pageTransaction table for extracting the Name field in transaction console. Please assist Extract name field from transaction console pageTransaction table for extracting the Name field in transaction console. Please assist
- 
             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 31 views 4 comments 0 points Most recent by Jagjit Singh Arora Reporting and Analytics for ERP 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 31 views 4 comments 0 points Most recent by Jagjit Singh Arora Reporting and Analytics for ERP
- 
             Extracting Booking History Details - Demand ManagementSummary: Hi All, I am trying to extract booking history details for a particular org for the last 3 years, along with the customer details. However, along with bookings …Ashish A Jha 102 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM Extracting Booking History Details - Demand ManagementSummary: Hi All, I am trying to extract booking history details for a particular org for the last 3 years, along with the customer details. However, along with bookings …Ashish A Jha 102 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
- 
             How to get overridden account attribute from AP tables?Hello, I am not able to find attribute for Overridden account in any AP tables. I am using Oracle Fusion Cloud Applications 24B (11.13.24.04.0) and the tool i am using f… How to get overridden account attribute from AP tables?Hello, I am not able to find attribute for Overridden account in any AP tables. I am using Oracle Fusion Cloud Applications 24B (11.13.24.04.0) and the tool i am using f…
- 
             HCM extract flow results in a tableHi, We are currently doing manual monitoring on schedule HCM extract runs and we are looking into creating an OTBI or BIP report in order to somehow automate this monito… HCM extract flow results in a tableHi, We are currently doing manual monitoring on schedule HCM extract runs and we are looking into creating an OTBI or BIP report in order to somehow automate this monito…
- 
             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 201 views 4 comments 0 points Most recent by Radhika Abhyankar-Support-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 201 views 4 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting and Analytics for ERP
- 
             Send Email to multiple employees based on the region they belongHi Team, We have received requirement where we need to send the email to all pending workers who are based in an office, and provides important Day 1 information. There …Vinay_Raulwar -Oracle 11 views 0 comments 0 points Started by Vinay_Raulwar -Oracle Reporting and Analytics for HCM Send Email to multiple employees based on the region they belongHi Team, We have received requirement where we need to send the email to all pending workers who are based in an office, and provides important Day 1 information. There …Vinay_Raulwar -Oracle 11 views 0 comments 0 points Started by Vinay_Raulwar -Oracle Reporting and Analytics for HCM
- 
             Create tables(DDL) from PVO metadata provided by REST APIWe are retrieving the columns details such as datatype, precision and scale using the following endpoint(REST API metadata) Url: https://{server_name}/biacm/rest/meta/da…Alex25 45 views 1 comment 0 points Most recent by Cătălin Hurjui-Support-Oracle Reporting and Analytics for SCM Create tables(DDL) from PVO metadata provided by REST APIWe are retrieving the columns details such as datatype, precision and scale using the following endpoint(REST API metadata) Url: https://{server_name}/biacm/rest/meta/da…Alex25 45 views 1 comment 0 points Most recent by Cătălin Hurjui-Support-Oracle Reporting and Analytics for SCM
- 
             Equivalent Oracle Cloud table/view for the EBS 11i entity CSI_II_RELATIONSHIPSSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CSI_II_RELATIONSHIPS? Content (required): Version (include the… Equivalent Oracle Cloud table/view for the EBS 11i entity CSI_II_RELATIONSHIPSSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CSI_II_RELATIONSHIPS? Content (required): Version (include the…
- 
             Extract data from Oracle Fusion via BI Publisher to perform calculations and then load them into EPMHello! I have some Oracle Fusion data in BI Publisher. I need to use this data as a basis for performing some calculations and then load the calculated information into …User_F8Z0S 31 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service Extract data from Oracle Fusion via BI Publisher to perform calculations and then load them into EPMHello! I have some Oracle Fusion data in BI Publisher. I need to use this data as a basis for performing some calculations and then load the calculated information into …User_F8Z0S 31 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
- 
             Chat report by Activity level by DaySummary: Is there a chat report that shows the most active time of day and can graph it for me? Content (required): Interval, month/.day/hour (not inclduing weekends) an…Marissa Gonzales 21 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service Chat report by Activity level by DaySummary: Is there a chat report that shows the most active time of day and can graph it for me? Content (required): Interval, month/.day/hour (not inclduing weekends) an…Marissa Gonzales 21 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
- 
             Truncate the Data size to avoid "ORA-12899: value too large for column" in ODISummary: We have a source a file that has more than 4000 char in one column and we trying to load data in ADW but the maximum varchar2 character limit is 4000 char only …Vivek Gautam 231 views 2 comments 1 point Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service Truncate the Data size to avoid "ORA-12899: value too large for column" in ODISummary: We have a source a file that has more than 4000 char in one column and we trying to load data in ADW but the maximum varchar2 character limit is 4000 char only …Vivek Gautam 231 views 2 comments 1 point Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
- 
             How to make wrap text in Oracle B2b service cloud to fit text in columnsSummary: Making wrap text in oracle B2B service cloud Content (required): In service request sub tab event capture, it is needed to wrap the text possible to fit the tex…ArunKumar AC 31 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service How to make wrap text in Oracle B2b service cloud to fit text in columnsSummary: Making wrap text in oracle B2B service cloud Content (required): In service request sub tab event capture, it is needed to wrap the text possible to fit the tex…ArunKumar AC 31 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
- 
             Actionable infoletSummary: Actionable infolet Content (required): Hi, Is it possible to build an actionable infolet for Service request? Version (include the version you are using, if app…User_9UU2H 21 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service Actionable infoletSummary: Actionable infolet Content (required): Hi, Is it possible to build an actionable infolet for Service request? Version (include the version you are using, if app…User_9UU2H 21 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
- 
             interactive output format query parameters are not working when new fields are addedhi all, I have a BI report which i have built with the report out put format as interactive. this report has two input query parameters. i have recently add two new attr…Akula123 21 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service interactive output format query parameters are not working when new fields are addedhi all, I have a BI report which i have built with the report out put format as interactive. this report has two input query parameters. i have recently add two new attr…Akula123 21 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
- 
             What is the impact of renaming a Fusion Analytics DataWarehouse DBaaS Database?Summary: We've deployed Fusion Analytics Warehouse as a PaaS service (Version 24.R1.P3). As part of that deployment, the DBaaS instance is created simultaneously, but we…Clay T. 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM What is the impact of renaming a Fusion Analytics DataWarehouse DBaaS Database?Summary: We've deployed Fusion Analytics Warehouse as a PaaS service (Version 24.R1.P3). As part of that deployment, the DBaaS instance is created simultaneously, but we…Clay T. 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
- 
             how to exclude our custom application data from being picked by Account Analysis Report?Recently We has implemented a custom application. Data for this custom application flows through accounting hub. The data volume is huge (millions of data each day). Whe…Sathish Ravi 31 views 2 comments 0 points Most recent by Sathish Ravi Reporting and Analytics for ERP how to exclude our custom application data from being picked by Account Analysis Report?Recently We has implemented a custom application. Data for this custom application flows through accounting hub. The data volume is huge (millions of data each day). Whe…Sathish Ravi 31 views 2 comments 0 points Most recent by Sathish Ravi Reporting and Analytics for ERP
- 
             supplier bank account change report, 'last updated by' column showing 'FUSION_APPS_PROV_PATCH_APPID'Summary: Recently Quarterly Fusion 24A patch and console conversion completed in my oracle fusion fiancials. Today Business tried to ran the custom supplier bank account… supplier bank account change report, 'last updated by' column showing 'FUSION_APPS_PROV_PATCH_APPID'Summary: Recently Quarterly Fusion 24A patch and console conversion completed in my oracle fusion fiancials. Today Business tried to ran the custom supplier bank account…
- 
             Where can i find Item Drawing Number in Oracle Fusion ERP tables ?I Am trying to search for "Drawing Number" in oracle fusion ERP tables, it might be an Attribute but I am not getting in which table I can find this attribute. Please re…Dona Sengupta 12 views 2 comments 0 points Most recent by Dona Sengupta Reporting & Analytics for Fusion Service Where can i find Item Drawing Number in Oracle Fusion ERP tables ?I Am trying to search for "Drawing Number" in oracle fusion ERP tables, it might be an Attribute but I am not getting in which table I can find this attribute. Please re…Dona Sengupta 12 views 2 comments 0 points Most recent by Dona Sengupta Reporting & Analytics for Fusion Service
- 
             View object cannot be found for HCM table PER_POSITION_EXTRA_INFO_FWe were using the oracle mapping document "Rel13_23D_BICC_HCM_Database_Mapping_with_ViewObjects.xlsx". Looking for the corresponding VO for table PER_POSITION_EXTRA_INFO…Ian Cosinas 91 views 3 comments 1 point Most recent by Chandra Chappidi Reporting and Analytics for HCM View object cannot be found for HCM table PER_POSITION_EXTRA_INFO_FWe were using the oracle mapping document "Rel13_23D_BICC_HCM_Database_Mapping_with_ViewObjects.xlsx". Looking for the corresponding VO for table PER_POSITION_EXTRA_INFO…Ian Cosinas 91 views 3 comments 1 point Most recent by Chandra Chappidi Reporting and Analytics for HCM
- 
             How do we add Tasks, Reports and Analytics Panel to the Order Management PageSummary: How do we add Tasks, Reports and Analytics Panel to the Order Management Page Content (required): Business requirement is to add tasks, reports and analytics pa…kalyan gade 111 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM How do we add Tasks, Reports and Analytics Panel to the Order Management PageSummary: How do we add Tasks, Reports and Analytics Panel to the Order Management Page Content (required): Business requirement is to add tasks, reports and analytics pa…kalyan gade 111 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
- 
             Is it possible to track BIP report logs where user has not submitted a report jobSummary: A user logs in to Report & Analytics and opens any custom BIP report to view/export output, without submitting a report job. We are looking to get table/report …Mayur_P 21 views 2 comments 0 points Most recent by Mayur_P Reporting & Analytics for Fusion Service Is it possible to track BIP report logs where user has not submitted a report jobSummary: A user logs in to Report & Analytics and opens any custom BIP report to view/export output, without submitting a report job. We are looking to get table/report …Mayur_P 21 views 2 comments 0 points Most recent by Mayur_P Reporting & Analytics for Fusion Service
- 
             Contract duration is displaying no data on FAWHi, I've been trying to create a simple report to show the contract duration of the new hires in a company for a specific month. My reports should look like that where T…Lauriane Massin Whitaker 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM Contract duration is displaying no data on FAWHi, I've been trying to create a simple report to show the contract duration of the new hires in a company for a specific month. My reports should look like that where T…Lauriane Massin Whitaker 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
- 
             Not able to find Name Field in the subject area OTBIHello Experts, Please help, where can I find the Name Field, I am currently using Human Capital Management - Transaction Administration Real Time, should I need to use a…Joliver Caangay 1 view 2 comments 0 points Most recent by Joliver Caangay Reporting and Analytics for HCM Not able to find Name Field in the subject area OTBIHello Experts, Please help, where can I find the Name Field, I am currently using Human Capital Management - Transaction Administration Real Time, should I need to use a…Joliver Caangay 1 view 2 comments 0 points Most recent by Joliver Caangay Reporting and Analytics for HCM