Forum - For Oracle Apps Customization and Extensions

Dear Friends,

We have now launched a forum.

What is different about this forum
The entries in this forum will be business requirement oriented.
The forum is dedicated to customizations & extensions only.

OA Framework Forum - http://apps2fusion.com/forums/oaf
If you wish to do any extension in OA Framework, then post your requirements in the right section, like iProcuremen, then

apps2fusion team will analyze your requirement and will suggest you a best practice approach and step by step solution.
You can find various samples of how to post your queries.
For example please see below URLs
http://www.apps2fusion.com/forums/viewtopic.php?f=9&t=91
http://www.apps2fusion.com/forums/viewtopic.php?f=10&t=96

PL/SQL API Forum http://apps2fusion.com/forums/
Every consultant keeps their scripts in pocket and re-uses them on different project.
In this forum, as time progresses, we will be posting all our scripts that we have used in the past many years of consulting.
For example, if you wish to write receivables invoice interface, you will be able to see the work of other developers on this forum.
This will be a collaborative effort, I hereby request each of you to share your scripts by posting them on this forum.

You will have to register to access this forum, it takes only 10seconds.

More forums will be added added in future, your suggestions are precious, email us on This e-mail address is being protected from spambots. You need JavaScript enabled to view it

Finally few humble requests
- Please post entries only within the relevant section
- Explain your problem properly, please don't use short cuts to explain [see samples]
- Please collaborate where you can, every contribution is appreciated

Thanks,
Apps2Fusion Team

Set as favorite

Bookmark

Email This

Comments (23)

Subscribe to this comment's feed

How about a forum/area for Methodologies
written by Ranu , July 31, 2008

Anil,
I was thinking,it might be a good idea to share learning from Project Management experiences,best practices for running projects,conversions & so on.Armoured with this knowledge & apps expertise already,eventually it has potential to help consultants on this website to be more able to increase their worth & more value to their client.

Cheers

report abuse

vote down

vote up

Votes: +4

...
written by Anil Passi , July 31, 2008

Hi Ranu

That is a good idea, I will discuss this further with yourself.

Thanks,
Anil Passi

report abuse

vote down

vote up

Votes: -1

Good Work ......Keep moving ......
written by balkrishna bihade , August 01, 2008

HI Anil,

The idea suggested by Ranu is very good ... Please think of it .

Thanks and Regards
balkrishna

report abuse

vote down

vote up

Votes: +2

...
written by Anil Passi , August 01, 2008

Hi Balkrishna,

Indeed it is, I am working with apps2fusion authors to further enhance this forum.

Thanks,
Anil Passi

report abuse

vote down

vote up

Votes: +0

oracle E- business Suit
written by shahed mohiuddin , August 02, 2008

ya its good idea.we have focus more on Extension and migration

report abuse

vote down

vote up

Votes: +2

...
written by Anil Passi , August 02, 2008

We have already put all the HRMS and Payroll Migration scripts on the forum.

I believe, more will keep pouring in from readers & contributors alike with time.

report abuse

vote down

vote up

Votes: -1

XML reports error
written by sureshkumar , August 12, 2008

Hi Anil,
We are using FSG report.After submit the XML report by selecting the template ,it displaying a ERROR MSG as the "template is not exist and contact ypur system admin".
Could you please help me in this issue.please find the below steps

XXX GL Financial controller -> Report manager -> Financial report submission -> report name ¶meters ->template ->storage location ->review->submit
with regards
suresh

report abuse

vote down

vote up

Votes: +0

Customer interface api in R12
written by nemai das , September 04, 2008

Hi Anil,
Is there any differences between 11i and R12 for Customer Interface? I developed a BPEL process to upload customer information and used the following tables :

1. RA_CUSTOMERS_INTERFACE_ALL
2. RA_CUSTOMER_BANKS_INT_ALL
3. RA_CUSTOMERS_PROFILES_INT_ALL
4. RA_CUST_PAY_METHOD_INT_ALL
5. RA_CONTACT_PHONES_INT_ALL

Is there any change(addition or removal of any tables) in R12? Or can I use my old process for R12 also?

Thanks in advance.

With regards,
Nemai

report abuse

vote down

vote up

Votes: +0

Project Management and Manufacturing Training
written by sc2904 , September 12, 2008

Anil,
Do you have any plans on training for Projects Management, Billing, Costing and Manufacturing. Please do let us know.

Thanks,
Shilpa.

report abuse

vote down

vote up

Votes: +0

...
written by Anil Passi , September 12, 2008

Hi Shilpa

Thanks for this query, we are always in pusuit of adding "value for money" trainings to our portfolio.
However we are not sure if there is enough volume/people seeking the training that you suggested

Thanks,
Anil Passi

report abuse

vote down

vote up

Votes: -2

FSG Reprot Error in R12
written by Vijayp , October 16, 2008

Anil,

I am trying to run FSG in R12 and its erroring out. There is no proper error message displayed.

I am pasting the log file.

Log File:

After recalculating exceptions.
Current date and time: Thu Oct 16 20:09:21 2008

After ranking.
After segment value routine.
XML processing start.
XML processing after xml_page_style.
XML processing after rgrcoh call.
XML processing for content_cnt 1.
XML processing after xml_page_style.
Couldn't find string
Current date and time: Thu Oct 16 20:09:21 2008

Entered sauulc with code 1 from line 908 of file rg/lib/rgrclob.c.

+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

+---------------------------------------------------------------------------+
Executing request completion options...

Output is not being printed because:
Program failed to set the report print style.

Finished executing request completion options.
Program exit with Error

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 16-OCT-2008 20:09:21

----------------
Except this i dont see any error message in the log file.

If there any solutions to this please suggest me.

Thanks,
Vijay

report abuse

vote down

vote up

Votes: +0

r12 custom reports
written by dd , October 28, 2008

hi, im doing custom reports. Can you tell how to run web reports in r12. can we use web.show_document? is there a report server in r12? and do we need to ensure that the report server has to configured and shud run? my dba says forms and report server are same and no separate server for reports?
Please clarrify

report abuse

vote down

vote up

Votes: +0

...
written by amar.a , October 29, 2008

Hi,
I am a trainee in apps, Can you giver me any useful information about apps.

report abuse

vote down

vote up

Votes: +0

OADBTransaction - 2 questions please
written by Franklin Alagala , November 03, 2008

Dear Anil,

I very earnestly request you to reply at the earliest possible.

Problem: Existing code is crashing due to memory leak in production environment. I have two questions please:

Question 1: (Connection Pooling Environment)
OADBTransaction oadbTransaction = getOADBTransaction();
Statement stmt = oadbTransaction.createStatement("statement inside");

I close statements but I do not close oadbTransaction and resultSet.
Does this lead to memory leak?

At one place I forgot to close statement also.
That means statement, resultset and oadbTransaction are not closed here.
Does this lead to memory leak?

-----------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------
Question2: (Connection Pooling Environment)
In my framework, I used the following statement:

Connection localConnection = oadbTransaction.getJdbcConnection();

I understand now that getJDBCTransaction() method is not recommended? Why?

I do not close the localConnection but I close the statements.
Does this lead to memory leak?
Does this also lead to out of connections error?

Your prompt response is most appreciated.

Regards,
Franklin Alagala
9703016412

report abuse

vote down

vote up

Votes: +0

Oracle Apps Release 12 - Implement Security on Customer Standard Form
written by Rajesh Khatri , November 09, 2008

Hi Anil,

We have a requirement wherein we need to implement record based security on Customer Standard Form. WE have a DFF Column at Account Level and Site Use LEvel and based on this column value User should be either be allowed to update the record or we need to restrict the update.

Also, based on this value user can either can add sites or cannot add sites.

I need to know what will be the best apporach to achieve this :-
1) OA Framework Extention - can you suggest how to start with this.
2) Virtual Private database
3) Database triggers on base tables.

What do you think will be the best approach. Please do let me know.

Thanks.

report abuse

vote down

vote up

Votes: -1

Oracle Apps Release 12 - Implement Security on Customer Standard Form
written by Rajesh Khatri , November 09, 2008

report abuse

vote down

vote up

Votes: +0

...
written by Anil Passi , November 09, 2008

Rajesh

For OA Framework pages, you should use OA Frameowork extension.
You can extend the entity object for method onUpdate() to throw exception when record is being updated mathces your conditions.

If you aren't too comfortable with this, then I suggest you use business event, by creating a subscription less than 99.
This will be similar to database trigger, but business events is a much more elegant approach.

Thanks,
Anil Passi

report abuse

vote down

vote up

Votes: -1

Memory Leak in OAF - oracle.jbo.server.ApplicationModuleServiceImpl
written by Franklin Alagala , November 10, 2008

Hello Anil:

Please refer to this class in OAF oracle.jbo.server.ApplicationModuleServiceImpl.
Inside methods below:
--> getQNameFromIRepByJavaType
--> getImplementationNameFromIRepByQName

Statements are not closed after use. Does this not lead to memory leak?
If this is true then there is a serious issue with this part of code in OAF.
We are having memory leak issues in our application and JProbe points to memory leak in OAF.

Kindly comment? We eagerly await your reply.

Best Regards,
Franklin Alagala
Infoys

report abuse

vote down

vote up

Votes: +0

Custom form
written by maniaks , November 13, 2008

Hi Anil,
I am doing a custom form for our client.
I ahve added the libraries including APPDAYPk.pll to the form.
While compiling using frmcmp in linux box it shows CALENDAR.SHOW ,ust be declared.I ahve added calendar.show in key-list-val trigger for an item.
Also it shows the compilation error in CALENDAR datablock triggers which calls calendar.event.
It shows the error as:
CALENDAR.EVENT must be declared in when-button-pressed trigger of CALENDAR Block.
Please help.

report abuse

vote down

vote up

Votes: +0

OAF Lov Search page not coming up
written by archiesprakash , November 14, 2008

Hi Anil,

I am a beginner in OAF and have a got a custom application.
This is an already existing custom application and I need to add some features.

The problem is as below:
I am running the fom directly from JDeveloper and the form opens fine.
I can navigate between pages in the form.
But None of the LOVs in the form open any search page.
when I click on the 'torch' button, the base page refreshes itself and does not pop-up any search page.
pop-up blocker is off.

clicking on date-field-calendar icon opens up the calendar.

Please help.

Thanks,
Prakash.

report abuse

vote down

vote up

Votes: +0

issue in workflow notification
written by vipin , December 01, 2008

Hi,

I am new to oracle workflow. i have a workflow issue. whenever an approver approves the PO,
his manager gets the notification of the PO approval. This notification should not be gone as in a day many PO's are approved.
How this functionality can be removed.

report abuse

vote down

vote up

Votes: +0

Displaying error in Oracle form from account generator workflow
written by mahendravin , December 11, 2008

I have a requirement of displaying a custom error message on the form when the account generator fails to derive the code combination.

The error message will tell the user about the invalid values passed to the Requisition, PO, Supplier Invoice account generators.

Please provide your inputs on how to display errors in Oracle Forms from a workflow.

Thanks & Regards,

mahendra

report abuse

vote down

vote up

Votes: +0

Issue I procurment invoices
written by Nikhil b , December 31, 2008

Can anyone let me know.How can you trace ,invoices ordered through I Procurment /E Procurment.

report abuse

vote down

vote up

Votes: +0

Write comment

Name