This discussion is archived
1 Reply Latest reply: Oct 11, 2012 4:25 AM by JohnvanderKooij RSS

Error during build record.

Soundappan Journeyer
Currently Being Moderated
Hi Team,
I received the belwo error, When I try to build a record via application designer.
any help on this is highly appreciated.


PT version: 8.52.09
Application: HCM 9.1

==============
SQL Build process began on 10/10/2012 at 2:02:45 PM for database HR91DEV.
File: E:\pt85209c-retail\peopletools\src\psbld\bldcreat.cppSQL error. Stmt #: 2196 Error Position: 7 Return: 904 - ORA-00904: : invalid identifier
Failed SQL stmt:SELECT DBMS_METADATA.GET_DDL('INDEX',:1) from dual
Error: AMC_CMPRT_CMPNY - SQL Error. Error Position: 7 Return: 904 - ORA-00904: : invalid identifier

CREATE TABLE PS_AMC_CMPRT_CMPNY (COMP_RATECD VARCHAR2(6) NOT NULL, EFFDT DATE, COMPANY VARCHAR2(3) NOT NULL) TABLESPACE PSDEFAULT STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PCTUSED 80

SQL Build process ended on 10/10/2012 at 2:03:02 PM.
1 records processed, 1 errors, 0 warnings.
===================


Thanks
Soundappan
  • 1. Re: Error during build record.
    JohnvanderKooij Explorer
    Currently Being Moderated
    Looks like an error on getting the Index DDL from the database. Reading up on Nicolas Gasparotto's blog (http://gasparotto.blogspot.co.uk/2011/03/peopletools-851-on-tables-build.html), it looks like AppDesigner shouldn't be doing that.

    What does your build script look like? And how does your Index DDL syntax look like in AppDesigner?

    Maybe Nicolas can tell us more.

Legend

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