NOTE: The Book value is manually entered by user and it is not affected by the Profit Centre lookup. Only the Profit Centre value is dependent on the Profit Centre data. Even though there is a book field in the profit center table, CM does not use this value. The book field is updated by user from the GUI. Check the audit trail for the claim and you can see who and when the value is changed. If you still have the claim, edit it, blank out the book, then trigger the profit center lookup by putting first 3 characters and click lookup. You will see the book is not populated from the lookup.
Below are sample queries to investigate issues reported with Profit Centre mapping.
Note: Book inside the edit dialogue is not populated from STATIC DATA>> Profit Centre
Select MRTPROFITCENTRE,MRTUBRLEVEL,MRTUBRTEXT,MRTPRODUCTID,MRT_CLOSEDFLD
from MRT_IDCLAIMSPROFITCENTRE
WHERE (UPPER(MRTDATAFEED) LIKE '%SWAPS%') AND (MRTPROFITCENTRE LIKE 'SEC1');
Select MRTPROFITCENTRE,MRTUBRLEVEL,MRTUBRTEXT,MRTPRODUCTID,MRT_CLOSEDFLD,MRTDATAFEED
from MRT_IDCLAIMSPROFITCENTRE
WHERE (UPPER(MRTDATAFEED) LIKE '%SWAPS%');
Select MRTPROFITCENTRE,MRT_CLOSEDFLD
from MRT_IDCLAIMSPROFITCENTRE
WHERE (UPPER(MRTDATAFEED) LIKE '%SWAPS%') AND (MRTBOOK='DB_LN_SECX');
Comments
0 comments
Please sign in to leave a comment.