Friday, September 14, 2007

Few Useful threads

Here is the list of few useful of the many threads replied by me on OA forums:

1)Dynamic tool tip in classic table
http://forums.oracle.com/forums/thread.jspa?messageID=2056047&#2056047

2)Putting a different color message in OA Framework page for instrtuction text etc:
http://forums.oracle.com/forums/thread.jspa?messageID=1966417&#1966417

3)How to make the cursor as "Busy" (i.e. HOURGLASS) and not like the usual "ARROW"..., when ur doing lot of tasks on an event
http://forums.oracle.com/forums/thread.jspa?messageID=1940174&#1940174

4)Delete Personilization:
http://forums.oracle.com/forums/thread.jspa?messageID=1959670&#1959670

5)Putting error message stack on OA page:
http://forums.oracle.com/forums/thread.jspa?messageID=1890435&#1890435

6)Make some rows' some columns read only in a table:
http://forums.oracle.com/forums/thread.jspa?messageID=1813973&#1813973

7)Not able to find server.xml
http://forums.oracle.com/forums/thread.jspa?messageID=1787572&#1787572

8)Runtime VO
http://forums.oracle.com/forums/thread.jspa?messageID=1886728&#1886728

9)Using alerts in OA Framework Page
http://forums.oracle.com/forums/thread.jspa?messageID=2067435&#2067435

10)Showing pl/sql exceptions in java(Also, see this thread if ur facing previous message stack retaining probling while using OAExceptionUtils class)
http://forums.oracle.com/forums/thread.jspa?threadID=598831&start=0&tstart=0

11)Dynamic CSS class generation in a OAF Page
http://forums.oracle.com/forums/thread.jspa?threadID=598398&tstart=15

http://forums.oracle.com/forums/thread.jspa?threadID=605557&start=15&tstart=0

12)

6 comments:

Unknown said...

Thanks for the links !!
Just came across couple of postings in oracle forum.I am new to OAF and having problem.Could you please advice on this
I have a page displaying some transaction details and is called from another page .As needed i need to change the source of the query in VO of my page.Implying my entire VO query changes.
As i had read somewhere that AM extension are not adviced.And the AM for this page was a root AM used across 3 other pages.So if i went ahead with VO extension, problem arises when this page is called from some other page.The AM of page has an append query adding where condition to the previous table coulms which are not there in new query.So what should be the approach,As the page layout design has to remain same

Mukul Gupta said...

Priyanka,
Here are my responses:
As i had read somewhere that AM extension are not adviced.
>> This is not true, AM extension only fails in AM is root AM.

problem arises when this page is called from some other page.The AM of page has an append query adding where condition to the previous table coulms which are not there in new query.So what should be the approach,As the page layout design has to remain same
>>As you said in the other page you just have to add few more where clauses in the VO query, you need to just add there initQuery method where conditions in VOimpl class of the VO and call this method in VOimpl class before executing query in AM.
--Mukul

Unknown said...

Thanks Mukul..But my problem still remains ..This extension involves changing the source of VO for an existing page(earlier table A now table B).From what i saw of the seeded code,for this VO there is an initQuery in the AM adding certain where conditions based on parameters received from url.And these 'where codnditions' are on the first table and some colums dont exist with the new source.So if i extend the VO how do i change the method in AM.As the AM for this page is a root AM.So is a VO extension the solution,in that case i need to change the controller code where this AM method is invoked??
or i was reading couple of ur posts in forum where u mentioned nested AM .
--Priyanka

Mukul Gupta said...

Priyanka,
Since, your AM is the root AM, you have two choices:
1)Make a nested AM:

What is nested AM?
Nested Am is nothing but the child AM of the root AM.

How it can be made?
Root AM is the AM at the pagelayout region. Nested Am can be any AM attached to any region under pagelayout region. So, just attach the AM class to any region under pagelayout region(it will become nested AM), and you can write ur custom methods in it.

2)Controller extension:
This although not recommeneded by Oracle, but used all over Apps community, because there are scenarios, where there no other alternative. Oracle, discourage this practice because in Fusion(ADF AND JSF) there will no controllers.But until Fusion(atleast next 4-5 years) you are safe for upgrades and as of now, nobody knows what path Oracle will follow in Fusion(JSF and ADF).

One more thing....

This extension involves changing the source of VO for an existing page(earlier table A now table B).
>>>If the parent VO was created in expert mode (meaning it uses handwritten SQL), only then the extended VO
will also be created in expert mode.(i mean only then you can change VO source table in extended Vo query, but select statement should include all attributes in the parent VO query.)

In your case Controller extension will be simple and straight forward. Just
I hope i am claer
--Mukul

Unknown said...

Hi Mukul,
Thanks !!..That would be helpful..
-Priyanka

shanti said...

HiPriyanka,

Did you come across this problem.If you are true with this, plz share ur knowledge with us.I am also facing similar problem.Here My problem is I am customizing/extending page by extending view object it means standard page should work with standard view object where as custom page should work with view object extension.I hope you are clear with my requirement.If anybody knows solution, plz let me know.

Shanti