OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » fnd

Home » Applications » Oracle Fusion Apps & E-Business Suite » fnd_execute (R12)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

fnd_execute [message #487873]

Mon, 03 January 2011 01:37

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

Report message to a moderator

Re: fnd_execute [message #487892 is a reply to message #487873]

Mon, 03 January 2011 04:23

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

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

Report message to a moderator

Re: fnd_execute [message #487925 is a reply to message #487892]

Mon, 03 January 2011 06:40

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

Report message to a moderator

Re: fnd_execute [message #487955 is a reply to message #487925]

Mon, 03 January 2011 16:53

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

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

Report message to a moderator