AP Suppliers in R12

on Wednesday, March 3, 2010

In R12 Accounts Payables, that there is no more supplier form. The Suppliers have gone to self-service now. This is not the only change in the supplier. The suppliers objects have moved from AP product to TCA (Trading Community Architecture) DataModel. Due to this, even the underlying tables have changed. Supplier information is no more stored in PO_VENDORS Table now.

3 new tables have been introduced.

• AP_SUPPLIERS

• AP_SUPPLIER_SITES_ALL

• AP_SUPPLIER_CONTACTS

But don't panic as your customizations can still work as there are views created with names of PO_VENDORS, PO_VENDOR_SITES_ALL and PO_VENDOR_CONTACTS for backward compatibility.

Being a part of the TCA, these tables are closely linked to the hz tables. Here is the list of few imp HZ Tables that are affected when a new supplier is added.

TABLE NAME

DESCRIPTION

HZ_PARTIES

Master table along with AP_SUPPLIERS instead of PO_VENDORS

HZ_PARTY_SITES

Master table for supplier sites along with AP_SUPPLIER_SITES_ALL instead of PO_VENDORS_SITES_ALL

HZ_LOCATIONS

Contains the party sites information

HZ_PARTY_USG_ASSIGNMENTS

Stores party usages

HZ_ORGANIZATION_PROFILES

Captures additional Supplier information, e.g. credit scoring details of Supplier or the Number of Employees working in Supplier Organization

IBY_EXTERNAL_PAYEES_ALL

Captures Payment related details of the Supplier

POS_SUPPLIER_MAPPINGS

It holds the mapping between the AP_SUPPLIERS.VENDOR_ID and HZ_PARTIES.PARTY_ID

This is useful in cases whereby two vendors effectively belong the same HZ_Party Record.

See the diagram below for Supplier/Sites Mappings to TCA Objects.



So whenever a supplier is added in R12, an entry is made in all these tables. Functionally also, creating the supplier is different from 11i. Here are the steps to create a new supplier.

1. Hit the CREATE SUPPLIER button

2. Enter a unique supplier name (Organization Name) along with other optional other information like Alias, Tax Registration Number, D-U-N-S number.

3. If the Supplier Number Entry option in the Payables System Setup window is set to Automatic, Payables automatically enters a Supplier Number for you. If this option is set to Manual, you must enter a unique Supplier Number.

4. Click Apply. The system creates the supplier record and accesses the Suppliers: Quick Update page.

5. To create Supplier Sites, you will have to create the locations for that supplier. For that, click on the "Address Book" Button.

6. On the Address Book page, click the Create button.

7. Fill all the address details and address purpose. i.e. Purchasing, Payment or RFQ Only.

8. You can add as many locations as you wish.

9. When created, you can manage the addresses for other information.



<< Click to view the image in large size >>

10. The system only displays sites that are in your MOAC profile

11. The address status indicates whether the supplier has provided any updates for the address. Using iSupplier Portal's Supplier Profile Management tools, suppliers can enter address book information online, creating any number of new addresses, modifying the details for existing addresses, and indicating how each address is used.

12. Suppliers can also inactivate addresses that are obsolete. Buyer administrators need to approve any changes in order to update the master supplier details.

13. Address statuses include:

• New. A supplier has created a new address.

• Change Pending. A supplier has changed the address details. Click the Update icon to review the changes that have been made. The page displays the original address details and the changes, indicated by a blue dot. Buyer administrators can approve or make additional modifications to the changes before approving or rejecting the change. If the supplier has indicated that the address should be removed, there is a status change from Active to Inactive.

• Current. There are no pending updates for the address.

14. Since suppliers are stored in TCA, the address details for the supplier may be used by other Oracle products so be careful if removing supplier addresses. If the address is inactivated, the system no longer associates it to any contacts, and any bank account assignments to the address are inactivated. Methods to inactivate addresses include:

• You can click the Remove button on the Address Book page. This sets the address status to inactive and sets the Inactive Date for every site that is associated with the address in all operating units to today's date.

• You can update the address and set its status to Inactive. This changes the address status and does not inactivate any of the sites that are using the address.

• You can use the Manage Sites page to manually update the Inactive Date for each site.

Overview of Oracle Inventory

on Monday, March 1, 2010

Oracle Inventory is core module of entire Oracle e-business suite, this module shares the information with almost every other module. Oracle Inventory let you define the Items and it is backbone of all inventory transactions.

Functionality provided by Oracle Inventory

Item Master

Item setup is critical part of Oracle ERP implementation. Item setup is required to place purchase orders, receive & transact inventory, to enter sales orders, ship goods/services to customer. Items are first setup in master inventory organization and same can enabled in every other inventory organization where it needs to transact. Item attributes are different flags that determine the characteristics of items. Item attributes determine whether item is procured item, saleable item, service item etc.

Inventory transactions

Inventory holds the onhand quantities and transactions that can cause onhand changes. Transactions originated from other modules (Shipping - customer shipments, Purchasing - Receiving goods into stock etc) are finally transferred to Inventory. Every transaction is associated with a transaction type, source, Item, quantity, unit of measure and additional attributes. Oracle provides many seeded transaction types and you can add custom transaction types as needed for accurate reporting.

Examples of Inventory transactions

       
Subinventory transfers

       
Miscellaneous issue/receive

       
Account Alias issue/receive

       
Move order issue

       
Sales order shipment

Serial & Lot control Its provides detail tracking of onhand and related inventory transactions. Lot number and serial number are critical requirements in a regulated environment like pharmacuetical, food processing industries. In case of any recalls lot/serial control provides tracing the current location of goods.

Inventory Planning

Oracle Inventory planning provides good planning methodoligies for indirect item purchases, MRO kinds of items while MRP (Material Requirements Planning) as planning method is still preferred for direct material. MRP functionality is delivered through Oracle MRP/SCP module. Widely known inventory planning methods are Reorder planning & Min-max planning, lets understand little bit more about these methods.

Reorder Point Planning (ROP) ROP uses Supply (onhand + expected receipts) and safety stock information to plan the re-order quantity. When supply falls below safestock a replenishment order is created considering the lead time and economic order quantity.

Min-Max Planning This planning method is bit different from ROP, The replenishment order is created when onhands falls below the minimum level set at the item.

Periodic Inventory verification methods

It is very important to have systematic onhand match with actual physical onhands for data accuracy and efficient planning purpose. Oracle Inventory provides two onhands verification and rconcialiation methods called Physcial Inventory and Cycle counting.

Physical Inventory It is an activity where 100% of onhand is physically verified and reconciled with system onhand. Typically this is done once a year or twice based on business needs. When physical inventory in progress typically all other operations will be on hold. Any differences in physical and systematic onhands are adjusted and approved in system and matched with physical onhand quantity.

Cycle counting It is a periodic counting process instead of onetime process like physical inventory. In cycle couting items are classified into ABC classes (high, medium, low value items). High value items are verified more frequent than low low value items. System generates the schedule of items that need to be counted and verified.

Overview of ERP

on Friday, February 26, 2010

An Enterprise Resource Planning (ERP) system is an information system that is implemented throughout an enterprise with the objective of making information accessible to everyone within the organization in real-time. These systems are designed to integrate all areas of the enterprise including financial accounting, sales, distribution, inventory, and human resources, and thus improve the performance of the organization in terms of resource planning, management control, and operational control.

            

ADVANTAGES

There are many advantages associated with an effectively implemented ERP system. Typical advantages include:

  • Significant cost savings
  • Valuable time savings – speeding up all areas of the business process
  • Accessible information throughout an enterprise in real-time
  • Gives managers and senior executives the ability to monitor activity, strategically plan, and make timely decisions, particularly in global organizations
  • Automates business activities in each area of the enterprise
  • Improving design and engineering practices
  • The process of tracking purchase orders and shipping products to customers (what was ordered, what arrived, what the seller invoiced)
  • Improved finance and accounting activities – by integration of cost, profit, and revenue information and improved presentation of this information [3]
  • By tracking products and sales, managers can realize which products are successful and which products they need to improve/ redesign
  • Improved security against employee crimes
  • Creates a competitive advantage over competitors not using ERP systems


 DISADVANTAGES

Although there are many significant advantages of ERP systems which contribute to competitive advantages and great success, there are also many disadvantages or downfalls. The biggest disadvantage of ERP systems is they can be very difficult and costly to implement and integrate into a large organization. Implementing a system requires a considerable amount of time and financial investment due to on-going training for all employees and it can take a long time to effectively integrate the system. Due to high costs ERP systems have been used mainly by very large organizations but with recent improvements in ERP software and trends towards needs based applications ERP is being used more frequently by medium and small sized organizations. [4] Another difficulty is that the success of the system relies on the employees using the system properly and with accurate information. [3] It can be very expensive to train the whole organization to use the ERP system and failure to do so can result in devastating financial losses to the organization. Another disadvantage of ERP is the lack of customization options. When adopting a new system you want to avoid customizing because it is difficult, timely and expensive.

STEPS TO IMPLEMENTATION

Implementing an ERP system can be a difficult and expensive process and unsuccessful attempts have been extremely costly for some organizations in the past. There are many detailed steps required for effective implementation and professional experience is highly recommended. However, the following 6 steps provide a basic framework and starting point for a successful ERP implementation.

Step 1 – Define Success and Planning

This starting point is often the key to success. First you must establish the problem you are trying to solve or what you want to achieve from implementing ERP. Do you want to improve inventory control? Do you want to speed up delivery? Do you want to automate business practices? And will these improvements contribute to increased profits and future growth? You also need to develop an implementation team, plan the project, and establish all the necessary steps to complete the project. A consultant or an ERP professional is highly recommended.

Step 2 – Set Priorities

During ERP implementations there will be countless problems discovered but due to complexity and high costs of ERP you need to set priorities and focus on the most important issues. It is also important to implement new systems step-by-step to prevent overloading managers and users with too much information when learning the ins and outs of the new system. Generally you want to begin the implementation with the core functions of your business and solidify those practices.

Step 3 – Avoid Modifications

This step is easy, avoid modify the source code of your ERP application software. You should be able to choose the right ERP software to fit your organization in terms of size and complexity so that you do not need to modify the code of the software. There may be pressure from employees to change the program to make it easier for them or make it more like the previous system used. However modifications are extremely costly and time consuming and rarely improve functionality.

Step 4 – Prepare for Change

Implementing an ERP system is a big change for your staff, customers, and suppliers. It is necessary to prepare everyone involved for the change, especially the managers and end-users of the product. Employee resistance can be harmful to the new system and your business so it is important to properly train all users with hands-on experience and plan for a smooth transition. Also it is necessary to have good communication and make it clear that the new system will contribute to greater success of the company and can provide better opportunities for them in the future.

Step 5 – Gain Executive Support

Executives support is crucial for adopting an ERP system. Executives need to ensure strategic alignment with the organizations goals and values. They also need to be actively involved in the implementation to motivate employees and reduce employee resistance. To gain executive support it is recommended to conduct a professional analysis of the company and coordination of the ERP system to be implemented in order to clarify the benefits of the new system. 

Step 6 – Budget Dollars and People

An ERP project can be very expensive and a planned budget is necessary. But more importantly having the right people and expertise to guide the project will determine your success. You can find people within your organization that obtain the right skills and knowledge or you can recruit an external project manager to commit to the implementation process. These candidates must be fully committed to the success of the project and they must obtain the right skills and industry knowledge to complete the implementation.