need to upload huge volume of AP and AR related transaction [message #421254] |
Mon, 07 September 2009 00:05 |
Niraj T
Messages: 14 Registered: June 2009 Location: Mumbai
|
Junior Member |
|
|
Dear All,
I need to upload huge volume of AP and AR related transaction to Oracle 11i through SQL. Can anybody help me out? All my data are in Excel. I need in detail, the procedure to be followed and how to upload.
For Example: In AP we have, Standard Invoice, Pre Payments, Debit Memos and Credit Memos and subsequent payments also. Similarly in AR we have Transaction such as Invoices and Credit Memos and subsequent receipts also.
If any body have any document or white paper please share with me on my below email ID.
Thanks in Advance.
Regards
Niraj
niraj_5685@yahoo.co.in
|
|
|
|
|
|
|
Re: need to upload huge volume of AP and AR related transaction [message #421363 is a reply to message #421290] |
Mon, 07 September 2009 20:28 |
|
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
sqlldr -help
userid ORACLE username/password
control Control file name
log Log file name
bad Bad file name
data Data file name
discard Discard file name
discardmax Number of discards to allow
skip Number of logical records to skip
load Number of logical records to load
errors Number of errors to allow
rows Number of rows in conventional path bind array or between direct path data saves
bindsize Size of conventional path bind array in bytes
silent Suppress messages during run (header,feedback,errors,discards,partitions)
direct use direct path
_synchro internal testing
parfile parameter file: name of file that contains parameter specifications
parallel do parallel load
file File to allocate extents from
skip_unusable_indexes disallow/allow unusable indexes or index partitions
skip_index_maintenance do not maintain indexes, mark affected indexes as unusable
commit_discontinued commit loaded rows when load is discontinued
_display_exitcode Display exit code for SQL*Loader execution
readsize Size of Read buffer
external_table use external table for load; NOT_USED, GENERATE_ONLY, EXECUTE
columnarrayrows Number of rows for direct path column array
streamsize Size of direct path stream buffer in bytes
multithreading use multithreading in direct path
resumable enable or disable resumable for current session
resumable_name text string to help identify resumable statement
resumable_timeout wait time (in seconds) for RESUMABLE
date_cache size (in entries) of date conversion cache
_testing_ncs_to_clob test non character scalar to character lob conversion
_parallel_lob_load allow direct path parallel load of lobs
|
|
|