OTBI
Discussion List
-
Meaning of Invoice Hold Notification ContentSummary: The Invoice Hold Notification has the PO Number, Invoice Line Number. I am not sure what is the "1" Content (please ensure you mask any confidential information…Pablo Schenquerman 1 view 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Reporting on withdrawn absencesSummary Is it possible to report approved and withdrawn absence bookings in OTBI?Content We have a requirement to start reporting on absences which have been withdrawn b…Elizabeth Docherty 330 views 25 comments 0 points Most recent by ZeyadAbdullaMohamed Reporting and Analytics for HCM -
OTBI results in errors saying "The specified criteria didn't result in any data."Summary: OTBI results in errors below Error Message : The specified criteria didn't result in any data. This is often caused by applying filters and/or selection steps t… -
How to return specified run result values on one row in Payroll Run ResultsSummary: Without using a pivot table, how can I get payroll run results to show input value names as the column headers, then the relevant run result values horizontally… -
Impact in the reports/dashboards after enabling RedwoodHave you encountered any issues with Reports/Dashboards after enabling Redwood across the HCM modules? Is there any documentation or impact analysis available for this? -
I want more than 2 prompt input lines in OTBI.Summary: I want more than 2 prompt input lines in OTBI. Content (please ensure you mask any confidential information): When a graph is created in OTBI, the value list is…User_53LLL 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Reporting Agent failed with error message SQLSetStmtAttrWSummary: We have reporting agents set up which all ran into error, when normally no issues. Content (please ensure you mask any confidential information): We have report…Max W 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
OTBI Analysis reports giving different set of data in fusionSummary: Hi Team, The OTBI report giving different set of data in fusion for different users, we checked the roles both users have the same roles but still difference in… -
Get list of all BI Publisher reports that use a specific data modelSummary: Is there a way in BI Publisher to get a list of all BI reports that are using xyz data model as the DM, in order to understand the impact of making changes to a…Shant_Sarkissian_WJG 676 views 7 comments 0 points Most recent by ManavM Reporting and Analytics for HCM -
OTBI Standard Subject Area with Custom Subject AreaSummary: Hi Team, I have a requirement where i need to add a custom object column mapped to a dynamic field to the OTBI report built using standard subject area. when i … -
Calculate number of DAYS between two dates in XX YEARS XX MONTHS XX DAYS format in OTBISummary: We have a requirement in OTBI analysis to calculate the number of days between 2 dates in the following format – XX YEARS XX MONTHS XX DAYS. We have tried some …Balakumar231286 61 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
release statement to workerSummary: We would like to report on the field " release statement to worker" to check how many Line Managers have enabled this for their direct reports once comp cycle i…Manoj B. Cheruvathoor 1 view 3 comments 0 points Most recent by Saliha MAACHA Reporting and Analytics for HCM -
How to Resync Arabic Hijrah Calendar in Oracle FusionWe are experiencing discrepancies in the dates within Oracle Fusion, specifically with the 'Arabic Hijrah calendar'. leading to issues with reports using Hijri Date. The…KirolosMagdy 118 views 2 comments 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Can you help me to adding the name of the employee in this SQL query?Summary: Hello team! I have this code, but I don't know how to add the name of the employee. Could you please help me with that? Content (please ensure you mask any conf…Claudia Linares L 21 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Busting with OTBI as DataSource in a DatamodelSummary Error on Busting with OTBI as DataSource in a DatamodelContent Hi All, I am trying to use a OTBI Analysis/OBIEE sql as a source in a BI Datamodel. The Bursting i…User_2025-01-22-19-45-49-284 53 views 2 comments 0 points Most recent by Asif_T Reporting and Analytics for HCM -
How to display new EFFs in BI reports?Summary: I have made new EFFs in PIM to see datas in BI reports. So I marked the BI Enabled check-box from setup and maintenance, but still cannot display them in the re…Nano Kanazawa 41 views 4 comments 0 points Most recent by Nathaniel.Wilcox Product Master Data Management -
OTBISummary: Hello Everyone, Unable to access OTBI reports data, able to access BI reports using her current roles Thanks Krishna Content (please ensure you mask any confide…Krishna Sigilipalli 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Does User Interface Text affect OTBI/Notification labels?Summary: I'd like to confirm the range of impact when using the User Interface Text. Does it also affect the field names of OTBI or workflow notifications?Kana Kutsukake-Oracle 11 views 2 comments 0 points Most recent by Kana Kutsukake-Oracle Self Service Procurement -
BI Publisher Pivot Table Limit/Configuration of able to add only 5 columnsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…S Javir 21 views 3 comments 0 points Most recent by Thulasipriya K-Oracle Reporting and Analytics for ERP -
SQL Query to identify transactions stuck in Pending interface to costingSummary: Users had done Cycle Count Adjustment and before the transactions could get accounted the items were made 'Inactive' this was done across organization in past p…Rahul_M8SG8 501 views 6 comments 0 points Most recent by Manikandan S R-Support Oracle-Oracle Costing -
Roles and Privileges ReportHi, Can you please help me to develop a report that lists all the privileges for all roles (including both predefined & custom roles) in Fusion? Something like this: Rol… -
Arabic Text in PDF Output Not Bold and Font Does Not ChangeSummary: Hello everyone, I am facing an issue with generating PDF output where the Arabic text does not appear in bold, and the font does not change as expected. • The b…