OTBI
Discussion List
-
How to use Listagg functionality in OTBI AnalysisSummary Listagg in OTBI reportsContent Hi Team, Listagg function in OBIEE reports is used to display multiple lov's in a a single row with (,)separator. How can we achie…Kalyani Koylada 1.1K views 8 comments 0 points Most recent by Tonya H Reporting and Analytics for HCM -
Only display the row with the earliest seniority dateSummary: Hi I'm creating a basic staff list which has seniority date on (some of our staff have protected service from a previous company) and I need to be able to show …HRJon 45 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
how to get latest anniversary seniorSummary: How to get the most recent date to show on an employee transaction Content (please ensure you mask any confidential information): In OTBI, using the subject 'Wo…EllieG 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there a way to automatically trigger a scheduled job if it encounters failure on scheduled run?Summary: We have one file that was not sent to SFTP location as there is a connection issue in the SFTP as there is an emergency change in SFTP. In Oracle BI Publisher, …Cristelle Rose Sampang 83 views 3 comments 0 points Most recent by Narula Shray Reporting & Analytics for Sales
-
How to add the EEO 4 field from Job to a OTBI report?Summary: Adding EEO 4 field to a OTBI report Content (required): Hello - how can you add the EEO 4 field to a OTBI report? I am able to locate the EEO-1 field but not EE…Jbow 54 views 1 comment 0 points Most recent by Shashank Priyadarshi - Oracle-Oracle Reporting and Analytics for HCM
-
Payroll - Calculation Cards Real TimeContent Good Morning, We are trying to find granular details with regards to Pension details. On the front end we can see in a sub-folder called 'Calculation Component D…User_2025-01-28-07-12-45-467 198 views 7 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Receipt Adjustments ReportHi, Please let me know if we have any report to see Receipt Adjustments (Return To Vendor and corrections transactions) by REQ or PO (something like Receipt Adjustments …
-
Report to get employee default expense accountSummary Report to get employee default expense accountContent Hi is there any report which can get what is the default expense account attached the employee please? this…User_2025-01-29-02-09-34-137 103 views 13 comments 1 point Most recent by Isabela Radivoi Reporting and Analytics for HCM
-
How to export OTBI Dashboard Section Permission?Summary: I am looking for an option to export the permissions granted at each section level. Is this possible? I attached the screenshots. I appreciate your help. thanks…SantoshKumarBhairi 17 views 1 comment 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
General help -> Unable to access oracle.comSummary Unable to access oracle.comContent hello, Is anyone facing this type of issue? I am unable to access any site within oracle.com. Nothing changed in my browsers a…SantoshKumarBhairi 275 views 7 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
It is possible to add an additional is column in the Bank Statement Transactions dashboardSummary: There is a native cash management dashboard that shows bank statement lines, their status and other information. It is required that an additional column be add…Cezar Mata 93 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Payables, Payments & Cash Management
-
Value as columnTeam, The timecard layout has been configured and there is a custom attribute created like below. PROJ_FUNCTION - AttributeVarchar1 We have got the above details from on…
-
How do you add a parameter to a seeded data modelSummary: How do you add a new parameter to a seeded data model? Content (please ensure you mask any confidential information): Version (include the version you are using…CarmenR. 21 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
In past we get all questions from prescreen questions report but now two questions missing ?Summary: HI Team, In past we get all questions from prescreen questions report but now two questions missing ? any refrence and help me on . Please find issued SQL file.…Maddipati Ajay Kumar 22 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Representing the data in graphs using custom formulas and logics in OTBI Dashboard.Summary: Representing the data in graphs using custom formulas and logics in OTBI Dashboard. We have a requirement to create a graphs in OTBI using the Absence Balances,…Bhukya Vamsi Naik 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Report to get list of users who are lockedSummary I need to get a list of locked user accountsContent I looked at the 'Reporting on Application Users and Roles' section the Oracle documentation, but none of thos…David Villegas 1.9K views 17 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How do you retrieve Payroll Relationship Close date into report in OTBI?Summary: Content (required): Looking to include close date off the payroll relationship field into an OTBI analysis report, I have looked at a few subject areas but this…
-
What Table is the Miscellaneous Receipt Distribution Comment located in?Summary: I am trying to get the comments entered on our Misc Receipt Distributions to come through in an Analysis or Report. Content (please ensure you mask any confiden…Kristina P - National Heritage Academies 71 views 4 comments 0 points Most recent by Madhavi.Godbole Receivables & Collections -
Is there a way to show only data for a user that is running a dashboard?Summary: I have created a dashboard for several reports. It shows the user that last updated a record. Is it possible for the user that runs the dashboard to show only r… -
OTBI Report Source System Item Real TimeSummary: When i join Item Number and one of my EFF attribute in Product table i am getting one extra row in EFF table which is all blank. Do you know what might be the i…Ankit Shah 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
We can able to load the data in User-Defined Table Business objects but not able to see in frontSummary: We can able to load the HDL data but we can't able to see the data but in backend we can able to see the data. Note: If we entered manually in UDT then we can s…Ravindr-Oracle 143 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
To check if the requisition has Suspended state completion eventsHi, We had an issue in FAW, where for some requisition the suspended completion duration is missing. While debugging this issue, we are trying replicate the same in FA, …
-
Help with Case Statement using Payroll - Payroll Run Results Real Time OTBI Subject AreaSummary: I'm looking for help with a Case Statement using Payroll - Payroll Run Results Real Time OTBI Subject Area. Content (please ensure you mask any confidential inf…
-
Bring back Headcount Data from 12 months agoSummary I want headcount data from 12 months agoContent I have a simple report that sums headcount up and gives me numbers for today however I want to return the numbers…User_2025-01-29-21-02-12-466 115 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Enabling HCM seeded Infolets in R11Summary We are in R11 and trying to enable Infolets by creating a Sandbox > Structures > Set system options and enable InfoletsContent We are in R11 and trying to enable…GopiKAutomus 198 views 4 comments 4 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report for Non-Catalog Item Information HelpSummary: We put in non-catalog learnings that we need to report on what information is being presented. Can someone help me with the selections to create this report, I …
-
How to make hyper link in one of the column values in BIP reportSummary: I have to establish link between MEANING Column values to the respective bip report . Thanks For Your Help!! RavindraRavindr-Oracle 191 views 3 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
OTBI analysis using costing - receipt accounting real time concatenated segments not showing dataOTBI analysis using "costing - receipt accounting real time" concatenated segments not showing data when any other fields is added to the report.Assem Khaled 1 view 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
BPFM hierarchya in OTBISummary:Hi , I would like to fetch the BPFM details from OTBI report These details are necessary for Business Thanks Content (please ensure you mask any confidential inf…