OTBI
Discussion List
-
Send a system notification for all employeesSummary Send a system notification(Not an email) to all employees of their previous day attendance reportContent My requirement is , need to send a system notification t…Murugesu.V 39 views 3 comments 0 points Most recent by HarishVummidi Reporting and Analytics for HCM -
Project Costs and OTBI Report access to project accountant through project role instead of Job RoleSummary Does a user assigned as Project Accountant on a project gets access to costs work area and OTBI to access costs with out job role and data access?Content We only…User_2025-02-07-19-59-41-847 166 views 5 comments 0 points Most recent by Pradeep Balakrishnan Project Management -
Save file directly to oracle import and export folderSummary Save file directly to oracle import and export folderContent There is the possibility to save the file generated by Otbi in the Oracle import and export file pat…Leandro Vasconcelos 24 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
How to exctract the AddressId in OTBI (PersonAddress)?Content Hello experts, is there a way to extract the Person Address Id in OTBI? In case, do you have the SQL Query to extract the AddressId? Thanks in advance for your t…Valerio Curzi 34 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
OTBI - prefix for current date minus daysSummary How can I define prompt for an OTBI report which is the current date minus variable of daysContent Hi, I'm trying to create a prompt of number, so if the user wi… -
Analysis Total is Rounding to ThousandContent Hi Champions, I have created Headcount Analysis in my Custom Dashbaord ( Like Count(worker.person_number) to get exact number of employees working in a particula…User_2025-02-07-19-03-14-525 8 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Compound sort in OTBIContent Hi All, Is it possible to do Sort on 2 columns in OTBI? Ex. First Sort on BU and second sort on LE in same report. Thanks, VijayUser_2025-02-07-19-03-14-525 39 views 2 comments 1 point Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Getting Error When Click "Drill to Transaction Detail"Content Hi Experts, When I'm clicking on link "Drill to Transaction Detail" from HeadCount Analysis ( I copied it in my custom Dashbaord) I'm getting following error. Er…User_2025-02-07-19-03-14-525 32 views 3 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Is it possible to write a validation query against excel/csv data source in data model?Content I have created 2 data sets using excel and csv as data source. I want to write basic query to validate data from these files. Is it possible to validate excel da…Samir Patro 38 views 4 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Removing Nulls from Limited Dashboard PromptsSummary Limiting dashboard prompt by other values while removing the null optionContent Hello, I've created a dashboard prompt where we're trying to limit the values of …Rob F 37 views 3 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM -
Duplicate Manager Data Integrity ReportSummary Duplicate Manager Data Integrity Report not workingContent Hi All, We have a data integrity report that we would like some help troubleshooting. This report is i…User_2025-02-07-16-42-37-187 31 views 4 comments 0 points Most recent by User_2025-02-07-16-42-37-187 Reporting and Analytics for HCM
-
How to setup private key authentication with sFTPContent Hi all, I'm trying to setup a sFTP connection to a vendor using private key authentication. I'm being told that Oracle needs to have a password setup, but the ve…User_2025-02-05-20-24-10-848 37 views 1 comment 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
Is it possible to add the Business Unit to the email subject for holds invoicesSummary Is it possible to add the Business Unit to the email subject for holds invoicesContent Hi, The End user wants when receiving the email notifications for holds in…Mohamed jouini 44 views 1 comment 2 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
How to create a report that has all course assignments of learners along with the initiative wit whiSummary I could not find initiative name as part of Learning management real time subject area. Please suggest a way to get learning assignments along with initiative in… -
Printing the Entire Dashboard PageSummary Print the entire dashboard page on the My Team DashboardContent We have pushed out some dashboard reports for our end users. We have placed these reports on the …Shelly Feyerherm 66 views 4 comments 1 point Most recent by Shelly Feyerherm Reporting and Analytics for HCM -
Separate remittance advice format change to PDFSummary Changing the format of the SRA from HTML to PDFContent Hi All, Does any one of you know's how to change the format of the SRA to be in PDF when sent to supplier …Francis Thériault 52 views 5 comments 1 point Most recent by Lee Eslick-Huff Payables, Payments & Cash Management -
Report AuditSummary Report showing when a report was last ran and by whoContent Hi All, I thought I saw this on a webinar, but I don't really recall. Is there a report in OTBI that …
-
Combining Fields into one Column / Field in OTBIContent Hi, I'm looking to see if its possible to combine multiple fields / columns into one field / column? I currently have a report that brings back 5 fields / column…
-
View only to details and attachments of an Expense ReportSummary View only to details and attachments of an Expense ReportContent Hi, Can you tell me if the Advanced Financial Controls allow you to setup access to grant someon… -
Locate First Names that begin with Blank characterSummary Locate First Names that begin with Blank characterContent Can anyone please advise on the proper Function or CASE statement to use in an OTBI Analysis to locate … -
Repeated QC Taxes are getting added whenever we click on EDIT, to view the invoice detailsSummary Repeated QC Taxes are getting added whenever we click on EDIT, to view the invoice detailsContent Hi All, Created a invoice for QC tax in AP, the invoice is vali…
-
Free Tutorial Videos!Summary Video tutorials to help you be successfulContent The Cloud PLM Advanced Tutorials may provide the guidance you need when you need it. Here are some examples: * I…Kyle Topham-Oracle 32 views 0 comments 2 points Most recent by Kyle Topham-Oracle Product Master Data Management -
Vacant Position report with Last incumbentSummary Need a vacant position report with last incumbent detailsContent Hi Team I need a vacant position report with last incumbent details in OTBI, can you please let …User_2025-03-07-20-55-01-859 70 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Having problem with Manager Field in OTBISummary Having improper value of Managers in OTBIContent In our system we have two different manager type i.e. functional manager and one is matrix manager. Functional M…Soumya Goswami-Oracle 128 views 7 comments 1 point Most recent by Raymund Jerome Reporting and Analytics for HCM -
Transaction Administration Real Time Subject Area - ReportContent Hi all, I am using this subject area to create report to pull the data about the pending transactions, however, we don't see that it has a dimension to show who …SunnyJaiswal 57 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM