BI Publisher
Discussion List
-
Query to find the approver name for AP invoicesWhat is the query or table name where we can find the approver name and approval date(action date) for an AP invoice. The table ap_inv_aprvl_hist_all gives the approver …KanikaMahajan 262 views 1 comment 1 point Most recent by User_20PH8 Payables, Payments & Cash Management -
QR Codes For Billing and PaymentsSummary QR Code Integration For Oracle PaymentsContent This summer (June 2020) Switzerland has announced that it will be switching from payment slips (orange and red) to…User_8O6L5 118 views 5 comments 3 points Most recent by Ashutosh_Srivastava Payables, Payments & Cash Management
-
Customizing the Payables Workflow Transactions Listing seeded reportSummary: Business needed few more column for the seeded report, But we do not have access to Data model.Suggestions needed in order to get this done. Content (required):…NarenInova 1 view 4 comments 0 points Most recent by Raunak Kumar Singh Payables, Payments & Cash Management
-
Sandbox- Customize create AP invoiceI have a requirement to make the 'product type' field as non editable in the 'Create Invoice' Page from the supplier portal. Do we have a document with the steps to how …KanikaMahajan 13 views 0 comments 0 points Started by KanikaMahajan Payables, Payments & Cash Management
-
How to derive number of working/Businessdays in Fusion AP OTBI reportsSummary: How to derive number of working or Business days in Fusion AP OTBI reports while selecting data items via AP subject area
-
Adding distribution budget date, accounting date and expenditure item date to AP Invoice Approval RTSummary: Has anyone added these fields to the AP Invoice Approval RTF? Content (required): Users are requesting we add this to aid in year end processing of invoices to … -
OTBI Payment reportDeal all : I have a payment report when I log in it from the catalog and search for it an open it there's a criteria Payment date that appear But this same report if i s…mickel rmeily 11 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Which table can I use to know the approval status of the payments?Which table can I use to know the approval status of the payments in oracle fusion? Client has a requirement to build a custom report to view the unapproved wire payment…KanikaMahajan 11 views 2 comments 1 point Most recent by SimonTomey Payables, Payments & Cash Management
-
Suppliers are not receiving Remittance AdvisesSummary: For some reason, none of our suppliers are receiving any Remittance Advises. The configuration on disbursements options, Payment process profiles, and supplier …Murali M. 31 views 11 comments 0 points Most recent by Bhavik Shah Payables, Payments & Cash Management
-
Positive pay BIP job failure with message java.lang.Exception: BIP Job 566409 Failed.Positive pay BIP job failure with message java.lang.Exception: BIP Job 566409 Failed. There is nothing mentioned regarding why the job failed. It has the java.lang.excep…TNETUSER123 1 view 2 comments 0 points Most recent by Divya Sidhaiyan Payables, Payments & Cash Management
-
Can the ESS Payment File Register Job be modified to generate separate PDFs for each check?Summary: What options exist to obtain an individual pdf file each check that is currently generated in the single PDF for a particular payment batch? Content (required):…Gerardo Carrillo 21 views 1 comment 1 point Most recent by Glen Ryen Payables, Payments & Cash Management -
AUTOMATICALLY INCREMENT THE DATE PARAMETER FOR COST TRANSFERS TO COST MANAGEMENT SCHEDULE RUNSSummary: Hi Content (required): Currently, my team is testing the 21D release update. The aforementioned feature (AUTOMATICALLY INCREMENT THE DATE PARAMETER FOR COST TRA…Sheneli Fernando 1 view 3 comments 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Custom Remittance Advice Template not appearing in Manage formatsSeparate Remittance advice do not have a data model. I have created a custom template that in BI publisher in custom folder custom>financials>payments, but my custom tem…KanikaMahajan 1 view 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Ledger Amount Field in the Payment in Case of Foreign PaymentSummary: Needs to know the table and the field holding the payment ledger amount. Content (required): We have a requirement to fetch the information for the Ledger Amoun…Ahmed Maher K. 11 views 3 comments 0 points Most recent by Ahmed Maher K. Payables, Payments & Cash Management -
How to establish a connection from Oracle Cloud to Local printerHow 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 1 view 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
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 21 views 2 comments 0 points Most recent by Jesus N Payables, Payments & Cash Management
-
Does Invoice Imaging support Payable Invoice coming in Chinese Language?Summary Does Invoice Imaging support Payable Invoice coming in Chinese Language?Content Does Invoice Imaging support Payable Invoice coming in Chinese Language? Apprecia…Sam Samaddar 13 views 4 comments 1 point Most recent by Raj Bhakta Payables, Payments & Cash Management -
invoice attachments downloadingDear All Whenever we are checking an invoice and we want to see the attachment of that invoice once we click on it the system will automatically download it. Is there a …mickel rmeily 1 view 1 comment 0 points Most recent by David Mckenna Payables, Payments & Cash Management
-
Can Last_update_date be taken as the date when invoice hold was released in AP_HOLDS_ALL?Which table and column will give the details of the invoice hold release date and invoice released by name ? Release 22BKanikaMahajan 11 views 1 comment 0 points Most recent by Hari Sanka-Oracle Payables, Payments & Cash Management
-
Payables Invoice Audit by Voucher Number ListingWhich role is required to run "Payables Invoice Audit by voucher number listing report" in oracle cloud in scheduled processes?Kanika Mahajan 1 view 0 comments 1 point Started by Kanika Mahajan Payables, Payments & Cash Management
-
Accounts Payable Trial Balance Report - no detailsSummary: Why do I only see a summarized amount, when running Accounts Payable Trial Balance Report? How do I get details per supplier? Content (required): Version (inclu…Bo Tøpgaard 1 view 2 comments 1 point Most recent by Bo Tøpgaard Payables, Payments & Cash Management
-
Seperate Remittance Advice EmailSummary Add a cc email to Seperate Remittance AdviceContent Hi We wish to track SRA by creating group e-mails that include the supplier name and another CC e-mail addres…SarahL 32 views 7 comments 0 points Most recent by Sujatha Kumari Payables, Payments & Cash Management -
PPR Disbursement Payment File Format - Error importing Custom TemplateSummary We used to import Custom Template in a Standard Oracle Report (Disbursement Payment File Format for PPR) but now it's not allowing or erroring outContent Hi, We … -
PGP Payment File Encryption and Decryption of MT940Summary Need to sign payment files generated via BI Report with Oracle PGP private key and encrypt the payment file using Bank public PGP keyContent We have this require…User_9YT5L 30 views 1 comment 1 point Most recent by User_5XX7A Payables, Payments & Cash Management
-
We have a requirement to send an encrypted payment file to bank from oracle system.We have a requirement to send an encrypted payment file to bank from oracle system. Bank is not willing to provide any encryption keys. How can the above requirement be …Kanika Mahajan 11 views 1 comment 0 points Most recent by Danut Stoian-Oracle Payables, Payments & Cash Management
-
Remittance Advice for Manual PaymentsHey, Separate Remittance Advice ESS process do gets triggered when we run a payment through Submit Payment Process Request and can also be manually triggered by selectin…Kanika Mahajan 11 views 1 comment 0 points Most recent by Kanika Mahajan Payables, Payments & Cash Management
-
Can an ISO 20022 CGI Payment File contain more than one Payment Method?Summary: Can an ISO 20022 CGI Payment File contain more than one Payment Method? Content (required): We are planning to use the ISO 20022 CGI seeded template to create a…
-
Auditing changes of VAT codes between PO and AP PO InvoiceSummary: Report of differences of VAT codes between Invoice lines and matched PO. Content (required): I am trying to create a report of any invoices that have a differen…AngelOftheNorth 1 view 1 comment 0 points Most recent by Simona Ipate-Oracle Payables, Payments & Cash Management
-
Is there a link between Contact and Bank account?Summary: We want to develop a report which list all the active bank account with their specific contacts. Content (required): I have been able to link the 2 using BI pub…Remi Grégoire-Jacques 11 views 2 comments 0 points Most recent by Remi Grégoire-Jacques Payables, Payments & Cash Management
-
User GUID populated for field Created byHi All, We would like to understand why user GUID is captured for few records in GL_CODE_COMBINATIONS table and for few records we have username populated. We could see …Swapnil Kashid 1 view 0 comments 0 points Started by Swapnil Kashid Payables, Payments & Cash Management