BI Publisher
Discussion List
-
Need an Oracle documentation which list changes done to database or TablesOracle agreed to share a documentation which will help customer identify changes done to Tables which might affect BI Publisher reporting. But, Oracle said there is no d…Vamsi Kuchipudi 11 views 2 comments 0 points Most recent by Vamsi Kuchipudi Reporting and Analytics for HCM -
Does anyone know which process populates this Benefits table?Summary: Content (required): I'm looking at table BEN_PRTT_RT_VAL and wondering if this is getting updated by a Benefits process vs. Payroll process? We see mismatches w…Scott Paulin 21 views 2 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
What HR roles can see Performance analyticsSummary: We have a Dashboard containing a tab with information on Performance Documents (status, ratings, etc.) and a tab containing information on Goals. Line Managers …Wouter.Schaap 1 view 5 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
ORA-00933 : While generating explain plan in BISummary: When we are generating the explain plan we are getting this error message from BI Data set. oracle.xdo.XDOException: java.sql.SQLSyntaxErrorException: ORA-00933…
-
Workforce Compensation Page Parameters for EL ExpressionsContent Hello experts, is there an Oracle official documentation which can allow me to have all compensation module parameters (i.e. ManagerId; PlanId; etc.) in order to…Valerio Curzi 32 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Payables Withholding Tax By Tax Authority Report shows blank page upon clicking 'Open' (run)Summary: We have Payables Withholding Tax By Tax Authority Report which is dashboard. When we try to run it ,upon clicking on 'Open' it leads to blank page,no data nor e…Priyanka More-Oracle 41 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Payables, Payments & Cash Management
-
Dynamic Dates for Parameters or SchedulesSummary Is there a list of dynamic dates for use in parameters or in schedules?Content Hi all - I did review this post (https://cloudcustomerconnect.oracle.com/posts/862… -
Not a Question: Dynamic Date Parameters in BI ReportContent This is not a question and I have shared the info, For most of the BI Reports we have the input parameter as "AsOfDate" alias Sysdate or current date. Sometimes …Janardhana Kondaveeti 129 views 5 comments 15 points Most recent by Visu Reporting and Analytics for HCM -
Budget Data from PBCS for Reporting (not control) - what reports exactly is it visible in?Summary: When you load budget data from PBCS to Fusion Financials General Ledger for reporting (not control budgets) can anyone confirm exactly which OTBI subject areas …User_2025-02-10-15-12-48-631 11 views 2 comments 1 point Most recent by User_2025-02-10-15-12-48-631 General Ledger & Intercompany -
Is supplier audit report available in fusion?Summary: We are looking for standard report to track old value and new value when supplier name, supplier bank number, etc is changed. Please let us know is there any st…
-
Need Help to fix Date parameter while integrating BI report into DashboardSummary: I have created a SQL with a date parameter that calculates effective date minus 5 days. Below is the code which is working well while running normally with BI r…Mohan Murali 81 views 1 comment 0 points Most recent by Mohan Murali Reporting and Analytics for HCM
-
How to exclude logged in user from BIP report?Summary: Logged in user needs to get excluded from their own BIP performance report Content (required): Hi, we have built a custom BIP report for performance data for ma…Franziska Reichel 31 views 4 comments 0 points Most recent by Franziska Reichel Reporting and Analytics for HCM
-
How to customize Subledger Period Close Exception ReportSummary: How to customize Sub-ledger Period Close Exception Report Content (required): Ledger Set Parameter to be added to the report. when i'm trying to edit datamodel,…Lydia Jayasingh 162 views 7 comments 0 points Most recent by Lydia Jayasingh Reporting and Analytics for ERP
-
Unable to pull Year and Month of serviceHey Guys, I have a requirement to bring out Year and month of service of employees in a custom payroll flow. I have created a FF and attached it to an attribute in HCM e…
-
Prevent files with only header row from getting generated from etext bursting in BI PublisherSummary: Prevent files with only header row from getting generated from etext bursting in BI Publisher Content (required): Hi Experts, I' bursting an etext template with…Aloka Bhattacharya 22 views 8 comments 0 points Most recent by Aloka Bhattacharya Reporting and Analytics for HCM -
Project Budget Data (EPBCS) with Project Actual (ERP/Project Costing)Summary: Project Budget Data (EPBCS) with Project Actual (ERP/Project Costing) Content (required): How are oracle customers that use EPM/EPBCS for project planning, appr…Andrew_Schmitz 21 views 0 comments 0 points Started by Andrew_Schmitz Reporting and Analytics for ERP -
ORC fields mapping with HCM TablesSummary: We're looking for mapping documents to associate each ORC field to the correspondent item in the HCM tables (e.g. ATTRIBUTE_CHAR1 etc) Content (required): Hello…gguittini 31 views 1 comment 1 point Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
Query to extract expense reports which are reassigned to different approverSummary: We are trying to expense reports which are reassigned from one approver to another approver. Content (required): I tried to query below tables but could not fra…
-
Query to extract expense reports which are reassigned to different approverSummary: We are trying to expense reports which are reassigned from one approver to another approver. Content (required): I tried to query below tables but could not fra…
-
How to find 'User Defined Column' within Compensation PlanSummary: Can anyone help locate this field within a Compensation Plan. I need to find "Numeric Column 18", preferably within a Subject Area or if it's only within a tabl…Andrew_Schmitz 41 views 5 comments 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Performance Task Next Step BIP ReportSummary: Creating a BIP report for Performance Tasks showing Step/Next Step Content (required): We have a BIP report for the Performance Task Steps which include Task St… -
Logo in BI Publisher RTFIs there any way of embedding a logo dynamically in BI Publisher RTF ? We wish to show different logos based on different legal entities.
-
To develop a BI report with calendar functionality.Summary: Need to develop a BIP report which uses bursting functionality and when ever mail triggers, it gets automatically saved in the the calendar of the mail just lik…