Monday, 18 April 2016

Oracle E Business Suite - Replicate Seed Data

What is Replicate Seed Data ?

   Replicate Seed Data is a Concurrent Program.

What is the Purpose of Replicate Seed Data ?

The purpose of the Replicate Seed Data Concurrent Program is to populate the Installed modules seeded values, so that new organizations can use the seeded data.

Whenever new Organizations are created (under the Multi-org Setup, which is mandatory), running Replicate Seed data is a pre-requisite step before you can start working in the newly created organization.

The Replicate Seed Data Concurrent Program can be run for a particular Operating Unit or for all Operating Units (as it is not mandatory parameter)


The concept of the program is that whenever new organizations are created they should d have seeded data from all relevant modules for normal integration among the modules. The seeded data is basic data needed to perform basic steps when setting up a new organization. 
   
How to Run the Replicate Seed Data ?

Responsibility : System Administrator

Navigation : Request --> Run 

Select Single Request and Click Ok

Select the Replicate Seed Data From List of Values

Click Submit .

 
Other Important Points To note While Running Replicate Seed Data:

1. Ensure all Users are Logged Out of System (So that Program Populate the Seeded Values before Transacting in New Org)

2. No Transaction has to be Performed Before Completion of Replicate seed Data. 

Sunday, 17 April 2016

Oracle iSupplier Advanced Shipment and Billing Notice (ASBN)


What is ASBN ?

   ASBN - Advanced Shipment and Billing Notice, is Created by a Supplier Company to Notify the buying company about Shipment against PO and Billing Informations of the respective Shipment.

What are the advantages of ASBN ?

1.ASBN Provides Visibility of In transit shipments and Billing information against PO.

2. Create Shipment Record.

3.Create AP Invoice by Populating the Billing Information into Invoice Interface and Running Concurrent Program " Payables open interface Import".

What is the Difference Between ASN and ASBN?

 ASN Provides the Details of Shipment Made by Supplier against PO.

ASBN Provides the Details of Shipment along with Billing Information of the Shipment against a PO.
 

Process Flow in ASBN

Create a PO :

 

Creating ASBN

Navigation : iSupplier Portal ---> Shipments --->Shipment Notices --->Create Advance Shipment and Billing Notices

 


Select PO Line and Click add to Shipment Notice

Add Line Details


Click Shipment Header
Enter Shipment Information

 

Enter Freight Information

 

Enter Invoice Information (only Differentiator between ASN and ASBN)
 
 

If Required Change the Remit to Site Address
 
 


Click Submit
 
 

Now the Data Would have Got Populated in

1. RCV_HEADERS_INTERFACE
2.RCV_TRANSACTION_INTERFACE
3.MTL_TRANSACTION_LOTS_INTERFACE (For a Lot Based Items)

Once the Receiving Transaction processor is Run, a Shipment Record is Inserted into 

1.RCV_SHIPMENT_HEADERS.
2.RCV_SHIPMENT_LINES.
3.RCV_TRANSACTIONS.
4.MTL_LOT_NUMBERS.
5.RCV_LOT_TRANSACTIONS.
6.MTL_MATERIAL_TRANSACTIONS.

Parallely Billing Information is Inserted into Invoice Interface Table 

AP_INVOICES_INTERFACE
AP_INVOICE_LINES_INTERFACE

Upon Running the Payables open interface import an AP invoice is Created.
Data is Inserted into Invoice Base Tables.

1.AP_INVOICES_ALL
2.AP_INVOICE_LINES_ALL
3.AP_INVOICE_DISTRIBUTION_ALL

Important Point for ASBN.

1.Supplier site Cannot be flagged off as Pay on Receipt.

Reason : ASBN will populate the invoice information in Open interface and a AP Invoice (PO Matching) will be Created once the Receiving Transaction Processor and Payables open Interface is Run. if a Supplier site is Flagged as Pay on Receipt, Again the system Would Try to Create a New Invoice upon Creating the Receipt. Hence to Prevent Duplication, ASBN Allows Only PO With Supplier Site without Pay on Receipt Enabled.


Navigation: Purchasing ---> Purchase orders ---> Purchase orders ---> Terms ---> “Pay On” Should be Null

 

2.Consigned Flag cannot be equal to "Y".

Navigation: Purchasing ---> Purchase orders ---> Purchase orders ---> Shipments

Go to More Tab “Consigned” Flag Should be Null.
 

 

        3.The match option cannot be equal to 'R' (Match on Receipt) for any of the Order    Shipments

Navigation: Purchasing ---> Purchase orders ---> Purchase orders ---> Shipments

Go to More Tab “Invoice Match Option” Should Not be Receipt.