I have problem to execute steps of ALM BI Process from Batch Processing framework.
I could run step 1 (Hierarchy Flattening) using SQL Plus/PLSQL Function Name: rev_batchHierFlatten Parameters: batch_run_id, mis_date, pDimensionId, pHierarchyId function rev_batchHierFlatten(batch_run_id varchar2, mis_date varchar2, pDimensionId varchar2, pHierarchyId varchar2,
and the output table REV_HIER_FLATTENED was loaded.
But when I executed this step from Batch Processing framework, the process finished succesfully but the output table REV_HIER_FLATTENED wasn't loaded.
Can anyone help me?
Thank you in advance.
Note: the Iccserver, Router, AM, Messageserver services are running on the application server.