Home » Applications » Oracle Fusion Apps & E-Business Suite » fnd_execute (R12)
icon4.gif  fnd_execute [message #487873] Mon, 03 January 2011 01:37 Go to next message
lokeshsurana
Messages: 212
Registered: April 2010
Location: India
Senior Member
Hi all
I am trying to open the Standard Purchase Order Form with some data
on when-button-pressed trigger
code is as follow:

 fnd_function.execute
                (
                FUNCTION_NAME=>'PO_POXPOEPO_VIEW',
                OPEN_FLAG =>'Y',
                SESSION_FLAG =>'Y',
                OTHER_PARAMS =>'PO_HEADER_ID="'||'1020'||'"'
                );


as i click only new form opening ..their is no data on it....


Please suggest solution for it...... Sad
Re: fnd_execute [message #487892 is a reply to message #487873] Mon, 03 January 2011 04:23 Go to previous messageGo to next message
vamsi kasina
Messages: 2096
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
What you could have already done before posting this are:
1. Find out which is the form behind the function PO_POXPOEPO_VIEW?
2. On which table / view the form is built?
3. Is the data present in the view with po_headers_id as 1020?

Please provide the information as much as you can always, as we can't peep into your machine to find out that is happening there.

By
Vamsi
Re: fnd_execute [message #487925 is a reply to message #487892] Mon, 03 January 2011 06:40 Go to previous messageGo to next message
lokeshsurana
Messages: 212
Registered: April 2010
Location: India
Senior Member
1. Find out which is the form behind the function PO_POXPOEPO_VIEW?
PO_POXPOEPO_VIEW is based on
user function name is as: View Purchase Orders

2. On which table / view the form is built?
base tables are : po_headers and po_lines
views: po_header_v and po_lines_v
i want cross check this how can i..?

3. Is the data present in the view with po_headers_id as 1020?

yes data is present in in the standard table



Re: fnd_execute [message #487955 is a reply to message #487925] Mon, 03 January 2011 16:53 Go to previous messageGo to next message
vamsi kasina
Messages: 2096
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
>> i want cross check this how can i..?
Open the form and check. May be from $PROD_TOP / $AU_TOP.

Anyway, as you said it is on po_headers / po_headers_v and
>> yes data is present in in the standard table
Which means you have not tried that at all or you have appended _all to the table name.
If you tried with the above tables, you would get zero rows, as those are related to MO.
Please check the org, to which that header is attached.
Also check what are the values of the following profile option attached to your responsibility/user and whether you have access to the org attached to the header or not.
MO: Default Operating Unit
MO: Operating Unit
MO: Security Profile

By
Vamsi
Re: fnd_execute [message #487993 is a reply to message #487955] Tue, 04 January 2011 01:00 Go to previous messageGo to next message
lokeshsurana
Messages: 212
Registered: April 2010
Location: India
Senior Member
so i need to pass here MO also
How can i pass those values like MO and PO_header_id so i can able to ope standard form with that header data..????

Re: fnd_execute [message #488057 is a reply to message #487993] Tue, 04 January 2011 08:25 Go to previous message
vamsi kasina
Messages: 2096
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Please read my previous post again and provide the results.

By
Vamsi
Previous Topic: How to define the Report Parameters
Next Topic: Inter-organization Transfer Error
Goto Forum:
  


Current Time: Fri Aug 29 21:38:56 CDT 2014

Total time taken to generate the page: 0.12865 seconds