Forum Discussion
Is there any error in the result? At least second AML should work, although the source item edit is unnecessary. If you know the relationship id the
<Item type="rh_OraMfgMaster_ProdNumNomen" action="edit" id="3A40258510F24D1685B044270F4B296A">
<RH_PRODUCT_CATEGORY_CODE>Z</RH_PRODUCT_CATEGORY_CODE>
<RH_TRADE_BRAND_CODE>F</RH_TRADE_BRAND_CODE>
</Item>
should be enough.
- srmorrison2 years agoIdeator I
alaxala,
Thanks for responding.
That's what is confusing, there are no errors thrown.
No system feedback at all.
Scott
- srmorrison2 years agoIdeator I
alaxala,
Sorry ... I closed the reply before I completed the comment.
Using the following AML:
<AML>
<Item type="rh_Oracle_Manuf_Master_Item" action="edit" id="C323F3AB54D84E70B54D895158EE3CB7">
<Relationships>
<Item type="rh_OraMfgMaster_ProdNumNomen" action="edit"
where="[rh_OraMfgMaster_ProdNumNomen].source_id = 'C323F3AB54D84E70B54D895158EE3CB7'">
<RH_PRODUCT_CATEGORY_CODE>K</RH_PRODUCT_CATEGORY_CODE>
<RH_TRADE_BRAND_CODE>T</RH_TRADE_BRAND_CODE>
</Item>
</Relationships>
</Item>
</AML>When I look at the AML server response I get ....
<SOAP-ENV:Envelope xmlns:SOAP-ENV="">schemas.xmlsoap.org/.../">
<SOAP-ENV:Body>
<Result>
<Item type="rh_Oracle_Manuf_Master_Item" typeId="8C4C0C666B564C928824E229F4476D1E" id="C323F3AB54D84E70B54D895158EE3CB7">
<classification>Finished good</classification>
<config_id keyed_name="18287161" type="rh_Oracle_Manuf_Master_Item">C323F3AB54D84E70B54D895158EE3CB7</config_id>
<created_by_id keyed_name="Manufacturing Batch Loader" type="User">7F42F026A2BC4EE99066DD094F3610D5</created_by_id>
<created_on>2023-09-10T22:06:01</created_on>
<rh_mfg_weight_code>LB</rh_mfg_weight_code>
<rh_plm_cre_by_div>AC</rh_plm_cre_by_div>
<rh_plm_description>SMALL - 26 TUBE - 1.5 TON</rh_plm_description>
<rh_plm_has_change_pending>0</rh_plm_has_change_pending>
<rh_plm_major_rev>00</rh_plm_major_rev>
<rh_plm_make_buy>Make</rh_plm_make_buy>
<rh_plm_part keyed_name="RA14AZ18AJ1NA" type="Part">BB42DF0F494D415288532C2323D388B0</rh_plm_part>
<rh_plm_plm_created_by_div>AC</rh_plm_plm_created_by_div>
<rh_oracle_item_id>18287161</rh_oracle_item_id>
</Item>
</Result>
<Message>
<event name="ids_modified" value="C323F3AB54D84E70B54D895158EE3CB7|3A40258510F24D1685B044270F4B296A" />
</Message>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>If I look at the SQL Server Table the only thing that has changed is the [modified_on] property.
I also tried using the ID of the relationship:
<AML>
<Item type="rh_Oracle_Manuf_Master_Item" action="edit" id="C323F3AB54D84E70B54D895158EE3CB7">
<Relationships>
<Item type="rh_OraMfgMaster_ProdNumNomen" action="edit" id="3A40258510F24D1685B044270F4B296A">
<RH_PRODUCT_CATEGORY_CODE>K</RH_PRODUCT_CATEGORY_CODE>
<RH_TRADE_BRAND_CODE>T</RH_TRADE_BRAND_CODE>
</Item>
</Relationships>
</Item>
</AML>Same result.
- alaxala2 years agoIdeator I
The property names in the AML are case sensitive. So you must specify them exactly as they are defined in the Aras itemType, not in the SQL table.