Create a New Program to Extract Purchase Order Information From Oracle System

591 Words3 Pages
Create a new program to extract Purchase Order information from Oracle system Create a new program to extract Purchase Order data from Oracle system and create a single Flat File for each Purchase Order extracted containing the Purchase Order data. The file(s) should be created at Produce Pro server. The new extraction program should consider the following criteria: Organization equal 22 (DMCO) or 23 (DMNA), Purchase Order status is approved; Ship to location, and extracted status should be equal to “N”. Each file will be validated for all PO required fields in PPRO. A final document import program in PPRO will process the file(s) to create new PO in PPRO. Create a Purchase Order flat file. Create a flat file based on the Purchase Order mapping table provided. The mapping table illustrates Oracle and Produce Pro fields’ relationship. Generate an extract audit report Generate an extract audit report in Oracle system. This report will show the total number of records extracted from the Oracle purchase Order tables. (Header and Detail) Update Purchase Order file in Oracle f...

More about Create a New Program to Extract Purchase Order Information From Oracle System

Open Document