Wednesday, November 22, 2017

Lookups in Oracle Apps R12

Tuesday, November 21, 2017

How to Get the Image dynamically in Oracle Rtf Reports

àdevelop the RTF TEMPLATE REPORT layout.
àcopy a dummy image in that RTF layout at the top position wherever you want the image.
àThen right click on the dummy image EDIT ALT TEXT(Ms office 2016) for the image
àIn the ALT TEXT give the following code for getting the image dynamically.
$OA_MEDIA—is the server path where you want to place the original image location
IMG_TEST.jpg—is the image name whatever you want to display in output.

FOR GETTING THE $OA_MEDIA PATH
àconnect to the PUTTY
àlogin with the credentials
à Run the command for set the environment   “ps -ef|grep inh”
Then you see list of paths in server …cd <path>  eg: /us1001/TEST/apps/tech_st
àin that path you will get the environment path “APPSTEST.env”
àthen run the command  “. APPSTEST.env” for setup environment.
àthen run pwd for getting present working directory
àthen run the command “cd $OA_MEDIA” and then run “pwd”
àthen you will get the $OA_MEDIA directory “/us1001/TEST/apps/apps_st/comn/java/classes/oracle/apps/media”

àconnect WINSCP and goto the above path for placing a image
ànext step in place the image in the above path
àthen run the concurrent program you will the image in the output pdf file.

Thursday, November 9, 2017

Putty commands

Putty commands


PuTTY Commands
SNS 5/20/2008
 
PuTTY Commands: 
 
ls - to list files in a directory:
cd - change directory
cp - copy a file
mv - move a file 
mv - move a file 
mkdir - make directory
pwd - show your current location
whoami - find out which user you are
date - display date and time
man - most important of all commands (opens manual pages for other commands):
q - quit or exit an application 
An A-Z Index of the Linux BASH command line
alias    Create an alias
apropos  Search Help manual pages (man -k)
awk      Find and Replace text, database sort/validate/index
break    Exit from a loop
builtin  Run a shell builtin
bzip2    Compress or decompress named file(s)
 
cal      Display a calendar
case     Conditionally perform a command
cat      Display the contents of a file
cd       Change Directory
cfdisk   Partition table manipulator for Linux
chgrp    Change group ownership
chmod    Change access permissions
chown    Change file owner and group
chroot   Run a command with a different root directory
cksum    Print CRC checksum and byte counts
clear    Clear terminal screen
cmp      Compare two files
comm     Compare two sorted files line by line
command  Run a command - ignoring shell functions
continue Resume the next iteration of a loop
cp       Copy one or more files to another location
cron     Daemon to execute scheduled commands
crontab  Schedule a command to run at a later time
csplit   Split a file into context-determined pieces
cut      Divide a file into several parts
 
date     Display or change the date & time
dc       Desk Calculator
dd       Data Dump - Convert and copy a file
ddrescue Data recovery tool
declare  Declare variables and give them attributes
df       Display free disk space
diff     Display the differences between two files
diff3    Show differences among three files
dig      DNS lookup
dir      Briefly list directory contents
dircolors Colour setup for `ls'
dirname  Convert a full pathname to just a path
dirs     Display list of remembered directories
du       Estimate file space usage
 
echo     Display message on screen
egrep    Search file(s) for lines that match an extended expression
eject    Eject removable media
enable   Enable and disable builtin shell commands
env      Environment variables
ethtool  Ethernet card settings
eval     Evaluate several commands/arguments
exec     Execute a command
exit     Exit the shell
expand   Convert tabs to spaces
export   Set an environment variable
expr     Evaluate expressions
 
false    Do nothing, unsuccessfully
fdformat Low-level format a floppy disk
fdisk    Partition table manipulator for Linux
fgrep    Search file(s) for lines that match a fixed string
file     Determine file type
find     Search for files that meet a desired criteria
fmt      Reformat paragraph text
fold     Wrap text to fit a specified width.
for      Expand words, and execute commands
format   Format disks or tapes
free     Display memory usage
fsck     File system consistency check and repair
ftp      File Transfer Protocol
function Define Function Macros
 
gawk     Find and Replace text within file(s)
getopts  Parse positional parameters
grep     Search file(s) for lines that match a given pattern
groups   Print group names a user is in
gzip     Compress or decompress named file(s)
 
hash     Remember the full pathname of a name argument
head     Output the first part of file(s)
history  Command History
hostname Print or set system name
 
id       Print user and group id's
if       Conditionally perform a command
ifconfig Configure a network interface
import   Capture an X server screen and save the image to file
install  Copy files and set attributes
 
join     Join lines on a common field
 
kill     Stop a process from running
 
less     Display output one screen at a time
let      Perform arithmetic on shell variables
ln       Make links between files
local    Create variables
locate   Find files
logname  Print current login name
logout   Exit a login shell
look     Display lines beginning with a given string
lpc      Line printer control program
lpr      Off line print
lprint   Print a file
lprintd  Abort a print job
lprintq  List the print queue
lprm     Remove jobs from the print queue
ls       List information about file(s)
lsof     List open files
 
make     Recompile a group of programs
man      Help manual
mkdir    Create new folder(s)
mkfifo   Make FIFOs (named pipes)
mkisofs  Create an hybrid ISO9660/JOLIET/HFS filesystem
mknod    Make block or character special files
more     Display output one screen at a time
mount    Mount a file system
mtools   Manipulate MS-DOS files
mv       Move or rename files or directories
 
netstat  Networking information
nice     Set the priority of a command or job
nl       Number lines and write files
nohup    Run a command immune to hangups
nslookup Query Internet name servers interactively
 
passwd   Modify a user password
paste    Merge lines of files
pathchk  Check file name portability
ping     Test a network connection
popd     Restore the previous value of the current directory
pr       Prepare files for printing
printcap Printer capability database
printenv Print environment variables
printf   Format and print data
ps       Process status
pushd    Save and then change the current directory
pwd      Print Working Directory
 
quota    Display disk usage and limits
quotacheck Scan a file system for disk usage
quotactl Set disk quotas
 
ram      ram disk device
rcp      Copy files between two machines.
read     read a line from standard input
readonly Mark variables/functions as readonly
remsync  Synchronize remote files via email
return   Exit a shell function
rm       Remove files
rmdir    Remove folder(s)
rsync    Remote file copy (Synchronize file trees)
 
screen   Terminal window manager
scp      Secure copy (remote file copy)
sdiff    Merge two files interactively
sed      Stream Editor
select   Accept keyboard input
seq      Print numeric sequences
set      Manipulate shell variables and functions
sftp     Secure File Transfer Program
shift    Shift positional parameters
shopt    Shell Options
shutdown Shutdown or restart linux
sleep    Delay for a specified time
sort     Sort text files
source   Run commands from a file `.'
split    Split a file into fixed-size pieces
ssh      Secure Shell client (remote login program)
strace   Trace system calls and signals
su       Substitute user identity
sum      Print a checksum for a file
symlink  Make a new name for a file
sync     Synchronize data on disk with memory
 
tail     Output the last part of files
tar      Tape ARchiver
tee      Redirect output to multiple files
test     Evaluate a conditional expression
time     Measure Program running time
times    User and system times
touch    Change file timestamps
top      List processes running on the system
traceroute Trace Route to Host
trap     Run a command when a signal is set(bourne)
tr       Translate, squeeze, and/or delete characters
true     Do nothing, successfully
tsort    Topological sort
tty      Print filename of terminal on stdin
type     Describe a command
 
ulimit   Limit user resources
umask    Users file creation mask
umount   Unmount a device
unalias  Remove an alias
uname    Print system information
unexpand Convert spaces to tabs
uniq     Uniquify files
units    Convert units from one scale to another
unset    Remove variable or function names
unshar   Unpack shell archive scripts
until    Execute commands (until error)
useradd  Create new user account
usermod  Modify user account
users    List users currently logged in
uuencode Encode a binary file 
uudecode Decode a file created by uuencode
 
v        Verbosely list directory contents (`ls -l -b')
vdir     Verbosely list directory contents (`ls -l -b')
vi       Text Editor
 
watch    Execute/display a program periodically
wc       Print byte, word, and line counts
whereis  Report all known instances of a command    
which    Locate a program file in the user's path. 
while    Execute commands
who      Print all usernames currently logged in
whoami   Print the current user id and name (`id -un')
Wget     Retrieve web pages or files via HTTP, HTTPS or FTP
 
xargs    Execute utility, passing constructed argument list(s)
yes      Print a string until interrupted
 
.        Run a command script in the current shell
###      Comment / Remark

MOVE CONCURRENT PROGRAM DEFINITION FROM ONE INSTACNE TO ANOTHER INSTANCE_complete

Valueset
=========

$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XXRS_CUST_PRICING_TYPE_NEW_VS.ldt VALUE_SET FLEX_VALUE_SET_NAME="XXRS_CUST_PRICING_TYPE_NEW"


Concurrent Program Definition
======================================

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXRS_WIP_PROD_TIME.ldt PROGRAM APPLICATION_SHORT_NAME="XXRS" CONCURRENT_PROGRAM_NAME="XXRS_WIP_PROD_TIME"


XXRSOE_CUST_PRICING

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXRSOE_CUST_PRICING.ldt PROGRAM APPLICATION_SHORT_NAME="ONT" CONCURRENT_PROGRAM_NAME="XXRSOE_CUST_PRICING"


Data Definition and Template Registration
======================================

FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD  $XDO_TOP/patch/115/import/xdotmpl.lct XXRS_WIP_PROD_TIME_DD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='XXRS' DATA_SOURCE_CODE='XXRS_WIP_PROD_TIME' TMPL_APP_SHORT_NAME='XXRS' TEMPLATE_CODE='XXRS_WIP_PROD_TIME'



DATA_TEMPLATE (Data Source .xml file)
=====================================

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=290098-vm4.testdb.rsne.com)(PORT=1528))(CONNECT_DATA=(SERVICE_NAME=UAT)))' -LOB_TYPE DATA_TEMPLATE -LOB_CODE XXRS_WIP_PROD_TIME -APPS_SHORT_NAME XXRS -LANGUAGE en -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $XXRS_WIP_PROD_TIME_D


RTF TEMPLATE (Report Layout .rtf file)
======================================

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=290098-vm4.testdb.rsne.com)(PORT=1528))(CONNECT_DATA=(SERVICE_NAME=UAT)))' -LOB_TYPE TEMPLATE -LOB_CODE XXRS_WIP_PROD_TIME -APPS_SHORT_NAME XXRS -LANGUAGE en -TERRITORY 00 -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $XXRS_WIP_PROD_TIME_DT



Bursting File
=============
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=290098-vm4.testdb.rsne.com)(PORT=1528))(CONNECT_DATA=(SERVICE_NAME=UAT)))" -LOB_TYPE BURSTING_FILE -APPS_SHORT_NAME XXRS  -LOB_CODE  XXRS_ASN_ERROR_RPT -LANGUAGE en  -XDO_FILE_TYPE XML-BURSTING-FILE -FILE_NAME XXRS_ASN_ERROR_RPT_BURST.xml -CUSTOM_MODE FORCE


===================
upload commands
===================

Valueset
=========
$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XXRS_CUST_PRICING_TYPE_NEW_VS.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE


Concurrent Program
===================

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXRS_WIP_PROD_TIME.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE




Data Definition and Template Registration
======================================

FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXRS_WIP_PROD_TIME_DD.ldt


DATA_TEMPLATE (Data Source .xml file)
=====================================

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=290098-vm4.testdb.rsne.com)(PORT=1528))(CONNECT_DATA=(SERVICE_NAME=UAT)))' -LOB_TYPE DATA_TEMPLATE -LOB_CODE XXRS_WIP_PROD_TIME -XDO_FILE_TYPE XML -FILE_NAME $DATA_FILE_PATH/$DATA_FILE_NAME.xml -APPS_SHORT_NAME XXRS -NLS_LANG en -TERRITORY US -LOG_FILE $LOG_FILE_NAME


RTF TEMPLATE (Report Layout .rtf file)
======================================

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=290098-vm4.testdb.rsne.com)(PORT=1525))(CONNECT_DATA=(SERVICE_NAME=DEV)))' -LOB_TYPE TEMPLATE -LOB_CODE XXRS_ASN_ERROR_RPT -XDO_FILE_TYPE RTF -FILE_NAME $XXRS_TOP/XXRS_ASN_ERROR_RPT_en_US.rtf -APPS_SHORT_NAME XXRS -NLS_LANG en -TERRITORY US -LOG_FILE $LOG_FILE_NAME



Bursting File
=============

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION  "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=290098-vm4.testdb.rsne.com)(PORT=1525))(CONNECT_DATA=(SERVICE_NAME=DEV)))"  -LOB_TYPE BURSTING_FILE -APPS_SHORT_NAME XXRS  -LOB_CODE  XXRS_ASN_ERROR_RPT -LANGUAGE en  -XDO_FILE_TYPE XML-BURSTING-FILE -FILE_NAME XXRS_ASN_ERROR_RPT.xml -CUSTOM_MODE FORCE


MOVE CONCURRENT PROGRAM DEFINITION FROM ONE INSTACNE TO ANOTHER INSTANCE

MOVE CONCURRENT PROGRAM DEFINITION FROM ONE INSTACNE TO ANOTHER INSTANCE
========================================================================
àConnect to PUTTY
àLOGIN WITH THE CREADENTIALS
àRUN THE COMMAND   "ps -ef|grep inh" FOR PATHS
àset the environment by the above paths(/us1001/DEV/apps/apps_st/appl)
àrun the evinronment command (". APPSDEV_phl3dsjpmtdb01.env")
àThen run the command “sqlplus” for connectiong to DB with username & password

àCREATE ONE DIRECTORY IN THE SPECIFIC PATH(Optional) for all files in ONE FOLDER EASY TO DOWN LOAD AND MOVE THE FILES

àFIRST RUN THE BELOW COMMAND FOR CONCURRENT PROGRAM DEFINITION


FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct JMORDERINTERFACE_FND.ldt PROGRAM APPLICATION_SHORT_NAME="JM" CONCURRENT_PROGRAM_NAME="JMORDERINTERFACE_FND"

EXPLANATION
apps/apps—DB username and password
JMORDERINTERFACE_FND.ldt—FOR CREATING A FILE
JM-- APPLICATION_SHORT_NAME
JMORDERINTERFACE_FND--CONCURRENT_PROGRAM_NAME

àThen we need to run the below command for DATA DEFINITION & TEMPLATE CODE DEFINITION

FNDLOAD apps/apps O Y DOWNLOAD  $XDO_TOP/patch/115/import/xdotmpl.lct JMORDERINTERFACE_FND_DD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='JM' DATA_SOURCE_CODE='JMORDERINTERFACE_FND' TMPL_APP_SHORT_NAME='JM' TEMPLATE_CODE='JMORDERINTERFACE_FND'

EXPLANATION
apps/apps—DB username and password
JMORDERINTERFACE_FND_DD.ldt—FOR CREATING A FILE IN THE SPECIFIC FOLDER.
JM-- APPLICATION_SHORT_NAME
JMORDERINTERFACE_FND-- DATA_SOURCE_CODE(data definition code)
JMORDERINTERFACE_FND—Template code

àNext, We need to run the below command for getting the RTF TEMPLATE FILE FROM THE APPLICATION and creating that file in specific folder.

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=phl3dsjpmtdb01.jacmel.com)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=DEV)))' -LOB_TYPE TEMPLATE -LOB_CODE JMORDERINTERFACE_FND -APPS_SHORT_NAME JM -LANGUAGE en -TERRITORY US -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $JMORDERINTERFACE_FND_DT

EXPLANATION
JDBC_CONNECTION—need to give the TNS NAMES
JMORDERINTERFACE_FND—LOB_CODE(LOB code from XML Publisher Responsibility)
JM-Application short name
En—laguage in template
US—territory

àThen we need to run the below command for getting BURSTING CONTROL FILE FROM APPLICATION to specific folder.

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=phl3dsjpmtdb01.jacmel.com)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=DEV)))" -LOB_TYPE BURSTING_FILE -APPS_SHORT_NAME JM  -LOB_CODE  JMORDERINTERFACE_FND -LANGUAGE en  -XDO_FILE_TYPE XML-BURSTING-FILE -FILE_NAME burst_JMORDERINTERFACE_FND.xml -CUSTOM_MODE FORCE

àall files got created in specific folder which you create first

àthen download the folder using SSH OR WINSCP to local machine

àNow connect to WINSCP with the destination Instance which you want to move the concurrent def

àmove the downloaded folder file to the new instance then follow the steps..

àConnect to PUTTY

àLOGIN WITH THE CREADENTIALS

àRUN THE COMMAND   "ps -ef|grep inh" FOR PATHS

àset the environment by the above paths(/us1001/DEV/apps/apps_st/appl)

àrun the evinronment command (". APPSDEV_phl3dsjpmtdb01.env")

àThen run the command “sqlplus” for connectiong to DB with username &
 password

àCREATE ONE DIRECTORY IN THE SPECIFIC PATH(Optional) for all files in ONE FOLDER EASY TO DOWN LOAD AND MOVE THE FILES

àThen we need to upload the downloaded files and concurrent prog Definition.

àRun the below command for uploading the CONCURRENT PROGRAM DEFINITION

FNDLOAD apps/j27d1wnf 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct JMORDERINTERFACE_FND.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

àRun the below command for UPLOADING THE DATA DEFINITION & TEMPLATE DEFINITION

FNDLOAD apps/j27d1wnf O Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct JMORDERINTERFACE_FND_DD.ldt

àRun the below command for UPLOADING THE RTF TEMPLATE FILE

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD j27d1wnf -JDBC_CONNECTION "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=phl3dsjpmtdb01.jacmel.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST)))" -LOB_TYPE TEMPLATE -LOB_CODE JMORDERINTERFACE_FND -XDO_FILE_TYPE RTF -FILE_NAME $JMINTRFACEORDER TEMPLATE_SOURCE_JM_JMORDERINTERFACE_FND_en_US.rtf -APPS_SHORT_NAME JM -NLS_LANG en -TERRITORY US -LOG_FILE $JMORDERINTERFACE_FND_LOG

àRun the below command for UPLOADING THE BURSTING CONTROL FILE

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD j27d1wnf -JDBC_CONNECTION  "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=phl3dsjpmtdb01.jacmel.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST)))"  -LOB_TYPE BURSTING_FILE -APPS_SHORT_NAME JM  -LOB_CODE  JMORDERINTERFACE_FND -LANGUAGE en  -XDO_FILE_TYPE XML-BURSTING-FILE -FILE_NAME BURSTING_FILE_JM_JMORDERINTERFACE_FND.xml -CUSTOM_MODE FORCE


àDONE FOR THE PROCESS  NEEDS TO CHECK WHEATHER ALL THE CONCURRENT PROGRAM DEFINITIONS , RTF FILES, BURSTING CONTROL FILES.

Thursday, November 2, 2017

MOVE CONCURRENT PROG DEF FROM ONCE INSTANCE TO ANOTHER INSTANCE

Valueset
=========

$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XXRS_CUST_PRICING_TYPE_NEW_VS.ldt VALUE_SET FLEX_VALUE_SET_NAME="XXRS_CUST_PRICING_TYPE_NEW"


Concurrent Program Definition
======================================

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXRS_WIP_PROD_TIME.ldt PROGRAM APPLICATION_SHORT_NAME="XXRS" CONCURRENT_PROGRAM_NAME="XXRS_WIP_PROD_TIME"


XXRSOE_CUST_PRICING

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXRSOE_CUST_PRICING.ldt PROGRAM APPLICATION_SHORT_NAME="ONT" CONCURRENT_PROGRAM_NAME="XXRSOE_CUST_PRICING"


Data Definition and Template Registration
======================================

FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD  $XDO_TOP/patch/115/import/xdotmpl.lct XXRS_WIP_PROD_TIME_DD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='XXRS' DATA_SOURCE_CODE='XXRS_WIP_PROD_TIME' TMPL_APP_SHORT_NAME='XXRS' TEMPLATE_CODE='XXRS_WIP_PROD_TIME'



DATA_TEMPLATE (Data Source .xml file)
=====================================

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=290098-vm4.testdb.rsne.com)(PORT=1528))(CONNECT_DATA=(SERVICE_NAME=UAT)))' -LOB_TYPE DATA_TEMPLATE -LOB_CODE XXRS_WIP_PROD_TIME -APPS_SHORT_NAME XXRS -LANGUAGE en -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $XXRS_WIP_PROD_TIME_D


RTF TEMPLATE (Report Layout .rtf file)
======================================

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=290098-vm4.testdb.rsne.com)(PORT=1528))(CONNECT_DATA=(SERVICE_NAME=UAT)))' -LOB_TYPE TEMPLATE -LOB_CODE XXRS_WIP_PROD_TIME -APPS_SHORT_NAME XXRS -LANGUAGE en -TERRITORY 00 -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $XXRS_WIP_PROD_TIME_DT



Bursting File
=============
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=290098-vm4.testdb.rsne.com)(PORT=1528))(CONNECT_DATA=(SERVICE_NAME=UAT)))" -LOB_TYPE BURSTING_FILE -APPS_SHORT_NAME XXRS  -LOB_CODE  XXRS_ASN_ERROR_RPT -LANGUAGE en  -XDO_FILE_TYPE XML-BURSTING-FILE -FILE_NAME XXRS_ASN_ERROR_RPT_BURST.xml -CUSTOM_MODE FORCE


===================
upload commands
===================

Valueset
=========
$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XXRS_CUST_PRICING_TYPE_NEW_VS.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE


Concurrent Program
===================

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXRS_WIP_PROD_TIME.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE




Data Definition and Template Registration
======================================

FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXRS_WIP_PROD_TIME_DD.ldt


DATA_TEMPLATE (Data Source .xml file)
=====================================

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=290098-vm4.testdb.rsne.com)(PORT=1528))(CONNECT_DATA=(SERVICE_NAME=UAT)))' -LOB_TYPE DATA_TEMPLATE -LOB_CODE XXRS_WIP_PROD_TIME -XDO_FILE_TYPE XML -FILE_NAME $DATA_FILE_PATH/$DATA_FILE_NAME.xml -APPS_SHORT_NAME XXRS -NLS_LANG en -TERRITORY US -LOG_FILE $LOG_FILE_NAME


RTF TEMPLATE (Report Layout .rtf file)
======================================

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=290098-vm4.testdb.rsne.com)(PORT=1525))(CONNECT_DATA=(SERVICE_NAME=DEV)))' -LOB_TYPE TEMPLATE -LOB_CODE XXRS_ASN_ERROR_RPT -XDO_FILE_TYPE RTF -FILE_NAME $XXRS_TOP/XXRS_ASN_ERROR_RPT_en_US.rtf -APPS_SHORT_NAME XXRS -NLS_LANG en -TERRITORY US -LOG_FILE $LOG_FILE_NAME



Bursting File
=============

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION  "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=290098-vm4.testdb.rsne.com)(PORT=1525))(CONNECT_DATA=(SERVICE_NAME=DEV)))"  -LOB_TYPE BURSTING_FILE -APPS_SHORT_NAME XXRS  -LOB_CODE  XXRS_ASN_ERROR_RPT -LANGUAGE en  -XDO_FILE_TYPE XML-BURSTING-FILE -FILE_NAME XXRS_ASN_ERROR_RPT.xml -CUSTOM_MODE FORCE


Table level Data flow for Order to Cash Flow (Oracle Apps)

In this blog I have highlight some of the KEY tables involved in Order to Cash table. There are lot of database table involves in this flow , but I have highlighted the key table and link between these tables.It help you while desiging the reports &queries. These tables are
OE_ORDER_HEADERS_ALL                  OE_ORDER_LINES_ALL 
WSH_DELIVERY_DETAILS                    WSH_DELIVERY_ASSIGNMENTS
WSH_NEW-DELIVERIES                         WSH_DELIVERY_LEGS
WSH_TRIP_STOPS                                   WSH_TRIPS
M TL_TRX_REQUEST_LINES                MTL_MATERIAL_TRANSACTION_TEMP
OE_SETS                                                     OE_LINE_SETS                     
PO_LINES_ALL                                         MTL_RESERVATIONS
MTL_MATERIAL_TRANSACTIONS_ALL
Data Flow Diagram
    In case you need sql Queries , please feel free to contact me.


    Oracle Fusion - Cost Lines and Expenditure Item link in Projects

    SELECT   ccd.transaction_id,ex.expenditure_item_id,cacat.serial_number FROM fusion.CST_INV_TRANSACTIONS cit,   fusion.cst_cost_distribution_...