OTBI
Discussion List
-
Unable to view the Supplier 360 DashboardHi, During the Oracle demo demonstration session, Supplier 360 Dashboard was shown to us, however, we are unable to navigate to the same in our Test/Live instance. Suppl… -
SQL/OTBI query to get the Organization Payment Method and Payment sourcesSummary: SQL/OTBI query to get the Organization Payment Method and Payment sources Content (please ensure you mask any confidential information): We are looking a report…Visu 1.3K views 5 comments 0 points Most recent by GajavalliKoteswararao Reporting and Analytics for HCM -
Chinese cannot show Bold when use rtf template to pdfHi All, I tried to customize a report's rtf template but I found the Chinese in the report cannot show bold while English show bold. I followed the disucss Added Font Ma… -
From custom BI report Can we add 'From and To date' for seeing GL balances with backdated.Hi All, Business wanted to have one custom BI report for seeing GL balances and in that they want one parameter that is 'From and to date' to see the GL Balances with ba…Vasu N0897645321-Oracle 4 views 1 comment 0 points Most recent by Julien_Dubouis General Ledger & Intercompany -
Failed to get creation date for Landed cost in OTBI ReportSummary: I have developed an OTBI report for Landed Cost. I didn't get any field for creation date, is that anyway to get this field please Content (please ensure you ma… -
Unable to view the Procurement DashboardHi, During the Oracle demo demonstration session, Procurement Dashboard was shown to us, however, we are unable to navigate to the same in our Test/Live instance. Procur… -
Birthday reportSummary Birthday report worked exampleContent Hi there I have a requirement to create a birthday report, that can run two weeks before the employee birthday month. This …User_2025-02-04-15-07-59-505 479 views 22 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Expression: Project Currency error when using dashboard prompt for project cross subject area real tSummary Error Codes: OAMP2OPY:G689FFB3:SDKE4UTF Expression: Project CurrencyContent wonder if anyone encountered the same issue when developing a new OTBI report using p…Sam Solomun 123 views 6 comments 0 points Most recent by 'Yehia Zakaria Reporting and Analytics for ERP -
BIP Report or Dashboard for Data at Security Console with RolesHi Team, I am trying to create a report for the below columns using either Subject Area or SQL Query. Trying to mimic the page of the Security Console as well as include…Swapnil Kashid 56 views 6 comments 0 points Most recent by Iann hick Reporting and Analytics for HCM -
Which Subject Area/field provides "entry type" of payroll cost results?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… -
Historical report on positions held by active and inactive employee within a date rangeSummary: Looking for a historical report on positions held by active and inactive employee within a date range Content (please ensure you mask any confidential informati…M.Naing 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Matrix manager dimension in worker assignment real time subject areaHello Team, I have used attributes in matrix manager dimension of "Workforce Management - Worker Assignment Real Time" subject area to get all direct and indirect report…VMahesh 43 views 6 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI is repeating the same values for multiple records.Summary: OTBI is Repeating the same values for multiple records, Subject Area Receivables Journal Real Time and Transaction Real Time Content (please ensure you mask any… -
(Untitled)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… -
Unbilled Amounts in "Project Billing - Bill Transactions Real Time"Summary: We are attempting to recreate the billing dashboard provided in the feature update for this 23D subject area: Bill Transaction and Exception Analysis Using Orac… -
OTBI Talent Review Rating HistoryHello, I need to pull a historical record of Talent Review ratings. I know it's possible to pull Performance Document rating history, but I'm specifically being asked fo…Nick Dorfner 52 views 5 comments 0 points Most recent by Nick Dorfner Reporting and Analytics for HCM -
Dashboard on Development Area: hrr_tmpl_metric_configSummary: Goodmorning, we're fancing a problema with the Talent Review Matrix in the Dashboard Standard The matrix is empty: analyzing the query from the log, we've seen …AM HRE 12 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM -
Can I use responsive design when displaying BI?Can I use responsive design when displaying BI? -
Female turnover rates of DashboardI'd like to ask that if I select the Female as the Gender, how is the female turnover rates calculated? Is the denominator of the ratio in relation to all employees or o…Chen, Reyna 22 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Query to get ResourceOrganizationName of the userHi All, I am trying to extract resources/users with specific ResourceOrganizationName. I want to extract the ResourcePartyNumber and ResourceOrganizationName. Can you pl…Anj M. 19 views 1 comment 0 points Most recent by Topher Heath-Support-Oracle Reporting & Analytics for Sales -
course usage reportHello, I would like to create a report to see course usage to potentially achieve trainings that have not been used for a while. Any suggestions on how to create this re…Sara.Zhao 15 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM -
Time spent per approver in workflow approvalsSummary: We have a requirement to report out how long a specific workflow proves (Approve Job Requisition) remained with each approver within the workflow. Is there a re…Audrea Miller 16 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to Remove Duplicate Rows from Pivot table in OTBISummary: In excel - once you add the data to the row it makes it one to one - in OTBI how would I ensure there are no duplicated rows of data? Content (please ensure you…THawkins_LGI 117 views 10 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Intermittent Error with Custom OTBI ReportSummary: We are experiencing issues with one of our custom OTBI reports, which had been functioning perfectly until recently. Users have reported that the report intermi… -
Scheduling FTP report - How to schedule multiple reports with one job?Summary: Our purpose is to launch only one job for multiple reports Content (please ensure you mask any confidential information): Hello experts, We have a requirement t…Giuseppe Casalino 12 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM