How to Enable attachment link in the form

How to Enable attachment link in the form:

Doc ID: 369215.1

0.
Register your custom table with minimum Primary key column mandatory.

----------------------------Registering Table optional--------------------------------

declare

p_appl_short_name varchar2(20) :='FND';

            p_tab_name varchar2(240):= 'XX_CUSTOM_TABLE';

            p_tab_type   varchar2(2) :='T';

            p_next_extent number := 512;

            p_pct_free     number :=  10;

            p_pct_used     number := 70;

begin

ad_dd.register_table

           (p_appl_short_name ,

            p_tab_name         ,

            p_tab_type        ,

            p_next_extent    ,

            p_pct_free    ,

            p_pct_used );

end;

 -----------------------------------------------------------------------------

--------------------------Registering Column optional-----------------------------

 declare

           p_appl_short_name VARCHAR2(20) := 'FND';

            p_tab_name      varCHar2(20):= 'XX_CUSTOM_TABLE';

            p_col_name     varCHar2(20) := 'XX_COLUMN1';

            p_col_seq      number := 1;

            p_col_type     varCHar2(20) := 'VARCHAR2';

            p_col_width    number := 20;

            p_nullable     varCHar2(20) := 'N';

            p_translate    varCHar2(20) := 'Y';

            p_precision    varCHar2(20) := '';

            p_scale       varCHar2(20) := '';

            begin

ad_dd.register_column

           (p_appl_short_name  ,

            p_tab_name       ,

            p_col_name    ,

            p_col_seq      ,

            p_col_type    ,

            p_col_width    ,

            p_nullable    ,

            p_translate   ,

            p_precision    ,

            p_scale    );

            end;

---------------------------------------------------------------------------

go to > Application Developer>Attachments>

1.

Entity Id/Entity name/Prompt: give meaningful which wil be appeared viewed by the end user.

2.

3.

4.

5.

6.

7.

Known Issues:

1. Error: FRM-40815:  Variable Global.A7_1_PK1 does not exist.

Solution: give Primary key correctly with block.column as in point 5.

2. if the link not appars then add this code before data block when_new_block_instance trigger.

 add When_new_block_instance trigger and put the  APP_STANDARD.EVENT('WHEN-NEW-BLOCK-INSTANCE'); 

Testing:

1.

2.

Click the attachment link

Give Meaningful Title, Description.

If ‘File’ selected it wil direct to oaf page others will be entered down.

Select File and click submit.

Go to the form, click yes as below.

Click Open document to view the same.