...
- Pre-sql null row handling for KFS_D_DOC_HDR
- PO Fact table lookup tables lookup for KFS_D_PO_COMM - DONE
- KFS_F_PO_ITM ORG_SID column only contains -1s
- KFS_F_DSBRMNT_ITM loading test query failure (BadRecCount = 2 and JoinedRecCount = 3).
- KFS_F_DSBRMNT_ITM_ACCTNG validation failed using old test script.
- KFS_F_PREQ_ITM test query failing for KFS_D_PO_COMM and KFS_D_PO_CONTR_MGR (BadRecCount = 0 and JoinedRecCount = 0).
- KFS_F_PREQ_ITM_ACCTNG has an etl coding error .- DONE
- KFS_D_CRDT_MEMO_DOC validation issue not working correctly. Need to be run twice.
Action items:
Andrew: Pre-sql null row handling for KFS_D_DOC_HDR. Review new comment from Anh regarding test script.
Austin: Identify new development that need to be done - review with Valerie.
Andy: Creating test scenarios for the type 2 changes for fact table validation.
Anh: Discuss validation issue with Bryce for test script issue for KFS_D_CRDT_MEMO_DOC.
...