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

December 24, 2015

Please go through the Setup steps, their significance and the navigation to the setup forms.

Define Profile Options
Define Mobile User ID

Navigation:
System Administration>Security>User>Define

Define Warehouse

Navigation:
Setup>Warehouse Configuration>Warehouses>Define Warehouses

Define Warehouse Parameters

Enable WMS attribute
  • Serial Control
  • Lot Control
  • LPN Control
  • Crossdocking Information
  • Time Zone
  • Default Cycle Count Header
  • Default Picking Rule
  • Default Put away rule
  • Cartonization Options
  • Default pick task type
  • Default replenishment task type
  • Default Move Order Transaction Type
  • Default Move Order issue Task Type
Navigation:
Setup>Warehouse Configuration>Warehouses>Warehouse Parameter

Receiving Options

Navigation:
Setup>Warehouse Configuration>Warehouses>Receiving Parameters

Define Subinventory Attributes

Navigation:
Setup>Warehouse Configuration>Warehouses>Receiving Parameters

Define Stock Locators Attributes

Units, volume, weight, Dimansions, coordinates

Navigation:
Setup>Warehouse Configuration>Warehouses>Stock Locators

Define Dock Door to Staging Lane Relationships

Navigation:
Setup>Warehouse Configuration>Warehouses>Dock Door to Staging Lane Assignments

Define Shipping Networks

Define the required shipping networks between different warehouses also attach the shipping method if needed

Navigation:
Setup>Warehouse Configuration>Warehouses>Shipping Networks

Define Item Attributes for WMS

Lot, Lot Expiration,Serial controlled, Physical attributes and Material Status

Navigation:
Setup>Material Setup>Items>Master Items

Define Material Statuses

You use this form to setup material status codes that enable you to control the movement and usage of material for portions of on-hand inventory that might have distinct differences

Navigation:
Setup>Transaction Setup>Inventory Transactions>Material Status

Define Lot and Serial Attributes

Navigation:
Setup>Material Setup>Lot/Serial Attributes>Lot/Serial Attributes Descriptive Flexfield>Segments

Define Warehouse Resources

Define all resources here Human, Equipment, etc so that accordingly you can assign tasks to these resources

Navigation:
Setup>Warehouse Configuration>Resources>Resources

Define Equipment Items

Equipment, such as forklifts, pallet jacks, and so on are used to perform tasks in a warehouse.  In WMS, you set up equipment as a serialized item and a resource.  
Users sign on to the serial number of the equipment and are dispatched tasks appropriate to that equipment.
  • Define the equipment as an item
  • Define the item as an equipment type 
  • Specify the equipment as serial controlled (predefined)
  • Enter the equipment capacity (optional)
  • Generate serial numbers for the individual pieces of equipment

Navigation:
Setup>Material Setup>Items>Master Items
Setup>Warehouse Configuration>Resources>Equipment

Define Equipment Serial Numbers

Navigation:
Setup>Inventory Management>Material Maintenance>Generate Serial Numbers

Define Departments

Navigation:
Setup>Warehouse Configuration>Departments & Resources>Departments

Define Transaction Reasons

Navigation:
Setup>Transaction Setup>Inventory Transactions>Transaction Reasons

Define Label Formats

You are setting up the data fields that you want the system to include on a particular label

Navigation:
Setup>Warehouse Configuration>Printing>Define Label Formats

Define Associate Label Formats to Business Flows

Navigation:
Setup> Warehouse Configuration>Printing>Assign Label Types to Business Flows

Assign Labels to Printers

Navigation:
Setup> Warehouse Configuration>Printing>Assign Printers to Documents

Define Cost Groups

Navigation:
Setup>Material Setup>Costs>Cost Groups

Define Account Alias

Navigation:
Setup>Transaction Setup>Inventory Transactions>Define Account Aliases

Define Pick Sliationp Grouping Rules

Setup pick slip grouping rules to specify different ways in which a warehouse might choose to fulfill a group of orders

Navigation:
Setup>Warehouse Configuration>Rules>Pick Wave>Pick Slip Grouping

Define Release Sequence Rules

Navigation:
Setup>Warehouse Configuration>Rules>Pick Wave>Release Sequence

Define Release Rules

Navigation:
Setup>Warehouse Configuration>Rules>Pick Wave>Release Rules

Define Container Types

Before you set up cartonization and container items, you should verify that the appropriate container types exist.  Container types represent the codes that you assign to various containers, such as boxes, bins and pallets.  The WMS system comes pre-seeded with a variety of container types but the system also enables you to set up your own

Navigation:
Setup>Material Setup>Items>Container Types

Define Container Items

Containers can be defined as item
Navigation:
Setup>Material Setup>Items>Master Items

Define Cartonization Groups

Inventory class categories can be defined for this
Navigation:
Setup>Material Setup>Items>Categories>Category Codes

Define Cartonization Category Sets

Navigation:
Setup>Material Setup>Items>Categories>Category Sets

Define Container Item Relationship

Navigation:
Setup>Material Setup>Items>Define Container Item Relationship

Define Shipping Parameters

Navigation:
Setup>Warehouse Configuration>Warehouses>Shipping Parameters

Define Task Types

For each unique combination of human and equipment resourses, a new task type should have been defined.

Navigation:
Setup>Warehouse Configuration>Tasks>Standard Task Types

Define Task Type Assignment Rules

To define rules for Cost Group Assignments, Label Format, Pick, Put Away and Task Type assignments.

Navigation:
Setup>Warehouse Configuration>Rules>Warehouse Execution>Rules

Define Warehouse Strategy

A strategy is an ordered sequence of rules that the system uses to fulfill complex business demands. The rules strategy are selected in sequence until the put away or picking task is fully allocated, or until a cost group that meets the restriction is found. When you define strategies, you also specify the date or range of dates on which the strategy is effective. You also specify whether you want the system to execute a strategy, if it can only successfully execute part of that strategy.

Navigation:
Setup>Warehouse Configuration>Rules>Warehouse Execution>Strategies

Define Warehouse Rules Workbench

Add the strategies here in a sequence with required parameter values to execute in required sequence.

Navigation:
Setup>Warehouse Configuration>Rules>Warehouse Execution>Rules Workbench

Define MWA Personalization Framework

To customize any mobile pages, any fileds in there, you can use this to customize
Navigation:
Setup>MWA Personalization Framework
Read More

0 comments:

December 16, 2015

Document Printing

In most of the oracle process, we need documents to be printed.
For example, during shipping, we need pick slip and pack slips to be printed in the warehouse or shipping doc.

Many business do they have multiple printers setup in the warehouse in different zones for the convenience of order fulfillment.

As per the requirement, oracle has given the flexibility to assign printers to the documents.
Below pre-requisites needed for automated document printing
  • Required Document Report needs to be defined and registered in oracle
  • Printer to be used in the warehouse needs to be defined and installed in the network
  • Printer needs to be connected on proper ip in the network

Assigning Printer to the Document

You can assign shipping documents and selected reports to specific printers. For example, you can assign pick slips and pack slips to your warehouse tractor feed printer, your mailing labels to a tractor feed printer stocked with blank labels, and other documents to a laser printer in your order entry office.
You can assign each shipping document and report to a different printer for each user, responsibility, application, or site. If a user or responsibility is not specified, Oracle Order Entry/Shipping uses the printer that you indicate for the application.

Navigate to the Order Management Super user responsibility
Setup --> Shipping --> Documents --> Choose Printer

Expand the Document Option and select the document name for which you want to assign a printer


Here you have multiple flexibility to choose a printer in different level.
You can choose a printer at below levels


  • You can choose from Site, Application, Responsibility, or User
  • If you select Responsibility or User in the Level field, choose the specific name in this field. If you select Site or Application in the Level field Oracle Order Entry/Shipping displays the name of your site, or Oracle Order Entry, and skips to the next field.
  • Select the name of the printer to which you want the shipping document to print.
  • Check the Enabled check box to activate the printer assignment
Do the setup as per your convenience.
Read More

1 comments:

December 15, 2015

Are locators mandatory for WMS ?
Ans. 
Yes, Locators are mandatory in WMS
What setup you do to enable WMS for an inventory organization ?
Ans. 
Organization should be WMS enabled in Organization Parameter form.
What is LPN ?
Ans. 
LPN is License Plate Number. This is an identification of an object/container(logical or physical) which holds Item/Items.
Click here for More.
What is cost group ?
Ans: 
Cost group is a combination of accounts(material and overhead accounts) which are setup at subinventory/organization level. When any transaction will happen, it will hit those accounts. As part of WMS, cost group can be assigned at material level. You can have multiple cost groups with in a subinventory based on different attributes as per your need.
Click here for more.
What are the different rules you can setup in WMS ?
Ans: 
Pick, Put away, Task Type Assignment, Cost Group Assignment, Label Format, Operational Plan selection
Click here for more
What is pick wave ?
Ans:
Pick Wave is the process of Picking a Group of orders which can be released to different warehouse operator with the use of Pick Release rule WMS Pick rule and WMS Task assignment rule.
Wave picking is a term for a process used in a warehouse management system to describe a process to support managing the work of a warehouse or distribution center. Wave picking is an application of short interval scheduling, to assign orders into groupings (waves) and release them together so as to allow management to coordinate the several parallel and sequential activities required to complete the work.
The individual orders in the wave are dependent on the criteria used to make the selection.[2] The wave data includes the workload by order or function (case picking, repack picking, pallet movement, pick position replenishment, packing, etc.), providing management the information to calculate staff requirements and assign staff by function, with the expectation that the work in each function, within each wave, can be started and be completed at about the same time. There are two basic planning elements and benefits of wave picking.
To organize the sequence of orders and assignment to waves, consistent with routing, loading and planned departure times of shipping vehicles or production requirements, etc., to reduce the space required for shipping dock handling to assemble orders and load; and
To assign staff to each wave and function within a wave, with the expectation that all the work assigned to each wave will be completed within the wave period, providing management with the ability to monitor and manage performance throughout the day, and respond in a timely way to problems that occur, and more effectively utilize the staffing throughout the shift.
Material handling methods and equipment are independent of waving. Each set of method (e.g., order pick, batch pick, bulk pick) and equipment (e.g., conveyor and sorter, ASRS, order picker, pallet jack, fork lift) will yield a different expected productivity rate for management to use in determining the number of staff-hours to assign to each function by wave.
Additional benefits of wave picking include the improved ability to
  • measure productivity within a function
  • budget labor
  • estimate the throughput capacity based on staffing levels
  • evaluate the impact of changes in methods and equipment by function
  • provide feedback regarding performance
  • Better understand the nature of the workload as it changes seasonally, as a consequence of demand, and as a consequence of sales efforts and marketing campaigns
Where do you use multi-level LPN ?
Ans:
Multi level LPNs are used when business needs to pack LPN controlled items into a container which itself LPN controlled.
For example: During Shipping, EACH items packed in BOX and BOX are packed in PALLET.
Click here for more
Explain put away rules ?
Ans:
Put away rules are defined to direct the picked items to business required staging areas in outbound orders and direct the destination locations for inbound purchase order or RMAs.
Put away rules can be defined with many business restrictions as per the need
What are task management activities you can do in MWS ?
Ans:
Task Management is the activity where warehouse controller will manage different tasks dispatched to warehouse like pick, put away. Controller can assign, unassign tasks to the warehouse resources either to persons or equipment using Warehouse Control Board.
Explain cross-docking feature ?
Ans: 
Cross docking is a process to accommodate the inbound material directly to a staged area for any existing outbound orders.
Supplies are directly tagged to demands and transacted from staging area.
This increases the efficiency of any warehouse operation and order fulfillment process by eliminating the steps of putting supplies into inventory and picking demands from inventory.
Oracle provided cross docking is 2 types

  • Planned Cross Docking
  • Opportunistic cross docking

In case of Planned crossdocking the pre-allocation is done during Pick Release. In opportunistic crossdocking dynamic allocation is done during material putaway.
How to achieve Cross Dock for partial quantity or Cross docking for 1 Sales Order and not for other Sales order?

What is bulk picking ?
Can WMS support over picking ?
What is express picking ?
Explain the cartonization features ?
What is warehouse control board ?
Can we use MSCA without WMS ?
What is MSCA ?
What are warehouse management strategies ?
Difference between physical and Cycle Count?
Why can’t we do physical Count as Cycle count?
How we can assign the tasks to employees automatically?
How to query in Warehouse Control Board?
How to Auto Print WMS label for one item and not for other?
How XML label data sent to printer? I.e. its not printing as shown in XML therefore so how printer print labels?
I want to display all 3 thing say item, LPN and Sub inventory in same line. How to achieve that?
What are basic setups to use MSCA or WMS?
How machines assigned to a particular task? is machine is also a resource or only person is a resource? if machine is not a resource how we assign it to a person or task?
Type of Label in WMS?
Type of label formats in WMS?
Can a LPN created in one organization be used in a different organization?
Ans: Yes it can be used using API WMS_CONTAINER_PUB.REUSE_LPNS provided the current LPN context is Issued Out Of Store and there is no pending transaction on that LPN.

Questions will be Answered soon. Meanwhile you can post more questions in the comment also you can answer to above questions in the comment.
Please help me to rectify if any of the answers are not correct.
Read More

2 comments:

LPN Context

LPN Context is nothing but the state/status of the LPN. Oracle WMS provided many states for an LPN. As per the current state/context, the usage of the LPN will change.
These context can be used to customize specialized picking and put away rules. Also context will help in querying tasks in warehouse control board.

Below are the different LPN context and their state definition

These context have a numeric value in the back end table.



Definition

Resides in Inventory:

Indicates that material associated with this LPN has been costed and accounted for in inventory. A LPN with this context may not be used when receiving material against a standard or inspection routed receipt, but may be used during a direct delivery routed receipt. Outbound transactions can be performed on LPNs with this context.

Resides in WIP:

Indicates that material associated with this LPN is currently being transacted in WIP (Work in Process). Therefore, the associated material is not yet in inventory and has not been costed to inventory.

Resides in Receiving:

Indicates that material associated with this LPN have been received using a standard routing or inspection routing receipt and have not been delivered/put away yet. Therefore, the associated material is not yet in inventory and has not been costed to inventory.

Issued out of Stores:

These LPNs are no longer tracked by the system, and hence, no longer associated with a locator within the warehouse. The system does however retain history information pertaining to transactions this LPN was involved in and material it was associated with prior to leaving the warehouse. LPNs shipped out of inventory receive this context and may not be re-received.

Pre-generated:

When LPNs are pre-generated by Oracle WMS and have not been used yet, they are not associated with any physical material. They can be printed and used to identify material during any stage of the material management process such as inbound, replenishment, outbound, and so on. Essentially, this context refers to LPNs that are ready to be used.

Resides in In-Transit:

A LPN with this context is an indication that it is currently moving from one location to another. Possible uses for this are when a LPN is moved from one organization to the next, for example while the LPN is on a truck. The LPN is in an intermediary state, but resides within the entire system. This context is used only for inter-org transit or internal sales orders where an indirect shipping network is defined between the organizations.

Resides in Vendor Site:

When a vendor sends an Advanced Shipment Notice (ASN) to Oracle WMS, the system internally generates LPNs and associates them with material information on the ASN. These LPNs receive this context. Material associated with LPNs of this context are not on-hand or costed until it is actually received.

Packing Context:

This context is temporary and used internally by the software as an intermediary. It should not be used or referenced anywhere including the setup of picking or put away rules.

Loaded for Shipments:

An LPN loaded for shipment has just been loaded onto a carrier ready to leave the warehouse. Once the entire carrier leaves the dock, the LPN obtains a context of 6 Resides in Intransit or 4 Issued out of Stores.

Prepack of WIP:

LPNs that reside in WIP and are associated with material that is pre-packed by WIP receive this context. This context adds an extra level of granularity to an LPN's usage within WIP. This is used when the system has associated the LPN with material and printed the labels, but the material has not yet been physically packed.

Picked:

LPNs picked during the picking process receive this context. They are intransit within the warehouse.

Read More

0 comments:

Oracle WMS: LPN

LPN is License Plate Number.
This is nothing but an identification of a certain object which holds Item/Items.
So for understanding, you can say LPN is an identification of a box in which you have kept the item/s whether in your warehouse locations or you have consolidated for shipping or identified for picking or receiving. At any point of time, item/s/group of items can be tracked using one single identification that is called LPN.
  •  This can be a physical container or a logical grouping.
  •  A single LPN can contain one or many qty of the same or different items
  • This is used to store information of items such as LOT, Revision, Serial, Organization, subinventory, locator, etc.
  • Contents of an LPN can be tracked during inventory stocking, shipping, receiving, in-transit
  • Receiving, Shipping, Picking, Packing of material can be done using LPN
  • Onhands can be tracked using LPN
  • Multiple items and qty can be transacted using LPN
  • Contents can be packed, unpacked, split or updated in LPN
  • Labels can be printed based on LPN for the contents inside an LPN
  • LPNs can be reused if that is empty or not assigned to any content

Nesting LPN

Oracle WMS allows to use LPN in nested also.
For example, you have made a Combo deal sale for Christmas.
If customer buys 2 laptop units, they will get one USB hub free.
And for better and faster shipment, you have already packed the units and kept for ready to ship.
So now the nesting hierarchy is like this



Read More

0 comments:

December 2, 2015

Oracle Order Management Setups

Oracle Order management is one of the most important part of the oracle EBS. The Order Management Application provides many flexible features enabling you to set up your system to begin processing order information. These orders can be created in Oracle Order Management Suite as well as in some other front-desk application. We can integrate these applications with Oracle Order Management for keeping a controlled track of orders and proper business flow. We can create different types of orders using this application can be for inventory stock items or for services.
You must define your business order policies, such as how you classify your orders, as well as various control features prior to processing orders within the application.
Important Setup Steps for Order Management
Click on the links to go to individual setup steps

Step Optional or Required
1. Define multiple organizations in Oracle Inventoryrequired
2. Setup Multi-Org (Multiple Organization) Access Controloptional
3. Define key and descriptive flexfieldsrequired under certain conditions
4. Define inventory organizations (warehouses), parameters, subinventories, and picking rules in Oracle Inventoryrequired
5. Define Profilesrequired
6. Setting OM System Parametersrequired
7. Define invoicing information, Payment Termsrequired under certain conditions
8. Define your sales representativesoptional
9. Define Tax Featuresrequired
10. Define Quickcodesrequired under certain conditions
11. Define header and line processing flowsrequired
12. Define Document Sequences for Order Numberingrequired
13. Define Order Import Sourcesrequired under certain conditions
14. Define the units of measurerequired
15. Define item informationrequired
16. Define the items that you sellrequired
17. Define the configurations that you sellrequired under certain conditions
18. Define price listsrequired
19. Define customer profile classesrequired under certain conditions
20.Define information on your customersrequired
21. Define item cross referencesrequired under certain conditions
22. Define your sourcing rulesoptional
23. Define Order Management Transaction Typesrequired
24. Set up Cost of Goods Sold Accounting flexfield combinationrequired under certain conditions
25. Define Processing Constraintsoptional
26. Define Defaulting Rulesoptional
27.Define Credit Checking Rulesrequired under certain conditions
28. Define Automatic Holdsrequired under certain conditions
29. Define Attachmentsoptional
30. Define Freight and Special Charge Typesoptional
31. Define shipping parametersrequired
Read More

0 comments:

September 11, 2015

Sourcing Rule in Oracle Purchasing

Sourcing rule is used to automatically replenish materials in an organization or business.
Sourcing rules determine the movement of materials between organizations in a global enterprise; these organizations include the suppliers and the materials include those items made at the manufacturing organizations.

Profile Options


  • MRP:Default Sourcing Assignment Set (set the value of the assignment set where you have added your item
  • PO: Automatic Document Sourcing (Yes
  • PO: Allow Auto-generate Sourcing Rules (CREATE AND UPDATE
  • PO: Allow Autocreation of Oracle Sourcing Documents (Yes)
  • MSC: ATP Allocation Method (User-Defined Allocation Percentage)

Define an Item

Noted Attributes:
  • Select any Inventory Planning method
  • Select the item Make or Buy
  • Enter a List price
  • Enter a default Buyer (this will help to assign a buyer during planning and in the requisition) 


Define Supplier and Supplier Sites

You can define supplier and supplier sites as required
Purchasing --> Supply Base --> Suppliers

Defining Sourcing Rule


Purchasing -> Supply Base -> Sourcing Rule

Notes:
  • You can use this rule across all orgs by Selecting All Orgs
  • If you want to use in specific org, the select the Org

Shipping organization type is 3 types
  • Buy From: Buying from a supplier
  • Transfer From: If you want to transfer the item from another organization in your business
  • Make At: This is for making the item in the selected organization

Allocation percentage: This is to identify how much % of the amount will be sourced from which org. This is helpful when you want to maintain multiple sources and want to split the sourcing amount between different sources, so you can split that by allocation%.
Master Scheduling/MRP uses these allocation percentages when creating planned orders, which Purchasing imports as requisitions through Requisition Import. In a group of requisitions imported from Master Scheduling/MRP, those requisitions show the percentage allocation you define. In other words, at the end of a planning period, orders--as a group--to those suppliers approximately equal the percentage split you defined. However, when you create a requisition in Purchasing, Purchasing sources to the supplier with the highest allocated percentage. The Approved Supplier List (ASL) entry for that supplier is then referenced in order to pick up source document information (from a blanket purchase agreement or catalog quotation), if source documents exist
Allocation Rank: To select the sequence in which sources will be identified during planning

Sourcing Rule Assign set, add the item for the sourcing rule


Once sourcing rules are defined, now time to assign the rule to Item or organization as you need
Purchasing à Supply Base à Assign Sourcing Rules
Here you can assign the sourcing rules at 4 different levels

  • Item 
  • Item-Organization
  • Organization
  • Global

Add the supplier to Approved Supplied List



This is optional, if you have checked ASL in Item attribute

Purchasing à Supply Base à Approved Supplier List


Run Min Max planning for the item



Inventory à Planning à Min-Max Planning
Submit the request for the item and make sure restock parameter selected as Yes

Then run requisition Import

This will create the Purchase Requisition and in turn submit the Create Releases Program which will in turn create the Purchase Order




Read More

0 comments:

Types Of Move Order


Move orders are created from different sources.
This can be identified from the Move Order header move order type field.

Different types of Move Orders are 

Move Order Requisitions: 

These are created from the move order form. Based on the setup at the organization and item level, move orders require approval before they can be allocated and transacted. These requisitions can be created to charge an account or move the material from one subinventory to another.

Replenishment Move Orders: 

These are auto-created with pre approved status. Depending on the planning type you can replenish the quantity in a subinventory for an item. Three types of replenishment plans (in relation to move orders) are available:
  • Min-max Replenishment Planning
  • Kanban Replenishment Planning
  • Replenishing Count planning

Based on these sources, when appropriate programs are run, move orders are automatically created.

Pick Wave Move Order Requisitions: 

These move orders are specifically for the sales order picking process. When Pick Releasing program is run move orders are created as preapproved and allocated(depending on the Pick Release setup). Pick Confirm process transacts these pick wave move orders.
Read More

1 comments:

September 6, 2015

Internal Requisition to Internal Sales Order

Creation Of Item

Create an Item and assign that to both the source and destination organization
Attributes
  • Purchased
  • Purchasable
  • Internal Order Enabled
  • Shippable
  • OE transactable

Creation of Internal Requisition

Now go ahead and create and Internal Requisition
Go to Purchasing Responsibility
Requisitions -> Requisitions

Note: You should have been defined as an employee/ buyer to create a requisition

  1. Type should be Internal Requisition
  2. Enter the item in Lines Tab
  3. Enter Quantity
  4. Enter Need By Date
  5. Select the Destination Organization
  6. Destination Location
  7. Select Source Organization

Click on Save, It will generate the Requisition Number. Note down the requisition number
Now need to Approve the Requisition
If you want to approve this requisition, then you should have required approval authority.
Lets do the required setup
Go to Human Resources (if Installed) responsibility
People -> Enter and Maintain

else in purchasing
Go to Setup -> Personnel -> Employees
Find the employee (if not created already, select new and create one)





Select Assignment



Here assign a Job
Now lets go and check whether this Job has Requisition Approval authority or not
For this, navigate to Purchasing responsibility
Setup -> Approvals ->Approval Assignments


In this form, select the Job which you have assigned to the employee


Now you can see which all document types are authorized to approve


Make sure Approve Internal Requisitions is entered here
If you can’t see this, then add the value
Make sure the Approval Group which you are assigning here that has the approval limit authorization with in which your IR amount comes
As in this case

Here the limit is max $50,000 and our IR amount is only $100
Now Go back to the requisition and approve the same
Query the requisition and click on the approve button

Make sure Submit for Approval selected (it should be by default) then click on OK
Wait for few min as the background process will check and clear the Approval workflow
And re-query the IR again
If Workflow Background Process not scheduled, you can go ahead and manually submit

Now again requery the IR from requisition summary form


You will see the IR is approved

Creation of Internal Order

Next step is to Run the Create Internal Order concurrent program which will interface the data to Order management for creating internal order
Go to View -> Requests -> Submit a new request -> Single Request
Select Create Internal Orders and submit


Once the program is completed, check the log file,



It means the data transferred to Order Entry
Now lets go to Order Management and import the data to create the Internal Order
Navigate to Order Management responsibility
Go to Orders, Returns -> Import Orders -> Order Import Requests


Now enter the below parameters
  1. Source as Internal
  2. Select your IR number in Order Reference field


Then Click Ok and Submit.
This will spawn another child order import program


Now go ahead and query your Internal order which is just created by importing the data in order organizer form
Orders, Returns -> Order Organizer
Give today’s date to refine
Select the source as Internal and give the IR number in the Order Source Reference



Now Click on Open.
Your internal order is ready



Tables Involved in this process flow


Differences between Internal Sales Orders and Inter-Organization transfer:

  • IR-ISO has approval process whereas there is no approval process for Inter-Org transfer
  • The IR cycle useful for more tracking, control (IR, SO), approvals and generating pick slips whereas Inter-Org transfer is a one step transaction, simple flow, more user friendly and no interfaces involved.
  • RMA is possible in Internal Sales Order whereas in Inter-Org transfer there is no functionality to Cancel, delete or Return or not receive an In-transit Shipment.

When Internal Sales Order and Internal Requisition will be picked up by Inter-Company invoicing process?

Internal sales order and Internal requisitions will be picked by Inter-company invoice process on the following conditions:
  • In shipping method, transfer type should be Intransit
  • Profile Option INV:Intercompany Invoice for Internal Orders value is Yes on site level. This will be used for creating Account Payable in the Intercompany Invoice process.
Note: Intercompany AP will be created irrespective of the IR received or not as per the standard functionality, INCIAP does not check for the same, it considers only INCIAR created or not.
Below query can be used to find out the eligible records

SELECT RCTL.*
FROM ra_customer_trx_lines_all RCTL, mtl_intercompany_parameters MIP
WHERE RCTL.interface_line_context = 'INTERCOMPANY'
AND RCTL.interface_line_attribute15 = 'Y'
AND RCTL.interface_line_attribute4 = nvl(93,
RCTL.interface_line_attribute4)
AND MIP.sell_organization_id = to_number(RCTL.interface_line_attribute4)
AND MIP.ship_organization_id = to_number(RCTL.interface_line_attribute5)
AND MIP.flow_type = 1
AND MIP.vendor_id is not null
AND MIP.vendor_site_id is not null
AND (line_type != 'TAX' AND extended_amount != 0)
AND NOT (line_type = 'TAX' AND link_to_cust_trx_line_id is not null);
Read More

1 comments:

Subscribe to

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