OTBI
Discussion List
-
Unable to restrict OTBI data based on legal entitySummary: While attempting to create any OTBI analysis from HCM subject areas, we are encountering an issue where the data is not being limited to a specific legal entity… -
Custom Folder is unavailable to all the UsersSummary: Our users are not able to see the Custom Folder under Shared Folders All our reports are in the Custom folder. Possibly -mistakenly the permission of the folder…
-
OTBI function enablingHi Team When the user is working in OTBI (Subledger Accounting – Journals Real Time) and need to extract parts of the “Journal Line Description” field using pattern matc…Jayani Avutu 63 views 2 comments 0 points Most recent by Jayani Avutu Reporting and Analytics for ERP
-
Otbi report to compare budget revenue, baseline cost to project funded amountI am triying to create a report to ocmpare project planned cost, budget revenue against the funded amount in contracts module by combining Project Finacial plan with Pro…
-
Enable custom reports centrally for all Job managers in PPM manage project financial plan analyticsWe are new to Oracle.. How can i enable list of custom report for all users/ or job manager role in the PPM manage project financial plan analytics pop up tab on the rig…
-
How can i get currency report to show currencies and the exchange rate against a currency in OTBIIgnore- Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Finding corresponding entity§ion of an intercompany transaction that hits an entity & sectionHow to find the originating entity and section number of a transation that ends up in another entity and section in the General Ledger. Currently our ERP COA has Entity,…
-
Item Structure Report for multiple itemsSummary: Is there any out of the box way to run the Item Structure Report for multiple items with some parameters such as organization, user item type, item category, et… -
Human Capital Management - Transaction Administration Real Time subject area not workingSummary: We have a report reuqirement to fetch all workflow transactions whether completed or failed, and for failed transactions we need to populate th eissue title, is…Velidi Supraja 11 views 0 comments 0 points Most recent by Velidi Supraja Reporting and Analytics for HCM
-
Query/table information to obtain issue description from transactions that end in errorSummary: need a way to report on Issue description, Resolution and Number from transactions that end in error. Content (required): When a transaction ends in error there…PrashanthGanji 348 views 11 comments 1 point Most recent by Velidi Supraja Reporting and Analytics for HCM -
Action link for learningSummary: Need guidance to create action link for course learning report. I have made a learning report where course related columns are present, e.g. learning item name,…
-
Performance Calibration Module data in OTBI?What Subject Area is this data stored in? I'm specifically trying to extract the Calibrated rating. I've found all other data in our module setup with the exception of t…tim.glasheen_1073872 32 views 4 comments 0 points Most recent by tim.glasheen_1073872 Reporting and Analytics for HCM
-
How to Create a Report for Approval/Reject Notifications in Fusion?Hi Everyone, We have a requirement to generate a report for all email notifications sent from Oracle Fusion for Approval or Rejection actions. The report should include …
-
Dynamic Date Prompts and SQL Setup for OTBI Workforce ReportSummary: Assistance needed with creating a dynamic OTBI report that allows users to enter date ranges for Assignment Details Effective Start Date and Assignment Details …ReiV 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Reporting "Additional Address Attribute 1" on OTBISummary Fields don't appear on the relevant subject areaContent Hi. I have aligned my country's geography and i have several address elements that i save on the fields: … -
In Fusion Projects DashboardHello All, In Fusion Projects, under Project Performance dashboard, is there a way i can show the PO dates (if they are late). For example under each of the Project, Tas…Vishnuvarth Subramanian-Oracle 1 view 1 comment 0 points Most recent by Andy May-Coates-Oracle Project Management
-
Adding Learning Comments to Criteria is causing my analysis to fail to process ResultsSummary: I have a report using Workforce Learning - Learning Records Real Time that works until I add "Evaluation Questionnaire"."Answer Comments" to the Criteria. Then …Sherie Ross 41 views 3 comments 0 points Most recent by Narula Shray Reporting and Analytics for HCM
-
How to get all the Queues & Resources assigned dates for a Service request in OTBI Analytics reportSummary: Hi Team, As per the requirement, we need to create reports with the list of resources assigned to the SR with the assigned dates and the same for Queues. Could …Nikhil_Samudrala 61 views 4 comments 0 points Most recent by Nikhil_Samudrala Reporting & Analytics for Fusion Service
-
Information on scheduled processesSummary: How to get information what schedule process are scheduled through BI Report. With specific fields Content (please ensure you mask any confidential information)…
-
OTBI Report: Missing Seniority, Entitlement, and Vacation BalanceI’m building the Employee Vacation and Sick Leave Balance Report in OTBI with the following filters: Assignment Status is in Active – No Payroll, Active – Payroll Eligib…
-
How to Get XLE_LE_ADD_INFO in HCM OTBI Subject Area?Summary We have a DFF with module Legal Entities and the Legal entity GL code has been created on Attribite1 of XLE_LE_ADD_INFO FlexfieldContent Hello Friends, We have a…Mansur Khalil 274 views 10 comments 3 points Most recent by Javier Miranda Reporting and Analytics for HCM -
HCM Table for Transaction Audit Trail DataHello, how are you? I would like to know in which HCM table the audit trail from Diagnostic Log data of a transaction can be found. I tried the HRC_TXN_HEADER table, but…LeonardoNogueira 11 views 2 comments 0 points Most recent by LeonardoNogueira Reporting and Analytics for HCM
-
Are Price List Approvers' details available for reporting in Fusion?Summary: Looking for table names to fetch approval history in a report for Price List Approvals Content (please ensure you mask any confidential information): Hi All, We…
-
How to Query Work Order Picks Pick Confirmed with zero QuantityWe are using Oracle discrete work order Picks. There are situations where a pick is created but picker does not find the quantity in the bin due to inventory issues. Pic…
-
Where are Social Security Wages in OTBI?I'm trying to report on information from W-2s, specifically the Social Security Wages from box 3 in the W-2. Where do we find that information in OTBI, specifically Soci… -
User Adoption Insights - Preconfigured Sample Reports in OTBISummary Sample reports for user adoption insights in OTBI are available with attached .catalog fileContent Oracle CX Sales has received requests to provide pre-configure…Greg Rice-Oracle 698 views 13 comments 9 points Most recent by Navin Jose-Oracle Reporting & Analytics for Sales -
Seeded report for ESS Job/BIP Reports running historyDoes Oracle has any seeded BIP reports or OTBI subject area to see below 1. ESS Jobs History 2. Scheduled BIP Report HistoryRohit Lohani 23 views 0 comments 0 points Most recent by Rohit Lohani Reporting and Analytics for ERP
-
Constructing Deep Link to the Accounts Receivables Invoices PageHi All Can someone please assist, I've written an Account Receivables OTBI report to look at invoices. I'm now trying to add a deep link so that I can drill down from th… -
Is there a report to monitor Microsoft outlook notification send to learners and instructors?Summary: To monitor the MS outlook notifications for learners and instructors Content (please ensure you mask any confidential information): A report that can provide de… -
Payroll - Personal Payment Details Real Time gives an errorSummary: Hi Everyone, Currently, I'm working on the "Payroll - Personal Payment Details Real Time" Subject Area. when I'm trying to add employee bank details, it gives m…Saher 51 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM