BI Publisher
Discussion List
-
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 732 views 13 comments 3 points Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management -
Table details to get Business unit for a tax code definedSummary: We need table or query to fetch business unit name for the given tax rate code. Content (required): Version (include the version you are using, if applicable): …Nishanth B Jain 132 views 4 comments 0 points Most recent by Nishanth B Jain Payables, Payments & Cash Management -
Self Service related Privilege's for Oracle Fusion PayablesSummary: We are looking Self service related Privilege's to Invoice Payables. The below two privileges provide access to Payables and are considered part of the license …Linga Murthy 219 views 4 comments 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management -
Report Fail with ErrorSummary: Content (please ensure you mask any confidential information): I have created a report to retrieve unreconciled transaction details. The report contains four da…Tharushi Sathsarani 11 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
Is there a way to extract the information regarding the Overflow Check Numbers in Oracle?Auditors needing to see the Overflow check numbers and I could not find any reports that can do fetch that information. Any reference or pointers will be greatly appreci…Kay 2 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management -
Load and Import Bank Statement Warning messageSummary: Hi Team, We are loading the bank statement using SOAP Services to run the "Load and Import Bank Statement" process. We are using a BI report to fetch the error …Rajeev Nayan 11 views 3 comments 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management -
Unable to track the changes made in BPM rules through audit reports when migrated from SOA composerSummary: We are trying to track the changes made in BPM rules. We are able to get the details in audit report when we are updating the rules manually but when the change…Surendra Rodge 12 views 1 comment 0 points Most recent by Cosmin Nadolu-Oracle Payables, Payments & Cash Management -
Back-end table for Vacation Rule delegation and Task delegationHi Cloud Community, We have an audit requirement to get details on the Vacation Rules set by the user and based on the certain criterion it will be marked as compliant /…Tushar_Singhania 43 views 2 comments 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management -
How to use round and sum in ctrlsum tag in oracle payment fileSummary: We need to show total in ctrl sum below. ex. payment1 : $100.1 ,payment2 : 100.4 the payment amount to show 100 and 100 as we doing round off. ctrl sum should s…harshalda 62 views 1 comment 0 points Most recent by Lakshmi Reddy Kishtipati Payables, Payments & Cash Management -
Manually uploaded attachments to invoice is not showing in UCM , even though have all the privilegesSummary: Manually uploaded attachments to invoice is not showing in UCM with CS attachment ID, even though have all the privileges and roles. For IDR invoices am able se…sindarapu 4 views 2 comments 0 points Most recent by Aleksandra Bykhan Payables, Payments & Cash Management -
packages for extending attributesSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Raj Koppanathi 1 view 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Unable to pull unencrypted bank account details through view iby_ext_bank_accounts_vWe need to share the unencrypted unmasked Bank Account data of certain suppliers. But when we use the View IBY_EXT_BANK_ACCOUNTS_V to get the CLEAR_BANK_ACCOUNT_NUMBER f…AbdulBasith 105 views 3 comments 0 points Most recent by Srinivas Nimmalapudi-Oracle Payables, Payments & Cash Management -
Banco de Chile Electronic Payment File FormatHi, Can anybody share here "Banco de Chile Electronic Payment File Format"?CA Nirmal Choudhary 11 views 2 comments 0 points Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management -
We are not able to see the Retainage column in the seeded XML Separate Remittance Advice ReportSummary: Please let me know how we can include the retainage column XML tag in the seeded Separate Remittance Advice Report Content (please ensure you mask any confident…Karnati Saisree 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
ISO20022 Format failing in CGI ValidationSummary: We use BMO Harris as our bank and we are trying automate Wire Payments. Bank supports ISO2022 Format, so we are trying to use ISO2022 format to send disbursemen…Sabarish Reddy Ganda 34 views 5 comments 0 points Most recent by Radhika Agarwal Sundarlal Payables, Payments & Cash Management -
Unable to Cancel AP Invoice(I Supplier Portal) using Rest API.Summary: Hi All, Our business receives a lot of invoices thru Supplier Portal, and some of them are rejected in the approval process. However, if the rejected invoices a…K venkatesh 44 views 2 comments 0 points Most recent by K venkatesh Payables, Payments & Cash Management -
I am trying to add intermediary bank accounts to our Wire Payment formatSummary Trying to add intermediary banks to our Wire Payment format for boa using a BAFF file formatContent I am trying to add intermediary banks to the payment formats …ChrisKellogg 232 views 17 comments 1 point Most recent by Glen Ryen Payables, Payments & Cash Management -
Sql to fetch Payload Rules dataSummary: What are the SQL tables to fetch data that we are seeing below - payload rule name, business object, real-time payload, batch payload, attribute, required, incl…Akhila 33 views 2 comments 0 points Most recent by Akhila Payroll and Global Payroll Interface (GPI) -
Positive pay files template migration through pasteItem2 soap APISummary: when using the pasteItem2 SOAP API to import the customized seeded report layout positive pay file, we encounter an issue: the report layout is successfully upl…Thyagaraju 5 views 1 comment 0 points Most recent by Thyagaraju Payables, Payments & Cash Management -
Send Separate Remittance AdviceSummary Send Separate Remittance Advice process completes successfully but mail notification not receivedContent Hi All, We have Setup the Separate Remittance Advice and…Surya Muralidharan-185000 147 views 13 comments 1 point Most recent by Lynn Du-Oracle Payables, Payments & Cash Management -
Unable to view the Output in ESS JobHI Team, When invoice import is done the ESS job(Import Payables Invoices Report) is being executed and the report is not generating at ESS Job level as showed in attach…Sarath Lakshman 64 views 2 comments 0 points Most recent by Sarath Lakshman Payables, Payments & Cash Management -
Enabling Pay Group in Payment File - 23A FeatureSummary: Reviewing some earlier What's New Features - I came across this in 23A: VAT PAYMENT IN LOCAL CURRENCY FOR POLAND FOREIGN CURRENCY INVOICES As part of this - I n… -
Is ABA format supported for payment file generation in Oracle Fusion?Summary: Is ABA format supported for payment file generation in Oracle Fusion? If yes, could you please provide some docs or analysis. Content (please ensure you mask an…Stephen Sushanth Alexander 44 views 2 comments 1 point Most recent by Nauman Khan Payables, Payments & Cash Management -
Print checks in dot matrix printerSummary: We are not able to print checks on an Epson printer directly from Oracle for our client in Central America. Content (please ensure you mask any confidential inf…Nestor Eyros 51 views 3 comments 0 points Most recent by AllenN Payables, Payments & Cash Management -
Need AP Aging Report based on Date parameter ,standard report does not allow to give Date paramSummary: Need AP Aging Report based on Date parameter ,standard report doesnot allow to give Date param Content (please ensure you mask any confidential information): Ve…Meer Muzafar Ali 2 views 1 comment 0 points Most recent by Damodharan Selvaraj-Oracle Payables, Payments & Cash Management -
Block invoice hold release on mail notificationsSummary: Block invoice hold release on mail notifications Content (please ensure you mask any confidential information): Hi, invoice hold notifications are sent to reque…Antoine.Kaiber 22 views 1 comment 0 points Most recent by Antoine.Kaiber Payables, Payments & Cash Management -
SQL Query to get Scanned Invoices as mentioned in UI PageWe would like to get SQL query for Scanned, Hold and Paid Invoices as mentioned in UI Page. Please find the below screenshot for more details. Also, we have SQL queries …Chandana Priya-Oracle 137 views 9 comments 0 points Most recent by AllenN Payables, Payments & Cash Management -
Need API for Lookup type PAY GROUP in Manage payables lookupsSummary: Hi Team, Do we have any REST API to get data for the lookup type for PAY GROUP under Manage payables lookups ? We found one API for this is not working to get f… -
How to auto increment the date parameters of the seeded report?Summary: I need to schedule the report on a monthly basis and will auto increment the said parameters. Payables Invoice Register: -From Entered Date -To Entered Date -Ac…User_7KNJ1 38 views 5 comments 1 point Most recent by Venk Kudire- Support-Oracle Payables, Payments & Cash Management -
The column "Accounting Status" on Manage Invoice screen is which table information?Summary: From which table can I get the "Partially accounted" in the attached image? Content (required): PATH :: HOME>Invoices>Task:Manage Invoices I want to get the val…REI TSUKAHAR-Oracle 680 views 6 comments 0 points Most recent by MarkGauthier Payables, Payments & Cash Management