Tag Archives: Import Data

CE Sample SQL*Loader Scripts

Posted by on June 5, 2008 No comments

Here are some sample SQL*Loader scripts for the ce_statement_headers_int_all and ce_statement_lines_interface tables:

LOAD DATA
REPLACE
INTO TABLE ce.ce_statement_headers_int_all
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
    statement_number            CHAR,
    bank_account_num            CHAR,
    statement_date            CHAR,
    bank_name                CONSTANT        'Bank Name',
    bank_branch_name            CONSTANT        '',
    creation_date            SYSDATE,
    last_update_date            SYSDATE,
    control_begin_balance        DECIMAL EXTERNAL,
    control_total_dr            DECIMAL EXTERNAL,
    control_total_cr            DECIMAL EXTERNAL,
    control_end_balance        DECIMAL EXTERNAL,
    control_dr_line_count        INTEGER EXTERNAL,
    control_cr_line_count        INTEGER EXTERNAL,
    control_line_count        INTEGER EXTERNAL,
    currency_code            CONSTANT        'TTD',
    int_calc_balance            DECIMAL EXTERNAL
)
LOAD DATA
REPLACE
INTO TABLE ce.ce_statement_lines_interface
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
    bank_account_num            CHAR,
    trx_date                DATE,
    attribute1                CHAR,
    trx_code                CHAR,
    bank_trx_number            CHAR,
    amount                DECIMAL EXTERNAL,
    attribute2                CHAR,
    trx_text                CHAR,
    statement_number            CHAR,
    line_number                INTEGER EXTERNAL,
    original_amount            DECIMAL EXTERNAL,
    currency_code            CHAR,
    creation_date            SYSDATE,
    last_update_date            SYSDATE,
    charges_amount            CONSTANT        0.00
)

Journal Importing GL_INTERFACE Data

Posted by on October 10, 2006 No comments

This documentation shows how to load journals that were loaded into the GL_INTERFACE table.

Step 1:        Log on as a user with access to the GL responsibility and select the General Ledger Manager responsibility.

Step 2:        Navigate to Journals > Import > Run.

Step 3:        Enter the Source and Group ID. Select Without Validation.

Step 4:        Click Import.

Step 5:        To delete imported journals, navigate to Journals > Import > Delete.

Step 6:        Enter the Source, Request ID and Group ID.

The Request ID is that of the request used to import the journals (check View Requests to determine this ID).

Importing Supplier Data

Posted by on October 3, 2006 No comments

We had some problems with loading the data because one of the fields, address_line3 was omitted from the data file. Verify the data file against the control file.

You must log on to the correct responsibility in order to import the data.

Company Org_id
Company A 123
Company B 141
Company C 142

After the data is loaded, two concurrent programs must be run to import the data:

  1. Supplier Open Interface Import
  2. Supplier Sites Open Interface Import

Data is loaded into:

  1. AP_SUPPLIERS_INT
  2. AP_SUPPLIER_SITES_INT

Data is imported into:

  1. PO.PO_VENDORS
  2. PO.PO_VENDOR_SITES_ALL

Change VENDOR_SITE_CODE to ‘PRIMARY’.

For manual entry of vendor numbers, change the settings in the application and populate the SEGMENT1 field.

Valid TERMS_DATE: ‘Net 30 Days’

VENDOR_INTERFACE_ID must be in both tables. Insert it into the data file if necessary.

Importing Data from GL Interface Table

Posted by on August 29, 2006 No comments

 Problem: After loading data into the GL_INTERFACE table, how is the data imported into the base tables?

Solution:

Step 1:        Log on to E-Business Suite and select the General Ledger Superuser responsibility.

Step 2:        Navigate to Journals, then Import and finally Run.

Step 3:        On the Import Journals form, enter the date range.

Enter data into the Source, Selection Criteria and Specific Value fields, and then click Import.

For example, ‘History’, ‘Selected Group ID’ and Value ‘1’.