How to sweep AR (Receivables) transactions that are in accounting error in Oracle EBS 12.1 or 12.2

In the second part of 2015 I came across with a new functionality available at that time for Oracle Receivable EBS release 12.2.x and just made available for release 12.1.x in 2016.

This functionality was known for Oracle Payables module but not for Receivables. I'm sure most of you will be happy mainly if you have struggled in the past to close Receivable accounting period on time but due to various accounting errors that was not possible. As workaround you closed period in pending status until fix was found.

AR sweep functionality is now available only for transactions that are in accounting error (xla_events table - fields event_status_code = U and process_status_code = I) and can be enabled after below patches are applied.
- For Release 12.1, the Manage Exception Functionality is available through Patch 22482346, and in the FEB-2016 RPC Patch 22471504.
- For Release 12.2, it is available through Patch 16634326.

If you are interested how to enable it and how it work feel free to take a look to below demo.

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 Copy or Generate Multiple Invoices From an Existing Receivable Transaction in Oracle eBS R12?

In different occasions I met people that were keying monthly or on a regular bases receivable transactions/invoices for same customer having same amount and under same contractual conditions.

Even if is not quite same amount but all the other information (customer, lines details) are similar you can successfully use the Copy To functionality in Oracle eBS Accounts Receivables.

Steps

1. Find the invoice / transaction you want to copy
2. Copy same invoice using Daily option
3. Copy same invoice using Monthly option
4. Copy same invoice using Annually option
5. Review generated transactions - output file
6. Review generated transactions - workbench

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

For some other helpful videos check my YouTube Channel. 

To receive notifications for new articles subscribe to this blog.

Email Address 

How to Find Invoice Receipt From Transaction Workbench in Oracle eBusiness Suite R12?

This video will walk you through invoice receipt details starting from receivables transactions workbench or from Account Details screen.

Steps included:

1. Find a paid receivables transaction / invoice
2. Transaction balance due details
3. Invoice has three receipt actions on it
4. Review each receipt details
5. Same details may be found from Account Details screen

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

For some other helpful videos check my YouTube Channel. 

To receive notifications for new articles subscribe to this blog.

Email Address