BI Publisher
Discussion List
-
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 1 view 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 31 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 …
-
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 32 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 548 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 11 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 42 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 187 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 11 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
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…
-
How to establish a connection from Oracle Cloud to Local printer to print chequesHow to establish a connection from Oracle Cloud to Local printer to print cheques Hi all, We are trying to establish a connection between Oracle Cloud and a local printe…Daniel Ackland 91 views 5 comments 0 points Most recent by Joseph Terry Payables, Payments & Cash Management
-
Query to get payment description from payable payment pageSummary: Hi everyone, I am building up a query for extracting all payable payment informations. I cannot find the payment description that I am able to see on the web pa…GNCC33 93 views 2 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management -
Work Confirmation with Invoice details reportSummary: PO Work Confirmation with Invoice details report Content (please ensure you mask any confidential information): Can someone help me provide a sample report cata… -
Customize CAMT.053 TemplateSummary: Hi All, We are looking to customize camt.053 template, and referring below document, but the instructions are not clear, do we have any better reference to cust…
-
add remittance message to remittance adviceSummary: I downloaded the XML payload and see Remittance Message in the payload, but is isn't available as a field when I try to add it in the field browser? Anyone succ…Alex Glose 31 views 7 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
create AP Invoice custom Inquiry role without using AP_MANAGE_PAYABLES_INVOICES_ACTIVITIES_PRIVSummary: can we create role for AP invoice Inquiry and view report access without using AP_MANAGE_PAYABLES_INVOICES_ACTIVITIES_PRIV" which Allows access to Oracle Fusion…manoj.kumar4 261 views 3 comments 0 points Most recent by Boying Payables, Payments & Cash Management
-
posistive pay CSV format with summary lineSummary: positive pay file in CSV format is generating only detail lines without summary. Used template from How to generate CSV format output for Positive pay file? (Do…Roman Havrylyak 11 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management -
Oracledatatable for supplier masterdata fieldsSummary: In an external application, we are creating checks on Supplier master data information combined with data from other sources. For 2 checks we need the data fiel…Daniel.Hut 24 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Document of record integration from HCM to 3rd party systemWe have requirement to build an integration for below points. Document integration: Document of record integration from HCM to 3rd party system (eg: passport, EID, Drivi…
-
Do we have any localization for SEPA payments in FinlandSummary: We are planning to implement SEPA payment for our Finland entity, but the standard SEPA formats provided by Oracle does not support Finnish bank requirements. I…Surya Skanska 1 view 1 comment 0 points Most recent by Nani Prasanth Doredla-Oracle Payables, Payments & Cash Management
-
Payment supervisor must not have access to Pending installments review page in PPR.Hi All, We have created a custom role for payment supervisor name as "XXXXX" in which our client has a requirement that payment supervisor must not have access to Pendin…Shilpa Pekade 21 views 1 comment 0 points Most recent by Nani Prasanth Doredla-Oracle Payables, Payments & Cash Management
-
How to enable Deep link on Payment Approval NotificationI need to add a deep link on Payment approval page, to show paid invoice details. What is the way to customize Payment approval Template to add the deep linkBindu Goyal 51 views 1 comment 0 points Most recent by Nani Prasanth Doredla-Oracle Payables, Payments & Cash Management
-
attach the PO and invoice documentThe Client requested to attach the PO and invoice document to the payment process requests approval notice. Is it applicable or not?Mohammad Hussein 1 view 1 comment 0 points Most recent by Nani Prasanth Doredla-Oracle Payables, Payments & Cash Management
-
My goal is to generate hyperlinks within BIP report outcomes, linking them to attachments related toSummary: I intend to create hyperlinks within BIP report results that correspond to attachments for AP Invoices. Clicking on these hyperlinks should lead to the display …bhavana.sudanagunta 155 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management