BI Publisher
Discussion List
-
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 91 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 -
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 21 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 42 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… -
How to see multiple values in new line in Oracle SQLSummary: Content (required): I need to develop a BIP report for talent profiles. As per the business requirement, I need to display multiple values (Ex. Skills, Language…Prajna Hegde 22 views 2 comments 0 points Most recent by Prajna Hegde Reporting and Analytics for HCM -
BI Publisher - How to pivot to display questions horizontally using answers instead of measuresSummary: BIP - How to pivot to display questions horizontally as the heading using answers instead of measures, displaying respondents as the first column Content (requi… -
OTBI including an header sectionSummary: We have defined an OTBI that exports lines with the images uploaded in the Fusion Product Hub module (SCM). Can be possible to include before the table section …adelsorbo-Oracle 42 views 5 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Succession Planning BIP ReportSummary: Content (required): Hi All, As per the client requirement, I am trying to create a BIP report for listing the incumbent (person) specific and position specific …Prajna Hegde 23 views 8 comments 0 points Most recent by Prajna Hegde Reporting and Analytics for HCM -
How to embed Logo/Images in BI Publisher RTF Template in HTML Output formatSummary: How to embed Logo/Images in BI Publisher RTF Template in HTML Output format Need to Embed Logo in HTML output format for BI reports Template. Options Content (r…Kaustubh Deshmukh 11 views 7 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM -
Need sample analysis/SQL to get various balance values for each assignment for EE with multiple GTSummary: When global transfer happens for any employee, we need to validate various balances to confirm if they are transferred to the new LE. During a year if an EE is … -
Can I create a button to print or cancel, when executing a report in BI?Summary: Can I create a button to print or cancel, when executing a report in BI? If possible, what would be the next steps? Content (required): Version (include the ver… -
How to convert xml data to columns in BI Publisher report Using ExtractValue?Summary: How to convert xml data to columns in BI Publisher report Using ExtractValue? Content (required): Version (include the version you are using, if applicable): Co…Lydia Jayasingh 51 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Procurement > Dashboards > Procure-to-Pay no 'Period' list of valuesSummary There is no value in the list of values for 'Period'Content Hi, I'm trying to open the seeded dashboard Procurement > Dashboards > Procure-to-Pay But with any us… -
Using BICC PVO in data model for BI publisher reportingSummary: is there way to configure data model to use BICC PVO? we need some custom reporting built and would like to leverage BICC PVO in data model Content (required): …Roman Havrylyak 41 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP