Reporting and Analytics
Discussion List
-
Unable to find table name for files uploaded on content server by partnerSummary: My objective is to find Content_id of the file uploaded to content server, i have my vendor uploading text documents on my content server and the external user/…Abdulrahman2k 1 view 1 comment 0 points Most recent by Abdulrahman2k Reporting & Analytics for Fusion Service -
Is the Standard AR Aging Report working after 24B Patch Upgrade?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nehsingh 22 views 2 comments 0 points Most recent by Ankita Ankita-Oracle Reporting & Analytics for Fusion Service
-
Is any possibility to Fetch Report Last run details ( BIP or OTBI reports)?Is any possibility to Fetch Report Last run details ( BIP or OTBI reports) Can anyone tell me that is oracle capturing the information for the Reports (BIP or OTBI) last…User_7A1QO 14 views 2 comments 0 points Most recent by Amol Patil HCM-Oracle Reporting & Analytics for Fusion Service
-
Can I get a report with a full list of ERP Roles that displays the access to Create FBDI Journals?For Audit controls creation of FBDI report and then ensure all the roles from that reports are reviewed.Jaya Syamala 21 views 2 comments 0 points Most recent by Jaya Syamala Reporting & Analytics for Fusion Service -
Inconsistent report bahavior with error ORA-56733: logical I/O limit exceeded - call abortedHello, We have a BIP report which is a customized version of the Account Analysis report. In this report, we have added sub-queries to have the reconiciliation details i…Kristelle 165 views 5 comments 2 points Most recent by Abhilash K - Deloitte USI 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…Sharmava 14 views 2 comments 0 points Most recent by Sharmava Reporting & Analytics for Fusion Service
-
How to retrieve data from xml file which is loaded as data source in data model in oracle fusionI have a requirement where report will have 2 data set.One data set will have xml file as data source and other data set will have sql query as data source.How to retrie…Suchita Chordiya 21 views 2 comments 0 points Most recent by Suchita Chordiya Reporting & Analytics for Fusion Service
-
Using BIP uploading the files to UCM serverHi using this document i was trying to upload the files to content server. Job is sucessfull and i got the content ID but unable to seach back the files which got upload…Shanmukhi 38 views 2 comments 0 points Most recent by Abdulrahman2k Reporting & Analytics for Fusion Service
-
What would the formula to convert decimal to hours be?We're creating a new infolet in OTBI for users to see their flexi balance, however it currently displays the balance in decimal (e.g. 30.8, 1.2, etc.) when we need it to… -
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 11 views 3 comments 1 point Most recent by Chiranjeevi Reddy Reporting & Analytics for Fusion Service
-
Unable to get WCC server[servername] SecurityGroups DetailsThere is an existing scheduled report job that uploads the csv report to CS. When I check it gets the error "Unable to get WCC server[servername] SecurityGroups Details"…ChrisSSS 41 views 1 comment 0 points Most recent by ChrisSSS Reporting & Analytics for Fusion Service
-
what Database table stores the Role Category informationSummary: need to fetch data describing that which user has what roles and its categories. we have used below tables for our custom query per_user_roles per_users , per_r…Mateen Khan 774 views 4 comments 0 points Most recent by UdayrajSingh Reporting & Analytics for Fusion Service
-
customize expense approval notificationHello, I am trying to add a couple of fairly trivial extra fields to the expense approval notification report, but find that the advice in the documentation does not wor…
-
I want to fetch goal target outcome dataHi I hope you are doing will I want SQL query to fetch goal target outcome data, I tried to use 'HRG_GOAL_TARGET_OUTCOMES' table but it is empty Navigation: My Client Gr…Mohamed_Shafay 35 views 1 comment 0 points Most recent by AdrianG_Oracle-Oracle Reporting and Analytics for HCM
-
Getting XMLPGEN - 03111 : User requested cancel operation ERROR in BIP ReportI have built a Order Management Pricing Report (BIP Report) Getting "User requested cancel operation" Error in the Report. Attached the screenshot for the reference, if …John Peter Noble-Oracle 95 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service
-
How to group the values using different columns in OTBI reportI want to create spearate column in the OTBI to get number of invoice count using supplier name, Invoice number and invoice creation date columns. I could be able to cre…Madushan Fernando 13 views 1 comment 0 points Most recent by Madushan Fernando Reporting & Analytics for Fusion Service
-
OTBI Analysis for for Performance DocumentsI need help/guidance in setting up an analysis filter to only pull the last 12 months of Performance Documents from the Workforce Performance - Performance Rating Real T…Colin M 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service
-
Is the Workforce Learning - Learning Management Real Time subject area being deprecated, and when?Can you help me understand if this SA is being deprecated in OTBI or if it will remain? This Customer connect article seems to indicate it was announced in 2021 that it …
-
What if an instance has been created on analytics cloud instead of FAW ?Hi guys, What's the difference between creating an instance on Analytics Cloud and FAW on OCI ? What if some work has been done on an instance (let's say Instance 1) cre…Lauriane Massin Whitaker 21 views 2 comments 0 points Most recent by Lauriane Massin Whitaker Reporting & Analytics for Fusion Service
-
Perform Shipping Transaction Import ESS Job not populating Request Id in WSH_NEW_DEL_INTERFACE tableHi All, We have below requirement, Create and confirm shipment through REST API Call "Perform Shipping Transaction Import" ESS Job through SOAP. Once done respective ord…Nagaraju Vandavasi 89 views 3 comments 0 points Most recent by Satya Ganti-Oracle Reporting and Analytics for SCM
-
How to print an embedded dashboard pageSummary: When opening a dashboard through directly in the catalog, there is a gear in the top right that gives the ability to print out a dashboard page. When a dashboar…NicolaosDerr 2 views 2 comments 0 points Most recent by NicolaosDerr Reporting & Analytics for Fusion Service
-
recruiting events analyticsHello, I would like to have some analytics or dashboards for metrics regarding recruiting events and campaigns in Recruiting. Is there any predefined dashboard, or a way…Carolina Oberti 21 views 2 comments 0 points Most recent by Chaitanya J.J.-Oracle Reporting & Analytics for Fusion Service
-
Link between Bank Statement line and Transactions for Group of Manual Reconciliation.We are working on the BI report to Pull AP and External Transactions. I need to join the CE_STATEMENT_LINES and CE_RECON_HISTORY_ITEMS to AP_CHECKS_ALL. When I tried to …Shikha_Singh12 3 views 1 comment 0 points Most recent by Sowmya Bonala-Oracle Reporting and Analytics for ERP -
Can BI Publisher Data Models query the table SYS.DBA_COL_COMMENTS in Oracle Fusion Cloud?Can BI Publisher Data Models query the table SYS.DBA_COL_COMMENTS in Oracle Fusion Cloud? I need to query this table to see the purpose of various fields in various tabl…
-
Unarchiving Custom folder after refresh fails without any error messageWe have been backing up the Custom folders (under shared folders) before the refresh on all non-prod pods. After the refresh is complete, we import back the custom folde…Vijay Ramani VJ 12 views 0 comments 0 points Started by Vijay Ramani VJ Reporting and Analytics for ERP -
In which subject area I can find Site details to create an OTBI report?I need the following fields in my OTBI report related to site to know their subscription status: 1) Oracle Fusion Site Name 2) Oracle Fusion Site Number 3) Oracle Fusion…Vishal Thakur 21 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
How can I create a report BI of notifications sent by service request workflow?Summary: How can I create a report BI of notifications sent by service request workflow? Content (required): Currently we are dispatching a series of notifications throu…Camilo Martinez-114335 21 views 1 comment 0 points Most recent by User_4XX09 Reporting & Analytics for Fusion Service
-
Load Data from FAH(fusion Accounting Hub) to FAW, need more details?Summary: Data load from Fusion Accounting Hub(FAH -Fusion Applications) to FAW(Fusion Analytics warehouse) Content (please ensure you mask any confidential information):…NsanthoshK 41 views 2 comments 0 points Most recent by NsanthoshK Reporting & Analytics for Fusion Service
-
Cloud Bi Publisher - BIP bursting not sending emailsHi All, I am using Oracle Analytics Publisher and have built a report and associated data model, with a bursting query. I want to schedule the report to be sent to email…NZ-user999 567 views 2 comments 1 point Most recent by NZ-user999 Reporting & Analytics for Fusion Service