OTBI
Discussion List
-
Cannot open OTBI Report Workforce Compensation subject areaSummary: Content (please ensure you mask any confidential information): Hello experts, when opening the attached OTBI report the system doesn't return any value. However…Valerio Curzi 11 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Which table stores material transaction history of a work order?Summary: Which table stores material transaction history of a work order? Content (required): Hi, there! I'm building a report to get material transaction history becaus…Andres De la Ossa-Oracle 1.1K views 3 comments 0 points Most recent by Jose Zuria-Oracle Manufacturing -
OTBI Report for General Ledger - Journals Real Time Not Displaying Correct AmountsSummary: Entered Credit & Debit Amounts and Accounted Credit & Debit Amounts are not displayed correctly in the OTBI Analysis using the General Ledger - Journals Real-Ti… -
Audit Trial for Workforce Compensation Approval taskSummary: Content (please ensure you mask any confidential information): Hello experts, when approving compensation plan (Approval task) the name of the last approver alw…
-
Seeded Deferred Compensation Overlimit Balance Exception report has incorrect formula valueSummary: Balance Exception Report for Deferred Compensation Overlimit with exception name 401k Over the Limit has incorrect formula value Content (please ensure you mask…Karen Settembrino 11 views 0 comments 0 points Started by Karen Settembrino Reporting and Analytics for HCM -
Extracting data from project management pvos and linking them to build an external reporting model.I need to extract data out through Project PVO's in order to fullfil an external reporting requirement. I am trying to find the PVO to bring below information together a… -
Need a SQL query to list suppliers with access to the Supplier Portal in Oracle FusionSummary: Need a SQL query to list suppliers with access to the Supplier Portal in Oracle Fusion Content (please ensure you mask any confidential information): Hi everyon…
-
How to get users last login dateContent Hi, We have requirement to fetch all users last login date and time. May i know which table can help to get the info. I tried FND_SESSIONS and ASE_USER_LOGIN_INF… -
Unable to Only Return Rows Relevant to the User Running the Agent using more than one subject areaContent Hello, We have a bursting agent to let our managers know that they have a new hire which was working previously. We've recently added the personal email into the…User_2025-01-31-00-25-12-234 26 views 12 comments 0 points Most recent by AvinashP Reporting and Analytics for HCM -
Reporting on Publish End Dates on Course or Offering LevelContent We have a dashboard report with various filters. One includes a dropdown with selection of the various courses. Some of them are not applicable/useable anymore a… -
How to capture a field with blank spaces at the end?Summary: We are trying to create an audit report that will identify email addresses that have extra spaces in them. Any idea how to capture those outliers in a report? C…CGardner01 32 views 7 comments 0 points Most recent by Riyaz Ali-Oracle Reporting and Analytics for HCM
-
Last login of service accountSummary: I would like to find when a particular service account last logged in either through UI or through Webservice or both in Oracle ERP Fusion. Is there any SQL que…
-
Reading offering, functional area and setup task using querySummary: For an integration, looking for a way to map Offerings/Functional Areas and available Setup tasks. Using OTBI, is it possible to write a report/query to get the…
-
GL segments not visible in OTBISummary: Hi all, I have an issue where some GL segments aren´t visible in OTBI. I tracked down some issues for why it was not visible and followed this note: https://sup…Daniel Lundsteen Minke 837 views 3 comments 1 point Most recent by Wim vd Veer General Ledger & Intercompany -
error using data mode property: Optimize Query ExecutionSummary: Hello everyone, a few days ago I experienced a new situation. I have a report that extracts a large amount of data (over 100,000). I tried to optimize the execu…Ayala01 15 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Can i restrict edit access to BI reports to those who creates itSummary: Hi Team, We have a requirement to restrict edit access to BI reports that a certain user has created it. i.e , The one who creates can only be allowed to edit i…
-
In OTBI unable to filter the trxs with 0 adjustments and with the status of approvedWhile creating an OTBI report, When we take the source criteria as Adjustment status we aren't able to filter out only the approved ones along with the transactions whic…Surbhi_1-Oracle 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
When clicking on Set Ownership of this Item under the Folder Properties , Report Time Stamp ChangedWhen clicking on Set Ownership of this Item under the Folder Properties , Report Time Stamp Changed Is this normal functionality? How can we revert this?PhillipJ 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Output when using a procedure callHello, I created a procedure call within OTBI. It is a complex PL/SQL that retrieve data from several tables. Each data pushed into a local table of records. All is fine…AA 21 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
OTBI report for Offboarding Journey also pulling rehires along with termsWe are trying to create a simple response and count report for Offboarding journey (for voluntary terms only) . We have added Workforce management - Checklist Real Time …Arnabb 1 view 1 comment 0 points Most recent by ravikiran goda-Oracle Reporting and Analytics for HCM
-
Which table stores the details of benefit dependents and their ages in the Benefit tables or OTBI?Summary: I need to fetch the designated dependent name, relationship to the employee, gender, date of birth, and age for each benefit plan. Please help me understand how…Ketha Paramesh 561 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
How to create balance calculation date for the reportSummary: Hi , I am working on one requirement , where i need to add balance calculation date parameter to one of the existing report . User is expecting if they give fut…Vishnupriya 23 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Recruit to Hire Dashboard customizationHi Team, As we have seeded Recruit to Hire Dashboard, we want to have customized dashboard based on our requirement. we want to hide below items from the dashboard. Can …VenkaeshSJDI 173 views 8 comments 0 points Most recent by Vaibhav Ramesh Reporting and Analytics for HCM
-
How to adjust level of access to OTBI's Administration pageSummary: We have several members on our team that has full access to every option within the OTBI's Administrative page. Is it possible to limit this access? For example…
-
Prompt values to be displayed on Direct and Indirect Reportees of manager selected.Summary: We have report which contains prompt Manager Direct Reportees Manager Indirect Reportees Job Name When i logged as a manager Prompt 1 will display all the direc…Hanuman_Prasad 11 views 2 comments 0 points Most recent by Hanuman_Prasad Reporting and Analytics for HCM
-
How can I export journal entry data incl. user information for auditor (JET analysis)?Hi, we need to extract a full journal entry list including subledger data and information about the user who performed the transaction. The external auditor wants to use…Holger74 1 view 1 comment 0 points Most recent by Chandra Sekhar Kadali-Oracle General Ledger & Intercompany
-
How to retrieve/calculate fiscal year for payroll period otbi reportSummary I would like to add fiscal year and calendar year in payroll by period OTBI reportContent Hi Team, I have created a prompt name toggle with 2 fields(calendar and…Kalyani Koylada 304 views 3 comments 0 points Most recent by Nidhi Chhajed Reporting and Analytics for HCM
-
Can we send notification to bell icon in Fusion HCM using the BI Publisher reports?Content Is there a way to send the notifications to the bell icon in the Fusion HCM by running the BI reports. Please provide your inputs on this. Thanks and Regards, Am…Amrit 138 views 8 comments 0 points Most recent by Bharadwaj Pisipati Reporting and Analytics for HCM