OTBI
Discussion List
-
OTBI Analysis: How to format Person Number as 6 digits with leading zeros?Summary: Hi experts, I have a business need that requires me to extract data from an OTBI analysis and format all Person Numbers as 6 digits with leading zeros when need… -
Supply Chain Operation for MaintanenceSummary: Supply Chain Operation Dashboard ( Maintenance/Manufacturing, Inventory, Costing and Quality Content (please ensure you mask any confidential information): Orac…
-
in which otbi table are the courses pricing informationSummary: Hi, In need to identify all the active courses for which the fields 'Required' and 'Use to calculate Catalog Item Price in Self Service' have not yet been tagge…
-
how to limit values in OTBI prompt when using SQL Results in choice list values.Summary how to limit values in OTBI prompt when using SQL Results in choice list values.Content Hi All, We have a requirement to show values in prompt as per AOR/securit…User_XT9HW 688 views 7 comments 0 points Most recent by Gerald Hartmann-Oracle Reporting and Analytics for HCM
-
How do I return vacation request data in the transaction console, which tables can I use?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…
-
How can I relate the QP_MATRICES table to the QP_PRICE_LISTS_TL table?I need to obtain the name of a price list from the name of a matrix.
-
Expose custom pivot tables in supply planning to OTBISummary: We have created custom pivot tables within supply planning cloud. Is there a way to see these custom pivot tables in OTBI? Can we export the custom pivot tables…Ramakrishna Reddy M 12 views 1 comment 0 points Most recent by NinaLyubenova-Oracle Supply Chain Planning and Collaboration
-
HCM Extract and BI Publisher - GC overhead limit exceededTeam, We have a HCM Extract which is invoking the BI Publisher to generate PDF output. But we are getting an error and HCM Extract is not generating any PDF output. Erro…
-
How to provide the gap between the 2 bars in bar graphSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Narendar Rao Naineni 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Report with Payments Disbursements and Invoices with Invoice distributionSummary OTBI Report with Payments Disbursements and Invoices with Invoice distributionContent I am trying to create a report that shows only the invoice expense account …User_2025-02-06-00-15-19-515 769 views 3 comments 0 points Most recent by J Dimond Reporting and Analytics for ERP -
Query to Derive Budget information for a purchase orderSummary: Looking for a query to derive Budget information(below highlighted columns) for a purchase order from the below screen,i.e Budget Account ,Budget Period and con…Ripendra Kumar-Oracle 738 views 3 comments 0 points Most recent by Mirza_Adeel Reporting and Analytics for SCM
-
Which criteria (OTBI Subject Area) need to create a report for identify slow moving itemSummary: Which criteria (OTBI Subject Area) need to create a report for identify slow moving item Content (please ensure you mask any confidential information): How to i…
-
OTBI output is different for 2 different usersSummary: Hi, We have a custom OTBI report which is scheduled to send report to the Business Users. This report shows that 100 employees have missing family contact infor…Sailajad 22 views 8 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for HCM -
Issue: Unable to expand Calculation Components Detail folder in Payroll - Calculation Cards Real TimSummary Users building reports on Calculation Cards Subject Area when try to expand Calculation Components Detail folder, the folder doesn't expand. Solution is provided…Tanvi Jain-Oracle 163 views 1 comment 2 points Most recent by Al Darabaris Reporting and Analytics for HCM
-
how to link between sales order and discount list through SQL in oracle fusion (non-matrix rule)Summary: I can link the SO to the discount list name by following the post below if I am using MATRIX_RULE https://community.oracle.com/customerconnect/discussion/commen…
-
View Reports and AnalysisSummary: View Reporting and Analysis on the Cloud Help Center Content (please ensure you mask any confidential information): There used to be a link for Reporting and An…AVorster-Oracle 21 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Is there a way to set a section to collapsed state by default on OTBI dashboard page?Summary: Need solution to set section collapsed on load of dashboard page. I understand there is an option to save the customization for each user but it is not viable t…Shreya Agarwal-Oracle 1 view 0 comments 0 points Most recent by Shreya Agarwal-Oracle Reporting and Analytics for HCM
-
Create SAFT-PT Audit File for Portugal not generating XML fileHello All i am trying to run the process Create SAFT-PT Audit File for Portugal and in the parameter i'm including the file i want it as XML but when the process succeed… -
How to report on details held in Past Incumbents section of Position DetailsSummary: We need to add some of the fields held in 'Position Details' into an existing report but cannot find within any tables columns that correspond to the fields vis…Leanne W 116 views 3 comments 0 points Most recent by Revathiiyyanar Reporting and Analytics for HCM
-
Report to say if employee has any direct reportsContent Hi, have a simple report that says something like PERSON NUMBER | Name | Department. I need to add an additional column that returns yes/no for if that employee …Mike Borghoff 130 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Installed Base Assets data not showing in the TablesHi All We are trying to build a Reconciliation report for the Installed Base assets records that we loading through the FBDI. Currently we are using table CSE_ASSETS_VL … -
Is it possible to add a time zone prefix to an OTBI report?Summary: If I want my OTBI report's data to only display one specific time zone no matter the user's preferences, how would I do that for just one report? Could the pref…CCannadayCTR 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report requirement for Bad debt Allowance/ ProvisionSummary: Hi This is regarding a report requirement related to allowances /Bad provisions and write off at entity level that we would like to clarify, The business expect…
-
Difference between Oracle Delivered OTBI Report-Budgets Wrksheet & Budgets Wrksheet Worksheet MgnrWhat is the difference between these two out of the box OTBI reports? Budgets Worksheet and Budgets Worksheet for Worksheet Manager Path: /Human Capital Management/Compe…MeghnaDe 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Overtime status is not showing data in workrelation subject areaSummary: Hi Team, We had defined overtime status at job level. like below. but the information is not showing workrelationship subject area. Request you to help on to fi… -
Looking for a Applicant Report < Oracle delivered report>Summary Looking for a Oracle out of box report output - To display all candidate responses to the application questions/fields including the signature with date and time…Prabhu Krishnamoorthy 19 views 3 comments 0 points Most recent by Karen Long Reporting and Analytics for HCM -
Current approval status table name for development goalsUnable to get approval status for development goal: Need a table name and SQL query for development goa approval status to check whether the goal is approved? rejected o… -
Trying to find a Link between Career Site and RequisitionSummary: We are trying to derive the career sites where a specific job requisition is published. Can you point us to a REST API which can provide this information ( alre…
-
Select performance goal seeded report customization in not working in Production.Summary: Select performance goal seeded report customization in not working in Production . where as working in TEST pod. Below are the steps followed to customize the r…