Reporting and Analytics
Discussion List
-
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 3 views 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 13 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 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 15 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 44 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 195 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…
-
How to fetch Goals Target outcomes in OTBIHi All, How to fetch Goals Target outcomes in OTBI? Thanks in advance.Robinson Ng 5 views 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 13 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 -
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 24 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 3 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 27 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…
-
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 2 views 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 32 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 63 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
-
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 2 views 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…
-
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
-
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…
-
How to review scheduled BIP jobs not yet running?I'm submitting several jobs to run at different hours and I would like to review the schedule before report are running. How can I do this? Thanks -
Query to get the prepayment Amount ValuesSummary Dear All, I am creating a BIP report, In which I need to calculate the number of employees processed in the payroll run and sum of total amount in processed in p…VaibhavChavan20_ 56 views 1 comment 0 points Most recent by VaibhavChavan20_ Reporting and Analytics for HCM
-
How to get API Activity log for user accounts in oracle fusionWe would like to integrate Oracle Fusion Cloud with third-party applications and would like to know the API to get the below common ERP logs to send to Audit purpose. 1.…
-
U.S 1099 Payment ReportHi, We had requirement to add below columns to U.S 1099 Payment Report. Vendor Type of TIN ( E/S) Vendor Recipient Address 1 Vendor Recipient Address 2 Vendor Recipient …Ismail Sherief 1 view 0 comments 0 points Started by Ismail Sherief Payables, Payments & Cash Management