I have created a custom logical unit / custom page to add to the Supplier screen as a custom tab. Is there an easy way to use the data migration tool (DMT) to populate the underlying custom table? I’ve seen instructions on setting up the DMT to handle custom fields on a standard IFS screen, but this situation is a little different, in my mind, because it isn’t and extension of a standard method.
Assuming you are on APP10.
This is possible as custom logical units are having the same structure. The only difference is view name suffixes with _CLV and all the attributes prefixes with CF$_.
This is well described in the following technical documentation path.
Try and let us know the outcome.
Thanks
OBJKEY should be generated always so you cannot identify your record using it. That is why it instructs to maintain your own key.
Yes, you can use excel migration procedure to import data. The only different is you should use _CLV as the view name. Source mapping columns and method list is fetched automatically as normal.
Thanks. I was able to set this up successfully.
I have another question. I have a referenced field (Supplier ID) in the custom page. Is there a way to get the OBJKEY from the referenced field to populate in the template behind the scenes? I’ve tried a couple of different things in the Default value column - both a select statement and a function call but neither seems to be working in that validating or executing the excel spreadsheet returns no values in the Results column and no data is migrated into the custom page. This was my latest attempt:
Set up a dummy field for Supplier ID that populated with a supplier number.
In the source table field I entered the following in the Default Value column: select supplier_api.get_objkey(SUPPLIER_ID) from dual
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.