BI Publisher
Discussion List
-
Supplier Recon reportSummary: We are importing the suppliers,address,site details using FBDI.Is there a specific report that we can access or generate to reconcile the imported data with the…User_2025-10-31-01-02-51-214 91 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
View Expense report receipts for approversSummary: Has anyone created a report or option to view (without download) Expense report receipts for approvers? Currently only option for approvers is through Expense r… -
The custom report is providing blank data to the user ( Receipt and cost accounting details report)Summary: Please be informed that we have created a custom report i.e. " Receipt and cost accounting details report.", but the user is not getting any data in the report.…Soare Oldrich Alexandru-Oracle 11 views 1 comment 0 points Most recent by Mohamedtaha-Oracle Reporting and Analytics for SCM
-
Are there any out of the box reports that would tell me if a Second Pass email was triggeredSummary: Looking for an out of the box report that would tell me if Second pass emails are being sent to applicants. Content (please ensure you mask any confidential inf…
-
Bar graph using BIP reportI have a bar graph in my BIP report , but the values are coming in decimal. In the Data model it is coming without decimal. Is it possible to have the values display on …Shreya Datir 11 views 1 comment 0 points Most recent by Shreya Datir Reporting and Analytics for HCM
-
Is there any Seeded report which gives, Depreciation expense account and location in fixed AssetsIs there any seeded report in Oracle fusion fixed assets, which gives depreciation expense account and location details for assets?PL Karthick Ramanathan 51 views 3 comments 0 points Most recent by Shawna Green-Support-Oracle Assets
-
how to use preprocess XSLT File in xdo_metadata in excel using bi publisher?Hi - I am new to hcm extract and would like to use the preprocess XSLT file on excel xdo_metadata bi publisher. I am looking for documentation because it is not currentl…
-
Is it possible to track who changed user roles and when it happened in Security Console?Summary: Content (required): Hello experts, is there a way by OTBI or SQL to retrieve who changed user roles in security console and when it occured? Thanks in advance f…Valerio Curzi 913 views 6 comments 0 points Most recent by Pavan Kumar Thummalapalli Reporting and Analytics for HCM -
Report for a Salary basis of the type "Salary amount is determined by simple components"Summary: We have a Salary Basis defined of the type "Salary amount is determined by simple components" and we have hired an employee with this salary basis. There are 5 …Sachin_Shirke 411 views 4 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Approval for posting of assets.Summary: Hello Team, We have a requirement Current functionality indicates that when an asset is changed from the New status to post status, there's a need for that proc…
-
How to get Phone number, Email Address, Home Address and Bank details old values using BIP ReportSummary How to get Phone number, Email Address, Home Address and Bank details old values using BIP ReportContent Hi Team, We are creating new HCM BIP Report to Fetch the…User_2025-02-01-06-07-07-886 843 views 7 comments 0 points Most recent by Ridma Karunanathan Reporting and Analytics for HCM -
In HCM Extract, can we add custom email for success/failure notification?The HCM Extract is triggering the custom BIP report and delivering the file to the specified SFTP folder. Now the user wants to get notified via email after the process …Kunwar Prashan Srivastava 147 views 4 comments 0 points Most recent by Jonalyn Cabrera Salonga HCM Extract -
Query to Display the Roles with their Data Security Profiles NameContent Hi Team, Has anyone created any report to display the List of Roles along with their assigned Data Security Profiles. Regards, Harish Vummidi Version 21CHarish Vummidi 218 views 15 comments 1 point Most recent by Mohit_Pal Reporting and Analytics for HCM -
Table for Additional Statuses (Timecard)We have a requirement to get Earned Date, Value, Unit of Measure, Payroll Time Type , Absence Type , Payroll Transfer Status & Payroll Processing Status. We are trying t…Manoharan 73 views 2 comments 0 points Most recent by Nagaraju Godasi Reporting and Analytics for HCM
-
Relationship between Invoice Tolerance and Hold NameSummary: Relationship between Invoice Tolerance and Hold Name Question: As part of Custom BIP report design, we need to establish a relationship between Invoice Toleranc…SonaliKar-Oracle 11 views 1 comment 1 point Most recent by Marx Rivera-Oracle Payables, Payments & Cash Management -
what the table used to extract all approvers from a GL journal batchSummary: I need to create a report, one of the fields i need to show all the approver. In the table gl_je_batch I have the last one. And using the table FA_FUSION_SOAINF…Nilson R Fachini 762 views 3 comments 0 points Most recent by Nilson R. Fachini General Ledger & Intercompany
-
Transpose rows to columns in OTBISummary I need to build a report that shows every employee as a column. Convert all rows to Columns in OTBIContent Hi I hope you can help me. I need to build a report th…
-
How to remove Blank Rows in a report?Summary: Once we export the report there are a few Blank rows at the bottom, is there a way to remove them? Content (please ensure you mask any confidential information)…THawkins_LGI 92 views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Getting corrupt XLS output for more than 100KB output.Summary: Report Name : AR Debtor Aging Report - MIRA Real estate.xdo Report Path : /shared/Custom/Transactional Reporting/Receivables/BI Publisher/Debtor Aging Template …Soare Oldrich Alexandru-Oracle 11 views 0 comments 1 point Most recent by Soare Oldrich Alexandru-Oracle Reporting and Analytics for ERP
-
PDF output is not giving the correct fontContent Hi, we are trying to generate a PDF output with custom font. While downloading RTF output, it is giving correct font, but PDF is not giving the same font. How do…Nivya Mathire 88 views 8 comments 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
movement request auto approval table in oracle fusionSummary: movement request auto approval table in oracle fusion Content (please ensure you mask any confidential information): Version (include the version you are using,…KOTTHURI ASHOKBABU 22 views 2 comments 0 points Most recent by KrishnaV Reporting and Analytics for SCM
-
Logic for Supplier Balance Aging ReportI want to know the logic behind the calculations of the columns - unpaid amount, buckets, aging amounts and unallocated amounts in the seeded Program - Supplier Balance …Priyal Pareek 146 views 4 comments 0 points Most recent by Daniel_Spritzer Payables, Payments & Cash Management
-
Electronic Invoice for Spanish Public AdministrationsHello, The customer must issue invoice to the Spanish Public Administration. The Spanish Public Administrations only receive invoice of a specific xml format, with an el…Saber El hadigui 11 views 1 comment 2 points Most recent by Marx Rivera-Oracle Payables, Payments & Cash Management
-
How do you display the run date, time (AM/PM), and timezone. Example 11/28/23 11:57 AM ESTSummary: When running a BIP report I am trying to show the timezone of the run date and time being displayed. I am using an RFT template. Content (please ensure you mask…
-
How to use an OTBI analysis to create a data model with a parameter (prompted?)Summary: I am trying to use an OTBI analysis to create a data model. My data model will be refrenced by Oracle Journeys so there is a requirement that I attach a specifi…Amy Wilson 867 views 7 comments 0 points Most recent by Stefan v. Glabbeek Reporting and Analytics for HCM -
Need Mapping/Calculation Logic for below fieldsSummary: We are building a report for Revenue By Customer/Contract. Below are the fields for which mappings/calculation logic or which table has the fields is requested.…
-
Reporting Prior Month Data SQLSummary: Can we add SQL to the formula to look at the Prior Month data? So tell it to look at the System date - 1(for prior month) and pull 1st to last date of that prio…THawkins_LGI 41 views 12 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM
-
Business Unit Hierarchy looking for Parent Business Unit NameSummary: I would like to know what table Parent Business Unit Name is in for a BI publisher SQL Content (please ensure you mask any confidential information): Version (i…
-
Need to create a BI report to See What Jobs Are Scheduled Along With Frequency, Start and End dateSummary: Hi All, We've a requirement from the customer where they need to create a report to See What Jobs Are Scheduled Along With Frequency, Start and End date. Can so…Sandeepan Rana-Oracle 21 views 3 comments 0 points Most recent by Sandeepan Rana-Oracle Reporting and Analytics for HCM
-
What table is storing Change working hoursHi Team, Which table is storing change working hours information? Any sample will be helpful.