Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Do you know..Oracle Inventory automatically generates requisitions to maintain an item’s stock level.

Posted on July 29th, 2007 by Sanjit Anand ||Email This Post Email This Post

Oracle Inventory automatically generates requisitions to maintain an item’s stock level. The requisitions may request stock from an internal predefined source organization or from an outside supplier.
Inventory generates replenishment requests automatically using the following methods:

  • Min–Max Planning
  • Reorder Point Planning
  • Subinventory Replenishments for Replenishment Counts
  • Kanban Replenishments

All inventory replenishment methods create requisitions via the Requisitions Open Interface.

Posted in Oracle Purchasing | 2 Comments »

Production requisitions … PO release

Posted on July 29th, 2007 by Sanjit Anand ||Email This Post Email This Post

A simple question …how can we drive creation of production requisitions from MRP, and automatically approve production requisitions for PO release.

Normally in oracle Master Scheduling/MRP creates requisitions for ”buy” items when you release them using the Planner Workbench. MRP generated requisitions are sourced using the same rules as on–line and inventory replenishment requisitions e.g., you can specify either Inventory or Supplier as the default source type, as well as the source organization and subinventory for internal requests. For ”buy” items, the Requisition Import process uses the item sourcing information to create either a purchase requisition or an inter–organization internal requisition for planned orders.

Posted in Oracle Purchasing | 2 Comments »

Integration with Oracle Purchasing – Shared Data Flow

Posted on July 21st, 2007 by Sanjit Anand ||Email This Post Email This Post

Last article I have mention , Integration aspect with oracle other modules. Here is the flow diagram of some of the shared data with other modules.


Posted in Oracle Purchasing | 2 Comments »

Integration with In Oracle Purchasing

Posted on July 21st, 2007 by Sanjit Anand ||Email This Post Email This Post

..why integration is important ..

Integration is an extremely important part to ERP’s. ERP’s main goal is to integrate data and processes from all areas of an organization and unify it for easy access and work flow. ERP’s usually accomplish integration by creating one single database that employs multiple modules providing different areas of an organization with various business functions.

Oracle Purchasing Integration

Oracle Purchasing works in conjunction with other Oracle Applications to share information.

  • Oracle EDI Gateway: Electronic Data InterchangePOintegration
  • Oracle Inventory: Items, demand, receipts
  • Oracle Master Scheduling/MRP: Demand
  • Oracle Order Management: Internal requisition
  • Oracle Work in Process: Outside processing
  • Oracle Human Resources: Employees
  • Oracle Project Manufacturing: Project Details
  • Oracle Quality: Quality Details
  • Oracle Payables: Invoice Matching
  • Oracle General Ledger :Journal Entries, Set of Books
  • Oracle Supplier Scheduling: Approved Supplier List (ASL)
  • Oracle Assets: Asset Details
  • Oracle Bill of Material: Resources
  • Oracle Cost Management :Pricing


When Oracle Inventory, Oracle Master Scheduling/MRP, and Oracle Purchasing are used in conjunction, they share supply information. The following information is shared:

  • Open purchase orders.
  • Open releases.


By using Oracle Project Manufacturing and oracle Purchasing, you can now specify project sand tasks for your requisition and purchasing transactions. Specifically, you can specify projects and tasks for the Inventory and Shop Floor destination types.


By using Oracle Workflow and Oracle Purchasing, you can automate the approval and document creation processes by using predefined Workflow processes.


Posted in Oracle Purchasing | 1 Comment »

Oracle Purchasing Product Overview

Posted on July 21st, 2007 by Sanjit Anand ||Email This Post Email This Post

What is Oracle Purchasing?

Oracle Purchasing is a comprehensive procurement solution designed to:

  • Help purchasing professionals reduce administration costs.
  • Process requisitions, purchase orders, requests for quotation, and receipts quickly and efficiently.
  • Enable you to focus on:
    o Value Analysis
    o Development of strategic supplier relationships
    o Management of the procurement process

Oracle Purchasing satisfies the following business needs:

  • Replaces paper processing with online requisition generation, purchase-order creation, and document approval.
  • Regulates document access, controls modification activity and approval, and is based on organizational signature and security policies.
  • Minimizes data entry time with item-saving templates.
  • Controls purchasing activity and enables accurate,automatic pricing using approved suppliers and supplier lists.
  • Consolidates purchase requirements from multiple warehouses, plants or locations.
  • Enables negotiating from a position of strength based on easy access to purchase volume statistics and supplier performance reports.
  • Facilitates communication between requesters, buyers, receiving staff, and accounts payable staff using online enquiries, attachments and notes.
  • Provides related functions, such as marketing, finance, master scheduling, inventory management, production, cost accounting, and customer order entry with access to
    purchasing information.
  • Manages historical purchasing data.

What is in Oracle Procurement solution suite?

From the oracle there are 4 different products , that helps in fulfilling complete business requirement as discussed above, these are mainly:

1. Internet Procurement (formerly Self-Service Purchasing) :A web-shopping solution for all employees that automates finding and requisitioning goods and services using self-guiding on-line catalogs coupled with efficient content management. Industry standard XML interfaces allow integration to customers’ existing Oracle, non-Oracle or legacy financial systems.

2. Purchasing Intelligence :a web-enabled analysis tool which provides access to enterprise-wide procurement information, along with the ability to perform ongoing analysis of sourcing decisions, contract compliance, and supplier performance .

3. Internet Supplier Portal, a self-service solution giving trading partners internet access to purchasing, receiving and payment information, as well as providing suppliers the capability to easily process their own transactions·extending process efficiencies across the entire supply chain.

4. Purchasing, which streamlines order planning and management for purchasing professionals.

Apart from these four basic products , these are also used as advance version of purchasing solutions:

  • Oracle Sourcing is the enterprise application that drives more and better sourcing through online collaboration and negotiation.
  • Oracle Procurement Contracts is used for createing and enforces better purchasing contracts.
  • Oracle Daily Business Intelligence for Procurement is used for the spend-analysis application that allows buyers to spot savings opportunities immediately.
  • Quality

More information can be found at :

Posted in Oracle Purchasing | 2 Comments »

Reports Options for accessing Purchase Order informations

Posted on July 21st, 2007 by Sanjit Anand ||Email This Post Email This Post

How many reports options available in Oracle Purchasing(PO) to access purchase order information.

They are 15-16 reports provide the access PO information in reporting format.Lets summarize some of them, these listing are based on the availability as per Oracle 11i10.2.

1. Purchase Order Detail Report

This report can be used to review all, specific standard, or planned purchase orders. This is used for review the open purchase orders to
determine how much you still have to receive and how much your supplier has already billed you.

2. Printed Change Orders (Landscape) Report
This report is used to print changed purchase orders in landscape format. Oracle Purchase provides a default format for the preprinted form.

3.Printed Change Orders (Portrait) Report
This report can be used to provides the same information as the landscape version, but printed in portrait format.

4.Printed Purchase Orders (Landscape Report)
This report can be used to print purchase orders in landscape format.Oracle Purchase provides a default format for the preprinted form.

5.Printed Purchase Orders (Portrait) Report
This report contains the same information as the landscape version, but is printed in portrait format.

6.Blanket and Planned PO Status Report
This report can be used to review purchase order transactions for blanket purchase agreements and planned purchase orders. Information will print for releases existing against the orders. If no release exists, only the purchase order header information is printed.

7.Contract Status Report
This review the status of your contract and list purchase order information regarding each contract using this report.

8.Purchase Agreement Audit Report
This report is used to review purchase order transactions for items normally required to buy using blanket purchase agreements. Oracle Purchase shows you when you purchased items using a standard purchase order that you could have purchased using a blanket purchase agreement.

9.Purchase Order and Releases Detail Report
This report can be used to review detail information for your blanket purchase agreements and planned purchase orders. The quantity ordered, receive and billed and the quantity due to be received are displayed so you can monitor the status Purchase Order Commitment by Period Report

10.Open Purchase Orders Report (by Buyer)
This report is used to review all or specific open purchase orders for specific buyers.

11.Open Purchase Order Report (by Cost Centre)
This report can be used to review all or specific open purchase orders relating to order charged to one or more cost centre suing this report.

12.Purchasing Activity Register Report
This report can be used to review purchase order monetary activity carried out for a time interval, such as a day or month.

13.Purchase Order Distribution Detail Report
This report can be used to review account distribution for a purchase order.

14.Purchase Summary Report by Category
This report can used to review the number of orders you place with vendors for a given category of item.

15.Cancelled Purchase Orders Report
This is used to review cancelled purchase orders.

16. Standard Notes Listing
This is used to review standard notes.

Posted in Oracle Purchasing | 3 Comments »

Comparing Purchase Orders

Posted on July 17th, 2007 by Sanjit Anand ||Email This Post Email This Post

Here are the comparison of different purchase orders. The details of the different types can be discussed in my previous post.

compare pO

Posted in Oracle Purchasing | 3 Comments »

Purchase Order > Approval hierarchy

Posted on June 22nd, 2007 by Sanjit Anand ||Email This Post Email This Post

The setting up of approval hierarchy for PO requires few mandatory setup , which start with employee /Buyer information.These are the following steps required.

  • Define the employee and his/her superiors
  • Define the positions for the employee and the superiors

N –> Setup –> Personnel –> Positions

  • assign the employee and the superiors to a position

N –>Setup –> Personnel –> Jobs

  • define an approval group which allows him/her to approve PO’s up to the approval limit. Same for the superiors.

N –> Setup –> Personnel –> Position Hierarchy

  • Make sure the document type (e.g. PO) allows ‘Owner can Approve’ (checkbox)
  • Assign the approval groups to the correct positions
  • Create a position hierarchy for every org according to your wishes
  • Assign the hierarchies to the document type
  • Run the concurrent request ‘Fill Employee Hierarchy’


and , finally the above can be understood in the data diagram as below.


Posted in 11i, Oracle Purchasing | 8 Comments »

Oracle API Availability -Purchasing

Posted on June 17th, 2007 by Sanjit Anand ||Email This Post Email This Post

To get the brief idea about some available standard available Oracle Application interfaces applicable within oracle purchasing modules and hopefully it should serve to familiarize individuals with limited knowledge of Oracle’s API functionality.

1. Open Requisition Interface

What you can do:
By this you can Automatically import requisitions from other oracle Application system or any other system using this interface. This allows you to integrate your oracle purchasing application with new or existing applications, such as material requirement planning, inventory management.etc.

What tables involved


2. Requisition Reschedule

What you can do:

This is required when you are having Oracle Master Scheduling/MRP or a non-Oracle MRP system integrated with your oracle Purchasing, you may find that you need to reschedule requisitions as your
Planning requirements change. This API’S lets you reschedule requisition lines according to changes in your planned orders.

What tables involved


3. Purchasing Documents Open Interface

What you can do:

You can Automatically import and update standard purchase orders, price/sales catalog information, and responses to request for Quotations(RFQ’s) from suppliers through this interface. This interface uses the API’s to process document data in the oracle applications interface table to ensure that it is valid before importing it into oracle purchasing. After the data is validated, the program converts the information in the interface table into the appropriate document in purchasing.

What tables involved


4. Receiving Open Interface

What you can do:

You can Automatically import receipt information from other oracle applications or other system using the receiving open interface. This interface lets you integrate your oracle purchasing applications with new or existing applications. E.g. you can load bar-coded and other receiving information from scanners.
More over the good things is that you can also bring Advance Shipment Notices (ASNs) sent from suppliers by this interface.

What tables involved


What you can’t done by this API’s

  • Serial numbering
  • Separate receive and deliver
  • Corrections
  • Returns
  • Movement statistics
  • Dynamic locators
  • Receiving against Internal Orders
  • Receiving against Inter-Organization transfers
  • Receiving against Drop Ship Orders
  • Receiving against RMAs

For more information for these three interface, you can refer these documenst.

  • Part No. A95953-02

Posted in Oracle Purchasing | 15 Comments »

Learn and implement – Purchase Orders in Oracle EBS Suite.

Posted on June 16th, 2007 by Sanjit Anand ||Email This Post Email This Post

Lets take a quick look on different types of Purchase Orders , and some of the important tips before implementing within Oracle ebs-Suite of PO module.

  • Standard Purchase Orders: You generally create standard purchase orders for one-time purchase of various items. You create standard purchase orders when you know the details of the goods or services you require, estimated costs, quantities, delivery schedules, and accounting distributions.
    • Suggested Use: Choose a standard purchase order when you require vendor commitment to specific items/services, quantities and delivery schedules, but a long-term agreement is not appropriate.
  • Blanket Purchase Agreements: You create blanket purchase agreements when you know the detail of the goods or services you plan to buy from a specific supplier in a period, but you do not yet know the detail of your delivery schedules. You can use blanket purchase agreements to specify negotiated prices for your items before actually purchasing them. Blanket purchase agreements can be created for a single organization or to be shared by different business units of your organization (global agreements).
    Much organization it is sometimes called as “standing order” or an “open order”.

    • Suggested Use: Choose a blanket agreement when you’ve negotiated volume discounts and want to create releases against these negotiated volumes, or when you commit to specific items, quantities or amounts.
  • Blanket Releases: You can issue a blanket release against a blanket purchase agreement to place the actual order (as long as the release is within the blanket agreement affectivity dates).
  • Contract Purchase Agreements/Order: You create contract purchase agreements with your suppliers to agree on specific terms and conditions without indicating the goods and services that you will be purchasing. You can later issue standard purchase orders referencing your contracts.
    • Suggested Use : Negotiate pricing on your entire volume of business. Use a contract to manage terms and conditions for this type of negotiation; couple it with a catalog quotation to reference pricing on a per item basis when you create standard purchase order lines.
  • Global Agreements: You may need to negotiate based on an enterprises’ total global purchase volume to enable centralizing the buying activity across a broad and sometimes diverse set of businesses. Using global agreements (a special type of blanket purchase agreement), buyers can negotiate enterprise-wide pricing, business by business, then execute and manage those agreements in one central shared environment. Enterprise organizations can then access the agreement to create purchase orders that leverage pre-negotiated prices and terms.
  • Planned Purchase Orders: A planned purchase order is a long-term agreement committing to buy items or services from a single source. You must specify tentative delivery schedules and all details for goods or services that you want to buy, including charge account, quantities, and estimated cost.
    • Suggested Use: Choose a planned purchase order when you want to encumber the order before creating releases. Also use to provide vendor scheduling for capacity management while issuing releases to confirm order commitment.

Apart from these there are few more types may be defined as per there industry segment , but more or less they can be fit into any one of the above mentions type.

Posted in Oracle Purchasing | 6 Comments »

« Previous Entries Next Entries »