-
Essay / Create a new program to extract purchase orders...
Create a new program to extract purchase order information from the Oracle systemCreate a new program to extract purchase order data from the Oracle system and create a Single flat file for each extracted purchase order containing purchase order data. The file(s) must be created on the Produce Pro server. The new extraction program must take into account the following criteria: Organization equal to 22 (DMCO) or 23 (DMNA), the status of the purchase order is approved; Ship to location and checkout status should be 'N'. Each file will be validated for all mandatory purchase order fields in PPRO. A final document import program in PPRO will process the file(s) to create a new purchase order in PPRO. Create a purchase order flat file. Create a flat file based on the provided purchase order mapping table. The mapping table illustrates the relationship between Oracle and Produce Pro fields. Generate an extract audit report Generate an extract audit report in the Oracle system. This report will display the total number of records retrieved from Oracle Purchase Order tables. (Header and Detail) Update Purchase Order File in Oracle f...