This is second post in a series to extract Rating Model data from Fusion environment in HDL format. The first post has a query to extract only the rating model data and second post describes the BIP query to extract rating model levels data. Query to extract Rating Model data: Query to extract Rating Model…
You can use below query to extract Rating Model data from fusion environment for updates. Save the data as RatingModel.dat before uploading to Fusion. You can make use of this query to extract data for reference or use it as a method to extract data from one instance and upload it to a different instance….
Rating models can be uploaded in bulk using HDL. Use RatingModel business object. Below is a sample file:
SQL Query to extract data for a particular value of a user table: Sample HDL:
SQL to extract data in HDL Format: Sample HDL:
Sample HDL File:
In case, you want to cancel work relationship of a Pending worker, below HDL can be used. Make sure to pass CancelWorkRelationshipFlag as Y. Sample HDL: You can extract the relevant Ids using below SQL:
