2013-06-12 - 5711.200 - Break Fix -Investigating the Wilcom. #POLCAApplication

2013-06-12 - 5711.200 - BreakFix - Investigating the Wilcom

Problem Summary


Few data fields in CSV file source are not matching with the Wilcom data.
Admin Info

Purpose
Investigating the Wilcom
Requested by
Joan/Daniela
Issue Date
05-13-2013
Resolved by
Venkat.A
Resolved Date
06-12-2013
Document Status
Complete

Detailed Problem Description


In the current process we are using RTA generated CSV files as our source for Polca. But few fields are not matching with Wilcom data.
Solution Analysis and Recommendations

As a solution NEC decided to get the incorrect data fields directly from Wilcom and rest of fields from RTA generated CSV files.
Below image is the recommended flow for the process.
Wilcom.jpg

Resolution


Update Ecalc package and its related stored procedures to get the correct data into Polca

Release Information


NA