Oracle Warehouse Builder give several way to find information to debug a mapping :
- a OWB - Graphical mapping debugger that enables you to see the data flow through the mapping in a graphical interface. The mapping debugger is embedded in the Mapping Editor. Warehouse Builder provides debugging capabilities for data flows within the Mapping Editor. Debugging functions are available on the toolbar and the Debug menu.
- the error table features
- an intermediate generation of the code the PLSQL in the intermediate generation style.
- a log journal in the public view (in the repository owner schema) - ALL_RT_AUDIT_MAP_RUN_ERRORS