Category 385
Discussion List
- 
             Assistance Required for Locating Tables and Differentiating Login MethodsWe are currently facing an issue where we are unable to locate the tables containing the following user details within our Oracle database: We could Identify some tables…Akhilesh_07 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service Assistance Required for Locating Tables and Differentiating Login MethodsWe are currently facing an issue where we are unable to locate the tables containing the following user details within our Oracle database: We could Identify some tables…Akhilesh_07 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
- 
             Assistance Required for Locating Tables and Differentiating Login MethodsI am currently facing an issue where I am unable to locate the tables containing the following user details within our Oracle database: I could Identify some tables that…Manan Khare 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service Assistance Required for Locating Tables and Differentiating Login MethodsI am currently facing an issue where I am unable to locate the tables containing the following user details within our Oracle database: I could Identify some tables that…Manan Khare 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
- 
             Inquiring about business object in audit reportSummary: Hi team, Please help us with the following questions: 1. What kind of log will appear when Business object type is not selected and is blank? 2. Are there any b…Zafar Ara Nawreen 21 views 6 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM Inquiring about business object in audit reportSummary: Hi team, Please help us with the following questions: 1. What kind of log will appear when Business object type is not selected and is blank? 2. Are there any b…Zafar Ara Nawreen 21 views 6 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
- 
             How to fetch audit logs for custom reports in analyticsHi All, Can we generate audit logs for the custom reports which are created in reports and analytics. Like, can we get the data of a custom report which we have created,…Nalsoft Pvt Ltd 21 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting & Analytics for Fusion Service How to fetch audit logs for custom reports in analyticsHi All, Can we generate audit logs for the custom reports which are created in reports and analytics. Like, can we get the data of a custom report which we have created,…Nalsoft Pvt Ltd 21 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting & Analytics for Fusion Service
- 
             How to Customize the Asset Register Report to remove special characters from asset descriptionI have to update the Data model query for Asset Register Report as the report is reading the special characters in asset description and resulting in distorted format of…Shikha_Singh12 31 views 5 comments 0 points Most recent by Shikha_Singh12 Reporting & Analytics for Fusion Service How to Customize the Asset Register Report to remove special characters from asset descriptionI have to update the Data model query for Asset Register Report as the report is reading the special characters in asset description and resulting in distorted format of…Shikha_Singh12 31 views 5 comments 0 points Most recent by Shikha_Singh12 Reporting & Analytics for Fusion Service
- 
             I need Time Elapsed from Report run History in Fusion HCMI ran the report in Fusion HCM I need to know how much time taken to complete the report Is there any way to know how any records in report out putRama Krishna Annam 11 views 2 comments 0 points Most recent by Rama Krishna Annam Reporting & Analytics for Fusion Service I need Time Elapsed from Report run History in Fusion HCMI ran the report in Fusion HCM I need to know how much time taken to complete the report Is there any way to know how any records in report out putRama Krishna Annam 11 views 2 comments 0 points Most recent by Rama Krishna Annam Reporting & Analytics for Fusion Service
- 
             how to restrict PII data in OTBI reportsHello, I am creating a report in OTBI and I am using these subject areas "Workforce Management - Person Real Time" and "Workforce Learning - Learning Records Real Time",…Joliver Caangay 11 views 1 comment 0 points Most recent by RajuT Reporting & Analytics for Fusion Service how to restrict PII data in OTBI reportsHello, I am creating a report in OTBI and I am using these subject areas "Workforce Management - Person Real Time" and "Workforce Learning - Learning Records Real Time",…Joliver Caangay 11 views 1 comment 0 points Most recent by RajuT Reporting & Analytics for Fusion Service
- 
             Chart not showing in bursting email in fusionDear Team, I have developed one report where we are showing chart in the output. Same output we are sending over the email through bursting query and the output is comin… Chart not showing in bursting email in fusionDear Team, I have developed one report where we are showing chart in the output. Same output we are sending over the email through bursting query and the output is comin…
- 
             data is not populating in fusion.ess_request_history if we run the BIP report manuallydata is populating in fusion.ess_request_history for only scheduled reports data is not populating in fusion.ess_request_history if we run the BIP report manually Step1)…Rama Krishna Annam 41 views 5 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service data is not populating in fusion.ess_request_history if we run the BIP report manuallydata is populating in fusion.ess_request_history for only scheduled reports data is not populating in fusion.ess_request_history if we run the BIP report manually Step1)…Rama Krishna Annam 41 views 5 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
- 
             Print to IPP printer using ExternalReportWSSServiceI am trying to print a pdf report using ExternalReportWSSService web service. The printer is configured correctly and I am able to print from BIP console, when using web… Print to IPP printer using ExternalReportWSSServiceI am trying to print a pdf report using ExternalReportWSSService web service. The printer is configured correctly and I am able to print from BIP console, when using web…
- 
             A seeded report has changed after Fusion update - Can we access it again?We had a recent update 23C and the report 'Inventory Valuation Report' has now disappeared and a new report 'Depreciated Inventory Valuation Report' has appeared. Howeve…Jim Jam101 11 views 2 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service A seeded report has changed after Fusion update - Can we access it again?We had a recent update 23C and the report 'Inventory Valuation Report' has now disappeared and a new report 'Depreciated Inventory Valuation Report' has appeared. Howeve…Jim Jam101 11 views 2 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
- 
             Using SOAP Web Services to Automate the Promotion of BIP and OTBI ReportsSummary: We are in the process of migrating to Oracle ERP cloud and need to determine a process/tool to automate and provide version control around BIP and OTBI report m…MD-JMS 62 views 2 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service Using SOAP Web Services to Automate the Promotion of BIP and OTBI ReportsSummary: We are in the process of migrating to Oracle ERP cloud and need to determine a process/tool to automate and provide version control around BIP and OTBI report m…MD-JMS 62 views 2 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
- 
             Can I dynamically mention the columns in PIVOT clause in a SQL query?This query is to be used in a BIP report. For Example: SELECT MONTH, AMOUNT, COLUMN_NAME FROM TABLE PIVOT(SUM(AMOUNT) FORM COLUMN_NAME IN ('COL_NAME1','COL_NAME2','COL_N…Aaron Paul 5 views 2 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service Can I dynamically mention the columns in PIVOT clause in a SQL query?This query is to be used in a BIP report. For Example: SELECT MONTH, AMOUNT, COLUMN_NAME FROM TABLE PIVOT(SUM(AMOUNT) FORM COLUMN_NAME IN ('COL_NAME1','COL_NAME2','COL_N…Aaron Paul 5 views 2 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
- 
             Audit Reports Through REST APISummary: Where is possible to find list of business objects type for CRM. Content (required): Hi, I'm trying to generate Audit Reports trough REST API. The purpose it's …Mariachiara 172 views 3 comments 1 point Most recent by Prasanth Senthivel-Oracle Reporting & Analytics for Fusion Service Audit Reports Through REST APISummary: Where is possible to find list of business objects type for CRM. Content (required): Hi, I'm trying to generate Audit Reports trough REST API. The purpose it's …Mariachiara 172 views 3 comments 1 point Most recent by Prasanth Senthivel-Oracle Reporting & Analytics for Fusion Service
- 
             Report who all are using Fusion Cloud applicationsSummary: Report who all are using Fusion Cloud applications Content (please ensure you mask any confidential information): Version (include the version you are using, if…SathishVellampalli 1 view 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting & Analytics for Fusion Service Report who all are using Fusion Cloud applicationsSummary: Report who all are using Fusion Cloud applications Content (please ensure you mask any confidential information): Version (include the version you are using, if…SathishVellampalli 1 view 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting & Analytics for Fusion Service
- 
             Separate heading for two grids in FRS reportWe have two grids in FRS report, is it possible to have separate Header for two grids?Hemanth Buccapatnam Tirumala 11 views 3 comments 0 points Most recent by Komala Reddy-Oracle Reporting & Analytics for Fusion Service Separate heading for two grids in FRS reportWe have two grids in FRS report, is it possible to have separate Header for two grids?Hemanth Buccapatnam Tirumala 11 views 3 comments 0 points Most recent by Komala Reddy-Oracle Reporting & Analytics for Fusion Service
- 
             How to display the latest add/new columns at last in BICC via UCM extractHi All, When we added new column in datastore(PVO) of BICC , while extraction of data via ucm we see the new column is not displaying towards last of extract. As per my …User_2025-03-07-19-58-28-256 56 views 2 comments 0 points Most recent by Akash.Gupta Reporting & Analytics for Fusion Service How to display the latest add/new columns at last in BICC via UCM extractHi All, When we added new column in datastore(PVO) of BICC , while extraction of data via ucm we see the new column is not displaying towards last of extract. As per my …User_2025-03-07-19-58-28-256 56 views 2 comments 0 points Most recent by Akash.Gupta Reporting & Analytics for Fusion Service
- 
             Table to fetch HCM Extract name and delivery optionsHi Team, Please let us know the tables required to fetch submitted extracts and its status in fusion HCM. Thanks, Jahanavijahanavi metta 157 views 1 comment 0 points Most recent by Abdulrahman2k Reporting & Analytics for Fusion Service Table to fetch HCM Extract name and delivery optionsHi Team, Please let us know the tables required to fetch submitted extracts and its status in fusion HCM. Thanks, Jahanavijahanavi metta 157 views 1 comment 0 points Most recent by Abdulrahman2k Reporting & Analytics for Fusion Service
- 
             Unable to find table name for files uploaded on content server by partnerSummary: My objective is to find Content_id of the file uploaded to content server, i have my vendor uploading text documents on my content server and the external user/…Abdulrahman2k 1 view 1 comment 0 points Most recent by Abdulrahman2k Reporting & Analytics for Fusion Service Unable to find table name for files uploaded on content server by partnerSummary: My objective is to find Content_id of the file uploaded to content server, i have my vendor uploading text documents on my content server and the external user/…Abdulrahman2k 1 view 1 comment 0 points Most recent by Abdulrahman2k Reporting & Analytics for Fusion Service
- 
             Is the Standard AR Aging Report working after 24B Patch Upgrade?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…Nehsingh 21 views 2 comments 0 points Most recent by Ankita Ankita-Oracle Reporting & Analytics for Fusion Service Is the Standard AR Aging Report working after 24B Patch Upgrade?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…Nehsingh 21 views 2 comments 0 points Most recent by Ankita Ankita-Oracle Reporting & Analytics for Fusion Service
- 
             Is any possibility to Fetch Report Last run details ( BIP or OTBI reports)?Is any possibility to Fetch Report Last run details ( BIP or OTBI reports) Can anyone tell me that is oracle capturing the information for the Reports (BIP or OTBI) last…User_7A1QO 18 views 2 comments 0 points Most recent by Amol Patil HCM-Oracle Reporting & Analytics for Fusion Service Is any possibility to Fetch Report Last run details ( BIP or OTBI reports)?Is any possibility to Fetch Report Last run details ( BIP or OTBI reports) Can anyone tell me that is oracle capturing the information for the Reports (BIP or OTBI) last…User_7A1QO 18 views 2 comments 0 points Most recent by Amol Patil HCM-Oracle Reporting & Analytics for Fusion Service
- 
             Can I get a report with a full list of ERP Roles that displays the access to Create FBDI Journals?For Audit controls creation of FBDI report and then ensure all the roles from that reports are reviewed.Jaya Syamala 21 views 2 comments 0 points Most recent by Jaya Syamala Reporting & Analytics for Fusion Service Can I get a report with a full list of ERP Roles that displays the access to Create FBDI Journals?For Audit controls creation of FBDI report and then ensure all the roles from that reports are reviewed.Jaya Syamala 21 views 2 comments 0 points Most recent by Jaya Syamala Reporting & Analytics for Fusion Service
- 
             Inconsistent report bahavior with error ORA-56733: logical I/O limit exceeded - call abortedHello, We have a BIP report which is a customized version of the Account Analysis report. In this report, we have added sub-queries to have the reconiciliation details i…Kristelle 246 views 5 comments 2 points Most recent by Abhilash K - Deloitte USI Reporting & Analytics for Fusion Service Inconsistent report bahavior with error ORA-56733: logical I/O limit exceeded - call abortedHello, We have a BIP report which is a customized version of the Account Analysis report. In this report, we have added sub-queries to have the reconiciliation details i…Kristelle 246 views 5 comments 2 points Most recent by Abhilash K - Deloitte USI Reporting & Analytics for Fusion Service
- 
             How to retrieve data from xml file which is loaded as data source in data model in oracle fusionI have a requirement where report will have 2 data set.One data set will have xml file as data source and other data set will have sql query as data source.How to retrie…Suchita Chordiya 21 views 2 comments 0 points Most recent by Suchita Chordiya Reporting & Analytics for Fusion Service How to retrieve data from xml file which is loaded as data source in data model in oracle fusionI have a requirement where report will have 2 data set.One data set will have xml file as data source and other data set will have sql query as data source.How to retrie…Suchita Chordiya 21 views 2 comments 0 points Most recent by Suchita Chordiya Reporting & Analytics for Fusion Service
- 
             Using BIP uploading the files to UCM serverHi using this document i was trying to upload the files to content server. Job is sucessfull and i got the content ID but unable to seach back the files which got upload…Shanmukhi 54 views 2 comments 0 points Most recent by Abdulrahman2k Reporting & Analytics for Fusion Service Using BIP uploading the files to UCM serverHi using this document i was trying to upload the files to content server. Job is sucessfull and i got the content ID but unable to seach back the files which got upload…Shanmukhi 54 views 2 comments 0 points Most recent by Abdulrahman2k Reporting & Analytics for Fusion Service
- 
             What would the formula to convert decimal to hours be?We're creating a new infolet in OTBI for users to see their flexi balance, however it currently displays the balance in decimal (e.g. 30.8, 1.2, etc.) when we need it to… What would the formula to convert decimal to hours be?We're creating a new infolet in OTBI for users to see their flexi balance, however it currently displays the balance in decimal (e.g. 30.8, 1.2, etc.) when we need it to…
- 
             Unable to see secondary ledger in FRS list of valuesWe have secondary ledger for Germany and Luxembourg, but the same are not available while selecting ledgers in FRS report.Hemanth Buccapatnam Tirumala 11 views 3 comments 1 point Most recent by Chiranjeevi Reddy Reporting & Analytics for Fusion Service Unable to see secondary ledger in FRS list of valuesWe have secondary ledger for Germany and Luxembourg, but the same are not available while selecting ledgers in FRS report.Hemanth Buccapatnam Tirumala 11 views 3 comments 1 point Most recent by Chiranjeevi Reddy Reporting & Analytics for Fusion Service
- 
             Unable to get WCC server[servername] SecurityGroups DetailsThere is an existing scheduled report job that uploads the csv report to CS. When I check it gets the error "Unable to get WCC server[servername] SecurityGroups Details"…ChrisSSS 52 views 1 comment 0 points Most recent by ChrisSSS Reporting & Analytics for Fusion Service Unable to get WCC server[servername] SecurityGroups DetailsThere is an existing scheduled report job that uploads the csv report to CS. When I check it gets the error "Unable to get WCC server[servername] SecurityGroups Details"…ChrisSSS 52 views 1 comment 0 points Most recent by ChrisSSS Reporting & Analytics for Fusion Service
- 
             what Database table stores the Role Category informationSummary: need to fetch data describing that which user has what roles and its categories. we have used below tables for our custom query per_user_roles per_users , per_r…Mateen Khan 854 views 4 comments 0 points Most recent by UdayrajSingh Reporting & Analytics for Fusion Service what Database table stores the Role Category informationSummary: need to fetch data describing that which user has what roles and its categories. we have used below tables for our custom query per_user_roles per_users , per_r…Mateen Khan 854 views 4 comments 0 points Most recent by UdayrajSingh Reporting & Analytics for Fusion Service
- 
             customize expense approval notificationHello, I am trying to add a couple of fairly trivial extra fields to the expense approval notification report, but find that the advice in the documentation does not wor… customize expense approval notificationHello, I am trying to add a couple of fairly trivial extra fields to the expense approval notification report, but find that the advice in the documentation does not wor…