Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

Contact Us

OA Framework - All Articles
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
 

Please find an article that explains the steps to modify LOV [list of values] by extending [not customization] of OA Framework.


As you would already know, LOV’s in OA Framework are driven by View Objects.
In D2K, if we wish to modify a query of an LOV, we could do so using CUSTOM.pll.

But there were limitations in CUSTOM.pll when it came to mapping new LOV columns to Screen fields.In this example, I will show you how something similar can be achieved without a single customization, by leveraging Extensions to View Objects using Jdeveloper[OA Framework].

There can be two variations to this requirement:-
a. Simply display a new field in LOV
b. Do the a) above plus map the new LOV field to existing field on main screen.
In this example, I will specify the steps for doing both a + bPlease note the following:-
1. This example below is a demonstration of steps, I haven’t implemented this specific example on any Production System. The idea is to get you started with doing extensions to view Objects OA Framework using jDeveloper.
2. I hope you have already read the article regarding extensions of EO, which was a real life iProcurement example for rebuilding charge accounts. The article for extending EO for iProc Account Generation can be accessed from this link 
3. This specific demonstration was prepared on 11.5.10 CU2 instance.


Following steps will be followed to extend VO:-
1. We create a new custom database view that has extra columns which we wish to display in LOV. Alternately you can embed your new SQL Statement too in extended VO. However I find usage of view beneficial, because in the event of bug fixes, codefix can be delivered without hopefully touching OA Framework.
2. Next we extend the VO, but prior to doing so, you need to FTP all relevant the files from $JAVA_TOP/oracle/apps/../..
Include those directories in your Project Classpath in jDev.
You will also need to open the respective server.xml file to see those objects.
3. Optionally you may also decide to FTP the XML MDS documents. These are in $XX_TOP/mds
4. Extend the view object
5. Deploy the extended files to $JAVA_TOP/oracle/apps/../..
6. Import the substitution definition using jpx
Note: The above 6 steps will add a new field to the VO, without actually customization of LOV VO
7. Personalize the LOV Region, by going to the LOV, and add a new region field using personalization[add new item]. Also using the personalization, define a mapping for the LOV field, so that its value gets copied to the desired field in main page.
Note: In order to do these personalization, you should have access to the MDS page, preferably in jdeveloper, so that you know exact names for those fields.
Modify View as below:-
CREATE OR REPLACE VIEW XXICX_PA_PROJECTS_EXPEND_V AS
SELECT ppev."PROJECT_ID"
,ppev."PROJECT_NUMBER"
,ppev."PROJECT_NAME"
,ppev."PROJECT_DESCRIPTION"
,ppev."START_DATE"
,ppev."COMPLETION_DATE"
,ppev."PROJECT_TYPE_CLASS_CODE"
,ppev."PROJECT_NUMBER_SORT_ORDER"
,ppev."PROJECT_TYPE"
,ppev."CARRYING_OUT_ORGANIZATION_ID"
,ppev."PROJECT_CURRENCY_CODE"
,ppev."ALLOW_CROSS_CHARGE_FLAG"
,ppev."PROJECT_RATE_DATE"
,ppev."PROJECT_RATE_TYPE"
,ppev."PROJECT_OU"
,ppev."EXPENDITURE_OU"
,ppev."PROJFUNC_CURRENCY_CODE"
,ppev."PROJFUNC_COST_RATE_DATE"
,ppev."PROJFUNC_COST_RATE_TYPE"
,lov.task_number AS xxicx_task_number
,lov.task_id AS xxicx_task_id
,xx_get_org_id_from_name(lov.org_name) AS xxicx_org_id
,lov.org_name AS xxicx_org_name
,lov.award_id AS xxicx_award_id
,lov.award_number AS xxicx_award_number
FROM xx_por_project_lov_v lov, pa_projects_expend_v ppev
WHERE lov.project_id = ppev.project_id

Identify the VO to be extended, and doubleclick to open it. This is to ensure that you have FTP’ed the necessary objects correctly.

Now, lets create a new VO, by right clicking on project

For this demo, I am creating the extension in Standard namespace, however when doing changes for real system, you must do so in a custom directory location.
Give this new VO a name xxicxProjectPALovVOEx

Also specify that it extends oracle.apps.icx.lov.server.ProjectPALovVO

Click next, and leave EO section blank here, as there is no Entity Object needed for this LOV.

Add the desired fields one by one. The existing columns from the VO being extended will already be listed here
Now, you can enter your new query

 

Important, note down the option to Generate java files for row level

Here is your Auto generated code [by jDeveloper]
You can see that the new VO class extends existing VO Class

Image

Now do substitutions in BC4J, right click on project

Select substitutions. On left pane you select the VO being substituted
and right hand pane the new VO

 

This would have create a .jpx file for you as below.

<?xml version="1.0" encoding='windows-1252'?>
<!DOCTYPE JboProject SYSTEM "jbo_03_01.dtd">
<JboProject
Name="xxIcxProjectLOVSubst"
SeparateXMLFiles="true"
PackageName="" >
<DesignTime>
<Attr Name="_version" Value="9.0.3.13.75" />
<Attr Name="_jprName" Value="xxIcxProjectLOVSubst.jpr" />
<Attr Name="_ejbPackage" Value="false" />
</DesignTime>
<Substitutes>
<Substitute OldName ="oracle.apps.icx.por.schema.server.PoRequisitionLineEO" NewName ="oracle.apps.icx.por.schema.server.xxicPoRequisitionLineEO" />
</Substitutes>
</JboProject>
Load the jpx file. For details see the article http://www.google.com/search?q=site:apps2fusion.com+iprocurement-11.5.10-rebuild-charge-account-4

Now, personalize the LOV region, by navigating to LOV, so that a new field item can be created for each new column added to extended View Object
A sample entry will look like below. Effectively, here you create a field in LOV and link that to new column in extended View Object.

Image

Next, you go to the main page, Lets say we wish to copy the LOV field Award Number to a field named Award Number in main screen.

For this, you can use personalization to define column mapping.

Also need to Copy the extended files to $JAVA_TOP/oracle/apps/…/lov/server
I recompile those on server to ensure that nothing special happened on my PC.
$javac xxicxProjectPALovVOExRowImpl.java
$javac ProjectPALovVORowImpl.java
$javac xxicxProjectPALovVOExImpl.java
Bounce the Apache


Anil Passi

Comments   

0 #1 balkrishna 2006-12-11 00:00
wat i have to read and practice to learn OA Framework because after one month i have to customize the sshr web pages using jdeveloper. i do not know java . i have to add tags and all the thigs nessacary to personilize the webpage


th anks

regards

balkrishna
Quote
0 #2 balkrishna 2006-12-11 00:00
wat i have to read and practice to learn OA Framework because after one month i have to customize the sshr web pages using jdeveloper. i do not know java . i have to add tags and all the thigs nessacary to personilize the webpage


th anks

regards

balkrishna
Quote
0 #3 Ronaldo Blanc Rocha 2006-12-18 00:00
Anil,

I´m trying to extends some VOs in a HRMS system, but got no lucky!

I do a hello world page to test the system, and it´s ok... but there are no extensions in it.
I need to extends some EOs and VOs... and I got only errors.

I´m new to OAF... can you help me??

thanx
Quote
0 #4 Anil Passi 2006-12-18 00:00
Hi Ronaldo,

Ple ase let us know the errors that you are getting.

Tha nks
Anil Passi
Quote
0 #5 Ronaldo Blanc Rocha 2006-12-18 00:00
Anil,

I´m trying to extends some VOs in a HRMS system, but got no lucky!

I do a hello world page to test the system, and it´s ok... but there are no extensions in it.
I need to extends some EOs and VOs... and I got only errors.

I´m new to OAF... can you help me??

thanx
Quote
0 #6 Anil Passi 2006-12-18 00:00
Hi Ronaldo,

Ple ase let us know the errors that you are getting.

Tha nks
Anil Passi
Quote
0 #7 Anil Passi 2006-12-21 00:00
Hi Rajesh,

$JAV A_TOP is included in CLASSPATH of Apps.

Hence you can create your custom directory in $JAVA_TOP and reference those files with your package names being directory names.


Tha nks,
Anil Passi
Quote
0 #8 Rajesh Khatri 2006-12-21 00:00
Hi Anil,

Thanks for maintaining this blog.

I had a requirement wherein I need to provide a HTML page to upload files to the server. I have created the JSP page and HTML page. I also need to place the new jar files required by the JSP page and also include those in the classpath.

C an you please tell me the steps involved in deploying the same in Oracle Apps.

regards,
R ajesh Khatri
Quote
0 #9 Anil Passi 2006-12-21 00:00
Hi Rajesh,

$JAV A_TOP is included in CLASSPATH of Apps.

Hence you can create your custom directory in $JAVA_TOP and reference those files with your package names being directory names.


Tha nks,
Anil Passi
Quote
0 #10 Rajesh Khatri 2006-12-21 00:00
Hi Anil,

Thanks for maintaining this blog.

I had a requirement wherein I need to provide a HTML page to upload files to the server. I have created the JSP page and HTML page. I also need to place the new jar files required by the JSP page and also include those in the classpath.

C an you please tell me the steps involved in deploying the same in Oracle Apps.

regards,
R ajesh Khatri
Quote
0 #11 Anil Passi 2007-01-04 00:00
Hi Kevin

That will certainly work. You might need to bounce the Apache after you have made changes to VO XML.

Note:- Changes done to VO query will not survive the Upgrade/Patches that re-deliver that VO.
Hence by Extending VO and Substituting, your customization will be upgrade safe.

Its your call as to the approach you wish to undertake.

T hanks,
Anil Passi
Quote
0 #12 Anil Passi 2007-01-04 00:00
Hi Kevin

That will certainly work. You might need to bounce the Apache after you have made changes to VO XML.

Note:- Changes done to VO query will not survive the Upgrade/Patches that re-deliver that VO.
Hence by Extending VO and Substituting, your customization will be upgrade safe.

Its your call as to the approach you wish to undertake.

T hanks,
Anil Passi
Quote
0 #13 Sergey Lomov 2007-01-09 00:00
In my previous message i mean parent VO package.
Quote
0 #14 Anil Passi 2007-01-09 00:00
.
.
.
Hi Kevin,

So you wish to hide or display a SubTab [i.e. a sub-menu] based on who the logged in person is?

Two options:-
1. Framework based...I am not sure how though. I think SPEL can work at item or region level but not sure about complete SubTab itself
2. customize fnd_menu_item_v l and based on fnd_global.empl oyee_id filter out the record entry for PerDiem menu item entry.

Optio n 2 :- might just be used for experimental purposes as a very last and final option, as it is not recomended to modify core objects in APPS.

Thanks
Anil Passi
Quote
0 #15 Sergey Lomov 2007-01-09 00:00
In my previous message i mean parent VO package.
Quote
0 #16 Anil Passi 2007-01-09 00:00
.
.
.
Hi Kevin,

So you wish to hide or display a SubTab [i.e. a sub-menu] based on who the logged in person is?

Two options:-
1. Framework based...I am not sure how though. I think SPEL can work at item or region level but not sure about complete SubTab itself
2. customize fnd_menu_item_v l and based on fnd_global.empl oyee_id filter out the record entry for PerDiem menu item entry.

Optio n 2 :- might just be used for experimental purposes as a very last and final option, as it is not recomended to modify core objects in APPS.

Thanks
Anil Passi
Quote
0 #17 M 2007-03-12 00:00
Hi Anil, So grateful for this comprehensive, one-and-only and extremely useful site of yours. I am new to Jdeveloper and have 3 main questions. I need to extend a VO in apps/per/irc/Ca ndidateSearch (show 2 more columns in search results). Please see my questions: 1.) For getting the original VO, should I FTP all files from oracle/apps/per/irc/Ca ndidateSearch/server? 2.) Which FTPed files should be put in jdevhome/myproj ect and which in jdevhome/myclas ses? 3.) Sometimes substitution does not work as my VO was in a Subtab page, for which I raised a TAR with Oracle; waiting for the update. But essentially, have I done it the right way if I FTPed the original files into myclasses as well as myprojects?
Quote
0 #18 Kiran 2007-03-22 00:00
Hi Anil,
I recently started working on JDeveloper.. In the first glance it looked tough and confusing.. Your site helped me alot to understand.
Ca n you please give some detailed Info on the MDS repository. I heard varied answers on this.. When and Why we use XML Importer/Export er. which XML files are actually moved into MDS database (JDR tables) and how personalization is effected.. I guess this is an important and difficult topic which everybody need thorough understanding for doing extensions/ customizations.
Thanks in advance,
K
Quote
0 #19 Anil Passi 2007-03-24 00:00
Hi K

Very good question. Infact inspired by your question I am currently writing something on very basics of MDS and OA Framework MDS Concept.

Con cepts are important, hence a very good point raised by you indeed.

Many Thanks
Anil
Quote
0 #20 Alex 2007-04-05 00:00
Hi!
Yes, VO substitution been loaded as /oracle/apps/ar /hz/components/ party/organizat ion/server/cust omizations/site /0/HzPuiOrgOver viewVO
Quote
0 #21 Alex 2007-04-05 00:00
And extended vo should be visible within bc4j section of About This Page. But then error occurs, extended vo not visible on about page...
Quote
0 #22 divya 2007-04-12 00:00
Hi, I have deployed my OA pages on to the server and bounced it.When I am running pages from apps ,some of the LOVs in my page are opening and fetching values but when I say wuick select they are not returning the values to my main page though I have given lov mapping correclty.The browser is continuously showing the status running when I say quick select.This problem didnot exist when I was testing my page through jdeveloper 10.1.3. Can you please tell me what could be the problem. Thanks in advance. Divya.
Quote
0 #23 Anil Passi 2007-04-14 00:00
Hi Divya

If this works on jDev, then it should work on Hosted instance too.

However , the difference is that in jDev, your MDS changes are locally stored on your PC as XML. Hence it is possible that column mappings are missing. Have you applied column mapping personalization s on hosted server?

Also , try bouncing the mid-tier.

If still no luck, then use Diagnostics to set the Debug level in fwk to statement and see at what stage it is getting stuck[start scrolling from bottom of fwk debug messages]

Th anks
Anil Passi
Quote
0 #24 Anil Passi 2007-04-17 00:00
Hi Divya

I am glad you fixed the issue, and am even more glad that you shared your experience to help others that may face same problem too.

Regards ,
Anil Passi
Quote
0 #25 divya 2007-04-17 00:00
Hi Anil,
Thank you for your response.I have tried bouncing the middle tier once but had the same problem.But I actually found out that the problem was with my local browser.I have tried opening the applications in mozilla as the browser opening from jdev also is mozilla and found that my oapages deployed were not having the lov problem , they were returning values to my main page.
Thanks again for your response.
Divy a
Quote
0 #26 souvik mukherjee 2007-04-20 00:00
HI anil
I have one small question.
Yhis is not related to OAF as such. In iSUpplier if the supplier wants to accept the order as it is then how can he proceed? Whenever I open up the PO, the tabs above have request changes/req cancellation/et c but no simple accept tab. Is it that the instance on which I am working has some customizations?

ANother thing that I noticed is this: I took a PO and created a ASN for it. I then tried to change the Po and gave different dates as promised dates. How is it that Oracle allowed me to change an order after I created the ASN?
another bug which I found out is this : There is no check when I split a order line and give different quantities to the qiantity, I can exceed the original ordered quantity.I mean Oracle does not sum up the line quantities to tally with the ordered quantity.
Kind ly let me know your views .
regards
Sou vik
Quote
0 #27 divya 2007-05-16 00:00
Hi Anil
I am having 2 pages one main page and one child page.The main page has a header region and a table region.in the table region for everyline there is a attribute rule id and there is a link for each line in the table which opens the child page.The child page has another table region which will be opened with the lines for the ruleid passed as parameter.In both the pages for the tables i have an addrows button which will add a row and later the entered values will be commited into the database.Now i have a cancel button in the child page which will take me back to the main page with retain Am as true.when I click cancel in child page after I delete a line in the page or simply do nothing in the page the pages are working fine.But once I say add row in the child page and commit values and come back to the main page the rule id for the lines in the table for anyline is always considered as the rule id that I updated.So whenever I click on the lines link the child page is opening with the same ruleid for which I have commited values.How do I reset this ruleid to take the current rows rule id in the main page.Thanks in advance.
Regar ds,
Divya.
Quote
0 #28 Michael 2007-07-04 13:55
Hi Anil

Thanks for the conference in Copenhagen the first of June; however I forgot to ask you a question which troubles me. How to make a VO based on an EO with having to select a stupid key, without getting transient attributes?

In many cases I would like to create a VO based on joins and not on a specific key, and then let the user update an attribute by inserting / updating the data.

Here is a simple example VO

SELECT pap.segment1
,pap.NAME
FROM pa_projects_all pap
WHERE pap.project_sta tus_code = 'APPROVED';

No ne of these attributes are keys, thus how can I base this VO on an EO?

PS This is just a very simplified VO and not the real code, but it illustrates the problem.
Quote
0 #29 Alex 2007-07-04 20:31
Hello and thanks for your articles ! Very useful !
You wrote about FTP'ing the XML MDS documents. Why uploading these files ? I thougth we stayed under JAVA_TOP directory.
Wher e do I have to put it ? Under myprojects\xx\m ds ?
Thanks !
Quote
0 #30 Anil Passi 2007-07-04 21:13
Hi Alex

In simple words, there are two type of XML Files in OAFwk
1. MDS
These are the page definitions UI related. These need to be loaded into the database by using a script or by using Functional Administrator Responsibility
You will find these xml files in jdevPackage/... /webui
2. BC4J xml files for AM, EO, VO
These need to be simply deployed to $JAVA_TOP/oracl e/apps/.../serv er..

Thanks
An il Passi
Quote
0 #31 Anil Passi 2007-07-06 21:27
Hi Michael [July 04, 2007],

Like most apps tables, PA_PROJECTS_ALL does not have a primary key.
When you create an EO, OA Fwk/jDeveloper creates a default Attribute for rowid and marks that as primary. This is required for BC4J to know the key used in modifying/delet ing/locking.

A nyhow, you should not create a new EO on PA_PROJECTS_ALL .
Do the below:-
1. See if oracle delivers a out of the box EO on PA_PROJECTS_ALL
2. If a standard EO does not exist, then you can create one on your own, however direct inserts are not allowed on pa_projects_all . Hence you need to create pl/sql based entity object, i.e. by extending OAPlsqlEntityIm pl. In the Insert/update etc methods of this EO, use the APIs like pa_project_pub. create_project or pa_project_pub. update_project

Thanks,
Anil Passi
Quote
0 #32 kingmed 2007-10-15 15:21
Hi,

How i can upload SSHR in local for extensible with Jdeveloper ?

Br
Quote
0 #33 Prasad CP 2007-11-14 15:01
Anil ,
in iprocuremnet i did spel of making justification mandatory if its is urgent req , since urgent flag is a string i added one new boolean attribue and made spel on this attribute .
but now i get an error like view not found in the AM , does it mean that i need to add the extended vo to the AM ?
Quote
0 #34 Ajit_nair1 2007-12-19 11:04
Hello,

I need a urgent help.

Actually I am trying to modify the exisiting Print Quote Document which is actually getting called from a template cald ASOPRINTQUOTE.x sl

This particular xsl uses HeaderVO, LinesVO and PromptVO and hence I had to modify these xml and in turn the .java files.

I customized it by adding the new columns thru JDeveloper and extending the VO's and substituting them

In the process while extending the respective VO's comes a step wherein I need to specify(Thru JDeveloper) Application Short Name and Responsibility Key.
Now the issue is this particular Quote dicument can be accessed from 2 different respons. called

Oracle HTML Order Quoting Sales Agent(Its a OA framework with application top as QOT)
& Quoting Sales Agent.(Its form based with Application top as ASO)

I chose ASO as the top as all my .class files and .xml files are present in
oracle/apps/as o/print/server

Now then after extending the VO's and importing it etc . when I log in thru the reponsibilty
Oracle HTML Order Quoting Sales Agent , it gets me a error of stmt exception.
wher as
it runs via the respon Quoting Sales Agent and reproduces a PDF output without any data??

There are few questions I am looking out for an answer desperately.


1) My HeaderVO, LinesVO and PromptVO are extended, so do i need to extend the links present in that in my new extended VO' s as well.

2) My xsl stylesheet has a statement as

select values of:....../Heade rVO/HeaderRow/. ...etc etc

do i need to replace the above line to my new extended VO i.e

select values of:....../CustH eaderVO/HeaderR ow/...etc etc

Kindly reply to me asap as I am in a development scenario..
Do let me kow if u need more clarity on this?

Regards,
Ajit
Quote
0 #35 kishore Ryali 2008-03-17 10:38
Hi Anil,
I was implementing all the OAF demos in ur site, on my way to get acquaintance with OAF.
I took Non-Catalog Request Page to display a new column "Supplier Num" in LOV and show the same value on the Non-Catalog Request Page. I did VO Extension and LOV Mapping and it all worked :) . But when I press "Clear All" button in the page, expect the new field all the other fields are getting cleared.

Do I need Controller extension to clear even my new field when "Clear All" is pressed?

Regar ds,
Kishore Ryali
Quote
0 #36 Vivek Sharma 2008-04-29 11:32
How can i restrict the LOV with category in iproc.
We need to customise the LOV returned for Category selection. Ie
restrict
the "Categories" that appear in the LOV.
Functional Navigation to this page - iProc Home Page-> non catalogue
request
> Category LOV
Quote
0 #37 div 2008-06-04 02:59
Hi Anil,

After extending vo,is there any nessicity to attach that extended vo to AM. How to refresh am.how exetnded vo will work for am.
if we want to display date and time how to display on pages.plz help me.in interview they asked me.

thanking u,
sri
Quote
0 #38 Anil Passi- 2008-06-04 03:37
Hi Sri

You do not need to attach the extended VO to AM, assuming that original VO is attached to that AM

Thanks
Anil
Quote
0 #39 AshwiniA 2008-06-09 09:47
Hi Anil

I have a scenario for I-procurement requisitions page to restrict it to a single requisition. The main table behind the View Object is PO_REQUISITION_ HEADERS.

I have created a custom view to restrict the View Object to a single requisition and created a synonym of the same, to reflect the custom view.

When I query the view object's query from backend it shows a single record as restricted. But when I try to run from the APPS end it still shows many requisitions.

I have got the apache bounced. Please advise me as what needs to be done.

Thanks
Ashwini.
Quote
0 #40 TaniaH 2008-08-05 21:50
This example was very helpful. Thanks.

I have a couple of questions:-
1) There are examples where Extended View is created as mycompany.oracl e.apps.icx.love .server where as you have created as oracle.apps.icx .love.server, which is the Best Practice?
2) I got a request to modify the $FND_TOP/mds/wf /worklist/webui /NotifDetailsPG
I have extended the oracle.apps.icx .por.wf.server. ReqLinesNotific ationsVO to include the extra data, I have followed all the steps above but got error "Page cannot be Displayed". Could you please help? The only modified files are below

ftped files to LINUX under $JAVA_TOP/mycom pany/oracle/app s/icx/por/wf/se rver
-rwxrwxrwx 1 oraread users 537 Aug 3 20:29 server.xml
-rwx rwxrwx 1 oraread users 6790 Aug 3 19:47 xxReqLinesNotif icationsVOExRow Impl.class
-rwx rwxrwx 1 oraread users 15934 Aug 3 20:25 xxReqLinesNotif icationsVOExRow Impl.java

Many thanks

TH
Quote
0 #41 Anil Passi 2008-08-06 01:58
Hi TH

In response to your questions:-
1. mycompany.oracl e.apps.icx.lov. server is the best practice.

2. You also need to FTP xxReqLinesNotif icationsVOEx.xm l

Thanks
Anil Passi
Quote
+1 #42 TaniaH 2008-08-06 17:04
Thanks Anil for the prompt response.
Yes I have ftped that too.
-rwxrwxrwx 1 oraread users 554 Aug 5 15:12 server.xml
-rwx rwxrwx 1 oraread users 6790 Aug 5 15:12 xxReqLinesNotif icationsVOExRow Impl.class
-rwx rwxrwx 1 oraread users 15934 Aug 5 15:12 xxReqLinesNotif icationsVOExRow Impl.java
-rwxr wxrwx 1 oraread users 17404 Aug 5 15:12 xxReqLinesNotif icationsVOEx.xm l

I have successfully imported:-
BEGI N
jdr_utils.listc ustomizations(' /oracle/apps/ic x/por/wf/server /ReqLinesNotifi cationsVO');
EN D;
/
---------- --------------- --------------- ---------
Outpu t:-
/oracle/app s/icx/por/wf/se rver/customizat ions/site/0/Req LinesNotificati onsVO
--------- --------------- --------------- ----------

BEG IN
jdr_utils.prin tdocument(p_doc ument => '/oracle/apps/i cx/por/wf/serve r/customization s/site/0/ReqLin esNotifications VO');
END;
/
-- --------------- --------------- --------------- --
Output:-




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

After bounche Apache

Go to "Open Notification" Error Found - Page Cann ot be displayed (after a very long loading time , more than 5 minutes)

Could you please help?
Quote
0 #43 TaniaH 2008-08-06 17:13
Re-try to add jdr_utils.print document output, did not load previously..... ....fingercross ed
But everything is as expected.
BEGIN
jdr_utils.print document('/oracle/apps/icx/por/wf/server/customizations/site/0/ReqLinesNotificationsVO');
END;
/
Quote
0 #44 Anil Passi 2008-08-06 18:11
Hi TH

For substitution to take effect, you need to bounce the entire mid tier, not just the Apache.
Alterna tely try clearing the global cache

Thanks
A nil Passi
Quote
0 #45 TaniaH 2008-08-06 22:11
Thanks Anil.
But after the DBA has bounced the whole mid-tier and also cleared the _pages directory.

I am still getting the same error - Page cannot be displayed.
How can I clear the global cache? Can I do this or only the DBA could?
Could you please help?

Many thanks
Quote
0 #46 Anil Passi 2008-08-07 01:39
Bouncing the entire mid-tier would have cleared the global cache anyway.
Please paste the entire error stack
Quote
0 #47 TaniaH 2008-08-07 16:41
Hi Anil,

Below is the content dump of the error page. Hope you could help.......... Many thanks.

http://rmlintst1.corp.resmed.org:8070/OA_HTML/OA.jsp?_rc=WF_SS_NOTIF_PAGE&_ri=0&OAHP=WF_SELF_SERVICE_APPLICATION&OASF=WF_SS_NOTIFICATIONS&_ti=174617357&language_code=US&CallFromForm='Y'&oapc=5&oas=zE6o0f41z2Xa27J4nqoJLw..

Network Access Message: The page cannot be displayed

Explanation: The request timed out before the page could be retrieved.

Try the following:
Refresh page: Search for the page again by clicking the Refresh button. The timeout may have occurred due to Internet congestion.
Check spelling: Check that you typed the Web page address correctly. The address may have been mistyped.
Access from a link: If there is a link to the page you are looking for, try accessing the page from that link.
Contact website: You may want to contact the website administrator to make sure the Web page still exists. You can do this by using the e-mail address or phone number listed on the website home page.
If you are still unable to view the requested page, try contacting your administrator or Helpdesk.

Technical Information (for support personnel)
Error Code 64: Host not available
Background: The gateway or proxy server lost connection to the Web server.
Date: 8/7/2008 8:36:24 PM [GMT]
Server: au3isa02.corp.r esmed.org
Source: Remote server

Quote
0 #48 oadeveloper 2008-12-02 05:04
Hi Anil,
I need to add a new line for Projects LOV in different responsibilitie s. In example on Internet Expenses.
I use Apps R12.
Then I'm trying to extend Project LOV to show 1 more lines/option (Project Type) than the default (Project Number, Project Name, Project Start Date, Project End Date, Organization Name)...
I think I've done it correctly. I've extended oracle.apps.ap. oie.server.Proj ectsLovVO into xxProjectsLOV and after that executed jpximport.bat sucessfully)
Bu t .. after bounce Apache... no new rows appear in the LOV... As I could read here.. it would be necessary to add a new column thorugh Personalization .. to be able to see the new column... (It would be necessary to query by Project Type ... and see the project type in the result table...) BUT on this page [/oracle/apps/a p/oie/webui/OIE PROJECTLOV] there's no link to Personalize anything.. then.. How to extend a LOV here an d add a new row?
Thanks.
Quote
0 #49 oadeveloper 2008-12-15 14:52
Hi friends,
[Apps R12]
Im tryingto do something similar, I've extended the Projects Lov (ProjectPALovVO ) to retrieve the TaskId and TaskNumber of the selected project.
[I don't understand one thing on this ANil's presentation: Why first of all is extended ProjectPALovVO and after.... on screenshot corresponding to item creation thorugh personalization it appears ProjectAllLov.. .??]
The tip:
I've got to pass through mappings the TaskId to task's LOV (I created a destination item with Personalization , at page level, where I store the taskid and another LovMap item in Task Lov Mappings that gets that taskid. With that I got to filter TaskLov)
What I'm trying to do is to fill directly the TaskNum item (where task number is shown in the page) but I don't know what I'm doing wrong.
I created a new item at level page where I store TaskNum (retrieved in project lov) then .. I created a lovmapping item in Task Lov mapping getting value form that page item... but.. when I execute the Project LOV.. my page items are filled but not my TaskNum... (despite the taskid filter for tasks lov works...)

Any ideas? I suppose there must be a little step ommited... but.. where!!!?

Than ks.
Quote
0 #50 WOjtek Wilk 2009-03-24 14:06
Great stuff!
Can you point me to the article on how to add an searchable item to the query region?
Thanks!
Quote
0 #51 May 2009-07-31 06:13
Dear oadeveloper,
Di d you create all in the same region ? Please check mapping: they must have the id of items referred.
Pleas e try.
Quote
0 #52 eduard 2009-10-21 13:57
Hi Anil,

I'm having problems with the Task Number field. I have created the new mapping but the value isn't showing. Surprisingly it is working for the award number

Could you please help me with this?

Thank you,

Eduard
Quote
0 #53 ahmed saad 2010-08-25 08:45
HI All,
i'm new at OAF , after extend oracle.apps.pon .negotiation.cr eation\server.B iddingPartiesVO , new data appeared in page of add supplier in RFQ but all data dose'nt appear in review RFQ page ( add supplier page and review supplier page base on the same view object which i extend it )
any one can help me ?
thanks
Quote
0 #54 priyakrishna 2010-09-20 23:58
Hi Anill..All,

Th ank you so much for the all the posting and technical article.. It helps me alot.

Now i have a doubut in OAF VO Extension and also m new to OAF.


Problem:

I have a LovVO which has four attributes coming from a view.

But now i need to change the VO query so that all the 4 columns should come from the another custom table.

How do i achive this?


Thanks for the help in advance

Rgds,
PriyaKrishna
Quote
0 #55 Archana Saharya 2010-11-22 15:23
Hi,
I am tryin to create a custom Home Page for iSupplier and i need to put up a message on the page in one region on the left side and on the right side regions need the links to the custom pages that I have.
Can you please give a liittle guidance on this.
Thanks.
Quote
0 #56 maayan 2011-01-05 15:02
Hi,
i would like to add to existing DFF a new segment and present it in iRecruitment FW.
i added the field in oracle forms \ DB .
the specific DFF is already shown in iRecruitment but the new fields dont appear .
how can i show them?

if you can please assist ,
Thanks
Maayan
Quote

Add comment


Security code
Refresh

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Jun 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
   1  2  3  4  5  6
  7  8  910111213
14151617181920
21222324252627
282930    

Enquire For Training

Related Items

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner