Monday 9 September 2013

How to Change the Output File Name Created by Payment Process Request

R12 after finishing Payment Process Request,Format Payment Instructions with Text Output request generates out put in particular directory depends on the below set up.
Default name of file is Request id.file extension

Oracle Payments Setup > Payment Process Profiles >


So the general requirement will be rename the file with sysdate, R11 i we can attach a custom program to payment program which will rename the file with sysdate for that payment request,Where as in R12 we don't have option to attach any custom program to do that.
By using the below script we can rename with sysdate.(Scheduled the same in UNIX)
#!/bin/sh
# Created: Anil Maguluri
# To rename the UK Format Payment Instructions with Sysdate
#-------------------------------------------------------------------
{
echo Format Payment Instructions
for file in UK*.xml
do
newfile=$(date "+%d%b%Y_$file" -d "$(stat -c "%y" $file)")
mv "$file" "$newfile"
done
echo rename the file
} > UK_install.log 2>&1

No comments:

Post a Comment