|
Integration
between PeopleSoft and Oracle
Applications provides real-time
employee information for KLA-Tencor
Corporation
|
|
| Business
Issues: |
 |
|
Delays in
business critical activities
like defining new buyer and
sales representatives in Oracle
applications due to lack of
up to-date employee information
in Oracle from PeopleSoft master
data
|
| |
|
|
| Solution: |
|
|
Imported
and converted Employee data
from PeopleSoft and synchronized
it with Oracle applications
roles such as Buyer and Sales
Representatives
|
|
Developed
data model for interface tables,
developed SQL*Loader scripts
to import PeopleSoft into temporary
tables; PL/SQL scripts and Unix
Shell scripts were developed
to validate the data and update
Oracle application tables; Concurrent
program was defined to automate
and schedule these programs
within Oracle Apps environment
|
| |
|
|
| Outcome: |
|
|
A seamless
integration between PeopleSoft
and Oracle Applications for
business critical employee information
|
| |
|
|
| All
Success Stories |
