Overview of Oracle EBS R12.2 Bank Payment Acknowledgement Processing in Payments Module

 

In this post I'm showing the EBS Payment Acknowledgement functionality delivered by Oracle starting with Release 12.2, or higher.

To prepare this demo I have used Oracle Support note 1493240.1 - R12.2: Bank Payment Acknowledgement Processing in Oracle Payments/Payables.

I have found this new functionality very useful as in my past projects we identified as a gap the payment acknowledgement process when the bank messages were handled outside EBS (by email) or by a custom solution (custom tables to store bank messages and custom reports to be published to business users).

Payment Acknowledgement functionality is about to load and display in EBS the bank processing status for each of your supplier/employee payments after successful transmission of the payment file to your bank.

Starting with release 12.2 a standard API is available to load acknowledgement file but the load of files to EBS database and call of API is subject of additional development.

From a setup point of view only Bank Acknowledgement Code Setup is required as your bank status codes should be mapped to ISO statuses provided by Oracle Payments:

• Accepted technical, syntactical and profile; passed to back office          (BACKOFF)
• Accepted back office; passed to clearing          (CLEAR)
• Accepted with change   (ACCC)
• Pending further processing        (PEND)
• Rejection          (REJECT)

From EBS process point of view this functionality will just show to you the bank status of your payment but will NOT:

• Void/change EBS payment status in Oracle Payments/Payables 
•  Impact bank reconciliation process in Cash Management

View end to end demo about EBS Payment Acknowledgement functionality delivered by Oracle starting with Release 12.2, or higher. 

For this demonstration I have used the E-Business Suite 12.2.4 VM Virtual Appliances provided by Oracle Software Delivery Cloud 

 

If you liked this article feel free to share it with your fellows. Thank you! 

For some other helpful videos check my YouTube Channel. 

To receive notifications for new articles follow me

Or subscribe by email

Email Address

How to use Microsoft Excel spreadsheets to create or modify Oracle EBS Purchase Order Lines?

Starting with Oracle EBS release 12.2.4 users may use Microsoft Excel (WebADI) functionality to create or modify Purchase Order Lines, Schedules and Distributions.

This information is from Oracle Procurement Releases 12.1 and 12.2 (inclusive of 12.0.2 – 12.0.7) document version 5.1 published on July 28, 2014.

At the PO Header level users can create or update lines, schedules and distributions in Excel and import these additions into the document. This feature may also be used at the line, schedule, pay item and distribution levels.

In this video I'm demonstrating how to use Microsoft Excel (Office 365) to create a new line for an existing Purchase Order (PO) and also to change price and quantity for existing PO lines.

This option is accessible only under Buyer Work Center (BWC) - Purchasing responsibility for all PO levels - header, lines, schedules and distributions. Based on the level you access "Update with Excel" option a different Excel template will be downloaded and displayed fields will be specific to each level (line, schedule, distribution).

PO lines before update

Microsoft Excel (Office 365) template automatically generated by Oracle EBS

 PO lines after update

View end to end demo about Microsoft Excel (WebADI) functionality to create or modify Purchase Order Lines.

For this demonstration I have used the E-Business Suite 12.2.4 VM Virtual Appliances provided by Oracle Software Delivery Cloud

If you liked this article feel free to share it with your fellows. Thank you! 

For some other helpful videos check my YouTube Channel. 

To receive notifications for new articles follow me

Or subscribe by email

Email Address