OTBI
Discussion List
-
How to get the position level of a position from the top using OTBISummary: We have a requirement to get the position level of a position from the top. eg: CEO is the top position and should be at level 1, 2 directors reporting to CEO s… -
Extract Assessment detailsSummary: I need to extract the questions and answers and the answer score per assessment. I can not find this in OTBI. I only per user by using the task score. Has anyon… -
What is the PVO for Item Descriptive FlexfieldsContent: Once DFFs for Items (EGP_SYSTEM_ITEMS_DFF) are "BI enabled" and deployed, what is the associated PVO that can be used in BICC to extract those Flexfield values …User_BEGVH 201 views 3 comments 0 points Most recent by Marc Vermeulen Reporting and Analytics for SCM -
OTBI - Talent Review - Holding AreaSummary: Not everyone are placed in a box assignment, some are in the holding area. Content (required): Subject area doesn't seem to have a Holding Area field. I need to…Ratha Sun 31 views 1 comment 0 points Most recent by Nancy Lang-Oracle Reporting and Analytics for HCM -
Talent Profile: How can I make CLOB fields visible in a report?Summary: Talent Profile: How to make Job responsibility, - description and - qualifications visible in an analysis? Content (required): Dear all I need to create a repor…Matthias Essrich 71 views 4 comments 0 points Most recent by David Pham-Oracle Reporting and Analytics for HCM -
Entity Relationship Diagram between ALL PVOs in Fusion HCM ModulesSummary: Entity Relationship Diagram between ALL PVOs in Fusion HCM Modules Content (required): Dear all - can we get ERDs for All PVOs from different HCM Modules from O…Nilanjan Biswas-Oracle 956 views 2 comments 4 points Most recent by Nilanjan Biswas-Oracle Reporting and Analytics for HCM -
Display Employee information as per attached imageHi All, I have developed an OTBI analysis to get employee emergency information. The requirement is to display the data pulled from the Emergency info OTBI report simila…Aditya Jadhav 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Deeplinks - How to use the return variable ?Summary: Deeplinks - How to use the return variable ? Content (required): Hello, I use this deeplink : ../fscmUI/faces/deeplink?objType=PURCHASE_ORDER_APUSER&objKey=poHe… -
Expose Billing Instructions field (Bill Plan) in AR Transactions UISummary: We have a global customer with each region using different invoice templates. I'm hoping to populate AR Invoice Template in the "Billing Instructions" field so …Raj Mohanraju FRNT 21 views 1 comment 0 points Most recent by Zaheer Ahmed-Oracle Project Management -
How to retrieve data from GL Cube?Summary: How to retrieve data from GL Cube? Content (required): The link below provides some information about the GL Cube (Overview of Oracle General Ledger Balances Cu…RS_CSAA 224 views 4 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
Oracle Seeded report for Oracle learning for Admin and Line managersSummary: Oracle Seeded report for Oracle learning for Admin and Line managers Content (required): Any reports available for LM or HR where they can view who has done wha… -
Track IP AddressContent Hi All, Is there any way to track IP Address of the user who has made changes and accessing fusion system? Thanks, Visu -
we have issue in OTBI report CANDIDATE REJECTION REASONS but we miss the latest records in scheduleSummary: Hi Team, we have OTBI report thta is CANDIDATE REJECTION REASONS report for particular country when we schedule the report it's fecthing(Candidate Job Applicati…AjayKumar Maddipati 61 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
How can we get the IP Address of a candidate after they have completed a Journey Checklist Task?Summary: Content (required): I need to get the IP Address for a person who has completed a checklist task. I understand that there is IP Address stored in IRC_CHECKLIST_…User_2025-07-18-13-29-11-469 73 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Unable to restrict results with workschedule filters when it is blank or non primarySummary: Issue: There are multiple subject areas combined together to generate results which is embedded in dashboard. A new change has been requested to include employe…Sowdha Murugan 31 views 7 comments 0 points Most recent by Sowdha Murugan Reporting and Analytics for HCM -
How can we hide edit link on analysis?Summary: Content (required): How can we hide edit link on analysis. I know how to do this from a dashboard by using the page report links but how can we achieve this fro… -
How to get - when the employee was created in the applicationSummary: Hi Everyone! Is there any way via (BIP/OTBI) to fetch when the employee was created in the application ? Version (include the version you are using, if applicab…ShawShankk 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Create OBTI Analysis for Learning to be automatically assigned to New Hires so many days in.Summary: We would like to start assigning initiatives or courses (whichever will work best) to New Hires within the following days into their job: Upon Hire with 7 days … -
Do we have subject area to develop OTBI report for EDI related attributes:Summary: We want to create one OTBI report with below sample: Supplier Name Supplier Site Supplier Number EDI documents Name enabled for this Supplier site Content (requ… -
how to query for this attributes from which table we can get these attributesSummary: Content (required): We want to fetch blended instructor led and self paced from bip query Versio n (include the version you are using, if applicable): Code Snip… -
Helen Tilling 11 views 5 comments 0 points Most recent by Helen Tilling Reporting and Analytics for HCM -
Costs for goods sold was not available in analyze product gross margin reportSummary Costs for goods sold was not available in analyze product gross margin reportContent Hi Costs for goods sold was not available in analyze product gross margin re… -
Is there any reason why OTBI analysis report is not able to fetch details of some supply plans?Summary: In our case, in production environment, we have 2 supply plans and in both of them "Enable for OTBI reporting" is "checked" but our OTBI analysis report is able…Soumya_Gharei 31 views 1 comment 0 points Most recent by Prateek_16-Oracle Supply Chain Planning and Collaboration -
Error when Combine 2 Subject AreasSummary: Hi All, I am trying to create an OTBI analysis by merging 2 Subject Areas: Worker Assignment Real Time and Person Real Time. The report will display employee wo… -
Show all Lines in Report ExportSummary: I have a large OTBI report that I need to export, and I need it to show all lines. Usually I just change the Data Viewing under Table Properties to Content Pagi… -
Audit Report using BIP and shadow tables for Assignment ChangesSummary: Looking for a custom BIP report query for Audit purpose using shadow tables. Content (required): We enabled the Audit for multiple products using the task 'Mana… -
Facing issue in performance goal dashboard reportsSummary: Facing issue in performance goal dashboard reports Content (required): Hi All, We are facing the issue in performance goal dashboard report. Even employee has e…Venkatesan 21 views 4 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Setting custom check format for APSummary: I am setting up custom AP check format first time. Need to know the steps, any document showing steps. Content (required): I need to add custom layout for AP ch… -
In OTBI report when I schedule the report through agent to me or others all records not coming?Summary: HI Team, We have head count details report with nearly 41000 records and we are used only one subject area(worker assignement real time ) with 25 cloumns so iss…AjayKumar Maddipati 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM