Reporting
Discussion List
-
How to find ER diagram of Incentive compensation data modelSummary: How to find ER diagram of Incentive compensation data model. Can you please point me to find the link to the ER diagram or sample queries joining earnings , tra…Pradeep Challa 15 views 3 comments 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation -
How to Automatically Send Password Reset Emails for specific Users from FIC at Once.Summary: I am looking for a way to automatically send password reset emails to a selective set of users within Oracle Incentive Compensation (FIC). The goal is to trigge…Sailendra Koppana 22 views 3 comments 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation
-
How to Retrieve User Login/Logout Time, Date, and Activity Details for all the users (Audit Report)Summary: I am looking for a way to retrieve user login and logout information, including the exact date, time, and activity details, for auditing purposes within Oracle …Sailendra Koppana 57 views 1 comment 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation
-
How to Make commission statements conditionally visible to RepsSummary: We have created Custom Commission statements in Fusion Incentive Comp - we want them to be visible to the Analysts at all times, but they should be visible to F…
-
OTBI : Incentive Compensation Participant Detail Real Time, Participant Compensation Plan Real TimeSummary: When we build reports with following subject area (a) Incentive Compensation Participant Detail Real Time (for Participant Detail Effective Start Date and Effec…
-
API for Extracting Incentive Transactions and Earnings HistorySummary: Hi Team, Is there any API to check incentive transactions and earnings history? We want to extract details from the following tables: cn_tp_transactions_all cn_…
-
Which tables can be used to get the results for audit report for the Incentive compensation?Summary: Hello, We have a requirement to create a report that is same as the data displayed in the UI when the audit report for the Incentive Compensation product is acc…
-
SQL Query to get Employee Compensation detailsHi, I tried to find a request to get employee compensation request details including all the request attributes. and the link between compensation requests and their rel…
-
How to Give Suppliers Access to Incentive Comp ReportingSummary: Need to be able to grant Suppliers access to Incentive Compensation Report. Content (please ensure you mask any confidential information): We have Suppliers who…
-
query to check users logged in to incentive compensationSummary: Hi Team, I am looking for help with the SQL query to check the number of Sales Representatives per BU who logged into OIC in 2024. Content (please ensure you ma…Pankaj Balkothe 11 views 1 comment 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation
-
hide an analysis within the dashboard based on the value entered by the user in the promptI need to hide an analysis within the dashboard based on the value entered by the user in the prompt. This will likely involve using a Section Condition. How can I param…Leonardo Chiqueti 1 view 1 comment 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation
-
OTBI publisher report with promptSummary: I have an OTBI Publisher report within a dashboard and a prompt for the dashboard. How do I connect the Publisher report to the prompt so that I can filter the …Leonardo Chiqueti 11 views 1 comment 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation
-
Requesting for Standard Integration for Oracle incentive compensationClient has requirement that they want to utilize the ICM for both Salesperson and Partner. for this they have quires that how system is picking the data regarding salesp…
-
Not able to find Name Field in the subject area OTBIHello Experts, Please help, where can I find the Name Field, I am currently using Human Capital Management - Transaction Administration Real Time, should I need to use a…Joliver Caangay 11 views 1 comment 0 points Most recent by Kim Vu-Support-Oracle Reporting and Analytics for HCM
-
All Column Values not passing all valuesSummary: When building a prompt, there is an option to include an option for "All Column Values". In testing this, it looks like it acts the same as "None", even when th…NicolaosDerr 12 views 1 comment 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation
-
How to Change the Prompt Order in OTBIIn OTBI, I have a prompt that uses a monthly period, but it varies annually in the month. How can I change the prompt order so that it appears monthly within the same ye…Leonardo Chiqueti 2 views 1 comment 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation
-
Issue with Exported Data Formatting in OTBIWhen exporting the report, composed of a pivot table, via the "Data -> Excel" option, the resulting file mixes rows and columns. How can I directly export the data witho…Leonardo Chiqueti 2 views 1 comment 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation
-
Territory Dimension, how to parameter using transactions from IncentiveSummary: How to restrict access to transactions in the OTBI (Oracle Transactional Business Intelligence) of the Incentive module, utilizing Territories from the Sales Mo…
-
Territory Dimension, how to parameter using transactions from IncentiveSummary: How to restrict access to transactions in the OTBI (Oracle Transactional Business Intelligence) of the Incentive module, utilizing Territories from the Sales Mo…Leonardo Chiqueti 22 views 1 comment 0 points Most recent by Chad Bryant-Oracle Incentive Compensation
-
Is it possible to add more than one manager for the same user?I have an organizational scheme that needs a user to be present within two workplaces at the same time. However, I need to limit transaction access in Oracle OTBI based …João Vitor Magri 41 views 1 comment 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation -
How to create hierarchies to limit access to data?Summary: Hello everybody. I have a critical problem with a client. I need to create some type of hierarchy within the incentive so that access to data from both Incentiv…João Vitor Magri 32 views 5 comments 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation
-
In which Incentive compensation tables are the custom global attributes found?Summary: We have created the custom attribute in global attributes in Transactions page, now we want to get that field in report and checking in 'Incentive Compensation …
-
How to extract transaction details for a period along with associated attainments and earnings?Summary: Oracle provides a payment extract out of the box. We want to to extract transactions for a period along with associated attainments and earnings information (mo…Anand Bharadwaj 21 views 1 comment 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation
-
Dispute resolution customization questionSummary: We have a customer who would like to customize their dispute resolution process so that the Sales Rep is able to see certain features regarding his dispute reso…Carol Schiffler 11 views 1 comment 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation
-
Where to get additional help / references for Oracle Fusion Incentive Compensation ?Some useful references : Links to Best Practices, How-to, FAQ, see Doc ID 2688415.1 Incentive Compensation Resource Center Implementation Guide : Implementing Incentive …Kim Vu-Support-Oracle 91 views 5 comments 1 point Most recent by Kim Vu-Support-Oracle Incentive Compensation -
Changing the file name of an Analytics exportSummary: When an analytics report is exported, the file name is the name of the report by default. Is there a way to change the export file name to be something dynamic/…NicolaosDerr 44 views 5 comments 0 points Most recent by Prabha.R Oracle-Oracle Incentive Compensation
-
How to get the Historical data from Performance Measure Results TableSummary: Let us assume there is a transaction generated a commission of 5000 and that is paid in April 2022 period , where as due to rate change in subsequent period the…Mahesh VT 121 views 11 comments 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation
-
Incentive Compensation - Sample Plan Performance DashboardSummary: Using this dashboard you'll be able to review important stats on the effectiveness your Incentive Compensation Plans. Each compensation program may define succe…