OTBI
Discussion List
-
Capturing Item Images in OTBISummary Capturing Item Images in OTBIContent Hello, We would like to capture the item images on OTBI report. We tried using Product Management - Source System Item Real …Anand Dhinakaran 33 views 8 comments 0 points Most recent by Anand Dhinakaran Product Master Data Management -
Automatic Association of Meter to an AssetSummary Automatic Association of Meter to an AssetContent Hi Is there any REST/FBDI loader to associate a meter to an Asset ? We are implementing Meter based strategies …
-
Formatting Code appearing in some columnsSummary Success Criteria & Comments ColumnContent Hi, I've just ran a Goals reports from the Workforce Management - Goals Tasks Real Time and found lots of formatting co…User_2025-02-05-22-44-35-842 30 views 6 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Find parent value in CoA hierarchy for balancing segment in OTBIContent As an investment fund manager , my company closes the periods per FUND which is defined in the hierarchy of the Balancing Segment Chart of Accounts. As per Oracl…MaartenDIF 144 views 8 comments 1 point Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
Nice look and feel outcome when NO result in OTBISummary How to display a nice page in case of NO result in OTBIContent Hi, do you know if there is some way to display a courtesy page if no result in a OTBI analysis? T…Nicola Petri 45 views 4 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
Infolet for Personal InformationContent Good Day All, i have created numerous infolets in the new UI and all work fine. One of the infolets is for Length of Service. Now if you are a Line Manager you w…Clifford Trett 87 views 4 comments 2 points Most recent by Swati SinghVerma Reporting and Analytics for HCM -
OTBI CapabilitiesSummary OTBI CapabilitiesContent Hi Experts, I hope some of you will agree that although OTBI has advanced features and capabilities still some consultants prefer to use…AshishERPCloud 317 views 5 comments 4 points Most recent by Kalyani Koylada Reporting and Analytics for HCM -
Awaiting BillingSummary Order stuck in Awaiting BillingContent Hello All, I have one order stuck in Awaiting Billing and upon running : Import Autoinvoice, this error is generated :Revi…User_2025-02-05-12-20-44-163 43 views 3 comments 0 points Most recent by Shyam Patel Order Management
-
Need to display Transferred CIP cost, Asset Placed in service cost in OTBI reportSummary But I could see only Rounded Transferred CIP cost or Unrounded Transferred CIP cost onlyContent Hi Can anyone help me with my question? Need to display Transferr…
-
Question: In Demand Management, How to use Moving_Total Function to exclude past one month while perSummary Question: In Demand Management, How to use Moving_Total Function to exclude past one month while performing summationContent Hi Team, We have an requirement to d…Ramesh Choudhary 31 views 1 comment 0 points Most recent by Nagappan Periakaruppan Supply Chain Planning and Collaboration -
New Hires in last 90 daysSummary New Hres reportContent Hi, I've found some examples of new hires report where the TIMESTAMP formula is -1 to show hire in the last year. How do I modify it to sh…User_2025-02-05-22-44-35-842 55 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Salaries in WordsSummary I Need to put in Word Template the Salaries in wordContent I need to put in template WORD (bi publisher) , the salary in full (Words) can someone help me?Jorge Donaire-229567 55 views 8 comments 1 point Most recent by Sahil_Makhiza Reporting and Analytics for HCM
-
Employee, Manager, Department Head ( Director & up ) and Division Head ( VP & up) in a report.Summary Employee, Manager, Department Head ( Director & up ) and Division Head ( VP & up) in a report.Content HI, I'm planning to build a BI Report having Employee, Mana…User_2025-02-07-19-03-14-525 51 views 9 comments 0 points Most recent by Mishra Ankit Reporting and Analytics for HCM
-
COUNT of new hires and veteransSummary Calculate the count of 2 custom fieldsContent Hi Team, I am calculating the count of employees who are new hires and veterans. Below is the query used which is n…Kalyani Koylada 56 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Action Link on Performance TileSummary Opening detailed report (attached via action link) in separate tabContent Hi All, We are compiling a dashboard which has multiple performance tiles in one sectio…Ankush Rode 58 views 9 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Absence BalancesContent Hi all - I am working on a report to show absences taken during a period of time, and I have it just fine for calculating how many absences someone has taken in … -
Conditional Formatting of Blank Cells not workingSummary I want Null / Blank Cells in RedContent Hi, I have a report (see XML attached) that has 17 columns, some of which have missing data (NULLS). All I am trying to d…User_2025-02-05-22-44-35-842 32 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Department name not available in Position Subject area - causing duplicate rowSummary Looking to report on position listing and incumbent information and getting duplicate rowContent Hi there, I have created a report based on position and have add…Mario B 41 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Future Starters / Pending WorkersSummary Need a list of pending workersContent Hi I'm trying to build a simple report that shows all pending employees (yet to commence employment). Which subject area sh…User_2025-02-05-22-44-35-842 84 views 7 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Manager name for the CEOSummary After promoting an associate to CEO, the former CEO is still seen as his managerContent When our previous CEO retired, he was replaced by an associate within the…User_2025-02-05-12-06-38-063 49 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
sql to use to find out if someone is a line a manager ?Summary sql to use to find out if someone is a line a manager ?Content What sql to use to find out if someone is a line a manager ? We dont use the manager flag at assig…Ruzwan Akram 52 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Involuntary Turnover ReportSummary Involuntary ReportContent Hi, I'm trying to build a report from scratch that will show the number of involuntary leavers and their reasons (e.g. redundancy) etc …User_2025-02-05-22-44-35-842 29 views 5 comments 0 points Most recent by Vis Perera Reporting and Analytics for HCM
-
Send/Push BIP Report Extraction file to Oracle Cloud Infrastructure (OCI)Summary Send/Push BIP Report Extraction file to Oracle Cloud Infrastructure (OCI)Content Hi All, We need to send/push a Fusion BIP Report using standard scheduler option…Kasinathan Palanikumar - Oracle-Oracle 61 views 1 comment 3 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service -
Date Prompt QuestionSummary As Of Date Prompt QueryContent Hi, I have a number of reports that use the SET VARIABLE PARAM_EFFECTIVE_DATE ='@{AsOfDate}'; that work correctly up to a certain …User_2025-02-05-22-44-35-842 54 views 28 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
YTD MTD QTD Balance reports for 401KSummary YTD MTD QTD Balance reports for 401KContent Hi Team, I heard that we do not have Time to date (YTD,MTD, YTD dimensions in OTBI. I have to fetch 5 YTD values for …SM-Oracle 92 views 3 comments 0 points Most recent by Lisa Ridgely-Oracle Reporting and Analytics for HCM