Reporting and Analytics
Discussion List
-
HR Help Desk Infolets "My HRHD Request Work Time" and "Team HRHD Request Work Time" return no dataSummary: Hi, I have a question about HR Help Desk Infolets. "My HRHD Request Work Time" and "Team HRHD Request Work Time" return no data and I am trying to understand wh…Viktoria Priona-Oracle 18 views 1 comment 0 points Most recent by Paul Romero-Support-Oracle Reporting & Analytics for Fusion Service -
Job Offer DFF values not appearing in OTBISummary: We are trying to pull a Job Offer Descriptive Flexfields (DFFs) OTBI report for India, the values are appearing blank. Interestingly, we can see the correct val… -
Access to Fusion transactional tables (GL_JE_LINES, XLA, PJC, CMR) using Fusion Data IntelligenceHi, I need to analyze data that in Fusion transactional schema is stored in tables such as: GL_JE_LINES XLA_DISTRIBUTION_LINKS PJC_EXP_ITEMS_ALL CMR_RCV_DISTRIBUTIONS We…Camilo Reyes 6 views 0 comments 0 points Started by Camilo Reyes Reporting & Analytics for Fusion Service
-
Customizing the Bursting Query for a Seeded ReportHello, is it possible to customize the bursting query for a seeded report? Instead of the original key used in the bursting, I want to use the Customer Account as the ke… -
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/…
-
Issue Accessing Data in Custom HCM BI Report in Lower EnvironmentHi Team, We have a custom BI report in the HCM module that retrieves both Salaried and Hourly employee data. Although the required data access and roles appear to be cor…Deepak kumar Rai 2 views 0 comments 0 points Started by Deepak kumar Rai Reporting & Analytics for Fusion Service
-
Zero values in Finance GL-profitability subject area in FDIWe are getting zero values in net income column, can you please suggest if there is any data load issue in FDI? or suggested any workaround is helpful.Ravi Kumar N 3 views 0 comments 1 point Started by Ravi Kumar N Reporting & Analytics for Fusion Service
-
PVO Schedule Extract Job Completes but No Data in UCMHello Team I have added a PVO object TC PO Receipt Extract , screen prints are uploaded Job Created: TC PO Receipt Extract and submitted immediately Job completely succe…Shankar Naidu-Oracle 1 view 0 comments 0 points Started by Shankar Naidu-Oracle Receivables & Collections
-
Need to display UTR number in supplier payment page against each payment Num from cash management.After importing MT940 into oracle fusion, The UTR number populated in additional information in cash management. Now we need to display the UTR number in invoice payment…Kolikonda 31 views 4 comments 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management
-
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…Sharmava 21 views 4 comments 0 points Most recent by Neerajk Reporting & Analytics for Fusion Service
-
Is there a way to request additional indexes to Oracle Fusion seeded tables like?Hello, we have a huge custom datamodel for the invoice print receivables process. After analysing the execution plan (provided by Oracle support for the main dataset) we…Frank.Steinjan 4 views 0 comments 0 points Started by Frank.Steinjan Reporting & Analytics for Fusion Service
-
Can we give content server document URL access to BIP user without giving content server accessSummary: We are trying to build the report which will give the attachment names So we have created a URL based on content server but now content server cannot be accessi…Prajkta Hire 13 views 0 comments 0 points Started by Prajkta Hire Reporting & Analytics for Fusion Service
-
In FOM. What is the fields names on the DOO_ tables to link a service line with its parent line.I'm trying to match the Service Line with its parent Line. I've created a SQL query in FOM. In my output, the service line is not matching up with its parent line. What …
-
BI Publisher Bursting Email Sent Even When Report Has No DataHi Oracle Support, Bursting emails are being sent even when the report output is empty. How can we prevent emails from being sent when there is no data?Gulab_Ansari 22 views 1 comment 0 points Most recent by VenkatesanR-Oracle Reporting and Analytics for ERP -
Customising Sales Order Acknowledgement ReportTrying to customize Sales Order Acknowledgement Report, I have added new fields in the Data model but when I have added the new fields in Template using BI Publisher as …
-
hwm_timecard_report.timecard_totals - Specification (Oracle Fusion)An Oracle Fusion seeded report for displaying bulk timecard approvals is executing the TimecardApprovalNotificationBulkReport which displays a PDF on screen. The data mo…Scotty C 121 views 3 comments 0 points Most recent by sreenivasulu.devineni-Oracle Workforce Management
-
PO PDF Printing in Supplier Address Language Instead of EnglishThe customer needs the PO PDF to be printed in English; however, it is currently being generated in the language defined at the supplier address. eg. supplier address la…Kinjal Patel-Oracle 11 views 1 comment 2 points Most recent by Ketan Janva-Oracle Reporting & Analytics for Fusion Service
-
Need a table that stores BIP Report Email recipient listHi, Which table stores the BIP Report Email recipient list. Thanks in advance.Kinjal Patel-Oracle 12 views 1 comment 4 points Most recent by Ketan Janva-Oracle Reporting & Analytics for Fusion Service
-
Tools for generating the Income Statements and Balance Sheet “out of the box"Is there any tool provided by Oracle for generating the Income Statements and Balance Sheet “out of the box”. If FRS is going to be sunset ->is there a tool already in t…twinkle talreja 11 views 0 comments 0 points Started by twinkle talreja Reporting and Analytics for ERP
-
where is almacenes all my data generated in fusion applications?My question is, how can I access all the data generated in my Fusion applications? I want to replicate my OAC instance in Power BI. I have an ADB instance, and I've conn…Víctor Nuno 11 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
Need details on PVO: FscmTopModelAM.NoteAM.CashAdvanceApprovalNotesPVOWe would like to request additional information regarding the PVO FscmTopModelAM.NoteAM.CashAdvanceApprovalNotesPVO. Specifically, we are seeking clarity on the followin…Panchatapa_Banik 12 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
invoice_id is blank in ap_trial_balances_gt tableHello All, We have a requirement to create a custom Payables Trial Balance Report by copying and customizing the data model to add more columns from ap_invoices_all tabl…DebasmitaDas123 41 views 3 comments 0 points Most recent by User_QTV9K Payables, Payments & Cash Management
-
How to reduce Report post processing time or template processing time in oracle fusion BI Publisher?We are working on one custom report performance which is taking more time for post processing. Report XML generation takes around 40 sec time and to generate excel repor…
-
Bursting Feasibility for BIP Report having Multiple Data ModelsDear Team, We have one requirement wherein we need to enable bursting for one report having multiple data models, kindly confirm if that can be achieved. If yes, then pl…
-
BI Report Pulled Into a Dashboard Displays the Parameters in TEST Environment but not PRODIn our Production environment I pulled a report into a dashboard and I can’t view the report parameters when I open the dashboard. However, when I create this report and…Brian Burns 1 view 2 comments 0 points Most recent by Mustafa Abu Dayeh Reporting and Analytics for ERP -
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…Sridher 216 views 10 comments 0 points Most recent by Nagarjuna Nudurupati Reporting and Analytics for ERP
-
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…
-
Dashboard Prompt Not Visible to Users with Custom RoleWe have a folder named PLM Reports located under Custom Folder, which has security enabled for two roles: Custom BI Administrator – Full Control Report Enquiry Role – Re…Karthik Chedella 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Cycle count adjustmentI have to make an cycle count history report BU wise – for this I am using INV_CYCLE_COUNT_ENTRIES table, in the frontend when i am checking the data for Transaction Typ…Rajendra.12 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Performance Issue After Joining EGO_ITEM_EFF_B on the basis of CHANGE_LINE_ID. Any solutions?Hi, I’m working on a query that previously ran within seconds, but after adding the lastLEFT JOIN, the execution time has increased significantly—even for a single chang…Ramsha Zameer 13 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM