OTBI
Discussion List
-
Custom role to access Expense Transactions Real Time subject areaSummary: I need help creating a custom role that grants access Expense Transactions Real Time subject area in OTBI. We don't want the users to have access to Expenses in… -
All employees are not visible in OTBI Expense ReportSummary: Business does not want to provide expense manager role and Expense Auditor role to user who will be using this report. Because of this all users are not fetched… -
User unable to view Employee's address details in OTBI ReportsHi Experts, We have created a report using the subject area 'Workforce Management - Worker Assignment Real Time'. We got the other cloumn values except city, county, sta…
-
Is there a way to filter this way in OTBI?Summary: Content (please ensure you mask any confidential information): I'm extracting columnA from a table. It has both null and not null values. »»»Filter should only …Stefano_Mazzocca 21 views 5 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
OTBI analysis on duplicate expense linesSummary: How do you do this? I'm new to OTBI and Fusion ERP. I need to report on duplicate expense lines, meaning an employee accidentally submitted their expense twice … -
Outage for Import Oracle Fusion Data Extensions for Transactional Business Intelligence?On the documentation page discussing importing DFF fields using Import Oracle Fusion Data Extensions for Transactional Business Intelligence it mentions "Running the pro…Angela Montenaro 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Is the number of rows retrieved from OTBI analysis is increased from 75K?Summary: OTBI analysis can retrieve maximum rows of 75K. But users are now able to retrieve around 160K records from the analysis. Is there any update/change happened in…Mounika Samayamantri 52 views 3 comments 0 points Most recent by GiuliaC-Oracle Reporting and Analytics for ERP
-
Can we Display 'Standard Cost' of Item in Demand Plan Tables?Summary Can we Display 'Standard Cost' of Item in Demand Plan Tables?Content Hi All, We have column 'Standard Cost' in Demand Plan in Items table (as shown in screenshot…Ramesh Choudhary 54 views 3 comments 0 points Most recent by Catherine Alequin Supply Chain Planning and Collaboration -
OTBI Map exampleSummary: OTBI Map example Content (please ensure you mask any confidential information): Hello experts, does anyone have an example of an OTBI report with a Map view? Th… -
Is there a way line managers can view element entries?Summary: Is there any way line managers can view reports with element entries? I'd like to create an overtime report so they can monitor their reportees claims but it do…
-
How to retrieve AS$_ATTRIBUTE7 in OTBI?Summary: I'm looking for assignment descriptive flexfields and I'm using "Workforce Management - Person Real Time" subject area Content (please ensure you mask any confi…Stefano_Mazzocca 21 views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
OTBI - Which Subject Area/field provides "Total Unit Cost" value from "Review Item Costs" UI?Hi folks, I'm struggling to find the correct subject area/field within OTBI that calculates the "Total Unit Cost" shown in the "Review Item Costs" UI (Supply Chain Execu…
-
OTBI Subject Area: Fixed Assets - Asset Depreciation Real Time data mismatchIn UI, Asset's Initial units were 100, And 66 units were partially retired and then Transferred out on Oct-24. So the current active units are 34 and the Depreciation Re…
-
Worker HDL Error A primary assignment already exists.Summary: We are trying to load worker data with historical Data in Dev1. We are getting this error(A primary assignment already exists.)for lot of inactive employees. We…Krishna Manmohan 122 views 3 comments 0 points Most recent by SarthakRohilla Reporting and Analytics for HCM -
How to export all the rows from EGO_ITEM_EFF_B Table?Summary: We have a requirement to export all the Attribute Groups Attributes data from EGO_ITEM_EFF_B table in a common format and push it to a downstream application. P…
-
OTBI - SUBTOTALSummary: Is there a way to show only the subtotal in OTBI? Content (please ensure you mask any confidential information): Version (include the version you are using, if … -
What subject area or field to display the corrected amount for Service POs in OTBISummary: We are using the subject area Receiving - Purchase Receipts Real Time to display PO Receipt information. We are using the field Receipt Amount to display the am…
-
LOV not displaying any values in OTBI promptSummary: Hi, I am creating prompts in OTBI for AP module and while creating prompts for 'Invoice created by username', 'Approver', 'Invoice Source' columns, the list of …
-
Restricting Person Type LOV on Line Manager Dashboard Without CustomizationWe are currently exploring options to restrict certain values from the Person Type LOV that appears on the Line Manager Dashboard. Since the Person Type Lookup is a syst…Shubham Kadam 11 views 3 comments 0 points Most recent by Shubham Kadam Reporting and Analytics for ERP
-
Can an OTBI report have a sub-total lines?Summary: I have created an LD Schedule OTBI report where I need to insert a sub-total by Employee the percentage of effort. Can someone share how I can add that in the A…Cris_Yee_Allenite 144 views 2 comments 0 points Most recent by Regie Mercado Reporting and Analytics for ERP -
Combine multiple Ethnicities in OTBI "Two or more races"Summary: Per the below - we have some Team Members that classify with more than one Ethnicity and the "Two or more race" option is no longer available in Oracle. This is…THawkins_LGI 221 views 16 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
Change to absence start or end date - event level reportingSummary: We have a requirement to report on changes to absence start and end dates i.e. when someone edits an existing absence. The OTBI Subject Areas are all Real Time …Amanda Hope 21 views 3 comments 0 points Most recent by Shivam Trivedi-Oracle Reporting and Analytics for HCM
-
Renamed position reportSummary: Hi, We have a requirement to report on changes to employees positions, which is fine but we have an issue when the Position name itself has been updated and the… -
While running an Analysis, we dont see any results for Expense Manger/Employee Supervisor name ?Summary:While running an Analysis, we dont see any results for Expense Manger/Employee Supervisor name which i impacting the Manager field dropdwon values of our Expense… -
How to eliminate duplicate measure after joining 2 OTBI subject areaSummary: Hi all, I have a report with 2 subject areas (HCM and Projects) Is there a way to show for highlighted values 8, instead on 40 reported hours? Basically is the …Raluca Balan-Oracle 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
custom email - how to add a link to access the systemSummary: Hi all, I would like to create a custom email. in the text of this email I would like to insert a link to access the system. in particular, I would like to inse…Alessandro Nesi 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Subject Area: Payroll - Personal Payment Details Real TimeHello, Could anyone help or confirm if the Subject Area: Payroll - Personal payment details real time can extract the Account Suffix for our Personal Payment Method? Cou…
-
Learner’s Score for Assessment Second AttemptHello Experts, I would like to ask where I can view a learner’s score for a second attempt at a learning assessment. Is this information stored in the database, and if s…
-
Looking for PO Receipt Number and related data in OTBISummary Cannot find PO Receipt Number, Receipt Date and related date in OTBI Subject Area: Procurement: Procure to Pay Real TimeContent Cannot find PO Receipt Number, Re…Rona Jeongco 726 views 14 comments 0 points Most recent by Scott at Scotacle Reporting and Analytics for ERP