1. What is the order of defaulting of the Receipt Routing on the receipts screen which may be set at various levels?
For Inter-Org Shipments (In-Transit Receipts) the Receipt Routing is defaulted as follows:
1. Item Attribute
2. if 1 is null, then Shipping Network for the Receiving Organization
3. if 2 is null, then Receiving Option
2. What are the different types of Inter-Organization Transfers?
Inter-Organization transfers can be performed as either direct or intransit shipments.
Direct inter-organization transfers:
Inventory
is moved directly from a shipping organization to the destination
organization. Receipt is not required to be made as the transfer is
direct to inventory
Intransit inventory:
Usually done when
transfer time is significant. Delivery location isn't specified during
transfer transaction, You only need to enter subinventory you are
shipping from, a shipment number, the freight information and
inter-organization transfer charge. Then you need to perform Receipt
from the Receiving forms.
3. What are the minimum setups required for Items which we use for Internal Sales Order?
The items which we use for Internal Sales Order must be Inventory
enabled, internally orderable and stockable, shippable, and Order
Management transactable for the source organizations. Under Inventory,
you need to select the Inventory Item, Transactable, and Stockable
options. Under Order Management, you need to select the Internal
Ordered, Internal Orders Enabled, OE Transactable, and Shippable
options.
4. How do we define the Inter-Organization Shipping Network?
Use the Shipping Networks window to define your inter–organization
network. You must enable the network between each source (shipping) and
destination (receiving) organization.
-Select Internal Order Required if you want all transfers between these two organizations to use internal orders.
-Specify whether you ship material directly, or use intransit inventory for shipments between these two organizations.
-For
intransit transfers, you can choose from the following primary receipt
routings: Standard receipt, Inspection required, or Direct delivery.
5. What are the steps to perform Inter-Organization Transfer?
Follow these 3 simple steps:
1. Setup Shipping Network: This
information describes the relationships and accounting information that
exists between a from (shipping) organization and a to (distribution)
organization.
Navigation path:
A. Choose the Inventory Manager responsibility.
B.
Setup/Organizations - Make sure that there is an entry for from/to
organization (between the organizations you intend to perform the
transfer). When you click on this form, you will get a LOV with orgs.
-Choose the From Org.
-Transfer Type can be either Intransit or Direct (Direct would ship directly to Inventory, so it would be a Direct Delivery).
-FOB can be either Receipt or Shipment, if the transfer type is entered as Intransit.
If Receipt the source inventory quantities get updated at time of receipt.
If it be Shipping, then the quantities get updated as soon as the shipment is done.
2.
Inventory/Transactions/Interorganization Transfer: When you click on
this form, you will get a LOV with orgs. Choose the from org. Specify
the to-org, transfer type as intransit, and input a value for
shipment-number.
Click on the transaction lines button. Input the
item, the quantity and the subinventories between which you want to do
the transfer. (Sometimes there might not be enough quantity in the
from-org to do this. For this : Go to:
Inventory/Transactions/Miscellaneous Transactions. Specify the Type as
Miscellaneous Receipt. Click on transaction lines button and specify
item/quantity).
3. Receive against an Inter-org Transfer: Choose Purchasing Super User responsibility.
Under
Purchasing/Receiving/Receipts - Query up against Shipment Number in the
find window. In RCV Transactions block, specify the quantity you want
to receive and commit the transaction.
6. What are the steps required for receiving against Internal Sales Order?
The process of receiving against Internal Sales Orders involves the following steps:
1.
Create an Internally Orderable Item - To do this you need to create an
Item and in the Order Entry attributes, check the Internally Orderable
check box.
2. Setup Shipping Network: This information describes
the relationships and accounting information that exists between a from
(shipping) organization and a to (distribution) organization.
Navigation path:
A. Choose the Inventory Manager responsibility.
B.
Setup/Organizations - Make sure that there is an entry for from/to
organization (between the organizations you intend to perform the
transfer e.g.. GLO -> SAC).
When you click on this form, you will get a LOV with orgs.
-Choose the From Org.
-Transfer Type can be either Intransit or Direct (Direct would ship directly to Inventory, so it would be a Direct Delivery).
-FOB can be either Receipt or Shipment, if the transfer type is entered as Intransit.
If Receipt the source inventory quantities get updated at time of receipt.
If it be Shipping, then the quantities get updated as soon as the shipment is done.
3. Create an Internal Requisition.
-Enter the item you created in step 1.
-Enter the Source and Destination Organization. Source Organization is on the right of the form and Destination to the left.
-Enter location (e.g.. SACHQ) and Source as Inventory.
-Save and approve requisition.
4. Run the Create Internal Orders concurrent program.
5. Change responsibility to Order Entry Superuser.
6. Run Order Import concurrent program.
7. When the process completes, you will see the Order Number in the log file.
8. If the process errors : "You must enter Tax Code. Tax code attribute is missing" then:
-Change responsibility to AR Manager (Receivables)
-Navigate Setup->Transaction->Transaction Types
-Query up record with Name = "Invoice Hdwe/svcs"
-Uncheck the Tax Calculation check box
-Save
9. Run the Demand Interface concurrent program.
10. Run the Manufacturing Release concurrent program.
11. Navigate to:
-Orders, Returns -> Orders, Returns -> Do a Find on the Order Number
-Click on the View button
-Click on Cycle Status
-Your Order should now be Pick Release Eligible
12. Navigate to Shipping -> Pick Release -> Release Sales Order
-Enter a Batch Name and your Order Number
-Save
-Note the Batch_ID by doing a Help->Tools->Examine.
13. Run the Pick Release concurrent program. Use Batch Name/Order Number as parameter. This can be run from command line as:
./OESREL apps_appdemo/fnd@comp16p 0 Y (from step L)
Perform Step K. Your Order should now be Ship Confirm Eligible
14. Navigate to Shipping->Confirm Shipments->Pick Slip
-Do a Find on the Order Number
-Click on Open
-Click on details
-Check if all values of quantity to be shipped are correct
-Save
15. Change Responsibility to Purchasing Super User.
Navigate to the Enter Receipts form and query on the Requisition Number.
You can now receive against the Internal Order.
To override the destination type at receipt time you need to set the profile option RCV: Allow routing override = Yes.
7. How are Lot and Serial Numbers handled in Inter-Organization Transfers?
When you perform an inter–organization transfer, the source and
destination organization may have different lot/serial controls.
Purchasing handles this situation as follows:
1. When the source
organization uses controls and the destination organization does not,
the control numbers are recorded as being issued from the source
organization. Lot/serial transactions are recorded for the destination
organization.
2. When the source organization does not use controls
and the destination organization does, the transaction is processed
normally.
3. When both source and destination organizations use
controls, the control numbers are recorded as being issued from the
source organization. These control numbers are tracked to insure that
the same control numbers that were shipped are the ones
that are
received. When items are returned from inventory to receiving or to the
supplier, only the control numbers originally recorded for the delivery
transaction can be used.
8. What's the cause of the error RVTSH-150 and what's the solution for it?
Error RVTSH-150 is because the following select is failing, returning 0 rows:
SQL> select ms.unit_of_measure
from mtl_supply ms
where supply_type_code = 'REQ'
and supply_source_id = :req_line_id;
The
error is because the Req. Supply missing. This is mostly a data problem
caused at customer site. Look into why the records are missing. May be
the data has been manually changed or some cancellations for the req.
shipment has taken place.
For data fix, reference
Note: 267439.1
9. What are the main tables involved in Inter-Organization Transfer?
A check is carried out to see if the transaction date is in an open
period as specified in the profile option (INV: Transaction Date
Validation). The column is acct_period, the table is ORG_ACCT_PERIODS.
The organizations setting, cost information, etc, are derived from:
ORG_ORGANIZATION_DEFINITIONS, MTL_PARAMETERS, MFG_LOOKUPS, MTL_INTERORG_PARAMETERS
[HR_ORGANIZATION_INFORMATION - for rel 11I].
The transaction information is derived from MTL_TRX_TYPES_VIEW for inter-org transactions where transaction_source_type_id=13.
The item information is derived from MTL_SYSTEM_ITEMS [MTL_SYSTEM_ITEMS_B - for rel 11I].
A check is carried out to verify the available item quantity on MTL_DEMAND and
MTL_ONHAND_QUANTITIES [MTL_RESERVATIONS included in rel 11I].
MTL_SUBINVENTORIES_TRK_VAL_V keeps track of the values of the subinventories.
MTL_ITEM_LOCATIONS is searched for the locators specified (if used).
GL_CODE_COMBINATIONS is searched for a valid locator combination (if used).
The cost of the item is gotten from CST_CG_ITEM_COSTS_VIEW.
The transaction is inserted into MTL_MATERIAL_TRANSACTIONS_TEMP table.
If
the item is under lot control, lot information is deleted from
MTL_TRANSACTION_LOTS_TEMP, likewise the serial numbers information if
the item is serialized is deleted from MTL_SERIAL_NUMBERS_TEMP,
MTL_SERIAL_NUMBERS.
The new lot information is inserted into MTL_TRANSACTION_LOTS_TEMP.
10. How can we return or correct delivered lines in an Internal Requisition?
It is not possible to perform Returns or Corrections on Internal
Shipments. Once the Internal Order is ship confirmed and interfaced to
Inventory, the shipment is created in Receiving tables, and there is no
way to back out or modify the shipments.
In order to return an
internally ordered item the original process needs to be reversed. An
internal requisition for the item has to be created in the source
organization, and then that order has to be processed back to the source
organization. This can be done as followed:
Reverse the original process to return an internally ordered item.
Create an internal requisition for the item in the source organization.
Process the order back to the source organization.
Or as a second option, a miscellaneous receipt and miscellaneous issue may be completed, as a workaround.
Enhancement request
Bug 2206351 has been logged to enhance the functionality to enter returns for internal shipments.
This is also true for Inter Organization Transfers entered on Inter-organization Transfer form INVTTMTX
For
IOT shipments the only solution is to create a new inter org
transaction from inventory org B to inventory org A if the initial IOT
is from org A to org B
Also online help clearly indicates
Finding Returns
Use
the Find Returns window to find source documents for which you can
enter returns. Use the Supplier and Internal tabbed region to search for
Purchasing documents. If Order Management is installed, use the
Customer tabbed region to search for customer return material
authorizations (RMAs).
Note: You cannot enter returns for internal shipments (that is, shipments with a Source Type of Internal).
11. What to do if the physical quantity received does not match quantity shipped?
Case 1: When physical qty received is more than qty shipped.
Example: Source org ships 80 pieces, but receiving org wants to receive only 100 pieces.
An
intransit shipment cannot be over-received. Receive the entire qty
shipped in the receiving org and create a new intransit shipment for the
remaining qty shipping it from the source org.
Case 2: When physical qty received is less than qty shipped.
Example: Source org ships 100 pieces, but receiving org receives only 80 pieces.
Partial
receipt of intransit shipment is allowed, but there is no way to cancel
the remaining qty. Hence, entire qty shipped should be received. To
adjust the on-hand quantity:
o A reverse intransit shipment can be done for the excess qty from receiving org to source org.
OR
o A miscellaneous issue from the receiving org for the excess qty can be done.
If only a partial receipt is done, then the remaining qty will continue to show in intransit until its received.
