Monday 12 August 2013

Oracle App Using Flash Message in Forms Personalization

Oracle App Using Flash Message in Forms Personalization
Responsibility: Application Developer
Navigation: Application > Messages
Create new message
Name: XX_TEST
Current Text Message: This is a test message for &USER_NAME
Save and close form.

Generate the message
Responsibility: Application Developer
Click on View > Requests in the menu to execute a concurrent program. Select Generate Messages program.


Click on Help > Diagnostics > Custom Code > Personalize
Create a new Personalization


Click on Actions
Sequence 10
Type: Builtin
Description: Retrieve the msg
Builtin Type: Execute a procedure
Argument: FND_MESSAGE.SET_NAME(‘XXCUST’, ‘XX_TEST’)


Sequence 11
Type: Builtin
Description: Set the USER token
Builtin Type: Execute a Procedure
Argument: fnd_message.set_token (‘USERNAME’, fnd_profile.value(‘USERNAME’))
Sequence 12
Type: Builtin
Description: Set the ORG token
Builtin Type: Execute a Procedure
Argument: fnd_message.set_token (‘ORG_ID’, fnd_profile.value(‘ORG_ID’))
Sequence 13
Type: Message
Description: Display the msg
Message Type: Show
Message Text: =FND_MESSAGE.GET





Thursday 8 August 2013

FNDLOAD Utility continued....

Upload The concurrent request to destination instance:-

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt

- WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

Store the downloaded LDT file in the below mentioned destination path:-

/home/steelappl


Download the data definition and template:-

FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD  $XDO_TOP/patch/115/import/xdotmpl.lct

XX_CUSTOM_DD_XML.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='KROSS'

DATA_SOURCE_CODE='ZZ_BSDR_NEW' TMPL_APP_SHORT_NAME='KROSS'

TEMPLATE_CODE='ZZ_BSDR_NEW'

Store the downloaded LDT file in the below mentioned destination path:-
/home/steelappl

Upload the data definition and template:-

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

XX_CUSTOM_DD_XML.ldt

Upload the rtf file :-

Store the downloaded xsl and rtf file in the below mentioned destination path:-

/home/steelappl

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.228)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=STEEL)))' -LOB_TYPE TEMPLATE -LOB_CODE ZZ_BSDR_NEW -XDO_FILE_TYPE RTF -FILE_NAME /home/steelappl/ZZ_BSDR_NEW.rtf -APPS_SHORT_NAME KROSS -NLS_LANG en -TERRITORY IN -LOG_FILE $LOG_FILE_NAME

Note:- Source and Destination instance should be same in structure.

Wednesday 7 August 2013

FND_LOAD Script for Download Concurrent Request And RTF File

(1) Down Load Concurrent Request Through FND_LOAD Scripts:-

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt PROGRAM APPLICATION_SHORT_NAME="XYZ" CONCURRENT_PROGRAM_NAME="BANK STATEMENT DETAIL XML REPORT"

(2) Down Load RTF file Through FND_LOAD Scripts:-

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.228)(PORT=1571))(CONNECT_DATA=(SERVICE_NAME=TEST)))' -LOB_TYPE TEMPLATE -LOB_CODE ZZ_BSDR_NEW -APPS_SHORT_NAME XYZ -LANGUAGE en -TERRITORY IN -lct_FILE  $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $LOG_FILE_NAME


Down Load Path:-
/home/appltest
For (1) The LDT File named- XX_CUSTOM_CP.ldt
For (2) The RTF File.