Table for LEGAL ENTITY details in Oracle Apps R12

This summary is not available. Please click here to view the post.

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

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.

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. 

Subinventories are not listed in Sales Order Line

Set the profile option "INV: Allow Expense to Asset Transfer" and retest the issue

Create XML Publisher report without RDF in Oracle Apps

Create XML Publisher report without RDF in Oracle Apps.

 Create XML Publisher report without RDF

1.  Create Program "Go To Application Developer --> Concurrent -->Program "

 Once you create (XML Publisher report without RDF) the Data definition, please create the respective concurrent program for this report if one does not already exists. Make sure the execute for this concurrent program should XDODTEXE

 2. Create a Data Definition using XML Publisher Administration Responsibility As shown below.

3. Click on Create Data Definition button and the details (Make sure you enter the concurrent program short name in Code) and click on Apply button

 Go back to Data definition and add the Data Template file as shown below (attached sample template file for your reference , make necessary changes to template for your report

4 Create a Data Definition using XML Publisher Administration Responsibility --> TEMPLATES ''CREATE TEMPLATE"

5. Run the report

6. If you choose output type 

EAM parameter setup