AutoInvoice Grouping Rules - Receivables

 

Auto-Invoice Grouping rules is a seeded functionality through which the system clubs the data which is imported from Order Management or other sources and creates Sales Invoice in Receivables. 

In EBS Grouping Rules can work with multiple Permutations and Combinations and we assign these rules in the "AR Transaction Source" Setup which is assigned to "Sales Order Transaction Type". Through this linkage system understands how to group the data from OM and creates Invoices in AR.

A few examples are Grouping by Sales Order.

Example: Grouping by Sales Order

Here "L.INTERFACE_LINE_ATTRIBUTE1" is the Sales Order Number

Assign this Grouping Rule to "AR Transaction Source"

To link this Grouping Rule we assign this Transaction Source to OM Transaction Type.

Creating Sales Orders and Importing them to AR.

O2C Accounting with GST (Tax Point Base - Invoice)

 

O2C Accounting with GST (Tax Point Base - Delivery)

 

Transaction Date Cannot be Future Date (Stuck in Transaction Open Interface)

Step 1: Query the record which needs to be updated

SELECT 
TRANSACTION_DATE,  MTI.*  

FROM  MTL_TRANSACTIONS_INTERFACE MTI
WHERE 
TRANSACTION_HEADER_ID='';     ---(From Transaction Open Interface)

BACK TO BACK PROCESS (OM)

BACK TO BACK PROCESS (ASSEMBLE TO ORDER)

Process: Back to Back is a process in which we assemble the product to sell it to our end customer. In Oracle EBS, we use a particular attribute (Assemble to Order) to do the process.

Steps to follow:

• ATO Item creation
• Sales Order Creation
• Requisition Import
• Auto-Create PO
• PO Receipt
• AP Invoice Creation (From PO)
• Ship Confirm of Sales Order
• Auto-Invoice Import (From OM to AR)

Request ID Stuck in AR Interface Lines

SYMPTOM:- When importing sales order from Order Management to Receivable, 'Auto-invoice Import Program' goes in error. Resulting in request id of 'Auto-invoice Import Program' got stored in receivable interface lines and unable to import order in receivables.

Analysis: The standard error due to which this issue occurs is that at time of 'Third Party Registration' of customer where registration number is entered incorrect, which leads in error-ed out of 'Autoinvoice Import Program'.

SOLUTION:-

Alternative 1 :-  

1. Do RMA for that particular sales order which will bring back the quantity of the item into the inventory. And delete both record of sales order and RMA order from receivable interface lines 
2. Correct the registration number at 'Third Party Registration Level'.
3. Create the sales order again and import it in receivables. 

Alternative 2 :-

create table RA_INT_LIN_BKP

as

select *

from RA_INTERFACE_LINES_ALL

where INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'

and INTERFACE_LINE_ATTRIBUTE1 = ''    ------(with Order Number)

and INTERFACE_STATUS is null;

-- 1 row should be backed up

create table RA_INT_SCR_BKP

as

select *

from RA_INTERFACE_SALESCREDITS_ALL

where INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'

and INTERFACE_LINE_ATTRIBUTE1 = ''    ------(with Order Number)

and INTERFACE_STATUS is null;

-- 1 row should be backed up

update RA_INTERFACE_LINES_ALL

set REQUEST_ID = null

where INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'

and INTERFACE_LINE_ATTRIBUTE1 = ''         ------(with Order Number)

and INTERFACE_STATUS is null;

-- 1 row should be updated

update RA_INTERFACE_SALESCREDITS_ALL

set REQUEST_ID = null

where INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'

and INTERFACE_LINE_ATTRIBUTE1 = ''         ------(with Order Number)

and INTERFACE_STATUS is null;

-- 1 row should be updated

commit;