OTBI
Discussion List
-
Personal Payment Method HistorySummary How to find out if the Employee has Added, Updated or Deleted a Payment Method?Content Hi All, I am trying to build a Personal Payment Method History Report in w…User_2025-01-31-02-00-10-435 153 views 8 comments 1 point Most recent by Isabela Radivoi Reporting and Analytics for HCM -
We need to create one OTBI analysis to display current and previous year calendar for Learning.Summary: We need to create one OTBI analysis to display current and previous year calendar for Learning . How can we achieve this? Content (please ensure you mask any co…Piyal Basak 31 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
-
Which areas are affected when time zone is changed in the Manage Inventory Organization parametersWhich areas in the oracle fusion cloud are affected when time zone is changed in the Manage Inventory Organization parameters
-
Is there any seeded report for Payroll Analytics Initiative?Summary: Is there already Oracle seeded report for this? Content (please ensure you mask any confidential information): Version (include the version you are using, if ap…Cherry Carpo 21 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
Redwood - See all Email Interactions in a ReportAs an admin or sales manager, I want the ability to see all activities logged for customers. Prior to Redwood, an Activity Report could be leverage to see all activities…Amanda McAfee 61 views 14 comments 0 points Most recent by Amanda McAfee Reporting & Analytics for Sales
-
Employee information is blank in Expense-Transaction Real TimeThis is a question about OTBI Expense - Expense Transaction Real Time. When the status of a corporate card transaction is "Inactive Transaction", the employee informatio…
-
OTBI Report showing below error when we open through edit and result viewSummary: Hi Team, we have OTBI report but that report when we open through edit and in result view getting below error but when we open directly open button no error com…AjayKumar Maddipati 21 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Advantages and Disadvantages of OTBI seeded dashboardsI'd like to know how the seeded Line Manager Dashboard works when it was copied to the Custom folder. If Oracle made some changes on the seeded Line Manager Dashboard, d… -
Need Payable Invoice DeeplinkSummary: Need to know which Payable Invoice deeplink can be used in OTBI to show AP invoices related to POs Content (required): Version (include the version you are usin…Arunima Pandey 21 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
OTBI Data as of yesterdaySummary: Hi there, I am trying to use the historical reporting capability of OTBI by inputting the logical SQL prefix of SET VARIABLE PARAM_EFFECTIVE_DATE='xxxx-xx-xx'; …Ruby Hui 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Busting OTBI Myths - Cross Subject Area ReportingContent Myth: You can't report across subject areas in OTBI I'd hope that this is not a myth anymore, but just in case, yes you can report across subject areas in OTBI. …Julian Challenger-Oracle 224 views 7 comments 7 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Left Outer Join between the same tableHello, I am trying to get a list of all expense reports and populate the Expense Report History.Event Date only when the Event Status is a specific one. So I attempted t… -
How to align Prompt labelsI am trying to align the Date Between Prompt Labels as the ‘Please select dates’ and ‘Between’ labels not aligned at runtime. Prompt created based on Calendar date: the …
-
Any one help me on department change report old and new departmentsSummary: HI Team, could you please help me on we need old and new changed department report. Thanks, Ajay Content (please ensure you mask any confidential information): …AjayKumar Maddipati 102 views 20 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Report of 'Corrected Import Journals Errors'?Summary: We're looking for a report that shows us all interfaced journals that have been manually 'corrected' - is there a seeded Scheduled Process or OTBI report in Ora… -
Not able to see the EFF data in the doo_headers_eff_b tableSummary: We are creating some new sales orders from UI having some default values assigned to certain EFFs, but the EFFs values are not visible into the doo_headers_eff_…
-
How to auto release "Credit Check Hold" applied based on "Credit Hold" Flag at Customer MasterSummary: How to auto release Credit Hold applied based on "Credit Hold" Flag at Customer Master Content (please ensure you mask any confidential information): We have ma…
-
Purchasing Mapping Set Details tablesSummary: Hi , How Get Purchasing Mapping Sets Details tables to query it in OTBI report Content (please ensure you mask any confidential information): Version (include t…
-
How to export the Full Asset details in the existing systemSummary: How to export the Full Asset details in the existing system Content (please ensure you mask any confidential information): As a part of Data Migration, we have …Goopikrishnan Jayaraman-Oracle 11 views 1 comment 0 points Most recent by SRGogula-Oracle Maintenance -
Resource class in oracle project table nameI need any supporting query that includes resource class of project on task information level. For better understanding I am pasting screenshot. As per my understanding …
-
Data Archival & retention for HCM CloudSummary Data Archival & retention for HCM CloudContent we wanted to know you what would be recommended best strategy for Data Archival & retention for HCM Cloud & do we …Ranveer.Tiwari-Oracle 64 views 3 comments 3 points Most recent by Gretchen_Atienza Reporting and Analytics for HCM -
Default prompt values not workingGood morning, I created a dashboard prompt that filters the values based on a query and works fine but I'm struggling to set the default values. In fact, even if I set "…
-
Report agents are not working post 24B upgradeSummary: We did 24B upgrade on Saturday and several reports scheduled via agents were not delivered after the upgrade. Below are the observations so far; Some reports th…Ridma Karunanathan 31 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Can we use Pivot dynamically in BIPSummary: Hi Experts , We are having a requirement to convert rows to columns dynamically we used pivot to achieve this but by using pivot we need to hardcode values whic…Bhavani Rikkula 121 views 10 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Facing issue in Headcount by department hierarchySummary: My client wants to view the period end active headcount by level 2 and level 3 department hierarchy. I tried to achieve that using the below catalog attached bu…Shreya Datir 11 views 2 comments 0 points Most recent by Shreya Datir Reporting and Analytics for HCM
-
In OTBI, when I am using Subject Area, how can I generate XML for the dataI am trying to generate the report using OTBI for a particular subject area. What I want is that I should be able to generate XML of the data so that I can use this in B…
-
Login Data from Identity Domain in Reporting and AnalyticsHello, Does anyone know if it's possible for login data from Identity Domain to be displayed somehow in HCM? I've tried the "User System Usage" OTBI subject area, and I'…Nick Dorfner 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
View the results in the Absence Calendar Real Time Entry ReportI have followed guidance from the 22B document to 'Generate Daily Breakdown of Absence Details Process' and the outcome of this process is to 'View the results in the Ab…