Reporting and Analytics
Discussion List
-
When does data move from WFTASKHISTORY to FND_BPM_TASK_HISTORY_B table?Summary: We are no longer able to fetch approvers name in report using FA_FUSION_SOAINFRA.WFTASKHISTORY table. It looks like Approvers information get archived to FND_BP…Chandrashekhar_Cholli 66 views 2 comments 0 points Most recent by Chandrashekhar_Cholli Fusion Applications Administration -
OTBI Succession plan - can't find fieldHello, I am working on an OTBI analysis and I'm having struggle finding some date fields. The subject area I have chosen is Workforce Succession Management - Plan Candid…Sara Suleiman 11 views 2 comments 0 points Most recent by veerendranath pulivarthi-Oracle Fusion Applications Administration
-
Is it possible to create a customer index on Oracle Cloud ERP seeded tables?Summary: We are currently using a BIP report to extract recently created transactions from ra_customer_trx_lines_all, relying on the last_updated_date field. The report …Pradeep Moganti 12 views 2 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
Environment Usage Assessmentへのインプットとなるデータ量を確認する方法Summary: Environment Usage Assessmentのワークシートに記載する情報を環境から取得する方法はありますか？ Content (please ensure you mask any confidential information): Orac…xochiai.Tatsuya3 25 views 1 comment 1 point Most recent by Andrada-Oracle Fusion Applications Administration
-
How to Customize the sub-template for AbsenceApprovalNotificationTemplate?I want to change a couple of words in the content of "AbsenceApprovalNotificationTemplate" workflow notification. As the required place was not found in the AbsenceAppro… -
Tips for ensuring an up-to-date Hosted Named User Usage Drill Through ReportWhat is the Hosted Named User Usage Drill Through Report? Oracle Fusion SaaS customers are provided with SaaS Service Usage Metrics Reports that shows them commercial us…Yvonne Park-Oracle 297 views 0 comments 2 points Started by Yvonne Park-Oracle Fusion Applications Administration
-
In User Lasy Activity details report some system users are coming along with the real usersSummary: We have developed a custom report to get the user last activity details.The report is giving system users data along with Real users , we are unable to identify…Bhavna Sharma-Oracle 31 views 5 comments 0 points Most recent by Anil Rout-Oracle Fusion Applications Administration
-
Oracle BICC not providing PVO's for IEX tables of AR ModuleHi Team, Currently we are consuming Fusion FSCM data via BICC console for loading data to our warehouse. We are able to load all data related to Customer, AR Invoices ,R…Ranjith Dammala 21 views 0 comments 0 points Started by Ranjith Dammala Reporting and Analytics for ERP
-
News and Announcements reporting on click rates?Summary: News and Announcements feature ability to find out how many clicked and opened to view. Content (please ensure you mask any confidential information): Is there …Sonia Canumay 21 views 2 comments 0 points Most recent by Sonia Canumay Fusion Applications Administration -
Managing PGP Encryption for Reports on sFTP ServerHi, We previously set up a daily scheduled transfer of reports to the sFTP server, using PGP encryption. Our customer now requests additional reports to be sent to the s…
-
Oracle ERP Cloud Essbase cubes clarificationHi everyone, Could you please share a complete list of Essbase cubes that can be enabled in Oracle ERP Cloud? Additionally, I would greatly appreciate any documentation …Michele_Mele 16 views 3 comments 0 points Most recent by Andrada-Oracle Fusion Applications Administration
-
Limited Oracle Allow List IP's For Outbound Connectivity For Fusion ApplicationsSummary: Limiting Oracle BI reports direct transfer IPs Safe list Content (please ensure you mask any confidential information): Base on this doc "Oracle Allow List IP's…Kimberly Nguyen 238 views 4 comments 0 points Most recent by Kimberly Nguyen BI Publisher Learning Center
-
Transfer report not update in the mobiltySummary: Hi team, We changed our transfer report from the custom Folder and we saw that it's updated in the Human Capital Management and it's work there good.(From what …Guy_Ora 11 views 1 comment 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
Need Percentage and Costing Effective start date ColumnsSummary: Currently im working on cost of department report. Need the Table name where percentage and costing effective start date will be stored. Content (please ensure …Supraja Sunnapu 11 views 1 comment 0 points Most recent by Supraja Sunnapu Payroll and Global Payroll Interface (GPI)
-
Need help with contract printing/contract management module in oracle cloudWe've one seeded Contract Printing report but there is no data model attached to it. We need to add one Supplier address on the contract template in such a way that it p…Devyanshi Ghanghas 61 views 7 comments 0 points Most recent by Shylaja Shetty-189359 Enterprise Contracts
-
Customer Contact- Person Audit TableSummary: Dear Experts, We are seeking your valuable inputs to identify the Audit Tables that store information related to updates made to Customer -> Account -> Contacts…
-
How can we migrate BIP scheduled jobs (Definitions) from one env to another env?Hi, We are refreshing multiple lower instances for go-live, and during this process, the BIP schedule jobs are not being migrated from the source to the target instance.…Praveen_Paul_raj 62 views 4 comments 0 points Most recent by Swapnil Kashid Reporting & Analytics for Fusion Service
-
Fields are missing in the new table PER_SENIORITY_DATES_F that were present in the PER_PERIODS_OF_SEAfter migrating from Seniority Date Version 1 to Version 3, I noticed that some fields from the PER_PERIODS_OF_SERVICE table are no longer present in the new PER_SENIORI…
-
Need Table name where approver comments are stored.Summary: Im working on Employee Request Type Report where i need Comments column. Here comments column need to be the comment left by the approver while approving the re…Supraja Sunnapu 13 views 1 comment 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
How WFTASK to FND_BPM_TASK_B and WFTASKHISTORY to FND_BPM_TASK_HISTORY_B tables mapDear All, We are looking proper documentation for mapping WFTASK to FND_BPM_TASK_B and WFTASKHISTORY to FND_BPM_TASK_HISTORY_B because we are facing the issue when we ar…
-
My approved invoices OTBI reportHow do I default in an OTBI report invoice approver to be the User running the report? Or at least have in the drop down list only value available my name (the name of t…Julia Kang 32 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
What other default jndi connection is available in Oracle fusion?If you navigate from BIP screens Adminstration page into Data sources, in the JNDI section, we can add the AuditDB connection(jdbc/AuditViewDB). What other DB connection…Earth place 4 views 1 comment 0 points Most recent by veerendranath pulivarthi-Oracle Fusion Applications Administration
-
facing trouble in printing repeating fields on PDF templateWe are having an issue on PDF template where we need to print multiple invoice lines on an invoice but issue is that we have to fix the space on template where these lin…Saumya Chadha 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Portugal E-Invoicing Mandate from Jan 2025Portugal has mandated e-invoicing from Jan- 2025 so we wanted to ensure the Oracle ERP cloud system complies with regulations. We would like to understand if any specifi…
-
External logging to Sumo Logic or SplunkHi, any guides how to configure our new Oracle ERP Fusion to forward its logs to an external logging SAAS like Splunk or Sumo Logic? Logs like who is logging on to our F…
-
Query overview ofreports and analysis from analytics?Summary: I would like to query the names and file paths of all reports, analysis' and data models in a specific folder in Analytics in HCM. I am specifically looking for…Mia Tøttrup 31 views 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
table name for Supply Chain Execuation > Inventory Management > Review Completed TransactionSummary: I would like to create a report using a query that retrieves the lot number and expiration date from completed transactions. The menu is located in Supply Chain…
-
is it possible to reflect the converted resource rate currency in printed invoice template?Oracle Fusion Cloud Hi All, Good day! We currently have an invoice template that prints labor details. In the Project contract line details, it is expected to print the …Eden Valparaiso 31 views 1 comment 2 points Most recent by Daniela Petria-Oracle Payables, Payments & Cash Management