E1: FORMEXTNS: Cannot Add Column, Column Not Available, ADD Icon Missing When DD Item Contains Special Character $,@,# (Doc ID 2739395.1)

Last updated on SEPTEMBER 29, 2022

Applies to:

Symptoms

In Form Extension Manager when DD Item contains one of the 3 allowed special characters (#,$,@), the following issues are observed :

 • ADD icon is missing on column based on DD Item containing (#,$,@) character
 • Expected remaining columns are missing after column based on DD Item containing ($,@) character
 • When Table have columns based on DD Item containing ($,@) character, click ADD icon on column based on DD Item not containing ($,@) character, nothing happens. Cannot add column.

Applications with above symptoms : P03B11Z1, P051121, P0911, P3002, P40296.

STEPS TO REPRODUCE :

1. DD Item containing # character

P0911 Work With Journal Entries

1. Click Form Extension  icon.
    Name: P0911_W0911I
    Business View: V0911C2, Table: F0911
2. Select Grid radio button.
3. Scroll to row "Registration Number [F0911.REG#]". ADD  icon is missing.
    
4. Databrowser F98711, find F0911, sort on DD Item, columns after REG# match same in Form Extension Manager.
     

2. DD Item containing $ character

P051121 Work with Time Entry by Individual

1. Click Form Extension  icon.
    Name: P051121_W051121A
    Business View: V06116C, Table: F06116
2. Select Grid radio button.
3. Scroll to last row "Security Indicator [F06116.SEC$]". ADD  icon is missing.
4. Expected remaining columns are missing after [F06116.SEC$].
5. Click ADD  icon on column [F06116.SAMT], nothing happens, cannot add column to the grid.
    
6. Databrowser F98711, find F06116, sort on DD Item, columns after SEC$ are missing in Form Extension Manager.
    

3. DD Item containing @ character

P40296 Work With Flexible Sales Accounts

1. Click Form Extension icon.
    Name P40296_W40296A
    Business View: V4096A, Table: F4096
2. Select Grid radio button.
3. Only 1 row is displayed. Hover "Record Type - CC/SUB/SBL Flex Format [F4096.@RT]". ADD icon  is missing.
4. Expected remaining columns are missing.
   
5. Databrowser F98711, find F4096, sort on DD Item, columns after @RT are missing in Form Extension Manager.
       

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.