Skip to main content

Oracle Forms-How to Enable Attachment in Custom Form of Oracle Apps

How to Enable Attachment in Custom Form of Oracle Apps



Step to enable Attachment Option in Oracle Apps Custom Form:

 1)      Navigation: - Application Developer -> Attachment-> Document Entities


2)      Now enter the information as shown below and save the records.




3)      
a) Open ‘Attachment Functions’ Screen

b) Entered the following information as shown below.

c)Save the records

Navigation: - Application Developer -> Attachment-> Attachment Functions

               Note: - Name = Form name
 



4)        Click on ‘Categories’ and select ‘Miscellaneous’ from LOV and save the records.

 

5)      a) Open the’ Attachment Functions’ again and select the type as ‘Function’ and entered the corresponding function name of the Form (function name=name of the form in which attachment will be enable).

b)Save the records and click on ‘blocks’



 6) 

a) Now ‘Block declaration’ Screen will open.

b) Entered the following information as sown below.

c) Block Name=”Enter the name of the BLOCK”

d) Secured by= none

e) Context1= “Name of the column with block name”

f) Click on ‘Entities’ button


7) 
a) Now ‘Entity Declaration’ screen will be open.

b) Select the ‘Entity’ name that has been entered in ‘Document Entities’ Screen.

c) Privileges will be selected ‘Always’ as default.

d)Checked the ‘include in indicator’ Flag



8) 
Go to PRIMARY KEY FIELDS tab and entered the primary key fields as shown below. Now save the records.

Comments

Popular posts from this blog

Oracle Forms -- Important Syntaxes

1. To get the enabled property of the item APP_ITEM_PROPERTY.GET_PROPERTY('CONTROL.FILTER_HOLD_RECORDS',ENABLED) 2. Disable Attachment for this Block in WHEN-NEW-BLOCK-INSTANCE  APP_SPECIAL.ENABLE('ATTACHMENTS', PROPERTY_OFF); 3. Default Where / Default Order By Set_block_property('XWII_MATL_DISP_HOLDS_V', Default_where, Lc_query); Set_block_property('XWII_MATL_DISP_HOLDS_V', order_by, Lc_query); 4. Visual Attribute    a. Define Visual Attribute for eg 'XWII' where you can set Colour  b. SET_ITEM_INSTANCE_PROPERTY('block.item_name',CURRENT_RECORD,VISUAL_ATTRIBUTE ,'XWII'); 4. Visual Attribute for Record APP_RECORD.HIGHLIGHT('XWII'); Where 'XWII' is the visual attribute where you can set Colour. 5. Initiliaze SPECIAL Menu app_special.instantiate ('SPECIAL1', GET_GROUP_CHAR_CELL ('SPECIAL_MENU.SPECIAL_MENU_ITEM', 1), '', TRUE, ''); 6. execute_trigger('SPECIAL25...

Oracle Forms - Window Resize ( Changing window size upon minimizing and maximising)

-- Added by Qutub M for View SU Redesign Proj. (Notes) DECLARE ln_width_diff NUMBER; ln_item_width NUMBER; ln_canvas_width NUMBER; ln_view_width NUMBER; BEGIN IF :system.EVENT_WINDOW = 'FULL_NOTE_DISPLAY' THEN ln_width_diff := TO_NUMBER(GET_WINDOW_PROPERTY('FULL_NOTE_DISPLAY',width)) - :PARAMETER.FULL_NOTES_WIDTH; ln_item_width := TO_NUMBER(GET_ITEM_PROPERTY('FULL_NOTE_DISPLAY.FULL_NOTE',width)); ln_canvas_width := TO_NUMBER(GET_CANVAS_PROPERTY('FULL_NOTE_DISPLAY',width)); ln_view_width := TO_NUMBER(GET_VIEW_PROPERTY('FULL_NOTE_DISPLAY',width)); -- SET_VIEW_PROPERTY('FULL_NOTE_DISPLAY', X_POS, 0); SET_VIEW_PROPERTY('FULL_NOTE_DISPLAY', WIDTH, :parameter.view_width+ln_width_diff); SET_CANVAS_PROPERTY('FULL_NOTE_DISPLAY', WIDTH, :parameter.canvas_width+ln_width_diff);     SET_ITEM_PROPERTY('FULL_NOTE_DISPLAY.FULL_NOTE', width, :parameter.item_width+ln_width_diff);     --M...