Skip to main content

Dear community. 

I am working through an upgrade from Apps9 to IFS Cloud and am recreating some of the Custom Menus with Commands. 

I have come across the situation that didnt occur in apps 9, which is the data types in a Window with Transfer type of Menu/Command. 

Here is an example, a custom menu in Apps9 which transferred to Inventory Transaction History, and showed all transaction history associated with that material line, in Apps 9, the source/destination keys were ORDER_NO, RELEASE_NO, SEQUENCE_NO AND LINE_ITEM_NO mapped to SOURCE_REF1, 2,3,4 accordingly. This works fine in Apps9. 

In Cloud (23R1) when attempting to create the same, since the source data type in the Shop Order Material Line is a Number field, and the SOURCE_REF4 column is a String this error appears when attempting to load the Inventory Transactions History list. 

Error details: i{"code":"TYPES_NOT_COMPATIBLE","message":"The types 'Edm.String' and 'Edm.SByte' are not compatible."}]

When looking at the detail in the Search dialog the following appears

SourceRef1 = '2037960' AND SourceRef2 = '*' AND SourceRef3 = '*' AND SourceRef4 = 1

which is correct, as this is what is being transferred, however the last value needs to be enclosed in ‘’ as the Inventory Transactions History wants a string value. 

Is there a way to force this in the Command? i.e. can we do a to_string or similar conversion or a do I need to create a custom attribute in the entity that does the conversion, and use that in the Command button? 

Be the first to reply!

Reply