OTBI
Discussion List
-
Is it possible to have conditional Display of report parameters on the basis of value in other paramSummary Is it possible to have conditional Display of report parameters on the basis of value in other parameter ?Content Hi Experts, Is it possible to have conditional …Abhishek Sood HCM 211 views 6 comments 1 point Most recent by Abhishek Sood HCM Reporting and Analytics for HCM -
OTBI Dashboard prompt defaultContent I have an OTBI dashboard prompt that I want to default to the current logged in user. However, the session (server) DISPLAYNAME value is in a different format an…User_2025-01-23-21-24-21-434 74 views 5 comments 2 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to locate documents in someone queue for approval and then reassign them to someone elseContent There are few POs sent to the user for approval and the user is not available to approve them. They are pending his approval so how to identify them and reassign… -
HCM Cloud - OSHA ReportsSummary Looking for documentation (HCM Cloud) on 300, 300a and 301Content I cannot find any configuration documentation related to these reports. Can someone please dire…David Zajac 41 views 2 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
BI publisher SQL for finding users who are active in the security console but terminated in the applContent Hi experts, We have found an issue where sometimes when an employee is terminated in HCM they are still showing as an active user in the security console. To res… -
Column Formatting for hashtag resultsContent Hi all, I'm hoping the request I'm asking is relatively simple to do. We have an OTBI report that when run within OTBI, displays date values as '00/00/0' but whe…MikeW 43 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Include Unbilled PPM invoices in Available Credit CheckContent Our client woul like to leverage the Credit Management module, however they are having difficulties with the available credit calculation. The available credit o…Suzette Dixon 51 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Receivables & Collections -
Trial Balance ReportSummary Trial Balance Report in multiple currenciesContent Hello team, Are there any steps on how to create/customize a trial balance report in order to show local and f…Alex121-Oracle 76 views 1 comment 1 point Most recent by Anca A-Oracle General Ledger & Intercompany -
How to derive 'Price' and 'Values' from multiple Price ListsSummary How to derive 'Price' and 'Values' from multiple Price ListsContent We've multiple Price Lists defined in our system. For same Organization/BU, we've different P…Omkar Panda-Oracle 85 views 9 comments 1 point Most recent by SilviaCosentino-Oracle Supply Chain Planning and Collaboration -
What roles are needed to access the BI Data modelContent Hi, I created a custom role and assigned the roles: BI Administrator Role BI Applications Administrator Duty BI Applications Functional Developer Duty BI Publish…Valdir Dutra 71 views 3 comments 0 points Most recent by Valdir Dutra Reporting & Analytics for Sales -
OTBI Elements Report is not Pulling in All ElementsContent I've built a simple OTBI report for Retirement Deductions and Matching Contributions. My company has 401K, 403B, and 457 Retirement Plans. So, I've filtered for …User_2025-02-11-07-08-23-440 49 views 1 comment 1 point Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Pay Code / Element Mapping to General LedgerContent Is there a Subject Matter Area which permits you to build an OTBI report of the Pay Codes and the GL Coding or Concatenate Segment associated with the specific P…User_2025-02-11-07-08-23-440 100 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Dealing with Initiatives linked to an OTBI analysis during Oracle updateContent Hi thereI will have an initiative linked to OTBI report. If for any reason in an Oracle update there is a change in the column names and I need to redo the OTBI … -
Activities and Related Activities ReportingContent In 21C, OTBI CX delivered a new subject area "CRM - CRM Activities with Related Activities". This subject area allows users to report on all activities with rela…User743281-Oracle 42 views 1 comment 3 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
Project task Exceptions-PPM Tables/ViewSummary Looking for Project Task Exceptions information in DBContent Hi All, I am looking for information about Project task exceptions data in PPM tables Or BI report t…
-
How to convert 100 Public Shopping List from DEV to TestSummary How to convert 100 Public Shopping List from DEV to TestContent Hi, I want to know if there is a way to convert 100 PSL from DEV to Test, or if there is a way to…User_08YER 20 views 2 comments 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement -
OTBI Agent to send one email for each recordSummary OTBI Agent is sending the entire report to the recipientsContent Hello Everyone, I need some help. We are trying to implement a mail merge that will be triggered…Alvaro Couto 160 views 12 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Cash Flow Statement-Indirect Method ?Summary Cash Flow Statement-Indirect Method ?Content Hello The company needs a Cash Flow statement Report, hence first at all we reviewed the cash management reports and…gabriel kinovisques-163562 99 views 2 comments 1 point Most recent by Vaishnavi Aryasomayajula-Oracle General Ledger & Intercompany -
How to add more descriptive flexfields in Business UnitsSummary How to add more descriptive flexfields in Business UnitsContent Hi We would like to ask if there is a way to add more descriptive flexfields in Business Units? T…User_2025-02-11-12-30-38-982 34 views 1 comment 0 points Most recent by Vaishnavi Aryasomayajula-Oracle Reporting and Analytics for ERP -
Unable to Create Cross Subject Area Report for Succession - Incumbent Plans x Candidate DetailsSummary Unable to Create Cross Subject Area Report for Succession - Incumbent Plans x Candidate DetailsContent As we are preparing for Talent Reviews, I have been trying…User_2025-02-08-03-57-26-191 31 views 8 comments 0 points Most recent by User_2025-02-08-03-57-26-191 Reporting and Analytics for HCM -
Mass update "Public item flag" on items in Private Item ClassSummary We are in the strange position that our Item Classes are all private but the items within the private classes are shown as "Public". We now need to disable the p…Mark Hartenberg 41 views 4 comments 0 points Most recent by Mark Hartenberg Product Master Data Management