Reporting and Analytics
Discussion List
-
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 7 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 12 views 1 comment 0 points Most recent by VenkatesanR-Oracle Reporting and Analytics for ERP -
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… -
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 116 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 14 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 16 views 1 comment 3 points Most recent by Ketan Janva-Oracle Reporting & Analytics for Fusion Service
-
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 12 views 0 comments 0 points Started by Viktoria Priona-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 16 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 44 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 9 views 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 206 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 22 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 15 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
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 28 views 4 comments 1 point Most recent by Diksha0912 Reporting & Analytics for Fusion Service
-
Support for bank's latest ciphers -newSummary: We received below notification from bank side for the security guidelines related to payment file transfer from Oracle fusion to bank (SFTP) We've detected that…
-
OTBI 'Can't load models - Restore your models' issueIn our TEST environment we are seeing the following issue is all users: As far as we are aware nothing has changed in the back end. We have done the following: Purged th…Mike Pee 20 views 1 comment 0 points Most recent by Paul Romero-Support-Oracle Reporting and Analytics for ERP
-
how to add the hyperlink to Dash board AnalysisWe have created an OTBI dashboard with an analysis that includes a graph based on suppliers and their purchased item categories. We need functionality that allows users …venkat chaladi 35 views 1 comment 0 points Most recent by Pratap1305-Oracle Reporting and Analytics for ERP
-
Is there a suitable replacement for PAY_ACTION_INFORMATION table for 'Employee_Rec' type rows.Hello, Could you please suggest a replacement table for PAY_ACTION_INFORMATION for action_context_type (POA) and action_information_category ('Employee_Rec'). We are fac…
-
Supplier Address –Phone/Email Audit Tables/History Data (Old Values) in Fusion stores in which tableHi Team, Could you please help me with the below? I am trying to identify which Oracle Fusion table stores the audit/history data (old values) for Supplier Phone, and Em…
-
Absence is wrongly calculating in OTBI reports when applied in advanced mode.Hi Folks, While submitting the absence in Advanced mode, the balance is calculating for whole week even if i apply for two days in a week. What might be the issue? Pleas…
-
How to extract more than 65000 records per excel sheet with BIP ReportSummary: Hi, Using Excel template, we can get output in XLS, XML and CSV formats. With XLS, if we have more that 65K records, it will create multiple sheets. With CSV, w…
-
How to implement rollup functionality in OTBI / BIP report in Oracle CX Sales Fusion?Hi everyone, I’m exploring whether Oracle OTBI (Oracle Transactional Business Intelligence) or BI Publisher can support a report layout similar to the Rollup (expand/col…Himanshu_Kumar 29 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service