Reporting and Analytics
Discussion List
-
Dynamic Deep Link URL in BI Publisher Report not workingSummary: I have a RTF template that shows details of AR Invoices. I have inserted a link on Invoice Number to take the user to the transaction in the application using D…
-
ESS JOB SHWOING DIFFRENT OUTPUTHi Experts! Greetings! Recently I Came across an issue in ESS JOB FOR BIP REPORT. When I run the ESS JOB then in the attachment (pdf) one part of the report is missing ,…Mainur-Oracle 41 views 2 comments 0 points Most recent by Crescentia David Reporting & Analytics for Fusion Service
-
Unable to see the DFF attribute which are based on Table type value set in the OTBI subject areaHi All, We have created a few custom DFF attributes under Manage Customer Account Descriptive Flexfields. Few are based on independent value sets, and few use table-type…Gurujothi D 172 views 10 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
How to schedule an OTBI report using agent with effective date prompt?I have OTBI analysis where I have added 'Effective date' prompt. I want to schedule this analysis via agent. However, wants to select date in prompt under 'condition' se…
-
Customization of Standard Trial Balance Reportwe have a requirement to create custom trial balance report using customize option from the standard Trial Balance report. The same time we want to keep both the reports…
-
Payables to General Ledger reconciliation report runs by business unit not legal entity instead?The Payables to General Ledger reconciliation report runs by business unit. Is there any possibility to run it by legal entity instead? There was a requirement to reconc…Pandeyujjwal007 11 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Timecard not populating to HXT_TM_MTRX table .When we are submitting Time card through Redwood page one of the attribute value of timecard not populating to HXT_TM_MTRX table . Still, we are getting data once creati…Mazumder Sourav-Oracle 83 views 4 comments 1 point Most recent by David Boudreau Workforce Management
-
How to display date in the format (like April 1st 2025) using RTF tags.The requirement is to display the date like April 1st, 2025 in the RTF Template using RTF Tags.Nalsoft Pvt Ltd 22 views 3 comments 0 points Most recent by Hari Haran Reporting & Analytics for Fusion Service
-
While selecting parameters for custom ess job I am getting error.Hi Team, One of our client wanted to make a parameter mandatory while submitting Create Electronic Payment files ess job, which is seeded ESS job. We have duplicated the…Syamakalla_Venugopal 62 views 5 comments 0 points Most recent by Sudheer P Payables, Payments & Cash Management
-
How to disable Approve Reject from workflow bell icon notification?Proposed Email template & resignation approval process to People Leader: 1. We are requesting to remove the ‘Approve or Reject’ button from the current resignation email…Nagendra Chitra-Oracle 917 views 22 comments 0 points Most recent by Rabia Hasan Human Capital Management
-
Extract journal with debit and credit in the same lineSummary:Extract journal with debit and credit in the same line Content (please ensure you mask any confidential information): The client requested the extraction of acco…User_Q4SYX 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
I am trying to populate latest date record to be printed for BPA from PO tables in a custom BIPPer the business requirement, we need to print COO from BPA attached to the shipment, if the shipment lines having country of origin code is NULL, and since there maybe …Shahid Qureshi 01 1 view 0 comments 0 points Started by Shahid Qureshi 01 BI Publisher Learning Center
-
Getting the the error when executing the ess job ?####[2023-10-26T09:15:36.294+00:00] [INFO] dummy file is deleted ================ BIPJobExecutable Execution Started ============ OutputFile : /u01/APPLTOP/instance/ess/…
-
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…
-
In case of SCFO context in AR invoice, how to get fullfillment line id?In oracle fusion, I want an sql query to find fullfillment line id in case of Supply Chain Financial Orchestration (SCFO). For DOO we are getting this from interface_lin…
-
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)
-
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 43 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
-
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 21 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 11 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 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 46 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
-
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
-
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 17 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 21 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service