What are the default parameters we will get to shell script while running from the concurrent program.

Below are the Default parameters we will get to shell script file while running through concurrent program


$0 - Shellscript name 

$1 - Oracle Data Base username/password 

$2 - User_id 

$3 - Oracle Applications username 

$4 - Concurrent request id 
Also from $5, $6 ..... will be the shell script arguments.

How to find inivisible characters available in table column value?

Below is the Query for finding the ASCII values which is available in the field

select dump(counted_by) from XX_MAS_CYCLE_COUNT_ENTRIES_TBL

How to Delete Bursting file from Data Definations in XML Publisher

How to Delete Bursting file from Data Definations in XML Publisher:

DELETE
FROM XDO_LOBS
WHERE LOB_CODE=<DATA_DEFINITION_CODE>
AND LOB_TYPE='BURSTING_FILE';