Reporting and Analytics
Discussion List
-
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 61 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 31 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
-
I need to Manage Maintenance Organization Relationships via REST APIsHello there, I am trying to find REST API Endpoints that might help me fetch the Maintenance Organization relationships, but I couldn't find anything helpful so far, Exc… -
Is it possible to have existing Purchase Orders reflect the changes done in the PO PDF code?We have made a new custom template and modified the logic in the Data Model level of the standard PO PDF Report. Is their any functionality available by which we can hav…
-
Custom View ESS Role is behaving unexpectedlySummary: There is a custom role created for business to provide access ESS history to certain users. The role was created under Role Category 'Common - Abstract Roles' w…Rahul_M8SG8 21 views 1 comment 0 points Most recent by Andrada-Oracle Fusion Applications Administration
-
We need to extract business approval delegation rules from hcm cloudwe have requirement to extract the business approvals delegation rules from hcm cloud system or please let us know any API or other way to extract that rule definitions.…
-
How to get details of ESS jobs and the associated logs into an onprem monitoring tool like SplunkSummary: I am trying to get details of the scheduled processes and its logs from fusion cloud application (specifically Subscription management cloud) into internal Splu…Kumar Masand 54 views 2 comments 0 points Most recent by Vijaya Sekhar A-Oracle Fusion Applications Administration
-
Inquiring about whether BOs are enabled for CRM Application Composer & Trading Community ModelHi team, I want to inquire whether BOs are enabled for the following products in the audit report: -CRM Application Composer -Trading Community Model Thanks and best reg…
-
Oracle base table to store journals created from rules or rule sets for a given accounting periodIs there any designated table storing rules or rule sets with relation to the journals. When it comes to constructing a way to track down journals created from specific …Pinakpani Podder 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
How to compare current and previous data in OTBI?Hi All, We have a requirement where we need to fetch and compare the data (an attribute on employee assignment page, say Job or Position) on 2 different dates in OTBI an…Suyog 61 views 1 comment 0 points Most recent by Augustin Aravind-Oracle Reporting & Analytics for Fusion Service
-
SQL query to fetch or Oracle base tablel to get Procument Business name for a particular contactSQL query to fetch or Oracle base tablel to get Procument Business name for a particular contact under contact user access.
-
Functionality of 'Every' Value in Weekely Frequency Report BI Agent Scheduler ?In BI Agent Scheduler, we have Frequency = Weekely and 'Every' = … Weeks so here what is meaning/functionality of 'Every' value. So suppose if we put Weekely Frequency a…AMIT KUMAR YADAV 11 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle BI Publisher Learning Center
-
Is there any way to convert PDF file to PDF A3 format in Oracle Fusion CloudSummary: Is there any way to convert PDF file to PDF A3 format in Oracle Fusion Cloud or Using OIC Content (please ensure you mask any confidential information): Version…Raoof Ahmed 1 view 2 comments 0 points Most recent by Kishore Padala-Support-Oracle Fusion Applications Administration
-
BICC job statusSummary: How to check all the schedules defined in BICC -- by anyone How to check which all jobs are currently running in BICC How to check which all jobs errored out in…joelroshan92 23 views 1 comment 0 points Most recent by Siva Kumar Viswanadhuni Reporting & Analytics for Fusion Service
-
How do you find length inputValue EL Expression Builder in Page Composer?Hello, I want to disable OK button if value field length under 12. But EL Expression not acceptable #{bindings.CrossReference.inputValue.length()} . How do you find leng…Sevval Coskun 11 views 2 comments 0 points Most recent by KKhin-Oracle Fusion Applications Administration
-
24B OTBI Reported Time Cards Real Time : Reported Timecard Details : Timecard Messages is blankAs per the 24B Feature, "SUPPORT VALIDATION MESSAGES IN TIME AND LABOR SUBJECT AREAS". I have a timecard that throws the error message via a time entry rule. But in the …
-
SQL query for Balance sheet and income statementWe have a requirement to get Ending balances and Average balance for Balance sheet using BIP, has anyone worked on this?Priyankaprks 194 views 1 comment 0 points Most recent by Laura Petre-Oracle General Ledger & Intercompany
-
Insufficient BIP privileges to run queries that fetch logs for an issue in Fusion Recruiting CloudWhen the queries that fetch Recruitment Content Library Notification Details and Email Message Content and Delivery Status details are run on BIP in order to collect log…Rohan Kulkarni-Oracle 1 view 0 comments 0 points Started by Rohan Kulkarni-Oracle BI Publisher Learning Center
-
How to get backdated Leave balance Data in OTBIWe have a requirement to get the Leave Balance of a particular Absence Plan on a particular date in OTBI, when we configure this , when we check it for backdate we still…