2014-05-29-13049.100 - BreakFix - DSSCO PO Feed program issue #ProductionBreakFix #DSSCOApplication
2014-05-29 - 10349.100 - BreakFix - DSSCO PO Feed Program Issue
Problem Summary
DSSCO PO Feed program issue
Admin Info
Purpose
|
DSSCO PO Feed program issue - PO Feed not sent
|
Requested by
|
Baiwa Zhang
|
Issue Date
|
05-28-2014
|
Resolved by
|
Vamshi
|
Resolved Date
|
05-29-2014
|
Document Status
|
Complete
|
Detailed Problem Description
(Include Screen Shots if required )
The PO feed for the PO 4500104021 was not sent to the carrier.
The PO has details in both Openpos and openpos_prev table and which got the shipping Instruction details in the openpos table.
As there is an update for the PO it should be sent to the carrier.
While comparing the data for the PO in both openpos and openpos_prev tables it is getting excluded as there is null value for shipping instruction in openpos_prev table.
Solution Analysis and Recommendations
(Include Screen Shots if required)
The NULL values should be handled in the view ChangedPOSFTP_vw_FF14 which is used to get the list of po's that need to be sent to the carriers.
Test Plan
[List test scenarios/cases to be executed here]
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Run the DSSCO Crystal reports to get the latest data
|
The CSV files should have data for the PO's
|
2
|
Run the SSIS packages for DSSCO
|
The data from the csv files will be loaded to the DSSCO tables.
|
3
|
Run the AUTO FTP process
|
The FTP process will send the PO feeds for the FTP details provided
|
Resolution
Modify the view ChangedPOSFTP_vw_FF14 to handle the null values.
Release Information
Provide link here to Release Notes if Technical Objects were changed