Go Directly To
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Get Started Guide
Join the world’s largest interactive community dedicated to Oracle technologies.
Learn from thousands of community experts
Get answers to your technical questions
Share your knowledge with peers
Please enter a title.
You can not post a blank message. Please type your message and try again.
Enterprise Resource Planning (ERP)
This discussion is archived
on Apr 1, 2008 2:41 PM by 628428
Apr 1, 2008 8:44 AM
This is in continuation to one of my previous queries to this forum...
Restrict creation of standard POs from scratch i.e. do not allow POs to be created without a backing requisition and
Do not allow Quantity value to be updated in the PO autocreated from Requisition
As suggested in the previous query, I tried form personalization to achieve this
Trigger event: when-new-form-instance
condition: :PO_HEADERS.DOC_TYPE_NAME in ('Standard Purchase Order')
object type: item
target object: PO_LINES.QUANTITY
property name: UPDATE_ALLOWED
This rule is not working! Can someone validate or suggest?
This content has been marked as final.
Show 1 reply
Re: Restricting Buyers
Apr 1, 2008 2:41 PM
in response to
Trigger Event: WHEN-VALIDATE-RECORD
Trigger Object: PO_HEADERS
Condition: :PO_HEADERS.DOC_TYPE_NAME='Standard Purchase Order' AND :PO_HEADERS.AGENT_NAME like 'Your Buyer Name'
Message Type Error
Message Text : Your message.