BI Publisher
Discussion List
-
XML file Required for Positive Pay etext template customizationSummary XML file Required for Positive Pay etext template customizationContent please let me know how to fetch the positive pay xml file required for etext template Vers…Smandanak 657 views 9 comments 1 point Most recent by ShrutiSood Payables, Payments & Cash Management -
For Disbursement Positive Pay File Formats Report; below ETEXT format is requirement.Summary: In the Disbursement Positive Pay File Formats Report output file, we want a single payment header 'A' type record and single payment trailer 'Z' record even tho…MANI SATYA SAI CHERUKURI 4 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
RTF template doing sorting by name is there any data restrictWe want to sort the data in alphabetical order for “Payment Process request status report”. This is the seeded report provided by oracle when PPR is ran. Seeded report i…SivaRamaKrishna-Oracle 12 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
Payment File submission to Natwest Bankline using BI Publisher deemed now as non compliantSummary: Natwest Bankline contacted us late 2023 to state that the OracleCorp XML Publisher software that is used to SFTP the payment file across as being Non-Compliant …
-
How do i access "Procurement Audit Details Report" in Oracle Fusion?Summary: How do i access "Procurement Audit Details Report" in Oracle Fusion? Content (required): How do i access "Procurement Audit Details Report" in Oracle Fusion? Is…AkashAgarwal 33 views 2 comments 1 point Most recent by SrikrishnaKarnatapu Payables, Payments & Cash Management
-
Payment Status: Pending action to address payment validation errors.Summary Payment Status: Pending action to address payment validation errors.Content Hi All, Payment Status: Pending action to address payment validation errors. Thanks, …Devendra Thota 208 views 2 comments 3 points Most recent by Senthil Mohanraj Payables, Payments & Cash Management
-
is there any rest api to get all rejected ap invoices?Summar Summary: Is there a REST API available for fetching all rejected AP invoices? If yes, how can it be utilized? Content: [Please provide any relevant information] V…Nikhil Pande 12 views 1 comment 0 points Most recent by Purvi -Oracle Payables, Payments & Cash Management
-
Is there a way to add field in Edit distribution feature on the BPM notificationIs it possible to pull the accounting date field into the BPM notification and make it editable when using the edit distributions feature on an invoice notificationAkanksha Bhardwaj 32 views 5 comments 0 points Most recent by Tara Ebarb Payables, Payments & Cash Management -
Payables Module: Specific tables and fields where the employee banking information is stored?Summary: I've been asked by one of our internal auditors the following 2 questions specific to the Oracle Accounts Payable module: List the specific tables and fields wh…K Hart13 76 views 5 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
How to get organization ID and name of bank statement data?Summary: We are trying to create custom BIP report that would output the bank statement import errors and successful data. Among the fields required by client was to add…Patricia Azucena 4 views 1 comment 0 points Most recent by Julien_Dubouis Payables, Payments & Cash Management
-
Test Changes to AP ChecksSummary: Is there an easy way to test the formatting of AP checks? Content (please ensure you mask any confidential information): We recently had to make a change to our…Raz Baboorian 32 views 4 comments 0 points Most recent by Raz Baboorian Payables, Payments & Cash Management
-
TransactionDocumentExtractDm data model used for Disbursement Payment File FormatsHi Guys Does anyone know of the existence of comprehensive documentation around the set of fields that are available to be used in a new "Disbursement Payment File Forma…
-
Printing the check number at the bottom of the physical AP Check reportSummary: We have created a custom AP Check RTF template based on the client's requirements. The custom RTF template is used in the Disbursement Payment File Formats repo…shrikardixit 22 views 1 comment 0 points Most recent by Trang Tran UCD Payables, Payments & Cash Management
-
Customization of seeded "Supplier Balance Aging Report"Summary:Hi, I am looking for customization of seeded Supplier Balance Aging Report in Oracle fusion application where I want to add currency as a parameter to run the re…Shraddhha Namde 161 views 11 comments 0 points Most recent by B Sekhar Reporting and Analytics for ERP
-
Generate ISOXML Payment Files in non-EnglishSummary: All our data entered for Suppliers and Bank Accounts were in English. We have countries like China, Taiwan, Japan and Korea requiring to send the files in local…Mani.Kumar 2 views 3 comments 0 points Most recent by Glen/Oracle Support-Oracle Payables, Payments & Cash Management
-
SQL for Invoice Status based on As-of DateHi Team, Can you please help provide a sample SQL where I can select the invoice amount and status based on as-of date. For example, as of 24th Jan 2024.. invoice 001 wa…Kaz 41 views 2 comments 0 points Most recent by Glen/Oracle Support-Oracle Payables, Payments & Cash Management
-
Payment infotile on the Invoices landing pageSummary: Starting Update 22C, the Payment infotile on the Invoices landing page is no longer be available. Has anyone recreated the Infotile, and can share? Content (req…AVorster-Oracle 32 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Is there a way to index a DFF Attribute?Summary: Our solution calls for use of DFF attributes to capture data from boundary applications that should be used as parameters and filtering in BIP/OTBI reports and …
-
Can anyone suggest some tips to optimize SQL queries for slow running BI reportsSummary: Can anyone suggest some tips to optimize SQL queries for slow running BI reports. Please share your knowledge or experience here. Content (please ensure you mas… -
24B FTP server errorSummary: We have certain BIP Reports setup in various environment and most of them have no issue except Dev1 environment, which was updated on 24B and when reports jobs …
-
Invoices incomplete status with yellow exclamation markSummary: Invoices imported by IDR are in an incomplete status. The lines on the invoices have a yellow exclamation mark, with type Item. We have a requirement to report …Narinder Sian 29 views 2 comments 0 points Most recent by Narinder Sian Payables, Payments & Cash Management
-
Direct Connectivity from SaaS with AWS S3Summary: Hi, Please advise if SaaS ERP can have a direct connection to AWS S3 to burst BI Publisher outputs to S3 storage. This is related to Payables module in ERP.Kay24 34 views 1 comment 0 points Most recent by Ionut Sanda-Oracle Payables, Payments & Cash Management
-
Is there a way to restrict Invoice Approval Email Notification in Oracle Fusion?Summary: We have several approval rules configured for AP Invoices. The requirement is to restrict oracle to send an approval email notification ONLY when specific appro…nbatra 488 views 11 comments 0 points Most recent by Unnati Mandhare Payables, Payments & Cash Management
-
Disbursement Payment File Formats : etext output file corruption?Hi Guys I am getting what appears to be corruption at the beginning of my payment text file as below, has anyone had this before? ???????????????????????????????????????…
-
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 13 views 1 comment 1 point Most recent by Marx Rivera-Oracle Payables, Payments & Cash Management -
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 33 views 2 comments 1 point Most recent by Brian Burns Payables, Payments & Cash Management
-
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 173 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…
-
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 12 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management