OTBI
Discussion List
-
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.…AjayKumar Maddipati 21 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.7K 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 51 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 103 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 118 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 188 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 73 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… -
How to improve the performance of OTBI dashboards and reportContent Hi, We have created a custom dashboard. And few reports are taking long time to respond. Can someone tell me how can I improve the performance of Dashboards and …Nivya Mathire 86 views 12 comments 0 points Most recent by Rizwan Basha Reporting and Analytics for HCM -
Some users cannot see infolet tab pages under AnalyticsSummary: Under Analytics, Although some users can see a few infolets, why are they not able to see infolet tab pages like General Accounting Infolets, Service Infolets, …
-
Not showing data in OTBI for other line manager type, how can we fix this?Summary: Right now, individuals with the manager type "Cross-Functional Manager" can't access any data about their direct reports in OTBI. The UI is behaving correctly; …Martijn van den Berg 21 views 2 comments 0 points Most recent by Martijn van den Berg Reporting and Analytics for HCM -
Request for Documentation on Fields Match for XML Document in IBY_TRXN_DOCUMENTS TableSummary: Hello, My team I are working on an H2H implementation for a client using the Oracle ERP Cloud system. As part of this implementation, I need to understand the s…Arturo Contreras 211 views 2 comments 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management -
Round to nearest 0.5 decimalSummary: Leave balance in hours, converted to days to 2 decimal points. Content (required): My formula is FLOOR("Front-Loaded Plan"."Accrual Balance"/7.4) however for so…Dawn Cawston - CPS 81 views 4 comments 0 points Most recent by Narendar Rao Naineni Reporting and Analytics for HCM
-
showing data based on the selected candidate in analysis added to offer screenSummary: We have analysis added to offer screen and we want to get data based on selected candidate so we need binding variable to take candidate number from the screen …Salma Mohamed Salem 21 views 1 comment 0 points Most recent by Alexandru C. -Oracle Reporting and Analytics for HCM
-
Control Budget UploadSummary: Control Budget Upload Content (please ensure you mask any confidential information): At the start of the Financial year, the budget from planning was not transf…
-
In which table is the "Resource Management" data stored?Which table stores the data displayed in Manage Resources search results? I want to retrieve these data with SQL. Path::Setup and Maintenance>Financials: Resources>Manag…REI TSUKAHAR-Oracle 277 views 1 comment 0 points Most recent by Shivashish Dwivedi-Oracle Project Management
-
What is the database field/column for PO Charge Account?Summary: Our client would like the PO Charge account/distribution to appear on the PO PDF template. We did not find it in the seeded data model, which means we would nee…Farah Zekria 11 views 1 comment 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing -
Unable to extract internal requisitions through requisition subject areaSummary: Want to retrieve the internal requsitions raised from the subject area Content (please ensure you mask any confidential information): When extracted, i am getti… -
Report Payables withholding tax and accountsSummary: Hello, We would like to know if there is a report to support the Payables withholding tax invoices and Tax Accounts Content (please ensure you mask any confiden…usr_a.nv 21 views 2 comments 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management
-
Do we have option to have multiple sheet in OTBI extractSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…