This discussion is archived
4 Replies Latest reply: Jan 21, 2013 4:44 AM by 976414 RSS

ORACLE error 20001 in FDPSTP

976414 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points