Reporting and Analytics
Discussion List
-
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 51 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 67 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 21 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 181 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…
-
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…
-
Receiving Pending Benefit Actions Email Alert although there is no pending action item for the user.Receiving Pending Benefit Actions Email Alert although there is no pending action item for the user. This is generated from custom report, and it is showing Pending Bene…
-
What is Automatic Invoices percentage in Procure to Pay Dashboard?Hello, What triggers or affects the Automatic Invoices percentage in the Procure To Pay dashboard?Yousef 21 views 2 comments 0 points Most recent by John Housari-Oracle Payables, Payments & Cash Management
-
SQL Query to get AP invoices stuck in initiated status in oracle fusion Cloud ERPHi All, I need a sql query to get all invoices in Initiated status that are not assigned to any user or security role for approval. Can anyone please guide me where I ca…Sneha_S 560 views 1 comment 0 points Most recent by Venk Kudire- Support-Oracle Fusion Applications Administration
-
Summary: Can we restrict the users to submit the ESS job/ Job set in SAAS applicationSummary: Content: We would like to restrict the users to submit the ESS job/ Job set in SAAS application. I tried with action item with reference to oracle Note: 2251561…surya reddy 52 views 7 comments 0 points Most recent by MandeepGupta Fusion Applications Administration -
Best practices for moving data from Oracle DM Cloud to a GCP data lakeHello Everyone, I'm Umesh, and we're currently implementing Oracle Demand Management Cloud. I'm looking for recommendations on the best practices for moving data from Or…Umesh GC 21 views 1 comment 0 points Most recent by Prateek_16-Oracle Supply Chain Planning and Collaboration
-
"view image" in oracle fusion receivables works for few transaction and shows blank pop for othersI have created a custom template for a BU and added it to the main seeded template in bill presentment for the "view image" feature in oracle fusion receivables manage t…Sneha_S 670 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Is it possible to trigger existing report in Oracle button page using Sandbox?We would like to trigger a report and run it as Scheduled Process when clicking existing Oracle Fusion button (Manage Invoice Preview button to be specific). Is it possi…Eden Valparaiso 71 views 1 comment 0 points Most recent by Gpe_AL-Oracle Reporting and Analytics for ERP
-
Last activity date w/ owner of last activity by accounts reportWe have a number of reports on our OTBI Dashboards that looks at last activity by account by a few different categories. Recently we've felt that bringing in the name of…