BI Publisher
Discussion List
-
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 11 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 42 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 291 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 371 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 Most recent by Aparna N-Oracle Reporting and Analytics for ERP
-
Requesting query to capture CMK Errors for AP Invoice Inbound MessageSummary: As per our client requirement, we need to generate BIP Report to capture CMK Errors for AP Invoice Inbound Message. The Report should have the Error type, error…Priyanka_Choubey 241 views 3 comments 0 points Most recent by Aaron Baker - Hanger, Inc Payables, Payments & Cash Management
-
NACHA CTX 820 addendaSummary: Trying to create a payment template which includes addenda records for each invoice when paying batch. This is described in Doc ID 1378367.1. How can we do this…
-
Pull a list of custom OTBI and BIP reportsSummary: Hello everyone, Is there a way to pull a list of custom OTBI and BIP reports? Thanks and REgards Content (please ensure you mask any confidential information): …
-
Need to do a Conditional Replacement on HCM Extract with EText TemplateSummary: Hello! I have 5 Value Set/Fast Formula for attributes in HCM Extract. 4 of them have some conditions to change a information showed on the 5th(The 5fth one is a… -
is there any way to hide the rows in excel using bi publisherSummary: Hi, I am new to bi publisher and wanted to have this in my report template using excel. is there any way to hide the rows in excel using bi publisher that is be…
-
Display Invoice Retainage details on the Payment Template and SRAHi Experts, Would like to know if we can populate the Retainage amount/details available on the Invoice into the payment template. Currently, the payment xml does not in…asurnilla 11 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
Pre-defined variable to get instance URL for analytics server similar to CURRENT_SERVER_URLHi, We need to include links to drill-down BIP reports in the output of a master report using an RTF template. When creating these links, the instance hostname should be…Ankit_Bhadja 95 views 1 comment 0 points Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP -
How to setup FTP server on PDH and send files from PDH to PDH FTP serverSummary: We have a requirement of sending Item and Cost master information from PDH to CPQ via SOA middleware. We need to enable and setup FTP server on PDH so that SOA …Kajal Dhawral 22 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for SCM -
DOJ from date and to date , DOE from date and to date parameter not working in BIP reportHello , I have create Date of Joining date parameter and Date of Exit parameter, however when user try to select dates and filter records , records are not getting filte…
-
Report detailsHi, There are lot of reports we are using and we want to know security of each report. Is there any way to find out below details from system 1)List of reports 2)Roles/p…Namrata_20 21 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM
-
Need a SQL query to fetch CIP asset and Capitalized assets separatelyHi All, We need a sql query to fetch details of CIP assets columns are Asset number, asset type, period name, asset id, cost Capitalized asset columns Asset number, asse…
-
can we use fetch multiple columns using single case statementHi Team, i am using the case statements as below to retrive the data for a single person but it is giving me the 4 rows for same person is there any way to group them al…Chetana Pawar 21 views 1 comment 0 points Most recent by Swathi Shetty Reporting and Analytics for HCM
-
display logo in excel format in Oracle Fusion BI reportI want to diplay the logo in Orcale Fusion RTF template in excel output When fetching output in pdf its showing the logo but not in excel fromat What is the sloution to …Abdur Rehman 61 views 4 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Not able to view the BI publisher report under supply planning work areaSummary: We created BI report for Supply planning and loaded and created a new folder Supply Chain Planning under /Shared Folders/Custom/ and saved the report there. But…Adhavan 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Store signature in cloud (employee DOR or somewhere) to be used in the reportSummary: In EBS we used to be able to store the employee signature in the DOR, then we used the image in the PDF reports (like tax certification). We wanted to do the sa…
-
Invoice Amount Calculation on Agreement Life CycleSummary: Does anyone know how the invoice amount on the Agreement Life Cycle is calculated? Content (please ensure you mask any confidential information): I am using the…Jill Larson 21 views 2 comments 0 points Most recent by Glen/Oracle Support-Oracle Payables, Payments & Cash Management
-
Fixed Assets - Report to Find if Assets have "Amortize Adjustment" flag checkedWe are creating a +$0.01 adjustment followed by a -$0.01 adjustment in the fixed assets module for every asset in order to have the “amortize adjustment” flag checked wi…