April 14, 2015

Consult the OPP service log for details.

For XML reports with layout or Cross tab type template errors will encounter with Complete/warning with Error Msg Consult the OPP service log for details.

Need to Check log file for error:
The path is
/u01/DZWD(service SID)/inst/apps/DZWD_jvezdap1/logs/appl/conc/log/filename.txt

To find the file Path  use the query



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 = 20918150(&concurrent program request_id)
;

Mostly the error will come when the template code given differs.
Note:Concurrent program short name and data definition short name should be the same and template code can differ from concurrent program short name.

No comments:

Post a Comment

Thanks for your comments submitted.,will review and Post soon! by admin.

COALESCE-SQL

Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...