OTBI
Discussion List
-
how to check Invoice is Accounted or not in Invoice Header Table AP_inovices_AllSummary: how to check Invoice is Accounted or not in Invoice Header Table AP_inovices_All Content (required): Business wants to see the list of invoices in BI Report whe… -
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 942 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 https://commu… -
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 1 view 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…
-
Report on Parent Position's Current Incumbent when Position is vacantContent We need a way to report on the parent position's current incumbent when the position itself is vacant. The report that we created shows the incumbent name for bo…Joanne Chung 484 views 13 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
In Cash Management OTBI, is it possible to get the transactions reconcilied to a statement line?Summary: On the Manual Reconciliation Cash Management page, it is possible to see which system transactions (AP, AR, etc) are reconciled to a given bank statement line. …User_2025-02-11-06-12-35-024 201 views 3 comments 5 points Most recent by John Ban Reporting and Analytics for ERP -
OTBI Dashboard Reverted to Old UISummary: Hi team, We have a dashboard that has reverted to an older UI in both Test and Production environments. However, the same dashboard in DEV looks fine and retain…Josel Pleyto 111 views 3 comments 0 points Most recent by Josel Pleyto Reporting and Analytics for HCM
-
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 472 views 22 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can we assign bulk roles to user accounts ( not employees)Summary: Hello All, Can we bulk assign roles to users those are not employees in fusion? Content (please ensure you mask any confidential information): Version (include … -
How to extract person images in .jpg format from Oracle HCM Cloud?Content I have a requirement to extract the person images from the Oracle HCM Cloud in the .jpg format. Please can anyone guide on this. -
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 121 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 51 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 1 view 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 42 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 51 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 11 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…
-
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 21 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM