Home » RDBMS Server » Server Utilities » need to upload huge volume of AP and AR related transaction (oracle 11i, Sun solaris)
need to upload huge volume of AP and AR related transaction [message #421254] Mon, 07 September 2009 00:05 Go to next message
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 #421255 is a reply to message #421254] Mon, 07 September 2009 00:27 Go to previous messageGo to next message
ayush_anand
Messages: 417
Registered: November 2008
Senior Member
This is an Oracle Apps related question please post it in suitable place.(this is plsql forum)
You can use interface tables and load the data using sql*loader or you can use concept external tables also.
Re: need to upload huge volume of AP and AR related transaction [message #421290 is a reply to message #421255] Mon, 07 September 2009 05:44 Go to previous messageGo to next message
Niraj T
Messages: 14
Registered: June 2009
Location: Mumbai
Junior Member

Hi

What is the process of data loading through sqlloader ? or if you have any document or white paper, please share it.

Thanks in Advance.


Regards
Niraj
niraj_5685@yahoo.co.in
Re: need to upload huge volume of AP and AR related transaction [message #421294 is a reply to message #421290] Mon, 07 September 2009 05:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL*Loader

Regards
Michel
Re: need to upload huge volume of AP and AR related transaction [message #421311 is a reply to message #421290] Mon, 07 September 2009 07:31 Go to previous messageGo to next message
ayush_anand
Messages: 417
Registered: November 2008
Senior Member
http://www.psoug.org/reference/sqlloader.html

If you want something in short Wink
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 Go to previous message
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
Previous Topic: Datapump log file read permission
Next Topic: SQLLDR - Deriving another field while loading
Goto Forum:
  


Current Time: Sat Apr 20 01:39:18 CDT 2024