BI Publisher layout template is not attaching when submit a concurrent program using a PL/SQL packag

Hi All,

I am trying to submit a Concurrent Request via a PL/SQL Package, but xml layout is not attaching while generating the report output. The request was submitted and completed successfully but the report output was XML instead of Excel. But the same is working when I submit the request from oracle application. This functionality was working perfectly in EBS 12.0.6, but recently it was upgraded to 12.2.5. The issue started only after the upgrade.

I am using the following script to submit the report;

DECLARE

   l_responsibility_id   NUMBER;

   l_application_id      NUMBER;

   l_user_id             NUMBER;

   l_set_layout_option   BOOLEAN;