Oracle Apps R12 adding Item from Master Org to Child Org

Check Master Org Item creation: 

http://mogalafzal.blogspot.ae/2018/03/oracle-apps-r12-item-creation-in.html

How to Assign all the items from Item Master to a different Organization

Prerequisite:- Organization Hierarchy need to setup

Need to run a request :- Item Organization Assignment from Inventory responsibility.
Parameter:- Source Organization as Item Master or any other organization(From where you want to assign)
Hierarchy Origin:- Destination Organization(Where you want to assign all the item)
Hierarchy:- Organization Hierarchy Name
Request Count:-1
Submit the request 

  Issues and Solutions:

1.

If you dont find Item Organization Assignment Concurrent Program, add manually to your responsibility request group.

 2. Once concurrent Prorgram completes with warning or error, with below msg in log then.

 
MESSAGE NAME : INV_IOI_MASTER_CHILD_4D
ERROR MESSAGE : Master - Child Conflict in one of these Attributes: Demand Time Fence(DEMAND_TIME_FENCE_CODE), Lead Time Lot Size(LEAD_TIME_LOT_SIZE), Standard Lot Size(STD_LOT_SIZE), Cumulative Manufacturing(CUM_MANUFACTURING_LEAD_TIME), Overrun Percentage(OVERRUN_PERCENTAGE), Calculation ATP(MRP_CALCULATE_ATP_FLAG), Positive Acceptable Rate(ACCEPTABLE_RATE_INCREASE), Negative Acceptable Rate(ACCEPTABLE_RATE_DECREASE). 

Solution:  some columns have null values, so we will upload manually using below script, run before in test instance after taking backup ofcourse.

REM datafix after uploading master items_before_assign_to_Other_orgs
REM take backup of mtl_systems_items_b before running this script

REM $Header: b19630365.sql 120.0.12010000.1 2014/10/28 12:08:24 liswang noship $
REM

REM dbdrv sql ~PROD ~PATH ~FILE none none none sqlplus \
REM dbdrv phase=upg checkfile:~PROD:~PATH:~FILE
REM +======================================================================+
REM |                Copyright (c) 1997, 2013 Oracle Corporation           |
REM |                   Redwood Shores, California, USA                    |
REM |                        All rights reserved.                          |
REM +======================================================================+
REM SQL Script File Name:
REM        b19630365.sql
REM

REM Description:
REM        This sql script updates item attributes with  
REM        R12 default value for all items.
REM

REM ========================================================================

set verify off
WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
WHENEVER OSERROR EXIT FAILURE ROLLBACK;



Update mtl_system_items_b
set CATALOG_STATUS_FLAG = 'N'
WHERE ORGANIZATION_ID = 1771 AND ENABLED_FLAG = 'Y' AND  CATALOG_STATUS_FLAG is null;

COMMIT;

Update mtl_system_items_b
set COLLATERAL_FLAG = 'N'
WHERE ORGANIZATION_ID = 1771 AND ENABLED_FLAG = 'Y' AND  COLLATERAL_FLAG is null;

COMMIT;

Update mtl_system_items_b
set CONTAINER_ITEM_FLAG = 'N'
WHERE ORGANIZATION_ID = 1771 AND ENABLED_FLAG = 'Y' AND  CONTAINER_ITEM_FLAG is null;

COMMIT;

Update mtl_system_items_b
set DOWNLOADABLE_FLAG = 'N'
WHERE ORGANIZATION_ID = 1771 AND ENABLED_FLAG = 'Y' AND  DOWNLOADABLE_FLAG is null;

COMMIT;

Update mtl_system_items_b
set ELECTRONIC_FLAG = 'N'
WHERE ORGANIZATION_ID = 1771 AND ENABLED_FLAG = 'Y' AND  ELECTRONIC_FLAG is null;

COMMIT;

Update mtl_system_items_b
set EVENT_FLAG = 'N'
WHERE ORGANIZATION_ID = 1771 AND ENABLED_FLAG = 'Y' AND  EVENT_FLAG is null;

COMMIT;

Update mtl_system_items_b
set INDIVISIBLE_FLAG = 'N'
WHERE ORGANIZATION_ID = 1771 AND ENABLED_FLAG = 'Y' AND  INDIVISIBLE_FLAG is null;

COMMIT;

Update mtl_system_items_b
set MRP_CALCULATE_ATP_FLAG = 'N'
WHERE ORGANIZATION_ID = 1771 AND ENABLED_FLAG = 'Y' AND  MRP_CALCULATE_ATP_FLAG is null;

COMMIT;

Update mtl_system_items_b
set VEHICLE_ITEM_FLAG = 'N'
WHERE ORGANIZATION_ID = 1771 AND ENABLED_FLAG = 'Y' AND  VEHICLE_ITEM_FLAG is null;

COMMIT;

Update mtl_system_items_b
set RECIPE_ENABLED_FLAG = 'N'
WHERE ORGANIZATION_ID = 1771 AND ENABLED_FLAG = 'Y' AND  RECIPE_ENABLED_FLAG is null;

COMMIT;

Update mtl_system_items_b
set BOM_ENABLED_FLAG = 'N'
WHERE ORGANIZATION_ID = 1771 AND ENABLED_FLAG = 'Y' AND  BOM_ENABLED_FLAG is null;

COMMIT;

Update mtl_system_items_b
set LOT_STATUS_ENABLED = 'N'
WHERE ORGANIZATION_ID = 1771 AND ENABLED_FLAG = 'Y' AND  LOT_STATUS_ENABLED is null;

COMMIT;

Update mtl_system_items_b
set SERIAL_STATUS_ENABLED = 'N'
WHERE ORGANIZATION_ID = 1771 AND ENABLED_FLAG = 'Y' AND  SERIAL_STATUS_ENABLED is null;

COMMIT;

Update mtl_system_items_b
set LOT_DIVISIBLE_FLAG = 'N'
WHERE ORGANIZATION_ID = 1771 AND ENABLED_FLAG = 'Y' AND  LOT_DIVISIBLE_FLAG is null;

COMMIT;

Update mtl_system_items_b
set LOT_SPLIT_ENABLED = 'N'
WHERE ORGANIZATION_ID = 1771 AND ENABLED_FLAG = 'Y' AND  LOT_SPLIT_ENABLED is null;

COMMIT;

Update mtl_system_items_b
set LOT_MERGE_ENABLED = 'N'
WHERE ORGANIZATION_ID = 1771 AND ENABLED_FLAG = 'Y' AND  LOT_MERGE_ENABLED is null;

COMMIT;

Update mtl_system_items_b
set LOT_TRANSLATE_ENABLED = 'N'
WHERE ORGANIZATION_ID = 1771 AND ENABLED_FLAG = 'Y' AND  LOT_TRANSLATE_ENABLED is null;

COMMIT;

Update mtl_system_items_b
set LOT_SUBSTITUTION_ENABLED = 'N'
WHERE ORGANIZATION_ID = 1771 AND ENABLED_FLAG = 'Y' AND  LOT_SUBSTITUTION_ENABLED is null;

COMMIT;

Update mtl_system_items_b
set BULK_PICKED_FLAG = 'N'
WHERE ORGANIZATION_ID = 1771 AND ENABLED_FLAG = 'Y' AND  BULK_PICKED_FLAG is null;

COMMIT;

Update mtl_system_items_b
set SERIAL_TAGGING_FLAG = 'N'
WHERE ORGANIZATION_ID = 1771 AND ENABLED_FLAG = 'Y' AND  SERIAL_TAGGING_FLAG is null;

COMMIT;

Update mtl_system_items_b
set EQUIPMENT_TYPE = 2
WHERE ORGANIZATION_ID = 1771 AND ENABLED_FLAG = 'Y' AND  EQUIPMENT_TYPE is null;

COMMIT;

EXIT;

--rerun the concurrent program again and check.