How to pass requested item Sys_id in import set table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-18-2025 10:27 AM
Hi All,
I am working on one project where I am trying to run tranform through catalog and get the tranformmap error logs under the particular filed of requested item. then we run work flow if there is some error message of that transform map in that requested item filed we will cancell the requested item.
I have created the business rule to create dynamic data source and import set run but the current issue I am not able to pass sys_id of the requested item into the import set refernce field which refernce to RITM.
after what I am looking to pass the error of tranform script to pass them in particular filed in ritm.
kindly help me this if there any approach of doing that please let me know.
below the business rule that create data source am import.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-18-2025 10:42 AM
Hi @keshav77 ,
To access RITM in import set, Please try creating a new field on import set table and try populating in before transform start and after loading. This way you can have ritm sysid and In your Transform Script (in the Transform Map), add a script that checks for errors and logs them to a field on the RITM.
In the flow or workflow of RITM, add condition to check whether error fields has data or not. Based on result you can cancel the RITM.
Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for
Kind Regards,
Pavani P
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-18-2025 10:46 AM
I am trying to do that but it is not passing the. Ritm Sysid in transform map
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-18-2025 11:29 AM
Are you capturing the ritm in any field in import set?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-18-2025 11:46 AM
Yes through the share business rule I am trying to capture the current record sysid by it not passing in importset table field