Re: Data Pump and HMRS APIs
From: <bilalemail_at_gmail.com>
Date: 8 Jun 2006 23:23:59 -0700
Message-ID: <1149834239.561875.222800_at_f6g2000cwb.googlegroups.com>
There is no relationship between Initial Balance Upload and Data Pump. They are two
separate processes. Initial Balance Upload is not used with Data Pump at all. Below you will
find a short description of each.
Initial Balance Upload
This procedure is used to transfer accumulated seeded and user balance values into Oracle
Payroll during implementations. The procedure is usually run from the Concurrent Manager.
Initial Balance Upload uses PAY_BALANCE_BATCH_HEADERS and _LINES interface
tables, similar to open interface tables used for importing data in other applications, such as
Oracle Financials. However, this process can be run only once (unless it is rolled back), and
not after Payrolls have been processed.
Navigation: HRMS > Processes and Reports > Submit Processes and Reports
> Initial
Balance Upload
Data Pump
This utility facilitates loading and updating Oracle HRMS data from external systems or nonHRMS
tables. Data Pump provides PL/SQL routines for mapping data from external sources
to Oracle HRMS APIs, allowing the user to load data into a single Oracle batch interface
table. Data Pump requires User-Defined keys, avoiding cryptic "_id"s, managing data in
views. Data is uploaded into the Oracle HRMS system using the Data Pump Engine, which is
a standard concurrent process. Data Pump is seeded in R11i, but you may need to add it to the
Request Group for your responsibility; it can be applied as a patch in R11.
Navigation: HRMS > Processes and Reports > Submit Processes and Reports
> Data Pump Engine
Received on Fri Jun 09 2006 - 08:23:59 CEST
Date: 8 Jun 2006 23:23:59 -0700
Message-ID: <1149834239.561875.222800_at_f6g2000cwb.googlegroups.com>
bilalemail_at_gmail.com wrote:
> you can load the data with Datapump but if you use the external tables
> for Oracle HRMS API you have to use the Sqlloader which is other then
> Data Pump.
What is the relationship between Initial Balance Upload and Data Pump?
Answer
There is no relationship between Initial Balance Upload and Data Pump. They are two
separate processes. Initial Balance Upload is not used with Data Pump at all. Below you will
find a short description of each.
Initial Balance Upload
This procedure is used to transfer accumulated seeded and user balance values into Oracle
Payroll during implementations. The procedure is usually run from the Concurrent Manager.
Initial Balance Upload uses PAY_BALANCE_BATCH_HEADERS and _LINES interface
tables, similar to open interface tables used for importing data in other applications, such as
Oracle Financials. However, this process can be run only once (unless it is rolled back), and
not after Payrolls have been processed.
Navigation: HRMS > Processes and Reports > Submit Processes and Reports
> Initial
Balance Upload
Data Pump
This utility facilitates loading and updating Oracle HRMS data from external systems or nonHRMS
tables. Data Pump provides PL/SQL routines for mapping data from external sources
to Oracle HRMS APIs, allowing the user to load data into a single Oracle batch interface
table. Data Pump requires User-Defined keys, avoiding cryptic "_id"s, managing data in
views. Data is uploaded into the Oracle HRMS system using the Data Pump Engine, which is
a standard concurrent process. Data Pump is seeded in R11i, but you may need to add it to the
Request Group for your responsibility; it can be applied as a patch in R11.
Navigation: HRMS > Processes and Reports > Submit Processes and Reports
> Data Pump Engine
Received on Fri Jun 09 2006 - 08:23:59 CEST