Workflow Queries to debug the Errors

Execute Below query to identify the errors why the workflow is struck 

SELECT

   workflowitemeo.item_type,

   workflowitemeo.item_key,

   workflowitemeo.begin_date,

   workflowitemeo.end_date,

   workflowitemtypeeo.display_name,

     ias.error_name error_name,

   ias.error_message error_message,

   ias.error_stack error_stack 

FROM

   wf_items workflowitemeo,

   wf_item_types_vl workflowitemtypeeo,

   wf_activities_vl activityeo,

   wf_item_activity_statuses ias 

WHERE

   ias.activity_status = 'ERROR' 

   AND ias.item_type = workflowitemeo.item_type 

   and workflowitemeo.item_type ='OEOL'

   AND ias.item_key = workflowitemeo.item_key 

   AND workflowitemeo.item_type = workflowitemtypeeo.name 

   AND activityeo.item_type = workflowitemeo.item_type 

   AND activityeo.name = workflowitemeo.root_activity 

   AND activityeo.version = workflowitemeo.root_activity_version 

 --  AND workflowitemeo.begin_date > SYSDATE - 1 

   AND workflowitemeo.item_type <> 'WFERROR'

 --  and workflowitemeo.item_key='485787'

 order by begin_date desc

FNDLOAD to download the FND attachments defined in application developer

•  FNDLOAD <uname>/<pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afattach.lct ABC.ldt FND_ATTACHMENT_FUNCTIONS FUNCTION_NAME="ARXTWMAI"

• FNDLOAD <uname>/<pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afattach.lct TTTTT.ldt FND_ATTACHMENT_FUNCTIONS FUNCTION_NAME="ARXTWMAI"

• FNDLOAD <uname>/<pwd> O Y DOWNLOAD $FND_TOP/patch/115/import/afattach.lct test1.ldt FND_ATTACHMENT_FUNCTIONS APPLICATION_SHORT_NAME="AR"

• FNDLOAD <uname>/<pwd> O Y DOWNLOAD $FND_TOP/patch/115/import/afattach.lct test6.ldt FND_ATTACHMENT_FUNCTIONS APPLICATION_SHORT_NAME="AR" FUNCTION_NAME="ARXTWMAI"  FND_DOCUMENT_ENTITIES ="RA_CUST_TRX" FND_ATTACHMENT_BLOCK_ENTITIES ="RA_CUST_TRX"

 How to direct the outputfile of the concurrent request to unix server path using XMLP Bursting  ORACLE APPS.

Step 1: In the DATA XML definition you need to define an element which contains the unix server path where you want to redirect the outputfile of the BI Publisher concurrent program output to .

Example: Define an element CF_PATH='/usr/tmp/kalyani'

Step 2: Define the Bursing control file as follows which contains the element CF_PATH.

In the below TESTFINV is the module name of the report or the main group, you need to find out the group from the data xml output from  Diagnostics->View XML of the BIP concurrent program.

<?xml version="1.0" encoding="ISO-8859-1" ?> 

<xapi:requestset type="bursting" xmlns:xapi="http://xmlns.oracle.com/oxp/xapi">

<xapi:request select="/TESTFINV/LIST_G_ORDER_BY/G_ORDER_BY">

<xapi:delivery>

<xapi:filesystem id="FILE_DELIVERY" output="${CF_PATH}"/>

</xapi:delivery>

<xapi:document output="${CF_PATH}" delivery="FILE_DELIVERY" output-type="pdf">

<xapi:template type="rtf" filter="" location="xdo://CAR.TESTFINV_NEW.en.US?getSource=true"/>

</xapi:document>

</xapi:request>

</xapi:requestset>