BI Publisher
Discussion List
-
How to concatonate two values into a single field on Positive Pay XML templateWe have a need to combine payee name and address line 2 into the same field for one of our Positive Pay XML templates. I have tried using the concatonation function disc…Daniel T Roy 12 views 4 comments 0 points Most recent by Daniel T Roy Payables, Payments & Cash Management -
Payment Approval History ReportHi Team, We are trying to develop a query for Payment Approval History Report. Business requested to pull the below details: Payment_number Submitted_By Submitted_Date P…Badripalli Archana-Oracle 129 views 4 comments 0 points Most recent by James McBride Payables, Payments & Cash Management
-
How can we get the Posted Revaluation amount calulation on Daily basis not period?Summary: Bank customer and daily running the revaluation and wants to see the posted revaluation amounts for each foreign currency and revaluation rate. Content (please …Eswarvoona-Oracle 11 views 1 comment 0 points Most recent by veerendranath pulivarthi-Oracle General Ledger & Intercompany
-
Fetch Payment File Reference into Disbursement Payment FileSummary: Fetch Payment File Reference into Disbursement Payment File Content (please ensure you mask any confidential information): We have a custom Disbursement payment…KDR 229 views 4 comments 0 points Most recent by ChaitratestUser Payables, Payments & Cash Management
-
Supplier number not displaying in AP Invoice Coding workflow notificationSummary: How to display Supplier number in AP Invoice Coding workflow notification? Content (please ensure you mask any confidential information): Upon receiving the inv…manojsharma2407.wa 11 views 2 comments 0 points Most recent by manojsharma2407.wa Payables, Payments & Cash Management
-
Empty fields are not displayed on the report output when exporting csvSummary: Empty fields are not displayed on the report output if it was Scheduled through Report and Analytics Content (please ensure you mask any confidential informatio…
-
How to fetch the payment date field under the payment tab (query required)Summary: Hi, I need to verify some information using Oracle BIP tools. Could you please provide the table or the query that will allow me to display the payables invoice…Emilie06 53 views 3 comments 0 points Most recent by Shouryadeep12-Oracle Payables, Payments & Cash Management -
Error on Payables Payment Register Data ModelSummary: Error on Payables Payment Register Data Model Content (please ensure you mask any confidential information): We have customized the seeded report/data model for…
-
Payment Process Request Status Report: Supplier Bank Account not populatedSummary: Hi, In the Seeded Payment Process Request Status Report , Supplier Bank Account is not populated although the supplier bank account is present on the invoice in…Shashank Shekhar 1 view 3 comments 0 points Most recent by AvinashRN Payables, Payments & Cash Management
-
Fusion Ap Invoice Workflow TablesHello Support, We have a requirement to get and build a report of the data stored in WF_NOTIFICATIONS tables of Oracle EBS system to Oracle Fusion System. In EBS we have…Nalsoft Pvt Ltd 77 views 2 comments 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management
-
Linking ce_statement_lines and ap_checks_allSummary: Hi all, I can't find a way to link the tables: ce_statement_lines and ap_checks_all. Is there any intermediate table to link these? Or any way to link bank stat…Sheik Shameem 45 views 4 comments 0 points Most recent by Sheik Shameem Payables, Payments & Cash Management -
Can we exclude Public Holidays when scheduling processesSummary: Our client has a requirement to exclude weekends and public holidays when scheduling, for some of the finance processes. We are able to see an option to exclude…Snehal H 32 views 5 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
What are the setups/steps needed to enable to print the checks in local language?We have a requirement from the Canada, that has to print the checks in their local language (Canadian French). Could you please provide the steps that need to enable in …Raju Thadakala_1234 32 views 3 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
SQL query to retrieve the canceled invoices amount as per the date for AP aging report.((select sum(aia1.CANCELLED_AMOUNT) from ap_invoices_all aia1 where 1=1 and aia1.APPROVAL_STATUS = 'CANCELLED' and aia1.invoice_id = aia.invoice_id AND :as_of_date < aia…Vikas V. Kamat 399 views 4 comments 0 points Most recent by Vikas V. Kamat Payables, Payments & Cash Management
-
Process Payment Files > ISO 20022 SEPA > Credit Transfer Messages > Predefined BI Publisher TemplateSummary: Process Payment Files > ISO 20022 SEPA > Credit Transfer Messages > Predefined BI Publisher Templates Content (required): Hello All, Regarding the ISO 20022 SEP…
-
In standard - Disbursement Payment File Formats report need xml /data model.Summary: User wants to see approval History details in Standard Disbursement Payment File Formats report. There is no data model available . Kindly provide the xml / dat…Naggrajan 32 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
How do we encrypt the Payables Payment Connection Credentials in the ERP database?Summary: How do we encrypt the Payables Payment Connection Credentials in the ERP database? They are encrypted on the screen but not in the ERP database tables which pos…CarmenR. 21 views 1 comment 0 points Most recent by Daniela Petria-Oracle Payables, Payments & Cash Management
-
Derive Logo on Payment File Format by Legal EntitySummary: Content (please ensure you mask any confidential information): Does anyone know the logic to derive a logo on a rtf payment file format by legal entity? For exa…Rory Mullin 11 views 2 comments 0 points Most recent by Rory Mullin Payables, Payments & Cash Management
-
Edit Bank Account Transfer XML PAIN 001 formatSummary: We are in the process of implementing bank account transfers and our bank is requesting the details in PAIN 001 XML format. Need help to get the XML format to e…Wilson Chelakadan 13 views 1 comment 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
Supplier Legal name change after few months in production and with existing open transactionsSummary Supplier Legal name change after few months in production and with existing open transactionsContent What is the best practice to handle the situation in Cloud i…Sam Samaddar 53 views 8 comments 0 points Most recent by Adman1234 Payables, Payments & Cash Management
-
Can we download AP invoice attchement for BU / period of timeSummary: Can we download AP invoice attchement for BU / period of time Content (please ensure you mask any confidential information): Can we download AP invoice attcheme… -
Regarding "SEPA Credit Transfer Initiation" paymentHello gurus, Good day! 1. I would need the original copy of "ABBL XML FORMAT" the xsl template for the "SEPA Credit Transfer Initiation (with unstructured remittance det…viji_r 32 views 1 comment 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management
-
How to fetch "Check Payment Status" and "Check Issued State" in HCM for US Payroll ?Summary Hi All, Kindly help me to fetch the details of the Check payment as in HCM. As I required a few below columns: Check Payment Status: What is the current status o…abhjkum-Oracle 18 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Check Printing IssueSummary: Overflow in Check Printing Content (please ensure you mask any confidential information): We have to customize the out of the Box Check Printing report. Above t…KetanDoshi 13 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
which table and column the 'Stage' field is fetched from in the 'Manage Payment Process Requests' ?From which table and column the 'Stage' field is fetched from in the 'Manage Payment Process Requests' screen in Oracle Fusion Payables as attached?Nirosha Yelicherla 62 views 4 comments 0 points Most recent by lkarthik-Oracle Payables, Payments & Cash Management
-
Payables Trial Balance Report ESS Job Template changeSummary: Hi, User requested to create a template change for Payables Trial Balance Report, the ESS job. As this is an oracle developed report you cant make a template ch…aireyevan 32 views 3 comments 0 points Most recent by Shouryadeep12-Oracle Payables, Payments & Cash Management
-
Will Oracle provide NAUPA Reporting format for unclaimed property filings to State?Summary: State of Illinois requires electronic reporting for the unclaimed escheatment property. Will Oracle Fusion create a reporting format in later releases to accomo…LE 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
ap_holds_all.last_updated_by as "HOLD_RELEASED_BY"This is related to the AP Invoice tax hold release. We are looking for the table details where the hold released by name will be captured for the AP Invoice. Currently w…POOJAJSINGH 23 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Query Invoice Group via BI ReportSummary: Content (please ensure you mask any confidential information): Is the business object Invoice Group available as column in one of the AP tables? Its available f…Rory Mullin 114 views 2 comments 0 points Most recent by Rory Mullin Payables, Payments & Cash Management