Difference between Value sets and Lookups

Form Personalization in Batch Details form

Req 1:
Default batch number as lot number (Non FG Batch)and WIP Qty as Transaction Qty for WIP batches in Pending lot screen (Batch Details form):

Condition:

:GME_BATCH_HEADER.BATCH_STATUS IN (1,2)
AND :GME_PRODUCT_LOTS.LOT_NUMBER IS NULL
AND :GME_MTL_DTL_PROD.LINE_TYPE = 1
AND EXISTS (SELECT distinct INVENTORY_ITEM_ID FROM MTL_SYSTEM_ITEMS_B
WHERE ORGANIZATION_ID in (101,102) AND INVENTORY_ITEM_ID = :GME_PRODUCT_LOTS.INVENTORY_ITEM_ID AND ITEM_TYPE <> 'FG')

Value: ${item.gme_batch_header.batch_no.value}                                                                                 

Req 2:Change EXPIRATION_DATE Format(Pending Lot Form)

DD:MON:YYYY to DD:MON:YYYY HH24:MI:SS

Value: DD-MON-YYYY HH24:MI:SS                                                                                                   

Req 3:If Revision number is null then return error msg (Batch Details Form Product tab)

Condition::GME_MTL_DTL_PROD.REVISION is null and                                                                    fnd_profile.value('MFG_ORGANIZATION_ID')=(select ORGANIZATION_ID from org_organization_definitions where ORGANIZATION_CODE ='XYZ')

How to create FND Messages in oracle apps ?

Application Adiministration --> Application --> Messages

select * from FND_NEW_MESSAGES where MESSAGE_NAME like'XHL_INV_RESTRICT_STATUS'

Migrate from One instance to another instance: 

Download:

FNDLOAD apps/$1 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XHL_INV_RESTRICT_STATUS_MES.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME="XX" MESSAGE_NAME="XHL_INV_RESTRICT_STATUS"

upload:

FNDLOAD apps/$1 O Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct XHL_INV_RESTRICT_STATUS_MES.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

Transaction Types in Inventory

SELECT DISTINCT mmt.transaction_action_id, mtt.transaction_source_type_id,

                mtt.transaction_type_id, mtt.transaction_type_name

           FROM mtl_transaction_types mtt, mtl_material_transactions mmt

          WHERE 1 = 1 AND mtt.transaction_type_id = mmt.transaction_type_id

TRANSACTION_ACTION_ID	TRANSACTION_SOURCE_TYPE_ID	TRANSACTION_TYPE_ID	TRANSACTION_TYPE_NAME
31	5	44	WIP Completion
1	5	35	WIP Issue
27	5	43	WIP Return
32	5	17	WIP Completion Return
27	13	42	Miscellaneous receipt
1	13	32	Miscellaneous issue
1	6	31	Account alias issue
27	3	40	Account receipt
1	3	1	Account issue
2	4	64	Move Order Transfer
27	6	41	Account alias receipt
29	1	71	PO Rcpt Adjust
52	13	89	Container Split
2	13	2	Subinventory Transfer
1	1	36	Return to Vendor
28	2	52	Sales Order Pick
8	10	8	Physical Inv Adjust
2	13	51	Backflush Transfer
27	12	15	RMA Receipt
27	1	18	PO Receipt
51	13	88	Container Unpack
1	2	33	Sales order issue
4	9	4	Cycle Count Adjust
36	2	10,008	COGS Recognition
50	13	87	Container Pack