Product Master Data Management

Get Involved. Join the Conversation.

Comments

  • Magesh Kesavapillai

    Pls raise a service request for investigation

  • Magesh Kesavapillai

    - When you say EFF, do you mean Supplier association EFF?

    - Rules can not update the primary flag of suppliersite association; however, you can write validation rules. if that helps in your case, you may try writing Reject rules (Reject, if Primary is No, etc)

  • Vasanth Mahendran

    Try with changeOperation as Create. I believe PDM is intelligent enough to update if Item Number already exist.

  • Vasanth Mahendran

    300000002879070 is the current version? Looks like the current version you want to branch from is wrong.

  • Sunny Todkari

    According to my experience:

    • Do I need an Item Organization?

    ----> Yes, this is equivalent to MASTER ORG in R12 and should be sued to define the items. No transactions should be made under this.

    • Do I need a second Inventory organization because I only have this 1 MASTER inv org?

    ---.> Yes, this second org will be used for executing the actual material transactions.

    • Any other tips/tricks/suggestions/best practices..?

    ----> Need one item org which will be used as master org for defining the item and then you can create the inv orgs as per the requirement for executing the transactions.

  • Jim Van Tongerloo

    An item organization defines an item when inventory balances are not stored and inventory storage or inventory movement is not reflected in the Oracle Fusion Applications. For example, you would use an item organization in a retail scenario, if you need to know the items that are listed by and sold through each retail outlet even though inventory and transactions are recorded in another system. Item organizations are also used to control the availability of attributes for items and item security. The item organization structure is similar to the inventory organization structure, except the item organization structure is not required to have an association with a business unit or legal entity. The item organization also does not have the required inventory organization-level attributes. 

    Item organizations can be changed by administrators to an inventory organization by updating the necessary attributes. There is no difference in the way items are treated in these two types of organizations except that there cannot be any financial transactions in the downstream applications (such as Oracle Fusion Logistics) for items that are assigned to an item organization. 

    This is what I mean with 'more on differences'.

    As I read this, I don't need any item organizations since I'm using inventory organization already and want to record inventory transactions..

    Any more on the 1 or multiple inventory organizations needed?

  • Mohammed Kaja Nawaz L J

    It's an assignment rule where validation should happen on "Trading Partner Item Relationship" component and if it's successful then assignment should happen on UDA.

  • Magesh Kesavapillai

    Trading Partner Item Relationship is not supported in Rules. (However, your usecase is not very clear. Is it validation or assignment?)

  • Magesh Kesavapillai

    yes. You can specify the UCM (webcenter) location/file and attach it with item. Sample payload below:

    <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

        <soap:Body>

            <ns1:createItem xmlns:ns1="http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/types/">

                <ns1:item xmlns:ns2="http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/">

                    <ns2:OrganizationCode>V1</ns2:OrganizationCode>

                    <ns2:ItemClass>Root Item Class</ns2:ItemClass>

                    <ns2:Template>Finished Goods</ns2:Template>

                    <ns2:ItemNumber>Compressor10HP_RP4</ns2:ItemNumber>

                    <ns2:ItemDescription>Reciprocating Compressor 10HP</ns2:ItemDescription>

                    <ns2:ItemAttachment>

                        <ns2:DatatypeCode>FILE</ns2:DatatypeCode>

                                                                                    <ns2:DatabaseDescription>desc</ns2:DatabaseDescription>

                        <ns2:FileName>assembly.png</ns2:FileName>

                        <ns2:UsageType>S</ns2:UsageType>

                                                                                    <ns2:DmFolderPath>/Contribution Folders/PIM</ns2:DmFolderPath>

                        <ns2:DatabaseTitle>assembly.png</ns2:DatabaseTitle>

                        <ns2:DmRepository>FusionAppsContentRepository</ns2:DmRepository>

                        <ns2:DocumentAttributes></ns2:DocumentAttributes>

                        <ns2:CategoryName>MISC</ns2:CategoryName>

                                                                                    <ns2:DmType>Document</ns2:DmType>

                        <ns2:DownloadStatus>N</ns2:DownloadStatus>                                                                         

                    </ns2:ItemAttachment>

                </ns1:item>

            </ns1:createItem>

        </soap:Body>

    </soap:Envelope>

  • Swathi gogula

    Can I load the file by giving the file location. Here you have placed the file text in Base 64 format in <Contents> Tag. My file size is huge. Looking to place the file in ucm by giving file location

  • Magesh Kesavapillai

    mergeItem is for updating one item at a time; processItem is for multiple items.

    I will let Dorairaj comment on why processItem does not work for you.

  • Mohammed Kaja Nawaz L J

    Thanks Dorairaj.

    mergeItem works like charm though processItem is not helped.

    I am working on release 13.18.02.

    It would be great to know differentiation between processItem and mergeItem.

    Thanks,
    Nawaz

  • Dorairaj Mathakala

    Hi Nawaz,

    Which release you are working? I have tested the given payload it working from our end, however you can try with following merge item operation which is pretty straight forward to create/update the item than the process Item operation.

     

    <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns12="http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/flex/egoItemEff/item/categories/">
        <soap:Body>
            <ns1:mergeItem xmlns:ns1="http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/types/">            
                <ns1:item xmlns:ns2="http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/">
                    <ns2:OrganizationId>204</ns2:OrganizationId>
                    <ns2:ItemId>300100111454941</ns2:ItemId>
                    <ns2:ItemEffCategory xsi:type="ns12:DrEff" xmlns:ns13="http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/flex/egoItemEff/item/contexts/">
    <ns13:InventoryItemId>300100111454941</ns13:InventoryItemId>
    <ns13:OrganizationId>204</ns13:OrganizationId>
    <ns12:DrDepartmentsItem xmlns:ns9="http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/protectedModel/">
      <ns9:ContextCode>DR_Departments_Item</ns9:ContextCode>
      <ns9:CategoryCode>DR_EFF</ns9:CategoryCode>
      <ns13:deptcode>QA1</ns13:deptcode>
      <ns13:deptid>30</ns13:deptid>
    </ns12:DrDepartmentsItem>
    </ns2:ItemEffCategory>
                </ns1:item>
            </ns1:mergeItem>
        </soap:Body>
    </soap:Envelope>

    Above payload will add one MR row to the Item.

  • Mohammed Kaja Nawaz L J

    Hi Dorairaj,

    Tried with given payload but ends with no luck as it response with error message as "
    An Item with the same Item Number Test MR Item already exists."

    Please find below latest request and response payload:
     
    Request Payload:
     
    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/types/" xmlns:item="http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/" xmlns:cat="http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/flex/egoItemEff/itemSupplier/categories/" xmlns:item1="http://xmlns.oracle.com/apps/scm/productModel/items/flex/itemRevision/" xmlns:cat1="http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/flex/egoItemEff/itemRevision/categories/" xmlns:cat2="http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/flex/egoItemEff/item/categories/" xmlns:item2="http://xmlns.oracle.com/apps/scm/productModel/items/flex/item/" xmlns:item3="http://xmlns.oracle.com/apps/scm/productModel/items/flex/itemGdf/" xmlns:ns12="http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/flex/egoItemEff/item/categories/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns0="http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/types/" xmlns:typ1="http://xmlns.oracle.com/adf/svc/types/">
       <soapenv:Header/>
       <soapenv:Body>
          <typ:processItem>
             <typ:changeOperation>Merge</typ:changeOperation>
             <typ:item>
                <item:OrganizationCode>ZZZ</item:OrganizationCode>
                <item:ItemClass>OSTA</item:ItemClass>
                <item:ItemStatusValue>Active</item:ItemStatusValue>
                <item:LifecyclePhaseValue>Production</item:LifecyclePhaseValue>
                <item:PrimaryUOMValue>EA</item:PrimaryUOMValue>
                <item:ItemNumber>Test MR Item</item:ItemNumber>
                <item:ItemDescription>Test MR Item Desc1</item:ItemDescription>
                <item:ItemExtensibleFlexfieldCategoryCode>OSTA</item:ItemExtensibleFlexfieldCategoryCode>
                <item:ItemEffCategory xsi:type="ns12:Osta" xmlns:ns13="http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/flex/egoItemEff/item/contexts/">
    <ns13:InventoryItemId>300000002879069</ns13:InventoryItemId>
    <ns13:OrganizationId>300000001789067</ns13:OrganizationId>
                   <ns12:TestDepartmentAg xmlns:ns9="http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/protectedModel/">
                      <ns9:ContextCode>Test Department AG</ns9:ContextCode>
                      <ns9:CategoryCode>OSTA</ns9:CategoryCode>
                      <ns13:deptname>QA</ns13:deptname>
    <ns13:deptId>20</ns13:deptId>
                   </ns12:TestDepartmentAg>
                </item:ItemEffCategory>
             </typ:item>
             <typ:processControl>
                <typ1:partialFailureAllowed>false</typ1:partialFailureAllowed>
             </typ:processControl>
          </typ:processItem>
       </soapenv:Body>
    </soapenv:Envelope>
     
    Response Payload:
     
    <env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
       <env:Header/>
       <env:Body>
          <env:Fault>
             <faultcode>env:Server</faultcode>
             <faultstring><![CDATA[JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000002832554 300000001789067 ] in ItemVersionEOJBO-27025: Failed to validate attribute ItemNumber with value Test MR ItemJBO-EGP:::EGP_DUP_ITEM_NUM: <MESSAGE><NUMBER>EGP-2775613</NUMBER><TEXT>An Item with the same Item Number Test MR Item already exists.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-28204: Too many objects match the alternate key oracle.jbo.Key[Test MR Item 300000001789067 ] for entity oracle.apps.scm.productModel.items.protectedModel.entity.ItemVersionEO, key ItemNumberAltKey.JBO-25090: Attribute value Test MR Item leads to duplicate keys for this entity type ItemVersionEO.JBO-28204: Too many objects match the alternate key oracle.jbo.Key[Test MR Item 300000001789067 ] for entity oracle.apps.scm.productModel.items.protectedModel.entity.ItemVersionEO, key ItemNumberAltKey.JBO-25090: Attribute value Test MR Item leads to duplicate keys for this entity type ItemVersionEO.]]></faultstring>
             <detail>
                <tns:ServiceErrorMessage xsi:type="tns:ServiceRowValErrorMessage" xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
                   <tns:code>27024</tns:code>
                   <tns:message>JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000002832554 300000001789067 ] in ItemVersionEO</tns:message>
                   <tns:severity>SEVERITY_ERROR</tns:severity>
                   <tns:detail xsi:type="tns:ServiceAttrValErrorMessage">
                      <tns:code>27025</tns:code>
                      <tns:message>JBO-27025: Failed to validate attribute ItemNumber with value Test MR Item</tns:message>
                      <tns:severity>SEVERITY_ERROR</tns:severity>
                      <tns:detail xsi:type="tns:ServiceAttrValErrorMessage">
                         <tns:code>EGP:::EGP_DUP_ITEM_NUM</tns:code>
                         <tns:message><![CDATA[JBO-EGP:::EGP_DUP_ITEM_NUM: <MESSAGE><NUMBER>EGP-2775613</NUMBER><TEXT>An Item with the same Item Number Test MR Item already exists.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>]]></tns:message>
                         <tns:severity>SEVERITY_RECOVERABLE_ERROR</tns:severity>
                         <tns:exceptionClassName>oracle.jbo.AttrSetValException</tns:exceptionClassName>
                         <tns:attributeName>ItemNumber</tns:attributeName>
                         <tns:attributeValue>Test MR Item</tns:attributeValue>
                         <tns:objectName>ItemVersionEO</tns:objectName>
                      </tns:detail>
                      <tns:detail xsi:type="tns:ServiceRowValErrorMessage">
                         <tns:code>28204</tns:code>
                         <tns:message>JBO-28204: Too many objects match the alternate key oracle.jbo.Key[Test MR Item 300000001789067 ] for entity oracle.apps.scm.productModel.items.protectedModel.entity.ItemVersionEO, key ItemNumberAltKey.</tns:message>
                         <tns:severity>SEVERITY_ERROR</tns:severity>
                         <tns:detail xsi:type="tns:ServiceAttrValErrorMessage">
                            <tns:code>25090</tns:code>
                            <tns:message>JBO-25090: Attribute value Test MR Item leads to duplicate keys for this entity type ItemVersionEO.</tns:message>
                            <tns:severity>SEVERITY_ERROR</tns:severity>
                            <tns:exceptionClassName>oracle.jbo.AttrValException</tns:exceptionClassName>
                            <tns:attributeName>ItemNumber</tns:attributeName>
                            <tns:attributeValue>Test MR Item</tns:attributeValue>
                            <tns:objectName>ItemVersionEO</tns:objectName>
                         </tns:detail>
                         <tns:exceptionClassName>oracle.jbo.TooManyObjectsException</tns:exceptionClassName>
                         <tns:objectName>oracle.apps.scm.productModel.items.protectedModel.entity.ItemVersionEO</tns:objectName>
                      </tns:detail>
                      <tns:detail xsi:type="tns:ServiceRowValErrorMessage">
                         <tns:code>28204</tns:code>
                         <tns:message>JBO-28204: Too many objects match the alternate key oracle.jbo.Key[Test MR Item 300000001789067 ] for entity oracle.apps.scm.productModel.items.protectedModel.entity.ItemVersionEO, key ItemNumberAltKey.</tns:message>
                         <tns:severity>SEVERITY_ERROR</tns:severity>
                         <tns:detail xsi:type="tns:ServiceAttrValErrorMessage">
                            <tns:code>25090</tns:code>
                            <tns:message>JBO-25090: Attribute value Test MR Item leads to duplicate keys for this entity type ItemVersionEO.</tns:message>
                            <tns:severity>SEVERITY_ERROR</tns:severity>
                            <tns:exceptionClassName>oracle.jbo.AttrValException</tns:exceptionClassName>
                            <tns:attributeName>ItemNumber</tns:attributeName>
                            <tns:attributeValue>Test MR Item</tns:attributeValue>
                            <tns:objectName>ItemVersionEO</tns:objectName>
                         </tns:detail>
                         <tns:exceptionClassName>oracle.jbo.TooManyObjectsException</tns:exceptionClassName>
                         <tns:objectName>oracle.apps.scm.productModel.items.protectedModel.entity.ItemVersionEO</tns:objectName>
                      </tns:detail>
                      <tns:exceptionClassName>oracle.jbo.AttrValException</tns:exceptionClassName>
                      <tns:attributeName>ItemNumber</tns:attributeName>
                      <tns:attributeValue>Test MR Item</tns:attributeValue>
                      <tns:objectName>ItemVersionEO</tns:objectName>
                   </tns:detail>
                   <ns0:sdoObject xsi:type="ns8:Osta" xmlns:ns0="http://xmlns.oracle.com/adf/svc/errors/" xmlns:ns9="http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/flex/egoItemEff/item/contexts/" xmlns:ns8="http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/flex/egoItemEff/item/categories/">
                      <ns8:TestDepartmentAg xmlns:ns0="http://xmlns.oracle.com/adf/svc/types/" xmlns:ns5="http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/protectedModel/">
                         <ns5:ContextCode>Test Department AG</ns5:ContextCode>
                         <ns5:CategoryCode>OSTA</ns5:CategoryCode>
                         <ns9:deptname>QA</ns9:deptname>
                         <ns9:deptId>20</ns9:deptId>
                      </ns8:TestDepartmentAg>
                   </ns0:sdoObject>
                   <tns:exceptionClassName>oracle.jbo.RowValException</tns:exceptionClassName>
                   <tns:objectName>ItemVersionEO</tns:objectName>
                </tns:ServiceErrorMessage>
             </detail>
          </env:Fault>
       </env:Body>
    </env:Envelope>

    Any point out would be helpful on the above payload.

    Thanks,
    Nawaz
  • Dorairaj Mathakala

    Hi Nawaz,

    Here is the working payload for adding eff multi row for existing item

     

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/types/" xmlns:item="http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/" xmlns:cat="http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/flex/egoItemEff/itemSupplier/categories/" xmlns:item1="http://xmlns.oracle.com/apps/scm/productModel/items/flex/itemRevision/" xmlns:cat1="http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/flex/egoItemEff/itemRevision/categories/" xmlns:cat2="http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/flex/egoItemEff/item/categories/" xmlns:item2="http://xmlns.oracle.com/apps/scm/productModel/items/flex/item/" xmlns:item3="http://xmlns.oracle.com/apps/scm/productModel/items/flex/itemGdf/" xmlns:ns12="http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/flex/egoItemEff/item/categories/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns0="http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/types/" xmlns:typ1="http://xmlns.oracle.com/adf/svc/types/">
       <soapenv:Header/>
       <soapenv:Body>
          <typ:processItem>
             <typ:changeOperation>Merge</typ:changeOperation>
             <typ:item>
                <item:OrganizationCode>V1</item:OrganizationCode>
                <item:ItemClass>DR_EFF</item:ItemClass>
                <item:ItemStatusValue>Active</item:ItemStatusValue>
                <item:LifecyclePhaseValue>Design</item:LifecyclePhaseValue>
                <item:PrimaryUOMValue>Each</item:PrimaryUOMValue>
                <item:ItemNumber>DR_ITEM_EFF_1</item:ItemNumber>
                <item:ItemDescription>DR_ITEM_EFF_1</item:ItemDescription>
                <item:ItemExtensibleFlexfieldCategoryCode>DR_EFF</item:ItemExtensibleFlexfieldCategoryCode>
                <item:ItemEffCategory xsi:type="ns12:DrEff" xmlns:ns13="http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/flex/egoItemEff/item/contexts/">
    <ns13:InventoryItemId>300100111454941</ns13:InventoryItemId>
    <ns13:OrganizationId>204</ns13:OrganizationId>
                   <ns12:DrDepartmentsItem xmlns:ns9="http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/protectedModel/">
                      <ns9:ContextCode>DR_Departments_Item</ns9:ContextCode>
                      <ns9:CategoryCode>DR_EFF</ns9:CategoryCode>
                      <ns13:deptcode>QA</ns13:deptcode>
    <ns13:deptid>20</ns13:deptid>
                   </ns12:DrDepartmentsItem>
                </item:ItemEffCategory>
             </typ:item>
             <typ:processControl>
                <typ1:partialFailureAllowed>false</typ1:partialFailureAllowed>
             </typ:processControl>
          </typ:processItem>
       </soapenv:Body>
    </soapenv:Envelope>
     
     
    Points note from the payload you mentioned:
    1.  Please add InventoryItemId and OrganizationId attributes in ItemEffCategory tag
    2. Change context and category codes according to your data
     
    Thanks
    Dorairaj