BI Publisher
Discussion List
-
How to create an OTBI Report to display POs by running for GL Parent/Child Department valuesSummary: How to create an OTBI Report to display POs by running for GL Parent/Child Department values Content (required): How to create an OTBI Report to display POs by …Abhilash K - Deloitte USI 23 views 4 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
What System Role gives access to PER_LDAP_ROLES?Summary: What System Role gives access to PER_LDAP_ROLES? Content (required): Hi All, I keep forgetting and cannot find a document outlining this but what role gives acc…Nicolas Trojack 21 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP -
COUNT Function to get specific valuesSummary: Hi Experts, I have created a report to get the sum of certain rows by specific values. For example, the column returns values as either "REC" or "UNR". So the r…Vipusha Chandrakumaran 84 views 3 comments 0 points Most recent by Vipusha Chandrakumaran Reporting and Analytics for ERP -
A report for print options for AR customers - Missing FieldSummary: A report is required to detail the print options for AR customers The issue I am having is location the tables that hold Statement Preferred Delivery Methods fr…User_2025-02-11-10-53-01-866 42 views 2 comments 0 points Most recent by User_2025-02-11-10-53-01-866 Reporting and Analytics for ERP -
How to link the sla to an invoice lineSummary: Need to link invoice lines to the subledger xla and xle files Content (required): Version (include the version you are using, if applicable): Code Snippet (add …
-
How to send and unsend a report based on its content in oracle BISummary: How to send and unsend a report based on its content in oracle BI Content (required): Hi everyone, There's a requirement to have a certain report output mailed …Sushan Peiris 42 views 3 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP -
OTBI Analysis: Is it possible to add a column that summarizes Invoice Amount by Supplier?Summary I'm building an analysis in OTBI and wanted to know if it's possible to have a calculated column that summarizes one of the other columnsContent I'm building an … -
Combine BiP and OTBI audit data in custom reportSummary: Is it possible to combine BiP and OTBI audit data? Content (required): We have enabled the BiP audit feature and have compiled an OTBI audit report. Business is…Stefan pettersson 45 views 3 comments 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
how to define a xml in rtf if there are multiple datasets with the same column nameSummary: Hi everyone, Recently I faced an issue with a seeded report that was customized. The report had two datasets with the same column on both, where when I try to l…
-
Error : Exceeded configured maximum number of allowed output sectionsSummary: Error : Exceeded configured maximum number of allowed output sections Content (required): Hi Experts, We are trying to run thr report " Payables Credit Memo Mat…Vipusha Chandrakumaran 443 views 1 comment 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Prepayment invoice detailsSummary: Prepayment invoice details Content (required): Hi experts, I got new report requirement to display prepayment invoice details based on as on date. 1. prepayment…
-
BI Bursting - ZIP text files during deliveryHi All Is it possible to zip the text files from BI FTP bursting ? ThanksMurthy Kodavati 230 views 2 comments 0 points Most recent by Murthy Kodavati Reporting and Analytics for ERP -
customizing Receivables Aging by General Ledger Account ReportSummary: I'm trying to customize the Receivables Aging by General Ledger Account Report, but I'm not able to get any sample data. Content (required): I have created a co…Anders W. Langholm 196 views 3 comments 0 points Most recent by AeeTee Reporting and Analytics for ERP -
What role is needed to run ESS job Vertex Payables Transaction Tax Action Report ?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Anthony Cambria 52 views 4 comments 0 points Most recent by Murali Gangidi Reporting and Analytics for ERP
-
performance between xmlpserver/services/ExternalReportWSSService versus more api rest in integrationSummary: performance between xmlpserver/services/ExternalReportWSSService versus more api rest in integration on oic Content (required): hello I could to know that diffe…Alessandro_Moccia 26 views 0 comments 0 points Started by Alessandro_Moccia Reporting and Analytics for ERP -
BICC - ability to product a single CSV output merging data from many data stores/VO'sSummary: Does BICC support selecting columns from different data stores/PVO's and apply query filter? Content (required): We have a business requirement to extract large…Arun N-OC 364 views 8 comments 2 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
Customize Receivables aging seeded ReportSummary Customize Receivables aging seeded Report - to include Project information and grouping totalsContent Hi, We want to customize Receivables aging by General Ledge…User_V0Y9V 585 views 7 comments 6 points Most recent by Anders W. Langholm Reporting and Analytics for ERP -
BI Publisher Excel TemplateSummary: How to display a column conditionally in BI Publisher Excel Template? Also I want to display a hard image in excel based on condition of data source in excel te…
-
Outbound Integration - Every one hourSummary: Outbound Integration - Every one hour Content (required): Hi All, We got the requirement for GL Journal outbound integration through BI report. The job should r…Venkatesan 62 views 9 comments 0 points Most recent by Sandeep S. Chauhan-Oracle Reporting and Analytics for ERP
-
Oracle Fusion BI Catalog Folder ControlSummary: Oracle Fusion BI Catalog Folder Control Content (required): We have encountered multiple times where users have accidently moved or made changes to BI Catalog F…Rihan Jameel 63 views 4 comments 0 points Most recent by Rihan Jameel Reporting and Analytics for ERP -
How to send BI Publisher reports to FTP folder from ESS jobSummary: How to send BI Publisher reports to FTP folder from ESS job Content (required): Hello All, I will appreciate your support in the following: When I schedule the …Bernard T 742 views 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Unable to locate Direct SQL option after upgrade 19ASummary Unable to locate Direct SQL option after upgrade 19AContent HI, I'm not able to location the Direct SQL option after upgrade the 19A. Can anybody suggest where w…Suresh Kumarasamy-Oracle 86 views 10 comments 2 points Most recent by Shyam Patel Reporting and Analytics for ERP -
Supplier Audit ReportSummary Supplier Audit ReportContent Good People, Anyone create supplier Audit Report as a custom one apart from the one available ? Thanks, SoumyaSoumya Prakash Parhi 175 views 18 comments 1 point Most recent by Gaurav Jain _Infosys Reporting and Analytics for ERP -
Receivables: Status Tracker in OTBI/BIPSummary: Content (required): Is it possible to report on this Status Tracker in OTBI? Or BIP? And if so which which subject area or which tables are these to find in? St…Nicolas Vahman 204 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
How to convert hexadecimal to Base64 in BI ReportSummary: How to convert hexadecimal to Base64 in BI Report Content (required): Hi All, How to convert hexadecimal to Base64 format in (SQL) BI report. Need to generate Q…Venkatesan 73 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Data missing in outbound integrationSummary: Data missing in outbound integration Content (required): Hi Experts, We implemented GL Journals outbound integration between fusion and AWS SFTP server. We have…
-
Can you please share with me Workflow/BPM tables in Fusion? Are there workflow/BPM tables for Cash AContent Can you please share with me Workflow/BPM tables for Cash Advances in Fusion? Following I found in Procurement 1.POR_AMX_RULES2.POR_AMX_PARTICIPANTS3.POR_AMX_DIM…
-
Sequence Command for BI PUblisher eTextSummary: Sequence Command for BI PUblisher eText Content (required): Hi Folks, I'm using eText template to do payments, I need a unique id for each payment but for each …Eliel Douglas 36 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
How many columns we can have in data modelSummary: Maximum number of columns we can have in data model Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code s…Nidhi Chhajed 31 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Failing to retrieve data from presentation layer when trying to export BIP folderSummary: Our team is using the VBS pipeline to export BIP reports from the dev region to the sat region. Everything was working correctly and then it stopped working on …User_2025-03-07-05-28-28-079 33 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP