With 26R1 release Fusion SCM Analytics Manufacturing functional - Work Order Asset functionality deprecated, which has been documented here.
While there is no intended out-of-the-box replacement for these data points - If you absolutely need this functionality in your reporting – you can still achieve the same using Data Augmentation by following the below steps.
Step 1: Source & Data Augmentation
- Path: FscmTopModelAM.ScmExtractAM.WieBiccExtractAM.WOAssetExtractPVO
- Table: DW_FAX_WO_ASSET
Step 2: Create Asset Translation Table
CREATE TABLE CUSTOM_DW_ASSETS_TL AS
SELECT * FROM OAX$oac.DW_CXSR_INSTALLED_BASE_ASSETS_D_TL;
Step 3: Create Combined Asset–Work Order Table
CREATE TABLE DWC_FA_X_CUSTOM_WO_ASSET_WO_DETAILS AS
SELECT
b.WOASSETPEOASSETID, b.WOASSETPEOCREATEDBY, b.WOASSETPEOCREATIONDATE,
b.WOASSETPEOORGANIZATIONID, b.WOASSETPEOREQUESTID, b.WOASSETPEOWOASSETID,
b.WOASSETPEOWORKORDERID, a.ASSET_ID, a.ASSET_NUMBER, a.DESCRIPTION,
a.ACTIVE_END_DATE, a.SERIAL_NUMBER, a.ITEM_ID, a.ITEM_ORGANIZATION_ID
FROM CUSTOM_DW_ASSETS_TL a, DW_FA_X_WO_ASSET b
WHERE a.Asset_Id = b.WOASSETPEOASSETID;
To validate run the below SQL and confirm it gives the expected output.
lSELECT * FROM DWC_FA_X_CUSTOM_WO_ASSET_WO_DETAILS;
Step 4: Grant Access (Login as Admin and Grant the permission to OAX$OAC)
GRANT SELECT ON OAX_USER.DW_FAX_WO_ASSET TO "OAX$OAC";
GRANT SELECT ON OAX_USER.CUSTOM_DW_ASSETS_TL TO "OAX$OAC";
GRANT SELECT ON OAX_USER.DWC_FA_X_CUSTOM_WO_ASSET_WO_DETAILS TO "OAX$OAC";
Step 5: SME Work – Create Dimension in Logical Layer
- Create a new sandbox (e.g., Work Orders Assets)
- Go to Manage Logical Star
- Add Dimension → Create New → Select DWC_FA_X_CUSTOM_WO_ASSET_WO_DETAILS
- Define Primary Key and relevant columns
- Create Hierarchy (e.g., Custom Work Order Hierarchy)
- Finish
Step 6: Manage Extension – Add Foreign Key to OOTB Fact
- From Fact → Right-click → Manage Extension
- Add Physical Column → Work_Order_ID from custom dimension
Step 7: Join Custom Dimension with OOTB Fact
- Fact: Maintenance Materials
- Join Condition: Fact.Work_Order_Asset_ID = WOASSETPEOWORKORDERID
- Set Content Level: Detail
Step 8: Modify OOTB Subject Area
- Action: Modify Subject Area → Select SCM – Maintenance Materials
- Add Elements → New Custom Elements
- Click Add → Finish
Step 9: Publish Customizations
- Apply and publish changes
Step 10: Validate Results
- Confirm data visibility and joins in the subject area
By following the above steps and using the relevant columns accordingly in your reports – you should be able to report on Work Order Asset functionality. Please to let us know if you run into any issues or have questions.
