Reporting on Change Records in Oracle HCM Using EXTRACTVALUE on XML_DATA_CACHE
Parsing contents of HRC_TXN_HEADER.XML_DATA_CACHE using EXTRACTVALUE to report on detailed change data captured during transactional events in Oracle HCM.
Details
Passing Multiple Values to a Parameter in Oracle BI Publisher
Oracle BI Publisher supports parameter types that allow users to make multiple selections, enhancing the flexibility and usability of reports.
Details
UKOUG Annual Conference 2024
Did you know most companies tap into just 30% of their data’s potential? Imagine unlocking 100%! Discover how to leverage your existing Oracle investment to build a powerful BI suite, transforming data into decisions with OTBI. Ready to maximize your analytics and ROI? Join us!
Details
Using SUBSTRING and LOCATE for Powerful Data Parsing
In OTBI, key flexfields codes are often stored as concatenated strings separated by dots or other delimiters. Extracting individual segments from these composite fields is essential for flexible reporting.
Details
Advised Solutions is a Crown Commercial Services Supplier
Advised Solutions is a trusted supplier for Crown Commercial Services (CCS), holding positions on the G-Cloud 14 framework. As a pre-approved supplier, we streamline the process for government departments to access our award-winning digital transformation services.
Details
Logical SQL for Cross-Subject Area Joins and Self-Joins
OTBI provides powerful ad-hoc reporting capabilities, but sometimes business requirements call for analyses that are not directly supported by the out-of-the-box subject area.
Details
HCM OTBI Effective Date Reporting in Oracle Cloud
Leverage the parameter PARAM_EFFECTIVE_DATE for effective tracking of headcount, employee movements, and key business metrics.
Details
Using @INLINES in your BI Publisher RTF Template
BI Publisher RTF templates support powerful markup commands to control data rendering, formatting, and logic in output documents. One advanced command is @INLINES
Details
Ascend 2024 Las Vegas
Ascend is the Oracle user community event that unites functional users, IT professionals, and experts for frank discussion and practical education. Attend Ascend to find inspiration and insight to elevate your Oracle experience.
Presented by the Oracle Applications & Technology Users Group (OATUG) and Oracle HCM Users Group (OHUG), Ascend delivers reliable insights, time-and-money-saving strategies, and valuable opportunities to connect with the global user community.
Details
“[nQSError: 27047] Nonexistent table” when Querying a PVO
When querying Public View Objects (PVO), developers can encounter the dreaded error: text[nQSError: 27047] Nonexistent table: “TABLE_NAME”
Details