OTBI
Discussion List
-
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 571 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 21 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 14 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 303 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 141 views 8 comments 0 points Most recent by Bharadwaj Pisipati Reporting and Analytics for HCM -
Is there any possibility to get the user name who is executing the report otmHi Team, Is there any known way to reliably fetch the user ID of the person executing a report in otm ? I am currently using the following SQL to retrieve the user's pre…Mrugen Sunil Munshi 51 views 7 comments 0 points Most recent by Mrugen Sunil Munshi Transportation Management
-
**SOLVED** How can I get Manager grade step to display in OTBI?I have a requirement to include the grade step of managers in a report I am building however there doesn't appear to be anything available out of the box for this. Does …Rob Ward 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How to fetch email ID of an user in oracle fusionSummary: How to fetch email ID of an user in oracle fusion Content (required): How to fetch email ID of an user in oracle fusion. I have the value of username and need t…Neelesh Varma 6K views 15 comments 0 points Most recent by SukanyaGhosh2502 Reporting and Analytics for HCM
-
Is it possible to report on element config? (e.g. is it taxable, pensionable etc)Summary: I'm looking to create an analysis which shows me the configuration of each element in terms of which have been set as taxable, pensionable, which payrolls they …BFell 11 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Summary Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Content Is "EDI Location Code" available for Reporting in Customer Real Time Su… -
Error: SQL query time exceeds the limit(500 sec). Stopped processingSummary Error: SQL query time exceeds the limit(500 sec). Stopped processingContent Hi All, Error: SQL query time exceeds the limit(500 sec). Stopped processing. I am un…Devendra Thota-220620 2.4K views 8 comments 4 points Most recent by Shyam Patel Reporting and Analytics for SCM
-
Report for specified pay period that shows time card hours paid and costsSummary: I need a report that can be run by department to show hours reported and the associated pay costs thru payroll. I am attempting in OTBI with Payroll Run Real ti…Giselle Valdovinos 29 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Need a report which lists all reports with roles required to run thoseIs it possible create a report that lists all reports in fusion Financials and the security role that is required to run each of these reports. Business is asked constan…Vinay414 31 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
Budgetary Control Balances Based on EntitySummary: We have a requirement to show the Budget Balance based on Entity Segment. Content (please ensure you mask any confidential information): When user is running th…
-
Which table contains the cross charge business unit exceptions?When creating a project there is a section on Cross-charge options that lets you specify "Allow Charges from All Provider Business Unit". There is then an area to add a …
-
Is the Release Statement to Workers flag available in OTBI and BI Tables?Summary: Content (please ensure you mask any confidential information): Hello experts, is the attached field available in Oracle HCM Reporting subject areas or BI Tables…Valerio Curzi 11 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Project Costing - Actual Costs Real Time: want to summarize totals by GL expense accountSummary: Project Costing - Actual Costs Real Time: want to summarize totals by GL expense account. The subject area itself includes fields like Natural Account, Concaten… -
Cost centres report in OTBISummary: Hi, I am wondering if anyone has a way of reporting on cost centres along with HR employee data in the same report. So far i have seen that Payroll costing setu…BillM 452 views 7 comments 0 points Most recent by Ignacio Velando-Oracle Reporting and Analytics for HCM
-
Query to fetch all the eligibily profiles linked to Benefit PlanSummary: Hello, CC! I am in need to biuld a query that given certain Benefit Plan I need to get all the Eligibility Profiles that is attached to it. Ex: I have a paramet…Matheus Roberto 255 views 1 comment 0 points Most recent by Thiru-Oracle Benefits-Oracle Reporting and Analytics for HCM -
Asset Capitalization Date in OTBISummary: We have created an analysis on Depreciation Real time subject area. There is an asset which is capitalized in Mar-25 period with date placed in service as 15-Fe…
-
Notes Attribute in Assignment Action Occurrence Subject AreaHello , We are interested in leveraging Notes attribute in Assignment Action Occurrence Subject Area from 25A , however I am having trouble locating where this attribute…
-
Table/query to get Corporate Card Transactions payment and expense report detailsSummary: I am looking for a query/table details where I can get to know whether the corporate card transactions are in expense report or not and the transactions are pai…