Workflow Important Tables

apps.WF_ITEM_TYPES
apps.WF_ITEM_ATTRIBUTES
APPS.WF_ACTIVITIES
apps.WF_ACTIVITY_ATTRIBUTES
apps.WF_MESSAGES
apps.WF_MESSAGE_ATTRIBUTES
apps.WF_NOTIFICATIONS
apps.WF_NOTIFICATION_ATTRIBUTES
apps.WF_ITEMS


SELECT STA.ITEM_TYPE                ITEM_TYPE
      ,  STA.ACTIVITY_RESULT_CODE     RESULT
      ,  PRA.PROCESS_NAME ||':'||
             PRA.INSTANCE_LABEL       PROCESS_ACTIVITY_LABEL
      ,  STA.PROCESS_ACTIVITY         INSTANCE_ID
      ,  STA.ITEM_KEY                 ITEM_KEY, STA.ACTIVITY_RESULT_CODE, STA.ERROR_MESSAGE, STA.ACTIVITY_STATUS, STA.BEGIN_DATE, STA.*
 FROM  apps.WF_ITEM_ACTIVITY_STATUSES  STA 
     , apps.WF_PROCESS_ACTIVITIES      PRA
 WHERE STA.ACTIVITY_STATUS     = 'ERROR'
   AND STA.PROCESS_ACTIVITY    = PRA.INSTANCE_ID
   AND STA.ITEM_TYPE           = 'DA_APP_5'--ITEM_TYPE_SELECTED
   --AND STA.PROCESS_ACTIVITY    = ERRANT_INSTANCE_ID

Comments

Post a Comment

Popular posts from this blog

API Procedure to inactive Items in oracle apps

--API to update the item status. /**** STEP 1) Insert data into pending interface table ****/ insert into mtl_pending_item_status           (inventory_item_id,           organization_id,           status_code,           effective_date,           implemented_date,           pending_flag,           last_update_date,           last_updated_by,           creation_date,           created_by)      values(          6760202,   -- Item Segment           114,   -- Organization Id           'Inactive',  -- status           sysdate,           sysdate,           'Y',           sysdate,           14654,           sysdate,           14654); /**** STEP 2) Call below API code to do the actual change ****/ declare  x_return_status VARCHAR2(100);  x_msg_count  NUMBER;  x_msg_data  VARCHAR2(1000); begin          inv_item_status_pub.Update_Pending_Status (                      p_api_version  => 1.0                     ,p_Org_Id   => 114  -- Organi
Read more

API To update Oracle Items

/* Formatted on 2018/04/23 12:05 (Formatter Plus v4.8.8) */ DECLARE    v_po_qty              NUMBER;    v_so_qty              NUMBER;    v_oh_qty              NUMBER;    b_has_backlog         BOOLEAN;    v_po_number           VARCHAR2 (40);    v_po_line_num         VARCHAR2 (40);    v_so_order_number     VARCHAR2 (40);    v_so_ine_number       VARCHAR2 (40);    v_subinventory_code   VARCHAR2 (40);    x_inventory_item_id   NUMBER;    x_organization_id     NUMBER;    x_return_status       VARCHAR2 (3000);    x_msg_count           NUMBER;    x_msg_data            VARCHAR2 (4000); BEGIN    DBMS_OUTPUT.put_line (   'Organization ID'                          || ','                          || 'Item Number'                          || ','                          || 'PO'                          || ','                          || 'SO'                          || ','                          || 'ONHAND
Read more

Graph Setting in Oracle Report Builder

<rw:graph id="CT_1" src="G_DATE" groups="PDATE" dataValues="CF_WT_AVG_EFFPerG_DATE"> <!-- <?xml version="1.0" ?> <Graph version="3.2.0.22" markerTooltipType="MTT_NONE" markerDisplayed="false" graphType="LINE_VERT_ABS"> <LegendArea visible="false"/> <MarkerText visible="true"> <GraphFont fontColor="#99"/> </MarkerText> <O1TickLabel tickLabelSkipMode="TLS_NOSKIP"/> <PlotArea borderColor="#0" borderTransparent="false"/> <SeriesItems> <Series id="0" color="#0"/> </SeriesItems> <Title text="Efficiency %" visible="true"> <GraphFont size="14" fontColor="#0" underline="true"/> </Title> <Y1Axis scaledLogarithmic="false" logarithmicBase="2.0" axisAut
Read more