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.
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Reporting & Analytics for Fusion Service
Discussion List
-
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):…
-
How can I create a report BI of notifications sent by service request workflow?Summary: How can I create a report BI of notifications sent by service request workflow? Content (required): Currently we are dispatching a series of notifications throu…
-
How to rename BI Publisher excel output spreadsheet.(sheet1, Sheet2,...)Summary: Business needs to display Sheet1,Sheet2.... to different names when generating the output in Excel through BI Publisher. Content (required): Business needs to d…
-
Oracle BIP Bursting to AWS S3Summary: Oracle bursting definition requires a folder specified; however, no folder exists when bursting to AWS S3 bucket. Content (required): I have a requirement to co…
-
Bi Publisher CSV output IssueSummary: Bi Publisher CSV Output Issue displaying all the fields in the output Content (required): Requirement is to display all the fields from the data model output of…
-
Oracle usage report that breaks down when a user last used a particular role.Summary: Hi Team, We have requirement to build a BIP report where we need get the details when a user last used a particular role. As an example, A user last accessed Pr…
-
Equivalent Oracle Cloud table/view for the EBS 11i entity CSI_TXN_TYPESSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CSI_TXN_TYPES? Content (required): Version (include the versio…
-
Equivalent Oracle Cloud table/view for the EBS 11i entity CSI_INSTALLED_BASE_VSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CSI_INSTALLED_BASE_V? Content (required): Version (include the…
-
How to enable selecting multiple values (not range) for Custom ESS Job parameters in Oracle FusionSummary: We have requirement where user need to select multiple values (not from - to range but random values) for different COA parameters in a custom ESS Job parameter…
-
what Database table stores the Role Category informationSummary: need to fetch data describing that which user has what roles and its categories. we have used below tables for our custom query per_user_roles per_users , per_r…
-
Can we fetch login data of all users for a year with Login Date and not LAST LOGIN DATE? All loginsWe have a audit requirement to present them with data of all users and all their logins in the past 1 year. For eg if a user XYZ has logged in 10 times into the instance…
-
How to display the latest add/new columns at last in BICC via UCM extractHi All, When we added new column in datastore(PVO) of BICC , while extraction of data via ucm we see the new column is not displaying towards last of extract. As per my …
-
Can we enable or disable report one parameter field based on other parameter field input?Summary: We received requirement like, 1) Choose field say start date or end date from drop down 2) Choose Operator Prior/After/Between from drop down 3) Enter Date : Da…
-
Filter unique values in a custom object on a DCL fieldSummary: A custom object has one of the fields as DCL(Dynamic Choice List). This DCL is in turn dependent on a custom object (LOV custom object) which will have duplicat…
-
item inventory availability quantitySummary: how could build an report to retrieve the item availability quantity based on organization_id, sub_organization, item_inventory_id and lot number. Content (requ…