Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. charmingcann

    Keeping Old Order number when converted to Oracle

    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...
  2. charmingcann

    forms messages not appearing in status line

    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...
  3. charmingcann

    Sales Order Import (SO Conversion)

    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...
  4. charmingcann

    File checking using shell script

    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...
  5. charmingcann

    data migration - sql loader issue

    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...
  6. charmingcann

    SQL-LOADER problem

    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)...
  7. charmingcann

    automatic ftp from local pc to unix server

    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...
  8. charmingcann

    HOW TO REGISTER A BITMAP REPORT IN ORACLE 11i ?!

    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...

Part and Inventory Search

Back
Top