Serial number is not available when doing any inventory transaction but shows in on hand quantity interface

source

I was facing problem in one of my client site that oracle shows on hand quantity for one item in on hand quantity screen with serial numbers but when user is going to transact it either by sub inventory transfer or by Miscellaneous issue it shows me on hand� zero on transactional form

I have investigated it in detail and find different notes on Metalink for the solution and fusion of these notes is solution

First of all get Inventory Item id , serial number and organization id from on hand quantity interface by using examine option.

Step 1

Run the following query to check exact status of that serial numbers

SELECT SUBSTR (inventory_item_id, 1, 9) “Item Id”,
 SUBSTR (serial_number, 1, 20) “Serial Number”,
SUBSTR (current_organization_id, 1, 9) “Organization Id”,
SUBSTR (lot_number, 1, 18) “Lot Number”,
SUBSTR (DECODE (current_status,
1, ‘Defined but not used’,
3, ‘Resides in Stores’,
4, ‘Out of Stores’,
5, ‘Intransit’,
6, ‘Invalid’,
NULL, ‘Verify Serial Number’,
current_status
 ),
1,
25
) “Status”,
SUBSTR (current_subinventory_code, 1, 25) “Subinv”,
 SUBSTR (current_locator_id, 1, 9) “Locator”,
 SUBSTR (group_mark_id, 1, 15) “Group Mark Id”,
SUBSTR (line_mark_id, 1, 15) “Line Mark Id”,
 SUBSTR (lot_line_mark_id, 1, 15) “Lot Line Mark Id”, group_mark_id,
 line_mark_id, lot_line_mark_id
FROM mtl_serial_numbers
WHERE inventory_item_id = ‘&EnterItemID’
AND serial_number = ‘&EnterSerialNumber’
AND current_organization_id = ‘&EnterOrgID’

Above query shows me the status �Resides in Stores� but this serial number is not displayed in transactional forms

Step 2

Then run the following query

SELECT i.inventory_item_id itemname, s.inventory_item_id itemid,

s.serial_number serialno, s.current_organization_id org,
s.current_subinventory_code sub, s.current_status stat,
 s.group_mark_id gmid, s.line_mark_id lmid, s.lot_line_mark_id
 FROM mtl_system_items i, mtl_serial_numbers s
WHERE inventory_item_id = ‘&EnterItemID’
AND serial_number = ‘&EnterSerialNumber’
AND current_organization_id = ‘&EnterOrgID’
AND s.current_organization_id = i.organization_id
AND s.inventory_item_id = i.inventory_item_id;

Check the value of following columns

1.�group_mark_id
This column is Group identifier (used by Oracle Inventory for ensuring that serial numbers used by one user’s session do not become available incorrectly to another user)

2.�line_mark_id
This column Used by Oracle Inventory for ensuring that serial numbers used by one user’s session do not become available incorrectly to another user. The column is used by Oracle Inventory’s serial number marking and unmarking routines

3.�lot_line_mark_id

Identifier used in serial number marking and unmarking routines

Step 3

If value of above mentioned column is not blank / null then run following query

UPDATE mtl_serial_numbers
SET group_mark_id = NULL,
line_mark_id = NULL,
 lot_line_mark_id = NULL
WHERE inventory_item_id = ‘&EnterItemID’
AND serial_number = ‘&EnterSerialNumber’��
AND current_organization_id = ‘&EnterOrgID’
AND current_status = 3

A serial number can have one of following statuses
1.�Defined but not used
2.�Resides in stores
3.�Issued out of stores
4.�Resides in transit

I used status = 3 in above query as I was looking for only those serial numbers which Resides in stores but not available to me for transaction

Step 4

Commit the record and then check are you able for transaction or not

Tennis Elbow

source

The following racquet specifications can put a racquet in the DANGER ZONE for contributing to TE. Let us check the specifications of your racquet (or check for yourself) to see if it is a racquet that falls in the DANGER ZONE.

1. Weight - Racquets less than 11oz. (Healthwise the ideal weight would be in the 12oz + range)

2. Balance - Racquets that are weighted head heavy are more prone to causing TE

3. Stiffness - Racquets with a stiffness/flex rating of 69 or higher can contribute to TE

4. Length - Racquets longer than 27" can also contribute to TE

Query for TXN TYPE ACTION & SOURCE

 SELECT COUNT(*)
 ,      mmtt.organization_id
 ,      mtt.transaction_type_name
 ,      meaning action
 ,      transaction_source_type_name
 ,      mmtt.transaction_type_id
 ,      mmtt.transaction_source_type_id
 ,      mmtt.transaction_action_id
 FROM   mtl_material_transactions_temp mmtt
 ,      mtl_transaction_types mtt
 ,      fnd_lookup_values_vl lkp
 ,      mtl_txn_source_types src
 WHERE  organization_id IN (2448,2434,2435)
 AND    mtt.transaction_type_id = mmtt.transaction_type_id
 AND    mmtt.transaction_source_type_id = src.transaction_source_type_id
 AND    lkp.lookup_type = 'MTL_TRANSACTION_ACTION'
 AND    lkp.lookup_code = TO_CHAR( mmtt.transaction_action_id )
 GROUP  BY
        mmtt.organization_id
 ,      mmtt.transaction_type_id
 ,      mmtt.transaction_source_type_id
 ,      mmtt.transaction_action_id
 ,      mtt.transaction_type_name
 ,      meaning
 ,      transaction_source_type_name

How to Enable Personalization link for OAF Pages

Profile Name	Value
FND: Personalization Region Link Enabled	Yes
Personalize Self-Service Defn	Yes
Disable Self-Service Personal	No

Material Workbench : Cost Group Transfer

Source

The "Cost Group Transfer" option is greyed out when trying to access it from the Tools Menu on Material workbench . How does one enable it ?

Check the Responsibility setup to see if the function "Material Workbench Cost Group Update" was excluded 

a. Login as System Administrator
b. Navigate : Security > Responsibility
c. Query up Responsibility
d. Check to see if the function "Material Workbench Cost Group Update" is present in the Exclusion list
e. If yes, Remove it and save the changes and the Cost group transfer option will be enabled in the Tools menu in Material workbench form

Or

Check the menu attached with the custom responsibility. See if the function Material Workbench Cost Group Update has "Grant" Option Checked

a. Login as System Administrator
b. Navigate : Applications > Menu
c. Query up menu attached with the Responsibility
d. The scroll down to see if the function "Material Workbench Cost Group Update" has the "Grant" option checked.
e.  If its unchecked, check the Grant option and the Cost group transfer option will be enabled in the Tools menu in Material workbench form

Move Order Issue Transaction for LPN

Move order has a config item of mixed transaction type.

.> Master is Move Order Transfer while one or more Child lines are Move Order Issue

.> Master is Move Order Issue while one or more Child lines are Move Order Transfer


After the Pick Load is complete.

.> Complete the issue lines using INV_PICK_WAVE_PICK_CONFIRM.PICK_CONFIRM.

Pass only the mmtt records as parameter and not the move order records

.> Now the Config LPN will have only the move order transfer items, while the
  move order issue items would have been issued out.
 
.> Since the integrity of the Config LPN has been destroyed, we will have to
   unpack the items from the config LPNS
 
.> Insert into the MTI with the transaction type 88 Container UnPack
   If there are any serials or lots associated with the config LPN
   populate the MTSI or MTLI
 
.> After successfully completing the unpack, we need to clear the task of all
   the references of the config LPN
   update mmtt set lpn_id = null, allocated_lpn_id = null