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)

TDS Sec. 194(Q) Setup-EBS

Govt. Notification - Finance Act, 2021 inserted a new section 194Q in the Income-tax Act 1961 (hereinafter referred to as "the Act") which takes effect from I st day of July, 202 I. It applies to any buyer who is responsible for paying any sum to any resident seller for purchase of any goods of the value or aggregate of value exceeding fifty lakh rupees in any previous year. The buyer, at the time of credit of such sum to the account of the seller or at the time of payment, whichever is earlier, is required to deduct an amount equal to 0.1 % of such sum exceeding fifty lakh rupees as income tax.

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;