BI Publisher
Discussion List
-
How to make 'Routing Attribute 2' field a drop down instead of a free text in the invoice header?Summary: We want to make 'Routing Attribute 2' field a drop down instead of a free text in the invoice header since our invoice approvals are based on this field and mos…AkashAgarwal 31 views 2 comments 0 points Most recent by Harsh Masharu Payables, Payments & Cash Management -
How can I find AP invoice Accounted by for my custom BI report?Please help with the queryAditi Agrawal2650 12 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
Invoice Document RecognitionSummary: When we run the schedule process - Invoice Document Recognition , we just want one column i.e subject. Is there any way or any report available which I can use …Sujatha Kumari 41 views 6 comments 0 points Most recent by Sujatha Kumari Payables, Payments & Cash Management
-
How to import a data from Oracle cloud to OTBISummary: Hi, we try to create a analysis in OTBI using a Payables Invoices - Installments Real Time Subject area, but we didn't get the any results, In ERP we have roles…Alex Pagliarini - Ninecon 11 views 1 comment 0 points Most recent by Abi Osborn Payables, Payments & Cash Management -
sql to use in custom BIP report to restrict data dynamically based on the users data security&accessWe are trying to build an custom BIP report/sql script to restrict data dynamically based on the users roles and their data access in fusion (for example, to query AP in…daniel4u2uk 473 views 11 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Show the postal 4 zip code on AP checkWe need to show the postal 4 zip code (postal code extension) in our AP check template, but the xml is not showing the field (Select document From iby_trxn_documents ord…Alvaro Artavia 31 views 3 comments 1 point Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Withholding Tax for Offest TaxSummary: Need to apply Withholding Tax on AP Invoice that has a Tax Rate + Offest Tax Rate (Gross Amount = Net Amount). System doesn't consider the offset tax rate for w…
-
Cheque specimen signature to be updatedSummary: Need to update the cheque specimen from one person to other. As the last day is August 29th; the next payment run is scheduled for September 5th so the cheque s…Gifty V 11 views 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management
-
Audit Receipt Accrual Clearing Balances ReportIn receipt accounting you have this report that can be run from the screen. I have not been able to find a way to do this without exporting the data from the screen. Is …
-
Can we customize the standard report with Internal tables provided by oracle? I found them empty.Summary: CCC-Internal tables provided by oracle do not have the data and unable to verify our customizations Content (please ensure you mask any confidential information…
-
we need a sample payment file for rtgs payment methodwe are implementing payments for customer and they want a payment file which has rtgs payment method so we need a sample payment file for rtgs payment method Thanks, Sai…Sai Divya Kolachana 1 view 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Static IP for sftp connectionSummary: Do you know if Oracle can use a specific IP address to transfer data to the SFTP server? We have configured a connection to the sftp server via OTBI/BI Publishe…Daniel Sobotka 22 views 1 comment 0 points Most recent by Vinay Galithoti-Oracle Payables, Payments & Cash Management
-
Creation of positive pay files with bank account appending to the file nameSummary: Creation of positive pay files with bank account appending to the file name Content (please ensure you mask any confidential information): Creation of positive …Arun0130 41 views 3 comments 1 point Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
How to check the date when we enabled audit trail in Oracle ?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Has anyone has experience with updating the 1099 NEC Copy B template?We are looking to make some changes to our 1099 NEC Copy B pdf template. Does anyone has some experience editing the pdf template?Jay Ruthiran 1 view 2 comments 0 points Most recent by Jay Ruthiran Payables, Payments & Cash Management
-
SQL Query to get the AP Invoice Validation DateHi, We have a requirement to determine the Invoice validation date . Please help us to get the query for the same. We tried using creation_date of xla_events by joining …Hitha Harikumar 831 views 5 comments 0 points Most recent by Julien_Dubouis Payables, Payments & Cash Management -
How to burst a standard report attachment run from scheduled process page to a users email?Summary: Our users spend so much time going into the system to download the files they run from the monitor/scheduled process page. We have already customized the Oracle…
-
Need a SQL Query Help To Fetch Non-PO Matched Invoice Lines (Account Payables)Summary: Our requirement is to fetch the Non-PO matched invoices, the query should even exclude Invoice lines which are associated with PO. Only Invoices without PO (at …Jayaram AnuPriya-Oracle 31 views 2 comments 0 points Most recent by Jayaram AnuPriya-Oracle Payables, Payments & Cash Management -
Sql Query to find the approver name for AP invoicesSummary: I am looking to get approver name for AP invoices Content (please ensure you mask any confidential information): Version (include the version you are using, if …Rahul K-Oracle 193 views 1 comment 0 points Most recent by Saurav Sunny Payables, Payments & Cash Management
-
PVO for tax line distributions of an invoice to load data to FAWSummary: we have a requirement to showcase tax line distributions if an invoice in a FAW report. These data is not coming to FAW from ERP through delivered pipelines. Wa…Balachandra reddy 22 views 1 comment 0 points Most recent by Daniela Petria-Oracle Reporting and Analytics for ERP
-
ISO 2022 Payment formatsSummary ISO 2022 Payment formatsContent Hello everyone, I am trying to understand how ISO 2022 payments work. How do we create those payment formats. If anybody has any …Lucky Sharma 58 views 6 comments 0 points Most recent by Lucky Sharma Payables, Payments & Cash Management -
Table Name for Approver's Data of BPM Worklist along with History of Approver'sSummary: Issue : Table Name for Approver's Data of BPM Worklist along with History of Approver's for a Person whose Task are Completed Now We want Table Name's for Appro…Roy Aniket 42 views 1 comment 0 points Most recent by Rama Mohan - Support-Oracle Payables, Payments & Cash Management
-
Different Bank Branch Number and Bank Alternate Branch Name in a single ISO20022 XML FileSummary: Different Bank Branch Number and Bank Alternate Branch Name in a single ISO20022 XML File Content (please ensure you mask any confidential information): We are …Christian Roxas 21 views 2 comments 0 points Most recent by Sunghpark Payables, Payments & Cash Management -
disable custom BIP report parameter once it's been selectedSummary: Content (please ensure you mask any confidential information): I have a custom BIP report it has parameter (list of value), say Invoice Number from AP table the…Support Team NAKAMOTO 3 views 0 comments 0 points Started by Support Team NAKAMOTO BI Publisher Learning Center
-
Bursting Report QuerySummary: I want to build report something like below: payment advise to supplier - Subject : Invoice ----- is paid mail body : Dear (supplier name)-->Got it , your invoi…Amit Saraf 11 views 2 comments 0 points Most recent by Mona Mantry Payables, Payments & Cash Management
-
How to enable BI for document fiscal classification fieldTeam, We are looking to enable BI for the field Document Fiscal Classification in invoice creation under the tax details. Enabling BI for the requested field will help u…
-
Not receiving email notifications for Invoice approvalsSummary Not receiving email notifications for Invoice approvalsContent Hi All, Not receiving email notifications for Invoice approvals Thanks, Dev Thota. Version 20CDevendra Thota 47 views 3 comments 3 points Most recent by Unnati Mandhare Payables, Payments & Cash Management
-
Is it possible to customize data model for check print reportIs it possible to customize data model for check print report to add additional fields.vikram khengare 1 view 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
AP Aging The report will present the invoices payed and unpaid status as of the date selected?Parameter As Of date = Due date The report will present the invoices payed and unpaid status as of the date selected But we are facing an issue with the invoices that ha…Mohammad Hussein 21 views 3 comments 0 points Most recent by Mohammad Hussein Payables, Payments & Cash Management