How to Enable Personalization link for OAF Pages

Set the values of following profiles to enable Personalization Page link in OAF Pages

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

  

Query to get Item details in Fusion

select iop.organization_code,
esi.item_number,
esi.DESCRIPTION,
esi.PRIMARY_UOM_CODE,
UOMT.UNIT_OF_MEASURE,
esi.ITEM_TYPE,
esi.INVENTORY_ITEM_STATUS_CODE,
decode(esi.LOT_CONTROL_CODE,1,'No',2,'Yes') Lot_Controlled,
esi.ENABLED_FLAG ,
ECB.SEGMENT1||','||ECB.SEGMENT2 Category,
ECSB.CATALOG_CODE
from EGP_SYSTEM_ITEMS esi,
INV_ORG_PARAMETERS IOP,
INV_UNITS_OF_MEASURE_TL UOMT,
INV_UNITS_OF_MEASURE_B UOMB,
EGP_ITEM_CATEGORIES EIC,
EGP_CATEGORIES_B ECB,
EGP_CATEGORY_SETS_B ECSB
where 1 = 1
and esi.organization_id = iop.organization_id
and UOMB.UOM_CODE = esi.PRIMARY_UOM_CODE
and UOMT.UNIT_OF_MEASURE_ID = UOMB.UNIT_OF_MEASURE_ID
and esi.INVENTORY_ITEM_ID = EIC.INVENTORY_ITEM_ID(+)
and esi.organization_id = EIC.organization_id(+)
and EIC.CATEGORY_ID  = ECB.CATEGORY_ID(+)
and EIC.CATEGORY_SET_ID = ECSB.CATEGORY_SET_ID(+)

Importing Sub-Inventories, Locators in Oracle Fusion.

Step 1: Navigate to Setup and Maintenance Work Area and Select the ‘Manufacturing and Supply Chain Materials Management Offering click the ‘Setup’ button


Step 2: Select the Functional Area ‘Inventory Management’ -> Click the ‘View’ menu ‘Columns’ -> Enable Checkbox ‘Actions’

Step 3: You will now see the ‘Actions’ icon displayed as a column. Click the ‘Actions’ icon for Task: Manage Subinventories and Locators -> Click ‘Export to CSV File’ -> Click ‘Create New’

Step 4: Click the ‘Submit’ button on the Export Setup Data to CSV File. Click the ‘OK’ button on the Confirmation dialog window

Step 5: Review the Export to CSV file by clicking ‘Actions’ -> ‘Export to CSV File’ -> ‘Ready for warning review 8-Nov-2015. A warning will be reported, however, you will be able to complete the item to subinventory assignment process.
 

Step 6: Click ‘Actions’ -> ‘Download’ -> ‘CSV File Package’
 

Step 7: Save File to local directory


Step 8: Extract the file ‘INV_ITEM_SUBINVENTORY.csv’ from the zip file to add item subinventory records


Step 9: Edit the INV_ITEM_SUBINVENTORY.csv file by adding the new records. In the screen shot below the records in green already existed and new records in yellow have been added to the CSV file.

Step 10: Add the edited file INV_ITEM_SUBINVENTORY.csv back to the zip file

Step 11: Navigate back to the main page and click the ‘Actions’ icon -> ‘Import from CSV File’ -> ‘Create New’


Step 12: Browse for your zip file and click the ‘Submit’ button

Step 13: Review the Import to CSV Process
 

Step 14: Process has been Completed Successfully. Click the ‘Done’ button
 

Step 15: Confirm the Item Subinventory records have been successfully created. Click the task link ‘Manage Subinventories and Locators’
 
 Step 16: the newly created records.