Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Enabling Folder – 9 Steps

Posted on August 21st, 2007 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

In oracle Applications' GUI includes unique features to enhance the productivity of Oracle's application users. Folder is one the features, that enhance the feature for high productivity.

What is Folder..

As per documentation is say .."A folder is a special kind of window that allows users to customize the set of fields and records displayed for a particular business entity without programming. Using the folder customization menu or tool palette, users can specify the records and the fields they wish to see, as well as field sequence, field prompts, and field display widths. Users can customize folders at any time, saving them for personal use or sharing them with others."

The most common use of folder technology is in the gateway to a key applications entity. Users can customize the folder window to display the set of fields and records that are most relevant to the business at hand. From the folder window, users can perform an action involving one or more of the returned records. Or, they can select a single record, open a detail window that shows all the fields for that record, and perform an action involving that record.

Here are the 9 steps to enable folders in custom forms.

These Changes will make sure that folder can be saved and its query criteria are also saved.

1. Pick up Template.fmb from your $AU_TOP/resource directory on server where forms are residing.

2. Check out all the libraries get loaded successfully along with the Template.

3. Check for APPDAYPK.pll loaded fine, else copy it from APPSTAND.fmb

4. Attach APPFLDR library/pll

APPFLDR can be found in $AU_TOP/Resource directory on server where forms are residing.

5. Copy the STANDARD_FOLDER Object Group

STANDARD_FOLDER Object group can be referenced from APPSTAND form which resides in $AU_TOP/Resource. This will also copies the dependent objects required for object group.

This will copy Folder Related Blocks,Canvases and other necessary objects.

6. Let us say we have One Main block, Not concerned with Control Blocks
Main Block:

XXPH_RCPT_HIS then

Create <BLOCKNAME>_RECORD_COUNT parameter
as XXPH_RCPT_HIS_ RECORD_COUNT parameter
where BLOCKNAME is the name of the block containing columns to be displayed. Data Type should be Number and Put default Value of 2.

Canvas
You need two canvas- one content and one stacked. Let us name content canvas as XXPH_RCPT_HIS_CONTENT and stacked canvas as XXPH_RCPT_HIS_STACKED. Both the canvas have same window.

Windows
Create One Window. Name it XXPH_RCPT_HIS_WIN with view name as XXPH_RCPT_HIS_WIN

Blocks
Main Block:
XXPH_RCPT_HIS contains database columns. Items should be on Stacked canvas (XXPH_RCPT_HIS_STACKED).

7. Create following eight triggers:

WHEN-NEW-BLOCK-INSTANCE
app_folder.event('WHEN-NEW-BLOCK-INSTANCE');

KEY-PREV-ITEM
if (:parameter.XXPH_rcpt_his_record_count = 1) then
previous_item;
else
app_folder.event('KEY-PREV-ITEM');
end if;

KEY-NEXT-ITEM
if (:parameter.xxph_rcpt_his_record_count = 1) then
next_item;
else
app_folder.event('KEY-NEXT-ITEM');
end if;

PRE-BLOCK
app_folder.event('PRE-BLOCK');

POST-BLOCK
app_folder.event('POST-BLOCK');

PRE-QUERY
app_folder.event('PRE-QUERY');

KEY-EXEQRY
app_folder.event('KEY-EXEQRY');

POST-QUERY
app_folder.event('POST-QUERY');

8. PROMPT Block:

Create new block XXPH_RCPT_HIS_PROMPT: which will contain prompts for the column displayed in upper block.

Make subclass information as DYNAMIC_PROMPT.

This block should contain:

Items which will be Prompts for above block columns (Item name should be same as Column name in above block). Prompt Items should be on Stacked canvas (XXPH_RCPT_HIS_STACKED).

Create new Items specified below:
Item Name: FOLDER_OPEN, Item Type: Button, Canvas: XXPH_RCPT_HIS_CONTENT,Subclass:Dynamic_Title
Item Name: FOLDER_DUMMY, Item Type: Text Item , Canvas: TOOLBAR ,Subclass:Folder_Dummy
Item Name: FOLDER_TITLE, Item Type: Display Item, Canvas: XXPH_RCPT_HIS_CONTENT,Subclass:Dynamic_Title

Item Name: ORDER_BY1, Item Type: Button, Canvas: XXPH_RCPT_HIS_STACKED
Item Name: ORDER_BY2, Item Type: Button, Canvas: XXPH_RCPT_HIS_STACKED
Item Name: ORDER_BY3, Item Type: Button, Canvas: XXPH_RCPT_HIS_STACKED
Item Name:Folder_Switcher, Item Type:Text,Canvas: XXPH_RCPT_HIS_CONTENT,Subclass:SWITCHER

Check out your Both Canvases for setting these new buttons,prompts.

9. Form Level Triggers

FOLDER_ACTION
--
-- Remove the message and uncomment the line after it to activate the folder actions
--
-- message('You must modify the FOLDER_ACTION trigger in your form!');
app_folder.event(:global.folder_action);

WHEN-NEW-FORM-INSTANCE
app_folder.define_folder_block(' XXPORCHUK ', -- 'Object Name'
' XXPH_RCPT_HIS ', -- 'folder_block',
' XXPH_RCPT_HIS_PROMPT ', -- 'prompt_block',
'XXPH_RCPT_HIS_STACKED', --'stacked_canvas',
'XXPH_RCPT_HIS_WIN', --'window',
NULL); --'disabled functions');

Related Posts

Posted in AOL | 14 Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
14 Responses
  1. Ravi Says:

    Hi,

    I tried the same but it dodn’t work. Could you please send me the form you have tried. May be I can change the database source for the block and try it.I appreciate any help

  2. Anand Chaturvedi Says:

    Please email me the custom form where you have enabled custom folder.

  3. Sanjit Anand Says:

    I did sometime back in one of the project , and these are the steps which was required to enabled.Unfortunatly, I donot have same form,if you need let me know, i will do and will share to you.

  4. Anand Chaturvedi Says:

    Sanjit,

    Please send me the sample form for reference.

    Regards,
    Anand

  5. Mahesh Says:

    Sanjit,
    We are also trying to implement the folder option in one of our custom form.
    It will be great if you can please send me the copy of the form you have customized to enable folder option?
    Any kind of direction would be fhelpful

    My mail id is: joismj@yahoo.com

  6. Top 18 EBS UI : Provides all users with a highly productive interface Says:

    […] Folders for screen layout in which you can change Prompts, Field Orders, Size etc. Refer this post […]

  7. Ganapathy Says:

    Hi,
    How to create new folder in Oracle Apps.Requesting u give me a suggetion ASAP.

    With Regards,
    Ganapathy M

  8. good Says:

    I test the steps you metioned,but I got the following error when compile the fmb file.

    identifier ‘APP_FOLDER.EVENT’ must be declared

    It seem the complier can not recognized the APP_FOLDER.EVENT, but I have attached the APPFLDR library/pll.

    It is really wired.

  9. Sanjit Anand Says:

    As mention in step 1, 2 you should take a note on these base objects which you use for starting

    1) The folder objects
    ———————–
    Every folder form must contain the folder objects (such as the windows that are used for saving folders and changing prompts) included in the
    STANDARD_FOLDER object group. If this object group does not already exist

    In the form, copy it from APPSTAND ($FND_TOP/resource/APPSTAND.fmb)

    2) Next is folder library
    —————————
    Every folder form must have the library APPFLDR.pll attached. The library file is $FND_TOP/resource/APPFLDR.pll.

    3) then the content canvas
    —————————
    Create a content canvas, as you would for any window. Assign it the property class CANVAS, and cavas type Content and assign it to the appropriate window. This canvas will
    hold the block scrollbar, the record indicator, and the folder_open
    and folder_title objects.

    ANd then proceeed with rest of steps as discussed above.

  10. Reza Says:

    My folder works fine expect when I resize the window. Resizing the window causes tghe vertical scroll bar to disappear. The horizontal scroll bar resizes OK. Do you know what the problem might be?

  11. Amarnath Says:

    Hi,
    I need to add a field to existing folder, what are the modifications that are required please suggest.

  12. ashok Says:

    Hi Sanjit,

    I have tried these steps and is not working. can you please send to me the custom form which you have used.

  13. shaik Says:

    Hi
    Can we implement the folder option on control blocks in a custom form [not a database block], is it possible

  14. Aiyaz Says:

    Please its urgent need. Kindly send me a detail document for creating folder forms in oracle apps for a custom form. Screen shot explanation will be highly appreciated. Thanks in advance.

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.