Home » Applications » Oracle Fusion Apps & E-Business Suite » how to view only approved purchase orders using form personalization (oracle application forms personalization)
icon4.gif  how to view only approved purchase orders using form personalization [message #398742] Fri, 17 April 2009 06:32 Go to next message
dsreddyin
Messages: 2
Registered: April 2009
Junior Member
Hi All,
Can anyone please help me out on form personalization issue?
I need to show only approved purchase orders in purchase order form. This customization should be done by form personalization only. When we query the form , only approved PO's should appear.The incomplete PO's shouldn't be able to view by users.I tried a lot using personalization but i'm uable to get the output. Please guys help me!, Any solutions for this.

Thanks,
Sreekanth.
Re: how to view only approved purchase orders using form personalization [message #398992 is a reply to message #398742] Mon, 20 April 2009 03:41 Go to previous messageGo to next message
dsreddyin
Messages: 2
Registered: April 2009
Junior Member
Can we do form personalization while switching to responsibility?
I want to restrict few things before navigating to any of the forms in Payables Manager responsibility. Please let me know if possible.

Thanks
Sreekanth.
Re: how to view only approved purchase orders using form personalization [message #399485 is a reply to message #398742] Wed, 22 April 2009 07:32 Go to previous messageGo to next message
B.T.S.Ananth
Messages: 216
Registered: June 2006
Location: chennai / Hyderabad
Senior Member

Hi Sreekanth,

Steps
--------
1. Open Purchase order Summary form and navigate as follows.
Help ---> Diagnostics ---> Custom Code ---> Personalize

2. Enter the Seq(<Any number say 10>) and Description of your choice.

3. Navigate to the Conditions Tab and set the following fields
Trigger event: WHEN-NEW-FORM-INSTANCE
Processing Mode: Not in Enter-Query Mode
Under --> Context
Level: <Choose the level(If you want it at Site level or at Responsibility level(Payables Manager responsibility) or a particular user)>


4. Navigate to ActionsTab
Set the following values
Seq: <Any number say 10>
Type: Property
Description: <Any character string you desire>
Language: All
Enabled: Checked
Object Type: Item
Target Object:FIND.APPROVAL_STATUS
Property Name:VALUE
Value: Approved

Regard,
B.T.S.Ananth
Re: how to view only approved purchase orders using form personalization [message #399673 is a reply to message #398742] Thu, 23 April 2009 07:47 Go to previous message
B.T.S.Ananth
Messages: 216
Registered: June 2006
Location: chennai / Hyderabad
Senior Member

Steps
--------
1. Open Purchase order Summary form and navigate as follows.
Help ---> Diagnostics ---> Custom Code ---> Personalize

2. Enter the Seq(<Any number say 10>) and Description of your choice.

3. Navigate to the Conditions Tab and set the following fields
Trigger event: WHEN-NEW-FORM-INSTANCE
Processing Mode: Not in Enter-Query Mode
Under --> Context
Level: <Choose the level(If you want it at Site level or at Responsibility level(Payables Manager responsibility) or a particular user)>


4. Navigate to ActionsTab
Set the following values
Seq: <Any number say 10>
Type: Property
Description: <Any character string you desire>
Language: All
Enabled: Checked
Object Type: Item
Target Object:FIND.APPROVAL_STATUS
Property Name:VALUE
Value: Approved
Seq: <Any number say 11>
Type: Property
Description: <Any character string you desire>
Language: All
Enabled: Checked
Object Type: Item
Target Object:FIND.APPROVAL_STATUS
Property Name:ENABLED
Value: FALSE

Validate > apply now and save

reopen the query form and see the changes
Previous Topic: Need to find currency code for org through SQL
Next Topic: ASCP centralized to decentralized
Goto Forum:
  


Current Time: Tue Dec 24 20:00:48 CST 2024