August 1, 2018

Step by Step Cycle Count in Oracle Warehouse

ABC Compile: 

It sorts the items in descending order in the subinventory or org based on the selection criteria
  • Define the ABC compile based on need 
  • Select subinventory/organization 
  • Select criteria to choose current onhand or historical transactions 
  • Once defined, click on compile. It will submit a request and will generate a sorting output list of items 

ABC Assignment Groups:

  • Create an assignment group 
  • Assign the ABC compile 
  • Attach the ABC classes 
  • Then Click on Assign Items 
    • Select sequence to classify the items into A B C classes 
    • Then click on Assign. It will submit a request 
  • Once request is completed, you can see how items are classified by clicking on Update Items 

Define Cycle Count

  • Define Cycle count based on need 
  • Give Adjustment account 
  • Enter late Days: after how many days uncounted cycle count will be considered as late count 
  • Starting seq: This is the staring number of the count 
  • Enter all other details as needed 
  • in Serial, LPN and Schedule tab, 
    • select the serial controlled count options 
    • Select the schedule, if you want to schedule the count 
  • In Adjustment and ABC, 
    • select approval criteria 
    • Give the ABC group created earlier 
    • In Option, select reinitialize and save, it will submit a request. Once the request is completed, you can see status will be completed in the cycle count as well. 
    • Then click on Classes and enter the no of counts you want to do for each class in a year 
  • From Tools --> Select Perform Full Cycle Count, it will submit request set, submit with proper parameter 
    • Once the request is completed, go back to cycle count and re-query and click on items, you will see last scheduled date should be populated against items 
    • Also in Serial, LPN and Schedule tab, you see Last date and Next date is populated as per the schedule 

Cycle Count Entry

  • Now Go to cycle count entry form, select the cycle count header name and then find all open counts 
  • It will show all open request counts pending 
  • You can either use this form or you can directly go to MSCA --> Inventory --> Counting --> Normal for entering the counts against the records 
  • Also you can count using WMS Task feature by going to MSCA, Task --> Directed task --> Warehouse --> Counting 

Approve Count

  • Go to Approve Count section post counting 
  • It will show all pending approval including adjustments if needed 
  • Select the option and save 

View Adjustments in material transactions

Read More

Features and Overview of iProcurement

  • Web based applications allows organization to perform purchase activities 
  • It’s a self-service application module which enables buyers raise and work on requisitions and corresponding tracking 
  • Web based shopping interface for goods and services including requisitions for temporary rate based labor 
  • Complete Catalog and Contents management 
  • Online Approvals management 
  • Streamlined order placement in integration with Purchasing 
  • Streamlined with Sourcing to complete the RFQ negotiation cycle 
  • Complete Order Tracking

Procurement Process in iProcurement

  • Process 
    • Enter Requisition online using catalog form 
    • Workflow Approval 
    • Buyer Creates Purchase Order 
    • Supplier Notified and delivers directly to requestor 
    • Record Receipt in iProcurement 
  • iProcurement Process Flow in Oracle 
    • Ordering 
      • Requisition 
      • PO 
      • Receiving 
    • Analysis 
      • Payment 
      • Supplier Performance 
    • Sourcing 
      • Supplier Management 
      • Negotiations & Awards 
      • Catalog Content Management 

Why switching to iProcurement

Issues in conventional procurement systems are
  • Lack of procurement information 
  • Minimal coordination of common purchases across organizations 
  • Scarcity of formal contracts(Only available are BPA and CPA) 
  • Large complexity like more people involved 
  • Lack of standardized process or systems 

Benefits of iProcurement

  • It provides an intuitive web interface 
  • Goods and services can be found easily and added to the cart like any other online shopping portals 
  • Streamlines Order Placement - Shopping 
    • Shopping List 
    • Multiple Shopping Cart 
    • Copy orders 
    • Service Requests 
    • Non Catalog Requests 
    • Automatic Document creation 
    • Centralized Purchasing 
  • Streamlined Order Placement - Delivery 
    • Inventory Replenishment Requests 
  • Streamlined Order Placement - Billing 
    • Procurement Card purchases for Catalog orders 
    • Oracle project integration 
    • Multiple Account Distributions and Account generation workflow integration 
  • Streamlined Order Placement 
    • Notes - Additional Item information, Upload & view attachments 
    • Approvals - Approval routing configuration and Vacation scheduling 
    • Review/resubmit and Cancellation 
  • Desktop receiving 
    • Requestor can receive and confirm receipt of requested goods and services directly in iProcurement 
    • iProcurement can automatically record the receipt transaction 
  • Streamlines employee ordering 
  • Enforce purchasing policies 
  • Reduces procuring costs 
  • Easy to upload and view additional information 
  • Search product internally or from external sources 
  • Automatic document creation 
  • Center led procurement process 

R12 Enhancements

  • New Approval types 
  • New user-interface options 
  • New option for creating and maintaining favorite lists 
  • Unified catalog architecture 
  • Better catalog authoring capability for buyers, supplier and catalog administrators 
  • Tolerance based change request routing and Approval 
  • Content security enhancements 

Integration with other applications

  • Oracle Purchasing 
  • Oracle Payables 
  • Oracle Inventory 
  • Oracle Projects 

iProcurement in P2P flow

  • Setups 
    • Jobs 
    • Positions 
    • Employees 
    • Hierarchies 
    • Approval Groups 
    • Assignment sets 
    • Item categories 
    • Buyers 
    • Purchasing/Financial/Receiving options 
    • DFF for Item Categories 
    • Define Information templates 
    • Define Realms 
    • Setup Attachments 
    • Setup Profile options 
    • Enable Function Securities 

Item Availability in iProcurement

  • Internal Catalog: Items assigned to categories enabled for iProcurement 
  • External Catalogs: Managed by supplier/Third Part or Self-managed 


  • Requisition Creation 
  • Requisition Approval 
  • PO creation and processing 
  • Shipment of Goods 
  • Receiving of Goods 
  • Invoicing 
  • Payments
Note: underlined steps can be done in iProcurement, for others EBS integration needed with respective modules

Core features of iProcurement

  • Catalog Management 
  • Shopping 
  • Checkout 
  • Requisition Tracking and Management 
  • Desktop Receiving
    Read More
    Copyright © . Oracle Apps (SCM) . All Rights Reserved
    Oracle Apps (SCM) is an online knowledge sharing blog which index online free tutorials, blogs and other sources, to get easier and accessible manner. The blog has been created keeping only one intention of sharing knowledge and for learning purpose. All trademarks, trade names, service marks, copyrighted work, logos referenced herein belong to their respective owners/companies. If any of the posting is violating copyright and you want us to remove that content. Please contact Here