Database Software

Hi All,

I am getting below error in sql loader. could you please help me how to solve this issue.

Record 1: Rejected - Error on table TEST_STAGING.

ORA-00947: not enough values

CREATE TABLE TEST_STAGING (

    TEST_STAGING_id     NUMBER(12,0)        NOT NULL ENABLE,

    pymt_tndr_typ             CHAR(20 BYTE)        NOT NULL ENABLE,

    pymt_date                 DATE                NOT NULL ENABLE,

    rcpt_id                   VARCHAR2(40)        NOT NULL ENABLE,

    payor_bank_acct_id        VARCHAR2(40)        NOT NULL ENABLE,

    rcpt_curr_code            VARCHAR2(40)        NOT NULL ENABLE,

    chk_no                    VARCHAR2(10),

    wire_no                   VARCHAR2(10),

    ach_no                    VARCHAR2(10),

    tndr_amt                  NUMBER(15,2)        NOT NULL ENABLE,

mat_type                  VARCHAR2(40)        NOT NULL ENABLE,

mat_val                   VARCHAR2(40),

cash_appl_amt             NUMBER(15,2),

    load_status               VARCHAR2(10),

    load_error_msg            VARCHAR2(500),

    audit_insert_dt           TIMESTAMP(6)        NOT NULL ENABLE,

    audit_insert_user_nm_tx   VARCHAR2(50 BYTE)   NOT NULL ENABLE,

    audit_update_dt           TIMESTAMP(6)        NOT NULL ENABLE,

    audit_update_user_nm_tx   VARCHAR2(50 BYTE)   NOT NULL ENABLE

);

OPTIONS (SKIP=1)

LOAD DATA

INTO TABLE TEST_STAGING

APPEND

FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'

TRAILING NULLCOLS

(   

    pymt_tndr_typ             "trim(:pymt_tndr_typ)" 

    ,pymt_date                 date "MM/DD/YYYY"  

    ,rcpt_id                   "trim(:rcpt_id)"

    ,payor_bank_acct_id        "trim(:payor_bank_acct_id)"

    ,rcpt_curr_code            "trim(:rcpt_curr_code)"

    ,chk_no                    "trim(:chk_no)"

    ,wire_no                   "trim(:wire_no)"

    ,ach_no                    "trim(:ach_no)"

    ,tndr_amt                  "trim(:tndr_amt)"

,mat_type                  "trim(:mat_type)"

,mat_val                   "trim(:mat_val)"

,cash_appl_amt             "trim(:cash_appl_amt)"  

,load_status    "SUCCESS"

,load_error_msg             "S"

    ,audit_insert_dt           SYSDATE

    ,audit_insert_user_nm_tx   "SK"

    ,audit_update_dt            SYSDATE

    ,audit_update_user_nm_tx   "SK"

,TEST_STAGING_id      "TEST_STAGING_SEQ.nextval"

)