Have you checked our new Android App!!! Please download and learn oracle at ease

April 20, 2020


Basic PO setup

  • Basic Organization structure setup, BG, SOB, Calendar, Currency, Chart of Accounts, OU 
  • Porfile options 
  • Setup Inv Org with subinv and locators 
  • Setup UOM, Conversions 
  • Setup Items 
  • Setup Employee 
  • Setup Approval -- 
    • Job, Positions, Hierarchy 
    • Define Approval group, Assign Approval Group 
  • Set Up Oracle Workflow 
  • Decide How to Use the Account Generator 
  • Open Inventory and Purchasing Accounting Periods 
  • Define Buyers 
  • Set Up Document Controls 
  • Define Purchasing Options 
  • Set Up Financial Options 
  • Set Up Receiving Options 
  • Define Suppliers
Read More

December 13, 2019

Sales Order operation on Inactive subinv
  • Pick release
    • Subinv is not allowed to be entered in the pick release form
    • But if submitted without subinv and there is WMS pick rule, it will pick release and task will be created
  • Pick confirm
    • Subinv value not allowed in picking page in MSCA, so pick confirm cant be done
  • Backorder
    • Backorder allowed from inactive subinv
  • Reservation
    • Reservation not allowed on an inactive subinv
  • Locator neither be inactivated nor status be changed when there is reservation and onhand exist


Read More

October 15, 2019


Partial Pick and Curtail Pick
There are different context for reason codes

Pick Partial: Reason code with this context will be used only while user wants to pick partial qty from the allocated qty. Using this user can change the allocated quantity in the task while picking. This is needed if the pick load page needs to provide a reason code for exception for picking partially.

Curtail Pick: Reason code with this context will let user decide how he wants to proceed with the task after partial qty has been picked, whether to back order the remaining quantity or to auto allocate the remaining quantity from a different location source provided onhand is available.
If user choose a curtail pick reason code with cycle count then all the remaining qty in that location source will be reserved against cycle count and a new task will be created from different source if onhand is available. If user choose a curtail pick reason code with no cycle count, then the remaining qty will be back ordered.

Curtail Pick with Cycle Count
Onhand available in multiple source location
  • Current Task Completed and new task auto created for the remaining qty
  • In Shipping Transaction, the picked qty is ready to be dropped and Remaining qty also available to be picked in a new task
  • In inventory, onhand been depleted by the picked qty and remaining qty in that locator is being reserved against cycle count and the qty for the new task is being allocated from different location

Onhand available in single source location
  • Current Task Completed and no new task auto created for the remaining qty
  • In Shipping Transaction, the picked qty is ready for ship confirm and Remaining qty back ordered
  • In inventory, onhand been depleted by the picked qty and remaining qty in that locator is being reserved against cycle count

*Note: In this process, not only the remaining task qty, rather the whole qty left in the locator for that item after partial pick will be reserved against cycle count and will not be available for other demands until unless those cycle counts are adjusted.

Curtail Pick with No Cycle Count
Onhand available in multiple source location
  • Current Task Completed and no new task auto created for the remaining qty
  • In Shipping Transaction, the picked qty is ready for ship confirm and Remaining qty back ordered
  • In inventory, onhand been depleted by the picked qty and remaining qty available for next demand

Onhand available in single source location
  • Current Task Completed and no new task auto created for the remaining qty
  • In Shipping Transaction, the picked qty is ready for ship confirm and Remaining qty back ordered
  • In inventory, onhand been depleted by the picked qty and remaining qty available for next demand

Read More

May 20, 2019


Read More

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
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