Learn Oracle

May 20, 2019

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

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

Flow

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

April 5, 2018

WMS Zone Picking basic setup steps

WMS Receipt Label Print flow

Once Receiving transaction saved, it processes the transaction and inserts the data into rcv_shipment_headers, rcv_transactions.
Once transaction completed in the same flow, inv_rcv_integration_apis.complete_lpn_group calls inv_label.print_label_wrap
inv_label.print_label_wrap generates the detailed XML and publishes in label history table
Once label history table populated with all data, inv_label.print_label_wrap calls INV_PRINT_REQUEST.SYNC_PRINT_REQUEST to print the label based on print mode and printers from profiles of either user or responsibility.

To get the label print work below basic setups need to be there

Responsibility or user which does the transaction needs to be assigned to the Receipt business flow with required label format(material or lpn or serial, etc)
For each label type, there should be a default label format
If you want to have specific labels printed for different conditions then specific label format rules need to be defined in the system.