Compiling The Extra Person Information DFF - ORA-06512: at "SYSTEM.AD_DDL", line 2086 (Doc ID 1613028.1)

Last updated on DECEMBER 22, 2016

Applies to:

Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, People Management in LIVE instance.

The concurrent program 'Flexfield View Generator' errors out when attempting to create an EIT structure for 'Extra Person Information' with the following error.


ERROR
Oracle error 911: ORA-00911: invalid character
ORA-06512: at "SYSTEM.AD_DDL", line 2086
ORA-06512: at line 1 has been detected in afuddl() [6_xad].
do_array_ddl(APPLSYS, PER, 2, 1, 723, PER_PEOPLE_EXTRA_INFO1_DFV): private_do_array_ddl(APPS, APPLSYS, HR, 2, 1, 723, PER_PEOPLE_EXTRA_INFO1_DFV): do_array_c_view(0, APPS, PER_PEOPLE_EXTRA_INFO1_DFV, 1, 723): array_assign_and_execute(APPS, 1, 723, FALSE): : do_apps_array_ddl(APPS, 1, 723, FALSE): :
substr($statement$,1,255)='CREATE OR REPLACE VIEW PER_PEOPLE_EXTRA_INFO1_DFV
(ROW_ID, "TYPE", GRE, Province, Employment_Code, Language, Surrender_of_Credit_Card, Amount_Due_on_Credit_Card, Company_Car_Documents___Keys, Amount_Due_on_Company_Car, Co_Accomodation, Amount_Due_on_Co'

View Name: PER_PEOPLE_EXTRA_INFO1_DFV

Name                                                         Null?     Type
--------------------------------------------------- -------- ------------
VIEW_HAS_FAILED_CHECK_LOG_FILE                         CHAR(61)



STEPS
The issue can be reproduced at will with the following steps:
1. responsibility 'System Administrator'.

2. Navigate to Descriptive Flexfield > Segment

3. Select DFF 'Extra Person Information' and Context Code = 'XX_EMP_BANK_DETAILS'.
    The code is ENABLED.

4. The checkbox 'Freeze Flexfield Definition' was UNCHECKED.
    Clicked on 'Segments'.

5. Created segments.

6. After these segments were created, the flexfield was frozen.

7. The structure was compiled.

8. The below message was shown:
    The flexfield was compiled successfully.
    Submitted request to generate flexfield view
    PER_PEOPLE_EXTRA_INFO1_DEV.

9. Clicked OK.
    The form throws error:
    The descriptive flexfield "Extra Person Information" of
    application 'Human Resources' uses features which are only
    supported in Oracle Forms. This flexfield may not function
    in other environments such as OA Framework or PL/SQL APIs.

10. This screen shows that the concurrent program 'Flexfield View Generator' completed in error.
    

     The output shows the error message as below:
     Oracle error 911: ORA-00911: invalid character
     ORA-06512: at "SYSTEM.AD_DDL", line 2086
     ORA-06512: at line 1 has been detected in afuddl() [6_xad].
     do_array_ddl(APPLSYS, PER, 2, 1, 723, PER_PEOPLE_EXTRA_INFO1_DFV): private_do_array_ddl(APPS, APPLSYS, HR, 2, 1, 723, PER_PEOPLE_EXTRA_INFO1_DFV): do_array_c_view(0, APPS,
     PER_PEOPLE_EXTRA_INFO1_DFV, 1, 723): array_assign_and_execute(APPS, 1, 723, FALSE): : do_apps_array_ddl(APPS, 1, 723, FALSE): :
     substr($statement$,1,255)='CREATE OR REPLACE VIEW PER_PEOPLE_EXTRA_INFO1_DFV
     (ROW_ID, "TYPE", GRE, Province, Employment_Code, Language, Surrender_of_Credit_Card, Amount_Due_on_Credit_Card, Company_Car_Documents___Keys, Amount_Due_on_Company_Car, Co_Accomodation,
     Amount_Due_on_Co'

     View Name: PER_PEOPLE_EXTRA_INFO1_DFV

     Name                                                         Null?    Type
     --------------------------------------------------- -------- ------------
     VIEW_HAS_FAILED_CHECK_LOG_FILE                         CHAR(61)



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms