Receivables - EBS (MOSC)

MOSC Banner

how to create credit card information via interface table

edited Dec 3, 2014 10:06AM in Receivables - EBS (MOSC) 1 commentAnswered

Dears,

   I need to create credit card information via interface table.

   I can't find the credit card information after the Customer Interface complete . but the interface data has been processed.

   My import CC information SQL as below:

INSERT INTO ra_customer_banks_int_all

( created_by,

creation_date,

last_update_date,

last_updated_by,

orig_system_customer_ref,

orig_system_address_ref,

primary_flag,

start_date,

org_id,

BANK_HOME_COUNTRY,

BANK_ACCOUNT_NUM,

BANK_ACCOUNT_CURRENCY_CODE,

BANK_NAME,

BANK_BRANCH_NAME,

Bank_branch_country,

BANK_ACCOUNT_NAME,

BANK_ACCOUNT_INACTIVE_DATE,

bank_number,

bank_num)

VALUES

( 6685,  --created_by

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center