|Oracle Financial Services Accounting Hub Implementation Guide|
Part Number E13420-05
The Financial Services Accounting Hub provides the following types of seed data:
Subledger application setups
For these setups, FNDLOAD technology imports and exports the data between the database tables and the ldt data file directly.
Subledger applications, such as Oracle Payables, support programs that transfer transaction data between subledgers based on the accounting generated by the transaction date. Users define Post-Accounting programs to distinguish journal lines for processing based on the accounting class associated with the journal entry line.
See: Post-Accounting Programs, Oracle Subledger Accounting Implementation Guide
Application accounting definitions and journal entry setups
The Financial Services Accounting Hub provides the Application Accounting Definitions Loader (AAD Loader) to transfer setups between the database and the ldt file.
The subledger application setups are the data created by the subledger applications to enable subledger accounting functionality. These setups establish the framework for building application accounting definitions. The setups include the following objects:
Subledger applications registered with the Financial Services Accounting Hub
Accounting event class options
Accounting attribute assignments
FNDLOAD exports and imports the subledger accounting setups between the database and ldt file. Use the xlamseed.lct control file for this purpose.
To export the subledger application setups from a database to an ldt data file, use the following command:
FNDLOAD <username>/<password>[@connect] 0 Y DOWNLOAD xlaemseed.lct <datafile> XLA_SUBLEDGERS APPLICATION_ID=<application id>
|Application ID||Application internal identifier|
To import the subledger application setups from an ldt data file to the database, use the following command:
FNDLOAD <username>/<password>[@connect] 0 Y UPLOAD xlaemseed.lct <datafile>
FNDLOAD inserts and updates the subledger application setups in the database; however, no existing data is deleted from the database.
See: Subledger Application Clean-up Script
For Oracle Receivables to export the subledger application setups from the database to the ldt data file ARXLASD.LDT, run the following:
FNDLOAD scott/tiger 0 Y DOWNLOAD xlaemseed.lct ARXLASD.ldt XLA_SUBLEDGERS APPLICATION_ID=222
For Receivables to import the subledger application setups from the ldt data file ARXLASD.LDT to the database, run the following:
FNDLOAD scott/tiger 0 Y UPLOAD xlaemseed.lct ARXLASD.ldt
The following script deletes the subledger application setups from the database. Once the data is deleted it is not recoverable unless the data was exported to an ldt data file.
Note: It is not necessary to run this script before running the import process. Run this script only if data must be removed from the database.
|P_API_VERSION||API version. The value should be 1.0||NUMBER||IN|
API return status. Possible values
|P_APPLICATIONS_ID||Internal identifier application||INTEGER||IN|
x_return_status VARCHAR2(1) ;
XLA_AAD_LOADER_UTIL_PVT.purge_subledger_seed (p_api_version => 1.0 ,x_return_status => x_return_status ,p_application_id => <application id>) ;
Copyright © 2006, 2016, Oracle and/or its affiliates. All rights reserved.