INV Movement Statistics Exception
Description
Categories: BI Publisher
Application: Inventory
Source: Movement Statistics Exception Report (XML)
Short Name: INVMVTEX_XML
DB package: INV_INVMVTEX_XMLP_PKG
Source: Movement Statistics Exception Report (XML)
Short Name: INVMVTEX_XML
DB package: INV_INVMVTEX_XMLP_PKG
Run
INV Movement Statistics Exception and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT error_type error_type5 , error_name error_name5 , movement_id movement_id5 , column_name column_name5, --INV_INVMVTEX_XMLP_PKG.cf_action_text5formula() CF_action_text5, INV_INVMVTEX_XMLP_PKG.cf_action_text5formula() CP_action_text5, --INV_INVMVTEX_XMLP_PKG.cf_error_text5formula() CF_error_text5, INV_INVMVTEX_XMLP_PKG.cf_error_text5formula() CP_error_text5, --INV_INVMVTEX_XMLP_PKG.CP_action_text5_p CP_action_text5, --INV_INVMVTEX_XMLP_PKG.CP_error_text5_p CP_error_text5, 'x' dummy FROM inv_mvt_excep_rep_temp WHERE error_name='INV_MGD_MVT_INVAL_VAL' ORDER BY 1 ASC,2 ASC,3 ASC |
| Parameter Name | SQL text | Validation | |
|---|---|---|---|
| Legal Entity |
|
LOV Oracle | |
| Economic Zone |
|
LOV Oracle | |
| Usage Type |
|
LOV Oracle | |
| Statistical Type |
|
LOV Oracle | |
| Period Name |
|
LOV Oracle | |
| Document Source Type |
|
LOV Oracle | |
| Display Warnings |
|
LOV Oracle |
