OTBI
Discussion List
-
Database table's name that contains EFF attributes data for items in a Change OrderContent Hi all, I'm looking for the database table's name that contains EFF attributes data for items in a Change Order. The table EGO_CHANGE_LINES_B seems to contain on…Carlos Benassi 47 views 1 comment 0 points Most recent by ManjuH-Oracle Product Master Data Management -
Role permissions to BI reportsContent We want to give access to our HR manager to modify BI report or create an adhoc OTBI analysis for the recruitment and onboarding module. What permission can we g… -
Add 45 day to Benefit Program Date in OTBI AnalysisSummary Add 45 days to Benefit Program Date in in OTBI Analysis filterContent Hello, I need to add a filter to the OTBI analysis. The filter should add 45 days to the Be…GauravGupta39 22 views 6 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM -
Is there a way to track which all analytics/Reports are run by users and via which device (Laptop VsContent Hi Everyone, Is there a way to track which all analytics/Reports are run by users and via which device (Laptop Vs Mobile phones) Please let me know if you have a…Reddykrishna Chidella-Oracle 43 views 2 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM -
Dashboard prompts using sql querySummary Need to create dashboard prompts using sql query as the relevant subject areas for prompt data is not availableContent Hi Experts, I have a requirement to have p…Anirudh Udupa 9 views 3 comments 0 points Most recent by Anirudh Udupa Reporting and Analytics for HCM -
Marketing Role Users not able to access Sales Subject areasSummary Marketing Role Users not able to access Sales Subject areasContent We want Marketing role users like (Marketing Manager, Marketing VP) to get access for Sales ob…Nithin Shivanatari 24 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
Customer Account with SitesSummary Customer profile reportContent Is there any standard or custom OTBI Report for customer profile including all active sites details. Version 21 C -
Best Practice for Initiative that Applies only to New JoinersContent Hey there we have courses in which we should only enroll the new joiners so I was thinking of having an initiative with an OTBI hooked to it. Let's imagine that … -
Journal Issue - "No sequence version is enabled or defined for sequence **** XX GL Accounting SequencContent Hi Guys I would just like to inquire if anyone of you have encountered this kind of error for created journals? Please kindly refer below "No sequence version is…User_2025-02-11-12-30-38-982 370 views 1 comment 1 point Most recent by Kallol Sinha General Ledger & Intercompany -
Can anyone give me Logical SQL with UNION ALL sample codeSummary Can anyone give me Logical SQL with UNION ALL sample codeContent Hi All, Can anyone give me Logical SQL with UNION ALL sample code Regards, Rashmi -
Viewing secured views for Oracle delivered reportsContent I am reviewing some of our delivered reports and am noticing what I believe to be an issue with our secured views. Specifically, I noticed that users can see the…Evan Lehrhoff 30 views 3 comments 0 points Most recent by Evan Lehrhoff Reporting and Analytics for HCM -
MATERIAL TRANSACTION: REFERENCE SOURCE TYPESummary INV_GENERIC_DISPOSITIONS HAS NO DATAContent Hi All, I need to get the reference number for each transaction. like for example sales order and it is reference num… -
How to add bin as prompt?Summary How to add bin as dashboard prompt?Content We have created a column, Position Status, on a position management analysis based of a calculated measure we created,…Aja Nealley 43 views 5 comments 2 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM -
Unable to fetch OTL Data from "Workforce Management - Worker Compliance Results Real Time" SubjectSummary Unable to fetch OTL Data from "Workforce Management - Worker Compliance Results Real Time" Subject area.Content Hi , I am trying to fetch the data from "Workforc…Dharmendra Jha 17 views 1 comment 0 points Most recent by John Finnegan-Oracle Reporting and Analytics for HCM -
Create a ORC Report with Records having hyperlink to ORCSummary Hyperlink to candidate ProfileContent Hi All, I have a requirement where I need to create an ORC report with candidate data. This report should have a hyperlink …Vibha Pandey - Oracle 48 views 4 comments 0 points Most recent by User_GIUF2 Reporting and Analytics for HCM -
Application Composer helpSummary Display BOM components on custom pageContent Hi, We have a requirement to show the component items for user entered BOM on a custom page and perform some update … -
Report of Assignments in a flowContent I was hoping to have a report of assignments within a flow so that we can use that as the basis to check whether people will be paid during the calculate payroll…Sharon Harper 35 views 1 comment 1 point Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Convert OTBI Analysis into BIP ReportSummary Convert OTBI to BIPContent Hi All, As our population in HCM is fast-growing, we are noticing some of the disadvantages of OTBI, performance, # of input records ,…User_KOLMZ 1K views 7 comments 1 point Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
Conditional Format - a detail field to a summarized fieldContent I have an analysis report where I list all the active positions and their FTE along with the employees assigned to those positions and their FTE. I want to compa…Annette M 17 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Training Needs AnalysisContent Anyone can share the Training Needs Analysis samples report developed in Oracle HCM?Chris Ding 167 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Price override and adjustments are not working on sales order lineSummary Price override and adjustments are not working on sales order lineContent Price override and adjustments are not working on sales order line. Though I did a pric… -
Address Audit ReportSummary Looking for a report with employee address changesContent Hi, Does anyone have a report that shows all address changes for an employee? Would want to see before …