How to store data mappings in Agile PLM?
How to store data mapping in Agile PLM? What I mean is if we want to store some rules or field mappings which will decide the next step or value of field for us. How to achieve that. Like in Oracle EBS we have lookup or Valusets used to store mappings or any other details with multiple columns not like list in Agile PLM.
Hi Vaibhave,
We can leverage Simple List in Agile to store Mapping.
Key Value can be put in apiName (should be unique) and mapping can be stored in List Value or description.
(API Name doesn’t support few characters).
Thanks,
Karthik
Hi Vaibhav,
there is a type of list, called cascade, where you can create validations for possible attribute values. It`s different from Oracle EBS where you have two attributes, the first attribute value validates the possible values in the second, in Agile PLM you have basicaly the same feature, but in one list type attribute, called cascade list.
My Best
Carlos
Validations, setting field values, etcetera are custom code (PX). As long as you are going there we use a spreadsheet checked into an Agile document. The PX then reads the spreadsheet.
Hi Vaibhav,
 Displaying of dependent fields dynamically is not available in Agile .Â
You Custom code development to achieve this.
1. A URL based process extension which will show dynamic list of values for dependent fields and validation and upon selection the values can be saved to agile.
2. Custom PX which looks for the data in a mapping sheet which is added to a document or which can be deployed on server .
Thanks
