How To Setup Cheque Writer (generic) with Template

1.  Set the Pay_Action_Parameters RUN_XDO and PRINT_FILE up properly. 

·         The parameter RUN_XDO (Run XML Publisher for Report Generation) should be set to the value of 'Y'  

Insert into pay_action_parameters
(PARAMETER_NAME, PARAMETER_VALUE)
values ('RUN_XDO', 'Y');
Commit ;

2         The parameter PRINT_FILES (Use concurrent request to print files) should be set to the value of 'Y'.

Insert into pay_action_parameters
(PARAMETER_NAME, PARAMETER_VALUE)
values ('PRINT_FILES', 'Y');
Commit;

3.  Go to the $FND_SECURE directory and capture the full path where the DBC file is located.

4.   Ensure that the Pay_Action_Parameter DBC_FILE (DBC file used to get JAVA connection) exist in the table and contains the value DBC Path file.

Insert into pay_action_parameters
(PARAMETER_NAME, PARAMETER_VALUE)
values ('DBC_FILE', 'XXXX');

commit;

here XXXX is the full path of DBC file including the filename ,  it should be something like /oracle/TEST/inst/apps/TEST_erpdemo/appl/fnd/12.0.0/secure/TEST.dbc

where TEST.DBC is the correct DBC file at your instance

·         Save the file and  Bounce the Apache and Concurrent Manager listeners.

The Below steps describes on how to Attach the Template to "Cheque Writer (generic)"

5.  Go to XML Publisher Administrator -> Templates -> Search for "Saudi Cheque Template" -> Download the RTF "PAYSACHQ_en.rtf"

6 Create New Data Definition and set the Code of the Data Definition as short name of the Request "Cheque Writer (Generic)" i.e. CHEQUE_WRITER_GEN

Data Definition : XXX_CHEQUE_WRITER_DD

Code: CHEQUE_WRITER_GEN

7 Create New Data Template and upload the RTF to the Data Template

Data Template:  XXX_CHEQUE_WRITER_DT 

Code: CHEQUE_WRITER_GEN

Application: PAYROLL

Data Definition : XXX_CHEQUE_WRITER_DD

Upload RTF: PAYSACHQ_en.rtf

8 Now, Test the Request