How-to get a full list of Validation Messages in preparing for the FBL Work Relationship Loads

Summary

This is part of a series of Quick Reference Guide "Frequently Asked Questions and Answers"

Content

Note: this sql is applicable to both FBL/HDL use cases

Run BIP query:

select MESSAGE_NAME,message_number,type,MESSAGE_TEXT ,context
from fnd_messages_vl
where message_name like 'PER_EM%'
and message_name not like 'PER_EMABS%'
and message_name not like 'PER_EMCKL%'
and message_name not like 'PER_EMWS%'
and message_name not like 'PER_EMSET%'

References

Data Migration And Integration Advisor: Oracle Fusion HCM (Doc ID 1572625.1)
HR Business Object Load - Error Code Library & Common Error Messages (