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

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

Length: 591 words (1.7 double-spaced pages)

Rating: Good Essays

Open Document

Essay Preview

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...

Need Writing Help?

Get feedback on grammar, clarity, concision and logic instantly.

Check your paper »

Oracle Databases Essay examples

- Oracle Databases A new energy is rising within CNS. Over the past year, many members of our administrative computing team have been developing Oracle applications. It is a new challenge to both CNS and our clients. We journey up the learning curve together and over the trial-and-error hurdles. Each day offers a new opportunity to understand another concept or process. Some faculties and departments are already using Oracle applications in their day-to-day operations. As time goes by, more and more information users will be working with an application based on Oracle database technology....   [tags: Papers]

Good Essays
1555 words (4.4 pages)

Oracle : For All Of Your Vendor Needs Essay

- Oracle: For All of Your Vendor Needs The Oracle Corporation is an American multinational computer technology corporation headquartered in Redwood City, California, United States. Oracle specializes in developing and selling computer hardware systems and enterprise software products – particularly its own brands of database management systems. As of 2011, the company is the second only to Microsoft in terms of revenue. The company also builds tools for database development and systems of middle-tier software, enterprise resource planning (ERP) software, customer relationship management (CRM) software and supply chain management (SCM) software....   [tags: Oracle Corporation, Supply chain management]

Good Essays
1227 words (3.5 pages)

Advantages of MySQL over Oracle Essay

- ... These prevent a user updating or modifying the database while it’s being read or written too. (Moodle.Ncirl.ie/Advanced_Databases.2014)   Concurrency Control Concurrency Control locking Strategies: There are two types of locking strategies that apply to a database management system, these are known as ‘Pessimistic Locking’ and ‘Optimistic Locking’. These are two different methods to control data within a database to prevent any lock problems. Pessimistic Locking: This lock strategy prevents concurrency by keeping an entity in the database locked whole it’s in the database’s memory....   [tags: database, website, security]

Good Essays
1332 words (3.8 pages)

Everest : Ford And Oracle Essay

- Everest: Ford and Oracle Abstract: This paper clearly explains the reasons for the failure of automatic procurement systems which is built for their production and non-production suppliers. The factors that leads to shut down the project are represented in this paper. The two main things that cause project failure are over budget, not meeting deadlines. Introduction: Ford Motor Company is a popular leading U.S. automaker which delivers automobiles with brand name Ford. “In 2010, it is the fifth largest automaker in the world as per the vehicle sales”....   [tags: Ford Motor Company, Automotive industry]

Good Essays
896 words (2.6 pages)

Tibetan Oracles: Fact or Fiction? Essays

- Tibetan Oracles The miraculous feats of the Tibetan oracles are well known sources of mysticism. Stories of men who can bend metal swords with their bare hands, dance wildly and proclaim the future have piqued the curiosity and fascination of many. However, most rationale people will question, how real is the Tibet oracle. Are these men really visited by the deities who they claim to be visited by or are they merely masters of illusion. “The desire to know the future is probably as old as the human race....   [tags: Tibet Oracle Oracles Essays]

Free Essays
4919 words (14.1 pages)

Financial Analysis of Oracle Corp Essay

- Financial Analysis of Oracle Corp INTRODUCTION Background and History Oracle Corporation is a technology company that supplies software for the use of information management. They develop, manufacture, market and distribute computer software that helps other corporations manage their data so they can better grow and prosper. In 1977, Larry Ellison, Bob Miner, and Ed Oates founded System Development Laboratories. After being inspired by a research paper written in 1970 by an IBM researcher titled “A Relational Model of Data for Large Shared Data Banks” they decided to build a new type of database called a relational database system....   [tags: essays papers]

Good Essays
2599 words (7.4 pages)

Essay about Oracle

- Oracle- Database Management System Data management is an extraordinarily old craft. Aristotle's scheme of interlocking classifications of knowledge in his work Physica is a data-management effort. In the early 1800s the Jacquard loom used holes punched in paper cards to represent instructions for controlling the action of a loom. These cards became the basis for Herman Hollerith’s card-sorting device, used for the 1890 U.S. census http://80-gme.grolier.com.ezproxy.apollolibrary.com. Many database programs were designed around the physical cards: the maximum information that could be encoded on a punch card became the length of a standard record....   [tags: essays research papers]

Good Essays
2005 words (5.7 pages)

Oracle Products and Services Essay

- Oracle Products and Services A Brief Overview of the Oracle Product and Service Lines Oracle is one of the premier database and application providers in the Industry. With the support of developers world wide, Oracle offers cutting edge technology in both the public and private sectors. Oracle has taken on many of its partners and today competes with some of the biggest names in the industry, such as:  Computer Associates with the Ingres database  IBM with DB/2 database  Informix with the Informix database  Microsoft with Access and SQL Server database  Software AG with ADABAS  PostgressSQL (free open source database) With all these differen...   [tags: Papers]

Good Essays
450 words (1.3 pages)

Essay about Oracle Implementations

- Oracle Implementations Introduction .........................................................................................................................3 Project Manager Role........................................................................................................3 Client Project Manager....................................................................................................3 Consulting Project Manager ...........................................................................................3 Scope, Objectives and Approach..................................................................................4 Scope.....................................................   [tags: Oracle Implementation Project Management Essays]

Good Essays
4787 words (13.7 pages)

Essay about Oracle

- Dates in Oracle are stored in numeric format. Each date represents the century, year, month, day, hours, minutes, and seconds. The default date format is DD-MON-YY. Using the SYSDATE function, you can display the current date and time. You can use SYSDATE as you would use any other column name. In order to view the time you will need to use the TO_CHAR function along with a format mask which includes a time format element. For example, you can display the current date by selecting SYSDATE from a table....   [tags: essays research papers]

Free Essays
961 words (2.7 pages)