Visit The New, Modern Unix Linux Community


Move the file from one path to another using .sh file in EBS Oracle apps.


 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Move the file from one path to another using .sh file in EBS Oracle apps.
# 1  
Move the file from one path to another using .sh file in EBS Oracle apps.

Hi All,

I just want to move the file from one path to another using .sh file in EBS oracle apps.

I have written in .prog but i need in .sh (file.sh)

XXC_SAMPLE_FILE.prog
Code:
#!/bin/bash
  # XXC_SAMPLE_FILE.prog
  DATE_TIME=`date | awk {' print $1"_"$2"_"$3"_"$4 '}`
  echo "parse_parms"
  REQID=$5
  echo $5
  echo "Request Id:" $REQID
  OUTPUT_FILE=$APPLCSF/$APPLOUT/o$REQID.out
  ATTACH_FILE="/XXC_OUTPUT"
  cp $OUTPUT_FILE $ATTACH_FILE

  echo " "
  echo "-----------------------------------------------------------------------"
  echo " "
  now1=$(date +"%T")
  echo "Installation Start time : $now1" 
  # ************************************
  #  End of Script
 # ********************************

Can you please help me on this?

Thank you,

Last edited by Mist123; 05-15-2019 at 10:43 AM..
# 2  
I think it works like it is.
Suggestions for improvement:
Code:
DATE_TIME=`date | awk {' print $1"_"$2"_"$3"_"$4 '}`

works, but the { } should be inside the ' ', to explicitly escape the { } special meaning in the shell.
Code:
DATE_TIME=`date | awk '{ print $1"_"$2"_"$3"_"$4 }'`

Put quotes around $variables in command arguments, to prevent the shell from doing further substitutions on them.
Code:
echo "$5"
cp "$OUTPUT_FILE" "$ATTACH_FILE"

echo and cp are commands.
# 3  
Thank you very much i will try and keep you posting the update
# 4  
Hi ,

Can you please help me on this?

Thank you
# 5  
Quote:
Originally Posted by Mist123
Hi ,

Can you please help me on this?

Thank you
Help you with what?

What did you try?

What happened?

What isn't working the way you want it to work?

What operating system are you using?

You are using the variables APPLCSF and APPLOUT without setting them? What values do they have in your environment when you run your script?

What command line is used to invoke your script?

Are you getting any diagnostics when you invoke your script? If so, what do they say (exactly in CODE tags, please)?

Assuming that you're running in the C or POSIX locale or in an American locale, why are you using:
Code:
  DATE_TIME=`date | awk {' print $1"_"$2"_"$3"_"$4 '}`

instead of:
Code:
  DATE_TIME=$(date '+%a_%b_%d_%T')

If you're not running in one of the locales mentioned above, what format are you hoping will be used when assigning a value to DATE_TIME?

PS. Note that it is unusual to write a script that requires five operands but never looks at the first four of them. Why do you do that?

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #240
Difficulty: Easy
In 1973, a transatlantic satellite link connected the Norwegian Seismic Array (NORSAR) to the ARPANET, making Norway the first country outside the US to be connected to the network.
True or False?

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How do I add a log file path to a vi file to monitor all the changes made to the file?

I'm curious to know how do I add an empty log file (test1.log) to an existing text file to monitor all the changes made to a.txt. Is this expression export PATH=$PATH:/home/test1.log right to be added to the text file a.txt? (5 Replies)
Discussion started by: TestKing
5 Replies

2. UNIX for Beginners Questions & Answers

Convert Relative path to Absolute path, without changing directory to the file location.

Hello, I am creating a file with all the source folders included in my git branch, when i grep for the used source, i found source included as relative path instead of absolute path, how can convert relative path to absolute path without changing directory to that folder and using readlink -f ? ... (4 Replies)
Discussion started by: Sekhar419
4 Replies

3. Shell Programming and Scripting

Send an email if "No such file or directory" in the shell script program log in EBS concur

Hi All, I have the below code(.sh) and need to send an email. #!/bin/bash cp /u02/xxc_incoming/TEST*.dat /u02/xxc_archive_incoming/AMER7764_ARPP_2/ cat /u02/xxc_incoming/TEST*.dat > /u02/xxc_incoming/XXC_TEST.dat rm /u02/xxc_incoming/TEST*.dat cd $XXC_TOP/bin sqlldr userid=apps/<pwd> ... (12 Replies)
Discussion started by: Mist123
12 Replies

4. UNIX for Dummies Questions & Answers

Need help to move .csv file from UNIX path to windows shared drive or c:\ drive

Hi Guys, Can any one help me on this. I need help to move .csv/.xls file from unix path to windows shared drive or c:\ drive? Regards, LKR (1 Reply)
Discussion started by: lakshmanraok117
1 Replies

5. Shell Programming and Scripting

Need help to move .csv file from UNIX path to window c: shared drive

Hi Guys, I need to move myfile.csv file from unix path(\oracle_home) to window c:\ shared drive h:\. Thanks in advance! Regards, Lakshman (1 Reply)
Discussion started by: lakshmanraok117
1 Replies

6. UNIX and Linux Applications

Mod_proxy_html on Oracle EBS

Hi , I am trying to impliment mod_proxy and mod_proxy_html as a reverse proxy for oracle EBS. Everything is working fine except the submenu links (still pointing to the internal url) of the modules tree view. Please help me. Regards, Arumon (0 Replies)
Discussion started by: arumon
0 Replies

7. Homework & Coursework Questions

how to delete core file (file created due to apps crashed)

1. The problem statement, all variables and given/known data: When looking for corefiles, include any file with core in its name. (Some UNIX/Linux systems add the PID of the process that created the core to reduce the chances of overwriting an already existing core file that might be needed. The... (6 Replies)
Discussion started by: s3270226
6 Replies

8. Linux

file location for GNOME auto startup apps

I know how to add an apps to auto-start in GUI, but I'd like to know how to do it mannualy. So where is the file saved to by GUI ? (1 Reply)
Discussion started by: honglus
1 Replies

9. UNIX for Dummies Questions & Answers

Oracle Apps Cron Job

Hi, I have created a shell script which will ftp a file from my Oracle DB server to a remote server - I've named this ftp_test.sh. I have set up a cron job to fire off the shell script and when I set the job I get a message returned that the job has been installed and everything seems o.k.... (1 Reply)
Discussion started by: cjhall01
1 Replies

Featured Tech Videos