OTBI
Discussion List
-
How to use outer join in OTBI AnalysisContent Hi All, I am using Worker Assignment Real Time Subject area and i have to pull only the person who has home phone number . The person who don't have home phone n…User_2025-02-04-18-22-33-673 1.6K views 5 comments 1 point Most recent by RajaPalli Reporting and Analytics for HCM -
Employee displays in analysis for indirect leader they no longer report up toSummary: We've kicked off our workforce compensation cycle. I have an employee who changed managers earlier this year. The indirect manager they previously reported to i…Susan Anderson 21 views 2 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
NOT ALL ROLES are covered in Fusion Report "User and Role Access Audit Report"Hi everyone, just a question regarding the Scheduled Process: "User and Role Access Audit Report", do you know why some roles are not included in this report? ie "Applic…Lia Naga 96 views 1 comment 1 point Most recent by Cătălin Hurjui-Support-Oracle Reporting & Analytics for Fusion Service -
OTBI-How to combine Requisition other locations into one fieldSummary: I have created an OTBI report ( Subject Area :Recruiting -Recruiting Real Time) , and the Requisition Other Locations are displayed in multiple lines in output …
-
Active Candidate Pools OTBISummary: Dear Community, We would like to create an indicator that counts all active candidate pools within our system. However, while exploring the Recruiting - Recruit…Giuseppe Iacono 2 21 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
OTBI report for finding position wise incumbants including candidates with Job offersSummary: We are looking for an OTBI report to fetch all incumbents of a given position along with candidates with active Job offers already given. This report will help …Pavan Kumar Thummalapalli 210 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
if we can run an OTBI report that shows when a password has been reset as well as an email updated?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Chandra Rao.D 23 views 2 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
Can someone please help, on where to find this value in oracle Tables?Hello can someone please help on where to find this field on HCM Table and Views? UI Navigation is Benefit Administration> Plan Configuration> Rates and Coverages> Varia…Joliver Caangay 11 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
What is Public View Objects (PVO) and where can we use it?Summary: What is Public View Objects (PVO) and where can we use it? Can it be used in Data model for BI Publisher report? Also, can we see the SQL or logic behind this P…Karun Jain-Oracle 5.9K views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
On-hand quantity on a historical dateContent We have a requirement where we need to get the inventory on-hand quantities of items by day @ 11:59:59pm since Jan 1, 2021. Is there a standard report that can b…User_2025-02-11-12-16-08-273 706 views 3 comments 2 points Most recent by Becca Edwards Inventory Management
-
The document column in table IBY_TRXN_DOCUMENTS is not displaying correctlySummary: The document column in table IBY_TRXN_DOCUMENTS is not displaying correctly in a way that allows us to see the hierarchy of each payment detail by payee, payer,…DahliaG 91 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Search User Analysis Reports OTBIWe have over 500 User Analysis reports that we use with initiatives to do systematic assignments for our courses, based on certain criteria. Common criteria are Job Code… -
Withdrawal Type - ReportingDoes anyone know if it is possible to report on this field?: I am looking in OTBI and not finding a field for withdrawal type, but it is in the learning UI(My Client gro…
-
Learning Content reportingSummary We could not find information on Learning content in OTBIContent Hi Team, Could you please help us to find in OTBI the information listed in these tables: wlf_li… -
OTBI which column is appropriate for only showing the Depreciation account code of AFFSubject Area: Asset Depreciation Real Time The Depreciation Account column displays not only depreciation accounts but also accumulated depreciation accounts. The column… -
Need Join Condition column for tablesSummary: Hi team, I have two tables to join hrc_dl_message_lines hdml and HR_ALL_POSITIONS, where i need position code from HR_ALL_POSITIONS table by joining with below …
-
How to group by formatted date column AnalysisSummary: Hi, we create analysis to count PO created yearly, so create Analysis include bill-to-location, creation date columns ,we want to group by bill-to-location, cre…
-
table name to fetch 'Write to person profile on completion' In learningSummary: Which table stores information about the Field 'Write to person profile on completion' In learning Navigation :- Course ->Skills and qualification -> manage -> …Shubham Wadekar-Oracle 2 views 0 comments 0 points Most recent by Shubham Wadekar-Oracle Reporting and Analytics for HCM
-
how to get the Annualized salary of terminated employeesSummary: I just need basic details like thePerson number, Name etc of terminated employees with their annual salary. How do I get this in the OTBI report ? Content (plea…Trupti Khodke 42 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Recruiting Offer > Message Notification OTBI FieldGood Day Experts, Is the 'Message Text' field in recruiting module in fusion available in OTBI Recruiting Real Time subject area? Navigation from fusion is Offer > Actio…
-
We need to update the #average headcount, #leavers, period start and period end headcount with OTBIWe need to Modify headcount columns in an Annual Turnover dashboard page. We need to update/review the #average headcount, #leavers, period start headcount, and period e…BHAVANA SINGH 22 views 0 comments 1 point Most recent by BHAVANA SINGH Reporting and Analytics for HCM
-
Task Type in Subject Area Workforce Management - Checklist Real Time - Checklist Task TemplateSummary: 1- Looking for the Task Type in the Subject Area Workforce Management - Checklist Real Time. This is to pull the configured task type for various tasks in the j… -
ESS Jobs DashboardSummary: ESS Jobs Dashboard Content (please ensure you mask any confidential information): Hi Team, Greetings! As you know -we submit/schedule multiple ESS jobs. Is ther…Parag Hiremath 382 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Pricelist FBDI Success and Error SQLSummary: Pricelist FBDI Success and Error SQL Content (please ensure you mask any confidential information): We are using FBDI for Pricelist Upload. Is there a SQL avail…
-
How to show 0 value instead of null value in a calculated formula column in OTBI report?Summary: How to show zero value instead of null value in a calculated formula column in OTBI report Content (required): I have a column 'Variance' which has value that i…Abhishek Shukla 1.2K views 6 comments 0 points Most recent by Pooja_hb-Oracle Reporting and Analytics for ERP -
How do I write a number in full in the report?Summary: I need to write the salary amount in full, for example, R$ 1,000.00 (one thousand dollars). I know it's possible using a PL/SQL function, but I couldn't do it i…Simiao Oliveira 11 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM