BI Publisher
Discussion List
-
Table for Additional Statuses (Timecard)https://us.v-cdn.net/6034893/uploads/59HOTVHRD3TK/timecard.txt We have a requirement to get Earned Date, Value, Unit of Measure, Payroll Time Type , Absence Type , Payro…Manoharan 71 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 704 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 91 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 12 views 0 comments 1 point Started 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 21 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 141 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 833 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.
-
how to bulk download the attachments in report job historyHi Team, I have a requirement to download the output name (attachments) in the Job History. But when I download the files it's coming in the XML Format. can anyone tell …Haritha 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Unable to get the proper count for Assignment Count when I am using two subject AreasSummary: Hi Team, we have requirement to get the count for Nationality to get this column we are using 'Person Real time' Subject Area. and we also have to filter this c…Ashok Dhara 12 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Which table Stores the AP Invoice Mail Received Date by the IDR and Process Date by the IDR?Summary: I'm creating a custom report and I need to add the Dates when Mail Received by the IDR and Process by the IDR. I refer from the OOTB report (IDRImageTraceabilit…James Canaber 41 views 2 comments 1 point Most recent by Brian Burns Payables, Payments & Cash Management
-
Someshvar Bansal 11 views 2 comments 0 points Most recent by Patrick Breidel-Oracle Reporting & Analytics for Sales
-
I need query to get expense approver nameDoes any one have query to get expense approver nameSwati U 281 views 2 comments 0 points Most recent by Stephen Westerfield-Oracle Reporting and Analytics for HCM
-
Subject area/database table for historical manager hierarchySubject area/database table for historical manager hierarchy Client is interested in building dashboards to show different HR metrics for which historical manager hierar…
-
Data Model throws a nullpointer exception while trying to retrieve dataSummary: I have created a data model with 2 data sets (one for employees and one for Contingent workers) - I have created an Excel Template that has 2 tabs for the data …User_2025-02-04-08-51-08-912 346 views 3 comments 0 points Most recent by John Peter Noble-Oracle Reporting and Analytics for HCM -
How to setup dynamic filters in BIP report?The dynamic filter should adhere to the following logic: Year: If today falls between February and December, use the current year. If today is in January, use the previo…Janardhan ACS-Oracle 31 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM
-
asset by locationSummary: Fixed Asset report with financial and location details Content (please ensure you mask any confidential information): For State/Corporate Income Tax reporting r…
-
Calling an external image in bursting using tokensHi We need to call an external image in the bursting query. by passing token. Please help in achieving this. Regards, ShanmukhiShanmukhi 11 views 3 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM
-
Profile id not available for some employeesSummary: Profile id not available for some employees Content (please ensure you mask any confidential information): Hi experts, we want to create a report that retrieve … -
BIP Report Job History RetentionSummary: Hi, How far back can we view Report Job History in Oracle Fusion? Is this the right answer? I want to be able to download the reports like in first picture. I h…
-
Schedule report option to deliver to email outside Oracle domainSummary: My client is looking at scheduling the reports via the report schedule Option in Oracle Cloud. How do we use the schedule report option to deliver to email if t…Aparna N-Oracle 1 view 0 comments 0 points Started by Aparna N-Oracle Reporting and Analytics for ERP