1 Reply Latest reply: Oct 11, 2012 6:25 AM by John van der Kooij RSS

    Error during build record.

    Soundappan
      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.
          John van der Kooij
          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.