Reporting and Analytics
Discussion List
-
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 15 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 22 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 M 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 64 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 22 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 191 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 2 views 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…
-
Report Approval Path PRWe have requirement to make report about all approval path (person) from requester until approver for transaction PR or PO. Is there any table or data set that used to c…fani2904 31 views 3 comments 0 points Most recent by Venk Kudire- Support-Oracle Fusion Applications Administration
-
Do we have a report that shows the total of foreign currency balances for the accountsSummary: Do we have a report that shows the total of foreign currency balances for the accounts in a particular ledger Content (please ensure you mask any confidential i…
-
Enterprise Contracts OTBI Fields - Couldn't find the notes on a contract field in the subject areaHi All, Is it possible to include the notes on a contract as a reportable field when creating an analysis? It is currently not an option. Can anyone please guide me on w…