FAW: Manufacturing Resource Details - Usage Rate Values Are Not Matching With Fusion Data.
(Doc ID 3006339.1)
Last updated on FEBRUARY 27, 2024
Applies to:
Data Intelligence - Version 23.R3.x and laterInformation in this document applies to any platform.
Symptoms
FAW 23.R4 - Manufacturing Resource details - Usage Rate values are not matching between Fusion and FAW.
DW_MFG_OPERATION_RESOURCES_CF.USAGE_RATE for different resources in a Work Order based on their Basis Types are not matching with corresponding Fusion source data.
Query used:
select OPR.WORK_ORDER_NUMBER, RES.RESOURCE_NAME, BAS.NAME BASIS_TYPE, OPR.USAGE_RATE from DW_MFG_OPERATION_RESOURCES_CF OPR, dw_egp_bom_basis_type_lkp_tl BAS, dw_mfg_resources_d_tl RESwhere OPR.RESOURCE_ID=RES.RESOURCE_ID and OPR.BASIS_TYPE_CODE=EGP_BOM_BASIS_TYPE_CODE and OPR.WORK_ORDER_NUMBER='<WO_NUM>';
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |