OTBI
Discussion List
-
Table for security console audit?Summary: We have auditing enabled. Specifically, the "Oracle platform security services" option. We need the table names where audit tracking takes place with respect to…Shant Sarkissian_NES 52 views 5 comments 1 point Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM -
Extract Asset Reporting Data process for tasks from Assets workarea and from Scheduled ProcessesSummary: Auto Submit process "Extract Asset Reporting Data" for tasks from Assets workarea and from Scheduled Processes ESS jobs. Content (required): On following note E…
-
In OTBI Report,we are used Worker assignement Event Real time but "State" column not available ?Summary: Hi Team, In OTBI Report, we are used most of the employee address columns from ( Worker assignement Event Real time) subject area but "State" column not availab…AjayKumar Maddipati 31 views 3 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
OTBI Union Query - R12 - Career StatementsSummary Report working in R11 but union no longer working in R12Content Hello I have an analysis in R11 that we use to identify the % of staff who have a career statemen…Andrew Braid 99 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Career Development ReportSummary: Trying to create an OTBI report using subject area "Workforce Career Development - Development Goal Overview Real Time". I have no issues adding fields from Dev…
-
How to identify slow moving items in Oracle fusion inventorySummary: Hi All, How to identify slow moving items in Oracle fusion inventory. Is there any report available for slow moving items ? Content (required): Version (include…Mangesh Shastri 472 views 5 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Inventory Management
-
Enhance Integrations of Deleted Entities Using Configured Reports -22C new featureSummary: Enhance Integrations of Deleted Entities Using Configured Reports- can you let us know based on which table in OAC,? Content (required): Enhance Integrations of…Adarsh Pai 41 views 1 comment 0 points Most recent by Shyam Lakshman-Oracle Product Master Data Management
-
Data Security in BIP ReportTeam, Which is the best way to apply the data security in BIP Report. Example: User belongs to the business unit "BU-A" should be able to see the data of "BU-A" We have …
-
BICC SYNC - PVO for PJF_PROJECTS_ALL_B_ tableSummary: BICC SYNC - PVO for PJF_PROJECTS_ALL_B_ table Content (required): Hi - I am looking for PVO to BICC sync table PJF_PROJECTS_ALL_B_ table. Please help. Version (… -
OTBI Emergency Contact by EmployeeSummary: Dear Community, How can i produce an OTBI report to generate an emergency contact? Can anyone share sample Data Model? We need to use this for Incident Response… -
Scheduled OTBI Report to provide output as on previous dateSummary: Want to schedule OTBI report which triggers output as on previous date as effective date Content (required): When OTBI report is scheduled, we have a requiremen…
-
Drill Down OTBI bar chart report is not working correctly using several columnsSummary: We have a master report which has the following columns: -Positioning Before, Grade Code, Gender, Number of eligible employees. I used a stacked vertical bar ch…bervin13 111 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to calculate cost of sickness in UKSummary: Calculate the cost of sickness using salary from element entry Content (required): I have been asked to calculate the quarterly cost of sickness. I was wonderin…Isabela Radivoi 21 views 2 comments 0 points Most recent by Isabela Radivoi Reporting and Analytics for HCM -
Prompt for Assigned on Date and Completion Date are not filtered based on the security of user (OLC)Dears, I've created a prompt with two filters: YEAR(Learning Record Details.Assigned on Date) YEAR(Learning Record Details.Completion Date) I don't understand the reason…
-
Need help with SQL query (OBIEE Dataset)Summary Building a report showing a persons information on 2 different dates - need help with some sql design (if possible)Content Hi All, I am trying to build a report …User_2025-02-04-08-51-08-912 40 views 6 comments 0 points Most recent by Roma Pandey Reporting and Analytics for HCM -
OTBI Row to Columns Conversion (FA HCM Rel 9.2)Summary Can we convert rows into columns in Fusion OTBIContent Hi Experts, Please have a look at attached word document and png file s and adviseAshishERPCloud 82 views 4 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM -
Any report available to fetch ESS -scheduled pick waveSummary: Any standard report available to fetch scheduled pick wave ESS. Content (required): our client has 5 inventory organizations, and each org has multiple pick wav…
-
Customer Statement Report using OTBI.Summary: I want to modify existing OTBI report for Customer Statement Report for which I have to fetch Commitment cost as Expenses under Expenditure Category. For which …Yashdeep 51 views 4 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for HCM
-
How to create Coupons for DiscountsSummary: We want to offer Coupons to offer discounts to the Customer Content (required): We need to offer Coupons to the customers via Coupon Codes. Once they bring that…
-
How do add export option to Dashboard UI reportContent Hi, I cannot find a way to make the option export in the UI dashboard available. of course through OBIEE this option is available, but after adding the report to…Gal Shani 98 views 7 comments 0 points Most recent by Satheesh Nesamani Reporting and Analytics for HCM -
Need source of PO Charge account for OTBI reportSummary: what is the database source field for the PO charge account - would like to include in an OTBI report Content (required): PO charge account on the page - what d…Bernadette Dorris 42 views 6 comments 0 points Most recent by Bernadette Dorris Reporting and Analytics for SCM
-
Incorrect value/Same Value being displayed in Projects-OTBI reportsSummary: Content (required): Projects-OTBI reports show incorrect values, Budgets, Actuals, and Commitments are all displayed as "3".Occasionally, or depending on what e… -
How can I get only the latest results when reporting on the status of a certain training?Summary: I try to report on the status of a certain required learning to see who has not completed it yet. If the learning was deployed this year, but also the year befo…Cora_Stanciu 31 views 3 comments 0 points Most recent by Cora_Stanciu Reporting and Analytics for HCM
-
Using Country of Origin field in Inventory TransactionsSummary: We have disabled the checkbox for tracking inventory by Country of Origin in Organization Parameters. But the Country of Origin field is available on receiving …Mugdha Tilwe 66 views 1 comment 0 points Most recent by Lynn Warneka-Oracle_inactive Inventory Management
-
Restrict the access for creating data model and create analysisSummary: Hi All, How to find the roles which are giving create and edit access of analysis and BIP report? is anyone have any SQL for to find out these in any custom rol…Amit_Ekbote 42 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM