Apps To Fusion

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

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

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

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

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

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

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.

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

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

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

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

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

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.

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.

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

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.

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.

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.

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

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.

Need Help on calling report in OAF Page
written by Somasekhar , January 20, 2009

Hi Anil,

At present i am wokring EAM Module. In EAM Stores i need to call one report.
In my OAF Page one button is there("The name of the button is Issue"). After clicking this button i need to fire one report(The name of the report is "Maintenance Picking Slip Issued Report").


Actually the requirement is :

I have a button in the OAF page. On click of that button a new pop up window should open where the report should be displayed. (the report is XML Publisher Report )

I am working on Seeded pages.
Please help me how to call report? I don't have any idea how to proceed for this.please explain clearly.


Thanks in advance..

Thanks,
Somasekhar.

MR
written by Pavan Kotharu , February 09, 2009

Hi Anil,

forms Personalization
written by Akhil Kumar , February 09, 2009

Anil,

I am trying to call a pl/sql function which is validating the phone number entered in the phones screen. I want to display error message if the phone number is not entered in a proper format. For that i am calling the function from
forms personalization and based on the value returned, i want to display an error message using raise form trigger failure and display some messages using fnd_message.show.
But unfortunately, i couldn't use form_trigger_failure and fnd_message in the Builtin type of Excecute a procedure. How to do this??
I can use the built in as Raise formtrigger failure but how to link that to the value returned from the procedure.

Thanks in advance.
Akhil

...
written by avprasad , February 12, 2009

I have observed in this forum no questions/queiries on India Localization.

Extending AbsenceTypeVO
written by Deepak Jena , February 17, 2009

Hi All,
We need to extend oracle.apps.per.selfservice.absence.server.AbsenceTypeVO View Obect. This object is being used in the page /oracle/apps/per/selfservice/absence/webui/AbsenceHomePagePG . Query is currently filtering absence types based on a business group. The query should also filer Absence types using the Person_Id who has logged into the self service page. Let us know the steps to be followed.

Thanks in Advance.
Deepak.

Oracle SSHR Function creation
written by Kartik T , February 19, 2009

Hi Anil

I want to attach some SIT functions with the Employee Self Service Menu. could you please tell me what informations need to provide at Create Function screen, to create this SIT function whcih I need to attach at Employee Self Service function.
I used seeded 'Special Information' function, and copied the same HTML call and Parameter for my custom function. when I click on this function from Employee self service Menu, I am geting an error. Error message I am geting is,
Can not access function XXX_PASSPORT. This installation does not manage mode pl/sql. Please contact your System Administrator.

Please suggest what is the issue and how to overcome from this.

Regards
Kartik T

how to add 2 new fields in Notification summary in PO module
written by Bommudurai Vairamuthu , February 19, 2009

I am working in GE energy project.I would like to add 2 new fields in the notification summary.For example I have crreated one internal requisition and it needs to be approved and I would like to display the priority of the requisition and part number which is in the IR.it is not there n existing notification summary screen.

Hi anilpassi and ranu ,
Pl help me on this issue.

Regards,
Bommudurai

Suppliers conversion from 1158 to 12i
written by VamsiKrishna , March 01, 2009

Anil,

In our company we are upgrading Oracle Apps from 1158 to 12i. Can you tell me the process of converting suppliers from 1158 to 12i.

Thanks,
Vamsi

Expense Report Import
written by RAMKUMAR A , March 05, 2009

Hi All,
I have to do Expense Report Import interface. Can you explain about how to import expense reports in IExpenses. Can you explain how to populate the interface tables?

Forms Personalization
written by Utpal , April 10, 2009

I want to run a concurrent request(a pdf report)through a special menu in POXPOEPO invokin FP.
After giving the parameter for the request the request will be submitted.
Then I want the FIND REQUEST Form to be displayed automatically as it happens when you submit a request through SRS Screen.

How to do that through FP?

Barcode scanning Form
written by Naveen , April 20, 2009

Hi Anil

This is the first time i am writing, I need your help.
I need to develop a form

Filed: Item: When user scans any Item (Barcode ) then Item should be populated. in the filed and
in the details block - It should populate the Item,Description, quantity, Po# and Supplier.

So user i wlll be scanning many items that means all the items with details must be populated in t he details block.

Can you please suggest me how to go ahead.
Please send me a mail to \n This e-mail address is being protected from spambots. You need JavaScript enabled to view it '> This e-mail address is being protected from spambots. You need JavaScript enabled to view it if possible.

Thank you
Naveen

api
written by geetar , April 28, 2009

i want information about the file upload api in form

...
written by timert , May 18, 2009

Prior to some practical issues, I read and learned the theory. There is a good article in wiwapia.com - http://wiwapia.com/en/linux . Afterwards everything becomes easier.

...
written by kritika , June 03, 2009

HI anil,

This is the error stack..

oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:88
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1145)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:140
at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2637)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1659)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:41
at _oa__html._OA._jspService(_OA.java:8
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:58
at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)
at java.lang.Thread.run(Thread.java:534)
## Detail 0 ##
java.lang.NullPointerException
at vtk.oracle.apps.pos.asn.webui.VtkPosAsnCreateCO.processFormRequest(VtkPosAsnCreateCO.java:84)

I am not able to find the exact reason.
Even i copied the standard Co class created a new one just changing the path in redirect url for submitt button.
It doesnt even extend any other class still i am getting this error.

Regards
k.kritika

Pointers on placing access controls in requistions
written by abhgaur , September 09, 2009

Hi,

iProc/Purchasing does have an option where you are restrict requisitions access either to your department, yourself.
I will really appreciate if you can provide some pointer which enable to put a control that users can access there and some specific departments only.
eg-
User A sees requsitions corresponding to Dep C , Dep B , Dept A (His Dept)
User B sees requsitions corresponding to Dep A , Dep C , Dept B (His Dept)

Thanks
Abhishek

...
written by sajeesh babu.k , September 18, 2009

HashMap phm = new HashMap() ;
phm.put("ParamEmpid",param);
phm.put("xxParammainAction",mainAction);

pageContext.setForwardURL(
"OA.jsp?page=/oracle/apps/ak/employee/webui/ManagePG"
,null //not needed as we are retaining menu context
,OAWebBeanConstants.KEEP_MENU_CONTEXT
,null //not needed as we are retaining menu context
//,null
,phm //pass the hashMap that contains values for all of the parameters
,true //retain AM
,OAWebBeanConstants.ADD_BREAD_CRUMB_NO
,OAWebBeanConstants.IGNORE_MESSAGES);

i had created this code and its showing one error..

error is
Error(59,25): method setForwardURL(java.lang.String, null, byte, null, java.util.HashMap, boolean, java.lang.String, byte) not found in interface oracle.apps.fnd.framework.webui.OAPageContext

How Flex plugin work with OAF ?
written by Amin , October 30, 2009

Hi Anil,

I asked in many forum dint get any reply, I have lot of expectation from you.

How Flex plugin work with OAF ?

Thanks,
Amin

...
written by Anil Passi- , October 31, 2009

I will write a step by step article on this.

Cheers,
Anil Passi

About Supplier level bank account
written by Prasenjit , November 02, 2009

SELECT * FROM
(/*This part is for site level bank*/
SELECT substr(v.NUM_1099,3, RUC,
UPPER(substr(V.VENDOR_NAME,1,30)) PROVEEDOR,
ia.INVOICE_NUM FACTURA,
TO_CHAR(ch.check_date,'YYYYMMDD') FECHA,
LPAD(TO_CHAR(ip.AMOUNT*100),11) IMPORTE,
ieb.bank_account_type FORMA_PAGO,
DECODE(ieb.bank_account_type, '1', '000', '2', '000', cbbv.branch_number) CODIGO_OFICINA,
ieb.bank_account_num--substr(ieb.bank_account_num,1,3)||DECODE(ieb.bank_account_type,'1','','2','0','3','0')||substr(ieb.bank_account_num,5,length(ieb.bank_account_num)) CODIGO_CUENTA ,
,' ' FLAG ,
' ' MARCA,
DECODE(v.num_1099,'20913339','20209133394',substr(v.num_1099,1,11)) NIT
,iep.payee_party_id
,iep.party_site_id
,iep.supplier_site_id
,iep.ext_payee_id
FROM
/*hz_party_sites hps*/
apps.iby_external_payees_all iep
,apps.iby_pmt_instr_uses_all ipi
,apps.iby_ext_bank_accounts ieb
,apps.ce_bank_branches_v cbbv
,ap_invoice_payments_all ip
,ap_checks_all ch
,ap_invoices_all ia
,Po_vendors v
,po_vendor_sites_all vs
WHERE
ieb.branch_id =cbbv.branch_party_id
AND ieb.bank_id = cbbv.bank_party_id
AND ieb.ext_bank_account_id = ipi.instrument_id
AND ipi.ext_pmt_party_id = iep.ext_payee_id
/* AND cbbv.branch_party_id = hps.party_id (+) */
--AND iep.supplier_site_id = vs.vendor_site_id
AND iep.supplier_site_id=vs.vendor_site_id
AND iep.payee_party_id = v.party_id
AND ip.CHECK_ID = ch.CHECK_ID
AND ip.INVOICE_ID = ia.INVOICE_ID
AND ch.VENDOR_ID = v.VENDOR_ID
AND ia.VENDOR_ID = vs.VENDOR_ID
AND ia.VENDOR_SITE_ID = vs.VENDOR_SITE_ID
AND ch.AMOUNT > 0
AND ch.CHECKRUN_NAME = '&1'
AND trunc(SYSDATE) BETWEEN nvl(ipi.start_date,SYSDATE-1) AND nvl(ipi.end_date,SYSDATE+1)


UNION
/*This part is for supplier level bank*/

SELECT substr(v.NUM_1099,3, RUC,
UPPER(substr(V.VENDOR_NAME,1,30)) PROVEEDOR,
ia.INVOICE_NUM FACTURA,
TO_CHAR(ch.check_date,'YYYYMMDD') FECHA,
LPAD(TO_CHAR(ip.AMOUNT*100),11) IMPORTE,
ieb.bank_account_type FORMA_PAGO,
DECODE(ieb.bank_account_type, '1', '000', '2', '000', cbbv.branch_number) CODIGO_OFICINA,
substr(ieb.bank_account_num,1,3)||DECODE(ieb.bank_account_type,'1','','2','0','3','0')||substr(ieb.bank_account_num,5,length(ieb.bank_account_num)) CODIGO_CUENTA ,
' ' FLAG ,
' ' MARCA,
DECODE(v.num_1099,'20913339','20209133394',substr(v.num_1099,1,11)) NIT
,iep.payee_party_id
,iep.party_site_id
,iep.supplier_site_id
,iep.ext_payee_id
FROM
--hz_party_sites hps
apps.iby_external_payees_all iep
,apps.iby_pmt_instr_uses_all ipi
,apps.iby_ext_bank_accounts ieb
,apps.ce_bank_branches_v cbbv
,ap_invoice_payments_all ip
,ap_checks_all ch
,ap_invoices_all ia
,Po_vendors v
WHERE

ieb.branch_id =cbbv.branch_party_id
AND ieb.bank_id = cbbv.bank_party_id
AND ieb.ext_bank_account_id = ipi.instrument_id
AND ipi.ext_pmt_party_id = iep.ext_payee_id
--AND cbbv.branch_party_id = hps.party_id
AND iep.payee_party_id = v.party_id
AND iep.supplier_site_id IS null
AND ip.CHECK_ID = ch.CHECK_ID
AND ip.INVOICE_ID = ia.INVOICE_ID
AND ch.VENDOR_ID = v.VENDOR_ID
AND ia.VENDOR_ID = v.VENDOR_ID
AND ch.AMOUNT > 0
AND ch.CHECKRUN_NAME = '&1'
AND trunc(SYSDATE) BETWEEN nvl(ipi.start_date,SYSDATE-1) AND nvl(ipi.end_date,SYSDATE+1))

About Supplier level bank account
written by Prasenjit , November 02, 2009

Hi Anil,

Sorry about the previous thread.....


I have a problem.
Suppose, a supplier has two sites. One of the site is attached to a bank account, where the onther bank account is not attached to none of the site...
So, there are two bank account. One is supplier level another is site level. Now, For a batch payment (In R12 for Payment Process Request), we have a requirement to find out the supplier associated with that batch payment alond with Supplier bank account number.

Now, for Bank account at supplier site level,its not a problem.. Problem occurs for bank account at supplier level. When an invoice is created against that supplier site which is not attached to any bank account, upon payment of that invoice, money should go to default Supplier level bank account.
But, for a bank account at supplier level the corresponding value of column supplier_site_id will be NULL in table iby_external_payees_all table. Now, how could I join an invoice which have a definite vendor_site_id to a Bank account having supplier_site_id as NULL in table iby_external_payees_all.

I am attaching my query herewith.

SELECT substr(v.NUM_1099,3, ,
UPPER(substr(V.VENDOR_NAME,1,30)) ,
ia.INVOICE_NUM ,
TO_CHAR(ch.check_date,'YYYYMMDD') ,
LPAD(TO_CHAR(ip.AMOUNT*100),11) ,
ieb.bank_account_type ,
DECODE(ieb.bank_account_type, '1', '000', '2', '000', cbbv.branch_number),
substr(ieb.bank_account_num,1,3)||DECODE(ieb.bank_account_type,'1','','2','0','3','0')||substr(ieb.bank_account_num,5,length(ieb.bank_account_num)) ,
' ' FLAG ,
' ' FLAG1,
DECODE(v.num_1099,'20913339','20209133394',substr(v.num_1099,1,11))
FROM
hz_party_sites hps
,apps.iby_external_payees_all iep
,apps.iby_pmt_instr_uses_all ipi
,apps.iby_ext_bank_accounts ieb
,apps.ce_bank_branches_v cbbv
,ap_invoice_payments_all ip
,ap_checks_all ch
,ap_invoices_all ia
,Po_vendors v
,po_vendor_sites_all vs
WHERE
ieb.branch_id =cbbv.branch_party_id
AND ieb.bank_id = cbbv.bank_party_id
AND ieb.ext_bank_account_id = ipi.instrument_id
AND ipi.ext_pmt_party_id = iep.ext_payee_id
AND cbbv.branch_party_id = hps.party_id (+)
--AND iep.supplier_site_id = vs.vendor_site_id
AND iep.supplier_site_id vs.vendor_site_id
AND iep.supplier_site_id IS NULL
AND iep.payee_party_id = v.party_id
AND ip.CHECK_ID = ch.CHECK_ID
AND ip.INVOICE_ID = ia.INVOICE_ID
AND ch.VENDOR_ID = v.VENDOR_ID
AND ia.VENDOR_ID = vs.VENDOR_ID
AND ia.VENDOR_SITE_ID = vs.VENDOR_SITE_ID
AND ch.AMOUNT > 0
AND ch.CHECKRUN_NAME = '&1'
AND trunc(SYSDATE) BETWEEN nvl(ipi.start_date,SYSDATE-1) AND nvl(ipi.end_date,SYSDATE+1)

...
written by Prasenjit , November 02, 2009

Anil, Please provide me some solution...

Thanx in advance

BAM Configure
written by uma maheswar , December 01, 2009

Hi Anil,

I have one quick question, Like i want to use BAM in my current project to generate reports.

So May i know in detail like: How to install BAM, what are the basic steps we need to follow before install.


Thanks
Uma

OAF customization
written by Narain , February 04, 2010

Hi Anil,
I have seen lot of your post, your ideas and solutions are impeccable. I am in need of your help. We have a requirement in which an existing OAF page need to be customized. An additional feature for downloading a file need to be introduced.My question is , whether we need to extend AM,VO for this or simple modification of page ie enough, expecting your reply

Reg: Extending the Controller to validate the User defined Attributes
written by Jeno J , February 23, 2010

Hi Anil,

First i want to thank you for the information and help that you have provided.

Now i have a query.We are using Oracle E Business suite's Product Life Cycle Management application.

I need to extend the controller so that i can validate a attribute in one attribute group based on a attribute in another attribute group.

Now i used the following code,
OAApplicationModule oaapplicationmodule1 = oapagecontext.getRootApplicationModule();
OAApplicationModule oaapplicationmodule2 = EgoExtFwkUtil.findNestedAM(oaapplicationmodule1, "EgoExtFwkAM");
OAViewObjectImpl vo = (OAViewObjectImpl)oaapplicationmodule2.findViewObject("EGO_ITEMMGMT_GROUP431ATTRNAME");

Row row = vo.first();
System.out.println("Value - " + row.getAttribute("CExtAttr1"));

This code prints the value which is available while rendering the page and not the value modified before submitting the page.

Please suggest the VO to get the new or modified values.

Thanks.

Customer upload in Oracle APPS R12
written by sanjit , March 09, 2010

hi,
please help me how to upload customer data in oracle apps r12 wiht the help of interface and which data fillup in the below table colums .my mail id:- \n This e-mail address is being protected from spambots. You need JavaScript enabled to view it '> This e-mail address is being protected from spambots. You need JavaScript enabled to view it

1> RA_CUSTOMERS_INTERFACE_ALL(ORIG_SYSTEM_CUSTOMER_REF,SIT E_USE_CODE ,CUSTOMER_NUMBER ,CUSTOMER_NAME ,CUSTOMER_STATUS,INSERT_UPDATE_FLAG ,ORIG_SYSTEM_ADDRESS_REF,PRIMARY_SITE_USE_FLAG,ADDRESS1 ,COUNTRY ,LOCATION)
2> RA_CUSTOMER_PROFILES_INT_ALL(CUSTOMER_PROFILE_CLASS_NAM E,ORIG_SYSTEM_CUSTOMER_REF,NSERT_UPDATE_FLAG,CREDIT_HOL D,ORIG_SYSTEM_ADDRESS_REF)
3>RA_CONTACT_PHONES_INT_ALL (ORIG_SYSTEM_CUSTOMER_REF,ORIG_SYSTEM_TELEPHONE_REF,TEL EPHONE,TELEPHONE_TYPE,INSERT_UPDATE_FLAG,ORIG_SYSTEM_AD DRESS_REF,ORIG_SYSTEM_CONTACT_REF,CONTACT_LAST_NAME)
4> RA_CUSTOMER_BANKS_INT_ALL(ORIG_SYSTEM_CUSTOMER_REF,PRIM ARY_FLAG,START_DATE,BANK_ACCOUNT_NAME,BANK_ACCOUNT_CURR ENCY_CODE,BANK_ACCOUNT_NUM,BANK_BRANCH_NAME,ORIG_SYSTEM _ADDRESS_REF)
5> RA_CUST_PAY_METHOD_INT_ALL(ORIG_SYSTEM_CUSTOMER_REF,STA RT_DATE,ORIG_SYSTEM_ADDRESS_REF,PRIMARY_FLAG,PAYMENT_ME THOD_NAME)

Personalize Invoice Folder
written by Craig , April 14, 2010

Afternoon Forum,

We are R12.0.6 - and our users love using spaces (trailing & leading) in the invoice numbers. Would it be possible to add personalization that would either clear the spaces or prevent them from being captured?

...
written by Ambica , April 29, 2010

why is form personalization getting called first and not custom.pll?

hi please send me ap,po,inv,gl technical consultant documents
written by sbabavalli , May 18, 2010

hi.
i am new to apps pls forward some material about modules in technical consultant point of u

I am a trainee in oracle
written by Jitender Kumar , June 19, 2010

Hi Anil,

first thanks for helping....
I am a trainee in oracle.i have started from D2K part.i hace completed my PL/SQL part.now i am moving on report builder.Could you please tell from where can read good report article and start on it

Thanks with Regards
Jitender Kumar

which table store All expenses in gl module
written by binay , July 02, 2010

I am working in cost variance report in GL module. I want in which table we will store expense like
general expenses
selling and distributions
marketing expenses
staff cost
financial expenses
depriciation
others
please send me to my \n This e-mail address is being protected from spambots. You need JavaScript enabled to view it '> This e-mail address is being protected from spambots. You need JavaScript enabled to view it