Oracle Application Servers Track

Insync 2011 Call for Presenters now on..

Monday, April 18th, 2011 by

Hi All,

It’s that time again… The Insync 2011 Conference is on in Sydney the 16th & 17th August 2011 at the Convention Centre.

The Call for papers is now open you have 2 weeks to complete and submit your abstract for this year’s event submissions close the 3rd of May 2011,

This years Event is bigger and better and will include the following streams:
  Oracle E-Business Suite
  Oracle JD Edwards EnterpriseOne
  Oracle JD Edwards World
  Oracle PeopleSoft Enterprise
  Oracle Enterprise Performance Management & Business Intelligence 
  Primavera Enterprise Project Portfolio Management
  Oracle Fusion Middleware & Development
  Oracle Database & Technology
  Oracle Fusion Applications
  Mobile Computing for Oracle Business solutions
  Best Practices for Oracle Business Solutions

If you would be interested in presenting on a topic you feel would benefit the Oracle Community please head to and follow the links to register and submit your abstract.

If you are not interested in presenting and would like to attend there are early bird specials for registering currently head to Insync website to find out more today.

This is one event you don’t want to miss!

Happy Easter Everybody, I hope the easter bunny is kind :)

Add Folder Tool to Custom or Standard Form (EBS)

Thursday, January 14th, 2010 by

Add Folder tool in custom or Standard form

In this example I am using a custom form to add Folder tool.

1.       Attach APPFLDR.pll (remove path)

2.       Check out APPDAYPK.pll is attached else copy it from APPSTAND.fmb

3.       Open APPSTAND.fmb (resides in $AU_TOP/Resource). Drag and drop from Object Group of APPSTAND.fmb Standard Folder group to your Object Groups. On popup click button Subclass (you may also copy it but it’s not recommended). It will copy new blocks, canvases and other necessary object to your form.

4.       First save your form, close it, and then close standard_object form.

5.       Create parameter BLOCK_NAME_record_count. Say your main block is LINES then you need to create Parameter named LINES_RECORD_COUNT. Datatype number. This block contains columns to be displayed in folder tool.

6.       You need 2 canvases. Create one content canvas (i.e. LINES_CONTENT) and inside of this add another stacked canvas (i.e. LINES_STACKED). Both canvases of course must have the same window.

7.       Main block:

a.       Items of main block should be on stacked canvas

b.      Should have item called CURRENT_RECORD_INDICATOR, subclass: current_record_indicator, Canvas: LINES_CONTENT. The name of this item is important to be exactly typed otherwise folder tool do not act properly when the window is resized.

c.       Should have an item called folder_switch subclass switcher, Visible:No.

d.      Block Properties: subclass: Block, Scrollbar: yes, Canvas: LINES_CONTENT, Orientation:vertical. (optionally Scroll Bar Width: 0.2)

e.      Items that will be displayed on the folder canvas should have the same location X / Y + .25 which is the height of the Prompt field, plus have to be visible and have the name of Canvas Stacked

f.        Main Block Triggers




if (:parameter.LINES_record_count = 1) then




end if;


if (:parameter.LINES_record_count = 1) then




end if;











FOLDER_RETURN_ACTION (Create user named trigger with this name)

/* here you can manage item properties

i.e. queriable property off*/

IF (:global.folder_action = ‘SHOW-FIELD’ ) THEN


name_in(’global.folder_field’),Queryable, PROPERTY_OFF);



a.       Properties

i.      Subclass: Block

        ii.      Show Scroll Bar: No

b.      Items

        i.       ORDER_BY1         Clase: Folder_OrderBy

NO Visible Canvas: LINES_STACKED

        ii.       ORDER_BY2         Clase: Folder_OrderBY

NO Visible Canvas: LINES_STACKED

        iii.      ORDER_BY3         Clase: Folder_OrderBY

NO Visible Canvas: LINES_STACKED

        iv.      FOLDER_OPEN       Clase: Folder_Open

Visible:Yes Canvas: LINES_CONTENT

        v.      FOLDER_TITLE      Clase: Dinamic_Title

Visible:Yes Canvas: LINES_CONTENT

        vi.      FOLDER_DUMMY      Class: Folder_Dummy

Visible:Yes Canvas: Toolbar

9.       Prompt Items

   a.       You must have the same field name of the Block FOLDER (LINES) and must appear in the same order they are sorted in this.

        i.       Class: Folder_Prompt_Multirow

        ii.       Initial value: Prompt you want to have the field.

        iii.       Visible: YES / NO depending on the case if the field appears as visible or not in the folder.

        iv.      Canvas: Stacked canvas (LINES_STACKED)

        v.      Position X / Y: Everyone should have the same location.

10.   Form Level Triggers        a.       FOLDER_ACTION


        b.      WHEN-NEW-FORM-INSTANCE

app_folder.define_folder_block(’ XXPETLINES12345′, — ‘Object Name unique in all applicatios’

‘ LINES’, — ‘folder_block’,

‘ LINES_PROMPT’, — ‘prompt_block’,

‘LINES_STACKED’, –’stacked_canvas’,

‘PETLINES’   –’window’


       c.       WHEN-WINDOW_RESIZED

if :system.event_window in (’PETLINES’) then


end if;

That’s all.

White Paper Feedback

Monday, August 10th, 2009 by

Hi All,

I wanted to write this post to open up any feedback based on our White Papers.

If you have recieved a White Paper from us in the last few months please feel free to post your comments onto this past so we can share with the network and Authors accordingly.

I look forward to your comments and feedback.


Bec :)

White Paper Competition Winners

Thursday, June 18th, 2009 by

Hi All,

With good news we would like to announce the top 10 papers for the Quarter 1 White Paper Competition for 2009.
The papers this year were all very diverse and well written. Our in house Guru Jim Crum help me come to the final conclusion after our directors had assisted me in reading over all the entries.

Papers were weighted on the following;

1.Widest interest for the topic among client readership 20%
2.Best coverage of the topic 30%
3.Best writing and presentation 30%
4.Most valuable to the interests of Contractors Network 20%

I am very please to announce our top 3 as follows;

1.AME The Solution to Real World Approval Problems - A guide for functional implementers to configure and use AME with iProcurement, AR, and other modules in eBusiness Suite R12 - Dean Christofolis

Well Done Dean, I know you had entered our previous competition in 2007 so well done on another great paper!!!

2.Release 12 Ledgers - Melanie Cameron
3.MDM Best Practices - Bob Barnett

Also Congratulations Bob & Melanie for great papers. Melanie this has been our first year of working together and your papers have been very well received by our Clients & Consultants globally. Bob well done again, Bob also entered our 2007 competition.

We can not forget the rest of our top 10:

4.R12 Subledger Accounting - Melanie Cameron
5.Building an Employee Registration Process in Oracle User Management Using OA Framework, AME and Workflow (3 part series) Kuren Dhand
6.Implementing your Pricing Policy within standard Oracle Applications Functionality Aidan Duffy
7.Payment plans for Oracle Receivables Stuart Micdiarmid
8.Oracle Applications 11i Output in Excel Robin Bremer
9.The Single Euro Payment Area (SEPA) - Jose Luis Herrera
10.Loading Data from Microsoft Excel Spreadsheet software into Oracle Matt Canning

A big Thank you to all the Authors who entered the competition. We appreciate the time and effort it has taken to produce these documents. I will be touching base with you all shortly to finalise the details.

Get ready for the next competition :) Bec

White Paper Competition - Entries Due Tuesday 31st of March

Thursday, March 19th, 2009 by

Hi Everyone,

I Just wanted to remind you allour White Paper Competition Entries will need to be in no later than the31st of March 2009 (just under 2 weeks away)…

Prize fundincludes;

1st Prize $4000 USD
2nd Prize $2000 USD
3rd Prize $1000 USD
10 x Runner Up $300 USD

Subjects are open acrossthe E-Business Suite, Oracle Databases, Oracle Development Tools, Oracle SOA Suite, Oracle Fusion Middleware.

This is a great opportunity topromote yourexpertise to aglobal audience.

If you have not already please emailme for a template

Lipitor Buy Zithromax Buy Butalbital Buy Xanax Buy Zovirax Buy Lorazepam Soma Buy Tenuate Buy Line Xanax Buy Paxil Xanax Online Hydrocodone Ultram Buy Flexeril Percocet Lortab Generic Viagra Zyban Buy Adipex Ultram Diazepam Buy Zithromax Viagra Buy Biaxin Buy Hydrocodone Online Buy Valium Buy Percocet Buy Generic Viagra Hydrocodone Buy Meridia Buy Prozac Valium Online Buy Soma Buy Didrex Xanax Online Buy Nexium Didrex Adderall Lorazepam Online Xanax Effexor Buy Bontril Valium Online Alprazolam Buy Bupropion Buy Adderall Buy Cipro Buy Tramadol Buy Vicodin Buy Ephedrine Nexium Buy Meridia Biaxin Acyclovir Codeine Buy Bontril Zovirax Butalbital Ativan Xanax Online Buy Lexapro Buy Zyban Buy Valium Buy Prozac Buy Lortab Cheap Phentermine Buy Zovirax Buy Seroquel Tramadol Online Generic Viagra Propecia Zithromax Buy Prozac Nexium Buy Xanax On Line Buy Flexeril Alprazolam Lexapro Buy Ambien Buy Zyprexa Buy Xanax