Useful Tricks while working on Enhancements

When we print data in excel format ,the leading zero values like '01' printed as 1

To avoid this bug use the below format in the source query.

'=('

  || CHR (34)

  || odl.item_code

  || CHR (34)

  || ')' item_code  

 Oracle Reports Concurrent Program completes with Warning With error "One or more post-processing actions failed. Consult the OPP service log for details."

---------------------------------------------

+------------- 1) PUBLISH -------------+
Beginning post-processing of request 3181343 on node FINAPPS at 25-OCT-2011 11:41:30.
Post-processing of request 3181343 failed at 25-OCT-2011 11:41:31 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.
+--------------------------------------+

...

The actual error returned by the XML Publisher Core engine is captured in the OPP log file.
One of the easiest way to obtain the OPP log file is to run the below script from the database by providing request_id.

SELECT fcpp.concurrent_request_id req_id, fcp.node_name, fcp.logfile_name
  FROM fnd_conc_pp_actions fcpp, fnd_concurrent_processes fcp
 WHERE fcpp.processor_id = fcp.concurrent_process_id
   AND fcpp.action_type = 6
   AND fcpp.concurrent_request_id = &request_id;

Simple ways to remove the Leading zeros from number

SELECT TRIM (LEADING 0 FROM 000123400) "example" from dual;

Format to send the in the Email from the PL/SQL code should start with below syntax.

'Content-Type: application/vnd.ms-excel; charset=3DWINDOWS-1251' || crlf ||

To change the fnd_standard_date datatype from concurrent program using below code which can be passed in plsql code.

 l_ship_date1 :=
           TO_DATE (fnd_date.canonical_to_date (p_ship_date_low), 'DD-MON-YY');