Reporting and Analytics
Discussion List
- 
             How do we track / audit of the PVO customization in BICC?How do we track / audit of the PVO customization in BICC? We have multiple teams working on creating Jobs in BICC after doing some PVO customization. It is overriding th… How do we track / audit of the PVO customization in BICC?How do we track / audit of the PVO customization in BICC? We have multiple teams working on creating Jobs in BICC after doing some PVO customization. It is overriding th…
- 
             the end date of assignment is 4712for the previous assignmentHi, Currently just Working on one requirement where i encountered a scenario is(Using Per_all_assignments_m) The person has four Assignments Active employee where the en…Kande Likhitha 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM the end date of assignment is 4712for the previous assignmentHi, Currently just Working on one requirement where i encountered a scenario is(Using Per_all_assignments_m) The person has four Assignments Active employee where the en…Kande Likhitha 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
- 
             The US Periodic Tax Filing ext- why New version does not work; Old version renamed to Obsolete work?Change title to The US Periodic Tax Filing ADP Quarterly Extract - New version does not work; Old version renamed to "Obsolete. This is a follow-up email to our conversa…Pamela Price-Oracle 31 views 3 comments 0 points Most recent by Faithe Chu-Oracle Payroll and Global Payroll Interface (GPI) The US Periodic Tax Filing ext- why New version does not work; Old version renamed to Obsolete work?Change title to The US Periodic Tax Filing ADP Quarterly Extract - New version does not work; Old version renamed to "Obsolete. This is a follow-up email to our conversa…Pamela Price-Oracle 31 views 3 comments 0 points Most recent by Faithe Chu-Oracle Payroll and Global Payroll Interface (GPI)
- 
             Roles: Missing Report and Analytics in Home > Menu after Role ChangesSummary: Hi everyone, Can anyone clarify what exact privileges are required to display the Report and Analytics function under Home > Menu? I’ve created a new role by re…Yahya Khan 41 views 2 comments 0 points Most recent by Yahya Khan Reporting & Analytics for Fusion Service Roles: Missing Report and Analytics in Home > Menu after Role ChangesSummary: Hi everyone, Can anyone clarify what exact privileges are required to display the Report and Analytics function under Home > Menu? I’ve created a new role by re…Yahya Khan 41 views 2 comments 0 points Most recent by Yahya Khan Reporting & Analytics for Fusion Service
- 
             Roles/access required to fetch the deletion group datawe are using the below query to fetch the deletion group detailsSELECT edg.DELETE_GROUP_NAME, esi.ITEM_NUMBER, iop.ORGANIZATION_codeFROM EGP_DELETE_GROUPS edg, EGP_DELET…Vagicherla Harish 1 view 1 comment 0 points Most recent by Aditi Srivastav-Oracle Inventory Management Roles/access required to fetch the deletion group datawe are using the below query to fetch the deletion group detailsSELECT edg.DELETE_GROUP_NAME, esi.ITEM_NUMBER, iop.ORGANIZATION_codeFROM EGP_DELETE_GROUPS edg, EGP_DELET…Vagicherla Harish 1 view 1 comment 0 points Most recent by Aditi Srivastav-Oracle Inventory Management
- 
             audit reportSummary: Requesting an audit report, which must contain the information listed in the attached images. It must be filtered by report name and the date the scheduled repo…ALFONSO JIMENEZ-Oracle 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service audit reportSummary: Requesting an audit report, which must contain the information listed in the attached images. It must be filtered by report name and the date the scheduled repo…ALFONSO JIMENEZ-Oracle 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
- 
             MICR line zeros showing too smallHi, We have created a cheque rtf template and to display the MICR line we have used MICRE13B font as per the bank suggested font and font size is 13. However in the MICR…Krishna Kishore 26 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service MICR line zeros showing too smallHi, We have created a cheque rtf template and to display the MICR line we have used MICRE13B font as per the bank suggested font and font size is 13. However in the MICR…Krishna Kishore 26 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
- 
             How To Remove Data Augmentation Column From Subject AreaSetup data augmentation to bring additional attributes to the subject area. Now I've deleted that data augmentation table from data augmentation screen, But still I can …Raghu_Nandan 15 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service How To Remove Data Augmentation Column From Subject AreaSetup data augmentation to bring additional attributes to the subject area. Now I've deleted that data augmentation table from data augmentation screen, But still I can …Raghu_Nandan 15 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
- 
             How to display Header and line groups in EXCEL Template, line has two groups@Kevin M-Oracle I have 3 groups in xml , G_3 is master , and G_1 & G_2 are in line. G_2 =Sheet1!$A$16:$N$16 G_1 =Sheet1!$O$16:$R$16 G_3 =Sheet1!$A$2:$R$16 While I add G_…Dineshkumar.A-Oracle 11 views 1 comment 0 points Most recent by Lori W-Support-Oracle Reporting & Analytics for Fusion Service How to display Header and line groups in EXCEL Template, line has two groups@Kevin M-Oracle I have 3 groups in xml , G_3 is master , and G_1 & G_2 are in line. G_2 =Sheet1!$A$16:$N$16 G_1 =Sheet1!$O$16:$R$16 G_3 =Sheet1!$A$2:$R$16 While I add G_…Dineshkumar.A-Oracle 11 views 1 comment 0 points Most recent by Lori W-Support-Oracle Reporting & Analytics for Fusion Service
- 
             How do we get Customer detail(Party name, Party site name) based on the business unit.How do we get Customer detail(Party name, Account Number, Party site name) based on the business unit. Basically, I want the joining for FUN_ALL_BUSINESS_UNITS_V with hz…Ritu123 51 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Receivables & Collections How do we get Customer detail(Party name, Party site name) based on the business unit.How do we get Customer detail(Party name, Account Number, Party site name) based on the business unit. Basically, I want the joining for FUN_ALL_BUSINESS_UNITS_V with hz…Ritu123 51 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Receivables & Collections
- 
             Oracle BIP Bursting to AWS S3Summary: Oracle bursting definition requires a folder specified; however, no folder exists when bursting to AWS S3 bucket. Content (required): I have a requirement to co…MD-JMS 191 views 3 comments 1 point Most recent by Ashwin GSC-Oracle Reporting & Analytics for Fusion Service Oracle BIP Bursting to AWS S3Summary: Oracle bursting definition requires a folder specified; however, no folder exists when bursting to AWS S3 bucket. Content (required): I have a requirement to co…MD-JMS 191 views 3 comments 1 point Most recent by Ashwin GSC-Oracle Reporting & Analytics for Fusion Service
- 
             Need a query to link the Import costs process id with load interface id is passed as parameterHi Team, I am working on a query which is consuming by dell Bhoomi integration platform to the status of the ESS Job. So they are passing the load_request_id (the proces… Need a query to link the Import costs process id with load interface id is passed as parameterHi Team, I am working on a query which is consuming by dell Bhoomi integration platform to the status of the ESS Job. So they are passing the load_request_id (the proces…
- 
             How to fetch Goals Target outcomes in OTBIHi All, How to fetch Goals Target outcomes in OTBI? Thanks in advance.Robinson Ng 1 view 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service How to fetch Goals Target outcomes in OTBIHi All, How to fetch Goals Target outcomes in OTBI? Thanks in advance.Robinson Ng 1 view 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
- 
             Query to get import/update customer in Oracle Fusion based on load request IDI am trying to import/update customer and wanted to get import error messages for those customer through the BI report. But getting few error messages even the customer …Zaid123 15 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service Query to get import/update customer in Oracle Fusion based on load request IDI am trying to import/update customer and wanted to get import error messages for those customer through the BI report. But getting few error messages even the customer …Zaid123 15 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
- 
             Change Order Summary Report QueryHi, Previously, there was a built-in customized report in Oracle PLM titled "Change Order Summary Report", which provided details of Change Orders along with redlining i…Ramsha Zameer 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting and Analytics for SCM Change Order Summary Report QueryHi, Previously, there was a built-in customized report in Oracle PLM titled "Change Order Summary Report", which provided details of Change Orders along with redlining i…Ramsha Zameer 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting and Analytics for SCM
- 
             How to solve this below errorI have received this error notification from oac. I am new to it and not sure where to go to check this. What I am able to understand here is that there was some failed …Neelotpal01 25 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service How to solve this below errorI have received this error notification from oac. I am new to it and not sure where to go to check this. What I am able to understand here is that there was some failed …Neelotpal01 25 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
- 
             FDI versioned dataset -- how many versions are kept in the database?In Fusion Data Intelligence Data Augmentations there is an option to select versioned dataset. Documentation states this fully extracts the object from Fusion with each …JDC 1 view 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service FDI versioned dataset -- how many versions are kept in the database?In Fusion Data Intelligence Data Augmentations there is an option to select versioned dataset. Documentation states this fully extracts the object from Fusion with each …JDC 1 view 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
- 
             How to add action link in otbi report to link it to parameterised bip report?We have requirement in which we need to add action link in the otbi column which will take us to a bip report. The bip report will have a parameter and that would be the…SHRUTI PRIYA 32 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service How to add action link in otbi report to link it to parameterised bip report?We have requirement in which we need to add action link in the otbi column which will take us to a bip report. The bip report will have a parameter and that would be the…SHRUTI PRIYA 32 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
- 
             How to generate BIP report bursting output in PDF and HTML bothThe requirement is to get the email notification through bursting BIP report as an attachment and email body both. The template of the report contains tables , company l… How to generate BIP report bursting output in PDF and HTML bothThe requirement is to get the email notification through bursting BIP report as an attachment and email body both. The template of the report contains tables , company l…
- 
             Need to find argument 56 of Account Analysis Report ESS JobI need to Submit Account Analysis Report ESS Job using SOAP, how can I find where is argument 56 value is getting fetched from? When I am entering Account filter that ti…Aditi Agrawal2650 11 views 1 comment 1 point Most recent by Aditi Agrawal2650 General Ledger & Intercompany Need to find argument 56 of Account Analysis Report ESS JobI need to Submit Account Analysis Report ESS Job using SOAP, how can I find where is argument 56 value is getting fetched from? When I am entering Account filter that ti…Aditi Agrawal2650 11 views 1 comment 1 point Most recent by Aditi Agrawal2650 General Ledger & Intercompany
- 
             BICC PVO for privileges and their link to rolesIs there a BICC PVO for privileges and their link to roles ?keshav rowjee 1 view 1 comment 0 points Most recent by Clara Azoitei-Support-Oracle Project Management BICC PVO for privileges and their link to rolesIs there a BICC PVO for privileges and their link to roles ?keshav rowjee 1 view 1 comment 0 points Most recent by Clara Azoitei-Support-Oracle Project Management
- 
             Does BI Publisher SFTP delivery connection support with Azure SFTP server ?Does BI Publisher SFTP delivery connection support with Azure SFTP server ?KabirB 31 views 3 comments 0 points Most recent by Z-Man-Oracle Reporting & Analytics for Fusion Service Does BI Publisher SFTP delivery connection support with Azure SFTP server ?Does BI Publisher SFTP delivery connection support with Azure SFTP server ?KabirB 31 views 3 comments 0 points Most recent by Z-Man-Oracle Reporting & Analytics for Fusion Service
- 
             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 61 views 8 comments 1 point Most recent by Calin Pavel Reporting & Analytics for Fusion Service 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 61 views 8 comments 1 point Most recent by Calin Pavel Reporting & Analytics for Fusion Service
- 
             Tables which stores the details of Request More Information for CandidateWould like to know which table stores the details that will be entered by the candidate when he/she is requested for More Information. The details may also include attac…Nalsoft Pvt Ltd 11 views 1 comment 0 points Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace Tables which stores the details of Request More Information for CandidateWould like to know which table stores the details that will be entered by the candidate when he/she is requested for More Information. The details may also include attac…Nalsoft Pvt Ltd 11 views 1 comment 0 points Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace
- 
             Print Receivable Transaction ESS job is going retrying status when child jobs is going into errorSummary: When we are running the ESS Job 'Print Receivables Transactions', The child jobs 'Print Receivables Transactions: Email Delivery' and 'Print Receivables Transac… Print Receivable Transaction ESS job is going retrying status when child jobs is going into errorSummary: When we are running the ESS Job 'Print Receivables Transactions', The child jobs 'Print Receivables Transactions: Email Delivery' and 'Print Receivables Transac…
- 
             Query to get supplier details along with bank details associated with that supplierSummary: Query to get supplier details along with bank details associated with that supplier Content (please ensure you mask any confidential information): Version (incl…Ritu123 1 view 1 comment 0 points Most recent by Sunil Jami-Oracle Supply Chain Planning and Collaboration Query to get supplier details along with bank details associated with that supplierSummary: Query to get supplier details along with bank details associated with that supplier Content (please ensure you mask any confidential information): Version (incl…Ritu123 1 view 1 comment 0 points Most recent by Sunil Jami-Oracle Supply Chain Planning and Collaboration
- 
             Issue with dependent parameters of report in fusion HCMHi Team, We have a requirement to create a report which would fetch the latest extract flow name w.r.t Legislative data group. Currently we have two parameters of LDG an… Issue with dependent parameters of report in fusion HCMHi Team, We have a requirement to create a report which would fetch the latest extract flow name w.r.t Legislative data group. Currently we have two parameters of LDG an…
- 
             25B REDWOOD INVENTORY MANAGEMENTIn 25B Inventory Landing Page - Reports and Analytics option is not available in REDWOOD UI but available in Classic UI.Vamshidar Talakanti 12 views 2 comments 2 points Most recent by Alex Montroy Reporting & Analytics for Fusion Service 25B REDWOOD INVENTORY MANAGEMENTIn 25B Inventory Landing Page - Reports and Analytics option is not available in REDWOOD UI but available in Classic UI.Vamshidar Talakanti 12 views 2 comments 2 points Most recent by Alex Montroy Reporting & Analytics for Fusion Service
- 
             OOTB BIP Audit Report has date filters in UTCWe are using OOTB Audit reports that log a timestamp whenever a user Open,View or Download any BIP report in the system. Customer is using them to track which users are …Anubha Vijayvergiya-Oracle 31 views 2 comments 0 points Most recent by Anubha Vijayvergiya-Oracle Reporting & Analytics for Fusion Service OOTB BIP Audit Report has date filters in UTCWe are using OOTB Audit reports that log a timestamp whenever a user Open,View or Download any BIP report in the system. Customer is using them to track which users are …Anubha Vijayvergiya-Oracle 31 views 2 comments 0 points Most recent by Anubha Vijayvergiya-Oracle Reporting & Analytics for Fusion Service
- 
             Would it possible to extend the sql quey time limit.Hi Team, There is an BIP report scheduled and it was taking more than 1800 secs to run. While it was crossing 1800secs the report is failing. Is there any way we can ext… Would it possible to extend the sql quey time limit.Hi Team, There is an BIP report scheduled and it was taking more than 1800 secs to run. While it was crossing 1800secs the report is failing. Is there any way we can ext…