Reports
Discussion List
-
To identify last modification details in Item Master , Item Locator and SubinventorySummary: We want to identify last modification details in Item Master , Item Locator and Sub inventory other than the 'last update date' , 'creation date', 'last updated…PrerakKhandelwal 31 views 0 comments 0 points Started by PrerakKhandelwal Reporting and Analytics for ERP -
Reports - How to export multiple grids in a single excel worksheet?Summary: is it possible to export multiple grids in a single excel worksheet with the new Reports tool? Content (please ensure you mask any confidential information): Wi…
-
How to retrieve AS$_ATTRIBUTE7 in OTBI?Summary: I'm looking for assignment descriptive flexfields and I'm using "Workforce Management - Person Real Time" subject area Content (please ensure you mask any confi…Stefano_Mazzocca 21 views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
meaning of BALANCE_TYPE_CODE in FLA_LEASE_BALANCES_ALLSummary: in FLA_LEASE_BALANCES_ALL table, there is column BALANCE_TYPE_CODE. there is 3types of BALANCE_TYPE, what's the meaning of that? why it's has different value. C…
-
Query to retrieve list of bi publisher jobs in oracle fusion.Summary: Hello Team, Could you please help in providing the query to show all the scheduled jobs from BI publisher page. Content (please ensure you mask any confidential…Srushti Dhote 33 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Formulas linked from the MR to another tab break after changing POVIs there a known workaround to prevent formulas from breaking when POV is updated? I tried linking a formula from a report opened via Smart View (I used Insert Formatted…Patrick Pontillas 11 views 1 comment 0 points Most recent by Tom LeFebvre-Oracle Narrative Reporting
-
Unable to add security permissions for HCM seeded report folderWe want to provide customized access to the seeded HCM report folders on the Reports and Analytics page, but we're unable to modify their security permissions directly. …fusionuser 32 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Subledger Period Close Exception ReportSummary Subledger Period Close Exception ReportContent I am seeing these transaction on the Sub-ledger exception report as per below table. 1. Does this means they were …
-
Hiding the settings icon in embedded BI dashboard via deep linkHi Team, to embed a BI dashboard within a custom icon without displaying the BI menu, we created a deep link to the dashboard (ref. How To Embed A BI Dashboard URL Witho…
-
Is there a way to change the format of the output from a report?We currently have a custom report we use for maintenance, and the user is requesting we help him change the output options so CSV can be used. We currently only have HTM…
-
What is the recommended way to extract data in bulk from the compensation external data tables?Summary: I need to extract Total Compensation Statement data from the the external data tables. What is the recommended way of doing that? Content (please ensure you mas…
-
Combine multiple Ethnicities in OTBI "Two or more races"Summary: Per the below - we have some Team Members that classify with more than one Ethnicity and the "Two or more race" option is no longer available in Oracle. This is…THawkins_LGI 221 views 16 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
Required table for the Payment Method Preferences in PayrollSummary: Hi, Could you please let us know the table where the information of Payment Method preference stored for Payroll module. PAY_ORG_PAY_METHODS_VL has no informati…
-
Subject Area: Payroll - Personal Payment Details Real TimeHello, Could anyone help or confirm if the Subject Area: Payroll - Personal payment details real time can extract the Account Suffix for our Personal Payment Method? Cou…
-
Need to make dynamic file name in BIP reportWe have a requirement to place the BIP report to SFTP server , file name should be dynamic as 'Filename_(sysdate-15)_(sysdate-3)'. I tried to make the filename as Filena…Anjali_Kumari4121 165 views 4 comments 0 points Most recent by Eveve Reporting and Analytics for HCM
-
Unable to select parameters in a Manage Job SetWe want to create the Job set and with job parameters itself so that every time we run the job set, we do not have to fill the parameters again. Can you tell us how we c…
-
Unable to find the SQL joining for Event class and Mapping set in Oracle fusion Project to CostingSummary: Hi, We are unable to find the SQL joining Event class (XLA_EVENT_CLASSES_VL) and Mapping set (XLA_MAPPING_SETS_VL) in Oracle fusion Project to Costing. The inpu…
-
FDI - Is there a Manager Flag or Supervisor Indicator field available for selectionSummary: Is there a specific field within FDI that can be used to check if an Employee is also a Line Manager? e.g. If I used the the Subject Area MTS HR Analytics - Wor…David Thomson-265878 21 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
How to embed Dashboard to My Team Page tab?Summary: Content (required): Could you please advise where I can find the instruction on how to embed an OTBI dashboard into My Team as a new tab? Thank you! Version (in…Evgeniya Repnina 201 views 12 comments 0 points Most recent by Vittoria Reporting and Analytics for HCM -
Online Excel preview to view BIP report outputs instead of downloading the file?When getting a BIP Report output in Excel format, is it possible to preview it online (as in cases with PDF/CSV outputs) rather than having it downloaded to system and o…PrerakKhandelwal 31 views 0 comments 1 point Started by PrerakKhandelwal Reporting and Analytics for ERP
-
How to best suppress base entity detail when ownership changes in reports?Not suppressing the detail results in double counting the base entity detail when reviewing descendants of the total Entity hierarchy even when the ownership has moved f…mattk1528 51 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Seeded Process/Report/Data Model customizationSummary: Once we did customization of seeded Process/Report/Data Model, after applied any patch/upgrade then the customization changes will override. Content (please ens…
-
Please provide definition of the following business Objects (In context of Audit Policies)Summary: Please provide definition of the following business Objects (In context of Audit Policies) - Data Security Control - Under Product "Common Work Object" Electron…dilipkumar 1 view 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Unable to see goals under approval/in draft in OTBI ReportsSummary We are not able to get the data for goals awaiting approval or in draft state using Workforce Management - Goal status overview real time Subject Area.Content Hi…Mohit Gupta-45440 220 views 18 comments 1 point Most recent by andywuwuwuwu Reporting and Analytics for HCM -
requirement to automatically trigger BICC/BIP batch jobs after the ComCal are completed in the FIC.We have a requirement to automatically trigger BICC/BIP batch jobs after the Compensation Calculations are completed in the FIC (Fusion Incentive Compensation) applicati…Anita_ABR12 41 views 4 comments 0 points Most recent by Varun Malhotra-Support-Oracle BI Publisher Learning Center
-
OTBI British Summer Time effecting dates in Payroll - Element Entries History Real TimeSummary: British Summer Time (GMT +1) is producing incorrect results from the date Prompt using Effective Start annd End Dates Content (please ensure you mask any confid…Kevin Robertson 1 view 0 comments 0 points Started by Kevin Robertson Reporting and Analytics for HCM
-
Procure to Pay DashboardsSummary: Procure to Pay Dashboards Content (required): How can these be added to the home dashboard once the user is login, instead of going to reports and analytics and…
-
Table to get Assignment change historySummary: Table to get Assignment change history Content (required): Hi All, We got a requirement to show the assignment changes (Like Transfer). From which tables we can…Venkatesan 1.9K views 12 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Issue is when we add termination date in two subject areas OTBI reportSummary: Hi Team, when we add the two subject areas it showing correctly but when i adding termination date it showing two rows as below ? one is with termination record…AjayKumar Maddipati 42 views 10 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM