title: Cause: FDPSTP failed due to ORA-06550: line 1, column 7:PLS-00221: is not a procedure or is undefined
body: <p>I'm trying to run a concurrent request in APPS but i keep getting this error </p>
  
  <pre><code>(Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
  PLS-00221: 'XXINV_ITEM_ORACLE_E5B0' is not a procedure or is undefined
  ORA-06550: line 1, column 7:  
  PL/SQL: Statement ignored)
  </code></pre>
  
  <p>and heres my package body its just a simple insert.</p>
  
  <pre><code>CREATE OR REPLACE PACKAGE BODY  APPS.XXINV_ITEM_ORACLE_E5B0 IS
  PROCEDURE  inv_com_proc (
        o_chr_errbuf     OUT      VARCHAR2,
        o_num_retcode    OUT      NUMBER
    )
  AS
    begin
    EXECUTE IMMEDIATE 'TRUNCATE TABLE  XXINV.XXINV_ITEM_ORACLE_E5B0';
    Insert into XXINV.XXINV_ITEM_ORACLE_E5B0(ORGANIZATION_CODE ,
    ITEM_NUM, 
    ON_HAND_QUANTITY ,
    ITEM_TYPE ,
    STATUS ,
    MATERIAL_COST ,
    MATERIAL_OVERHEAD_COST,
    RESOURCE_COST,
    OVERHEAD_COST,
    OUTSIDE_PROCESSING_COST,
    SUBINVENTORY_CODE ,
    LOCATORS )
    select OWNING_ORG_CODE, ITEM_NUMBER, ON_HAND_QUANTITY, ITEM_TYPE, STATUS, MATERIAL_COST ,
    MATERIAL_OVERHEAD_COST,
    RESOURCE_COST,
    OVERHEAD_COST,
    OUTSIDE_PROCESSING_COST,
    SUBINVENTORY_CODE ,
    LOCATOR
    from apps.XXRPT_INV_VALUATION_D535_V
    where apps.XXRPT_INV_VALUATION_D535_V.SUBINVENTORY_CODE = 'FG' AND apps.XXRPT_INV_VALUATION_D535_V.STATUS = 'ONHAND';
    COMMIT;
    END;
  
  end XXINV_ITEM_ORACLE_E5B0;
  </code></pre>