Im going to do SO conversion from SOB to new SOB in Oracle.I want to keep the order number generated in the old SOB and convert this with the same order number in the new SOB. I've read but I cannot confirmed that it's possible by creating a transaction type and associate the manual sequence...
i've developed new form using the template form in oracle applications and when i run the form in oracle apps, the standard form messages like "query caused no records" or "transactions completed" are not appearing in the message line. Even the "list of values" text...
Im going to import Sales Order from legacy system to Oracle ERP. All SOs to be converted will be in BOOKED status. Based on the documents I've read, if the SOs are in BOOKED status,the BOOKED_FLAG in the OE_HEADERS_IFACE_ALL is set to 'N' and an interface table called OE_ACTIONS_IFACE_ALL will...
I have this shell script that gets a file from a particular server :
HOST_IP=111.111.111.11
E_DEST=$SAMPLE_TOP/in
E_USERID='mis'
cd $E_DEST
ftp -n -v -i << EOF
open $FTP_HOST_IP
user $FTP_USERID
ascii
lcd $E_DEST
get file1
bye
EOF
I need to check whether the file is existing or not. If not...
I need some help with the following issues in sql*loader :
(1) How can I eliminate the job headers and job tails (unwanted lines) in the file?
(2) How to do the import where each line represents column in the interim table?
Here is my sample data :
!job header1 (1st line)
!job header2...
Im going to do importing of data from a legacy system to Oracle ERP using sql loader. Each line in the file consists of columns . Below is a sample data :
!job1
!run batch
500003443 -- part number (3rd line)
711-3434 -- account number (4th line)
25 -- quantity (5th line)...
I need to automate the transferring of file from local pc to unix server.
I've created a batch file and run this in my pc, it works. I've created a shell
script and run this in unix server, it fails.
The requirement is to create a script to automatically get the file in a local
PC and then...
I'm new in using oracle apps v11i. Im doing reports using Reports6i. I found out that it's different to register a bitmap report in oracle 11i. When I try to run it in oracle apps , i cannot view the output. i found out that there are things to be done (in unix) before you can actually run the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.