To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting & Analytics for Fusion Service
Discussion List
-
Report Analysis adding multiple subject areas (more than 2) errorHi there, we have a scenario where we have added a new subject area to an existing report that is already set up with the Dimensionality flag, so one would assume adding… -
How do I source: profile item id for spreadsheet loaderI'm trying to build a spreadsheet loader to load license and certifications specifically Responsible Manager which sits in Responsible Person Region in Skills and Qualif…
-
How to use event triggers to send a reportI created a report in OTBI that returns urgent requisitions that were not processed by the buyer, but I would like to send this report to the buyer when an urgent line r… -
Using SOAP Web Services to Automate the Promotion of BIP and OTBI ReportsSummary: We are in the process of migrating to Oracle ERP cloud and need to determine a process/tool to automate and provide version control around BIP and OTBI report m…
-
Print to IPP printer using ExternalReportWSSServiceI am trying to print a pdf report using ExternalReportWSSService web service. The printer is configured correctly and I am able to print from BIP console, when using web…
-
E-stamp & signature for Standard Reportshello, I need a solution to put E-stamp and Signature on standard and customized reports , for example Payslip report
-
Support for Bank's Latest CiphersSummary: Support for Bank's Latest Ciphers Content (please ensure you mask any confidential information): I recently received an email from Bank regarding an update to t…
-
How to show Average First Response Time and Average Handling Time on a graph for Service RequestsSummary: We have a detail report by service request that uses certain calculations to take into account the number of hours worked a day by CS. We have the following wor…
-
Please help with the database column for 'Exchange Gain Or Loss' in Fusion ReceivablesSummary: Need database column for 'Exchange Gain Or Loss' in Fusion Receivables Content (required): There is a column when managing receipts in Oracle Fusion Receivables…
-
Can I use output from one BI report as input to another BI report?Summary: Content (required): I know that I can create multiple templates for my output, but that would require me to run the data model again. I'm looking for a way to p…
-
Organization name need to be replaced with department name.Summary: Hi All, Can some one help me on changing the Organization name instead of Department name in below query Content (required): In the query its is fetching old or… -
Looking for sql to find day/timestamp of employee's policy acknowledgmentI am looking for the table(s) to find the signature day/timestamp for a policy that was 'signed' during an onboarding journey. I started in PER_ALLOCATED_TASKS - is that…
-
Need to Stop Showing Business Unit Code in Report HeaderHi All, I have created Report using Oracle FRS and in the report output i need to stop appearing this BU code. Please Advice -
A seeded report has changed after Fusion update - Can we access it again?We had a recent update 23C and the report 'Inventory Valuation Report' has now disappeared and a new report 'Depreciated Inventory Valuation Report' has appeared. Howeve…
-
SQL to get employees and their dependents enrolled in a benefit planLooking for "SQL to get employees and their dependents enrolled in a benefit plan" to build BIP Report. -
How to stop the BIP scheduled reportHi All , Could you please let me know How to stop the BIP Hourly scheduled report. Thanks, Nagendra
-
What is the table that stores error records for Depreciation Override of Asset using ADFDI?Hi All, We are using ADFDI to Override the depreciation of Asset. After importing the records we need to generate the error report for failed records. Which table stores…
-
We need to download the report for the audit purposeSummary: We need to download the report for the audit purpose. System changes log Authorization change log; add modify, delete. From where we can get this detailed repor…
-
We would like to show a bank payment type (Receipts Only) in Cash Management to complete Bank RecsSummary: Our staff is trying to reconcile the bank statements (task is completed daily) BUT there are no identifiers that indicate whether payment was received via Maste…
-
Is there a report or analytics for activity notes?Summary: Analytics for activity notes Content (required): Hello, For the Service request module, we need to create a new report that can download the notes from the acti…
-
SQL query to fetch employees holiday applied on during employees is on maternitySQL query to fetch employees holiday applied on during employees is on maternity
-
Additional Information for Leave PlansDear All, Unable to find table/column value of "Additional Information" field regards absence accrual details Kindly let us know/share the table or column details which …
-
How to setup monthly report generation and sending to mail address every month?Hello, I have a question for monthly generation report and scheduled sending to mail address, how to setup it? Can you please help? Kind Regards
-
sql functionsLooking for sql function to use inside BIP report which does the following: We have a table column that stores: -AE,BH,BR,CA,CH,CN,GB,HK,IE,KW,MX,NL,OM,QA,SA,SG,US we wo…
-
Audit Reports Through REST APISummary: Where is possible to find list of business objects type for CRM. Content (required): Hi, I'm trying to generate Audit Reports trough REST API. The purpose it's …
-
Can we get employee ID of salesperson in reportsHow can we get employee ID of salesperson in reports, From Opportunity, when we pull employee ID, its giving the employee ID of the Opportunity owner, but can we get emp… -
How to select an employee's work email in OTBI and the worker will appear also if he doesnt have it?How to select an employee's work email in OTBI and in case he does not have such an email, it will display the employee without an email?
-
How To Restrict Access To Custom and Other Folders in Reports and AnalyticsSummary: We would like to restrict access to reports and analystics folder or Custom folder under reports and analystics. Pelase advise. Content (required): Version (inc…
-
Does anyone have an idea on how to Call Third Party API from Fusion via ESS JobSummary: We have a standalone Oracle DB and and API that exposes the data from a specific table. Since we can't connect OTBI to other DB, we just want to be able to call…
-
How to export single offering of BICC for migration between instancesSummary: Ideally now we have have the bulk dump irrespective to specific offering that was modified exported and then imported to different instance. Content (required):…