4 Replies Latest reply: Jan 21, 2013 6:44 AM by 976414 RSS

    ORACLE error 20001 in FDPSTP

    976414
      Hi
      In select statement i used view TPC_ORDER_REPORT_V

      Previously report runs without error,
      but i have changed view i.e. removed one column from this view , and when try to run it gives following error

      **Starts**17-JAN-2013 13:25:06
      ORACLE error 20001 in FDPSTP

      Cause: FDPSTP failed due to ORA-20001:
      ORA-06512: at "APPS.APP_EXCEPTION", line 72
      ORA-06512: at "APPS.TPC_ORDER_REPORTS_PKG", line 715
      ORA-06512: at line 1
      .

      The SQL statement being executed at the time of the error was: S






      Can anyone help me to resolve it

      Thanks,
      Sunil

      Edited by: 973411 on Jan 16, 2013 10:44 PM

      Edited by: 973411 on Jan 16, 2013 10:45 PM
        • 1. Re: ORACLE error 20001 in FDPSTP
          Srini VEERAVALLI
          Make sure that you remove the column object from rpd physical layer also. The selected columns should match with columns objects.
          • 2. Re: ORACLE error 20001 in FDPSTP
            Kishore Rout
            Hi,
            Can you execute below query from apps user and paste the output here.

            select * from dba_objects where status='INVALID' and object_name='TPC_ORDER_REPORTS_PKG';

            Regards,
            Kishore
            • 3. Re: ORACLE error 20001 in FDPSTP
              976414
              Hi Kishore,

              I have executed your query

              select * from dba_objects where status='INVALID' and object_name='TPC_ORDER_REPORTS_PKG';


              Result : Blank record

              Means not any row fetch. I have checked executing following query.

              select * from dba_objects where status='VALID' and object_name='TPC_ORDER_REPORTS_PKG';

              result:

              OWNER     OBJECT_NAME     SUBOBJECT_NAME     OBJECT_ID     DATA_OBJECT_ID     OBJECT_TYPE     CREATED     LAST_DDL_TIME     TIMESTAMP     STATUS     TEMPORARY     GENERATED     SECONDARY

              APPS     TPC_ORDER_REPORTS_PKG          571808          PACKAGE     1/13/2011 8:53:20 PM     1/7/2013 6:10:40 AM     2013-01-07:06:10:40     VALID N     N N
              APPS     TPC_ORDER_REPORTS_PKG          571811          PACKAGE BODY     1/13/2011 9:18:15 PM     1/15/2013 8:02:03 PM     2013-01-15:20:02:03     VALID     N     N     N

              Hence I sure package is valid .......

              Edited by: 973411 on Jan 21, 2013 4:05 AM

              Edited by: 973411 on Jan 21, 2013 4:06 AM
              • 4. Re: ORACLE error 20001 in FDPSTP
                976414
                Hi Srini,
                Can u tell me how to remove the column object from rpd physical layer.

                Edited by: 973411 on Jan 21, 2013 4:44 AM