Hi all,
My customer have a requirement to disable the Price field in Purchase Requisition and Purchase Order screen.
Customer is enforcing the policy of getting the requisition or purchase item from quotation line.
Kindly advise what need to be configured to disable the Price field in PR and PO screen.
Thank you.
Rgds,
chijperng
How to disable Price field in PR/PO screen?
-
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
if you are using 11.5.10 + then use forms personalization feature.
[quote]Hi all,
My customer have a requirement to disable the Price field in Purchase Requisition and Purchase Order screen.
Customer is enforcing the policy of getting the requisition or purchase item from quotation line.
Kindly advise what need to be configured to disable the Price field in PR and PO screen.
Thank you.
Rgds,
chijperng
<i><div align="right">Originally posted by chijperng
[quote]Hi all,
My customer have a requirement to disable the Price field in Purchase Requisition and Purchase Order screen.
Customer is enforcing the policy of getting the requisition or purchase item from quotation line.
Kindly advise what need to be configured to disable the Price field in PR and PO screen.
Thank you.
Rgds,
chijperng
<i><div align="right">Originally posted by chijperng
Hi Ahmad,
Good day. Thank you for your prompt reply. we are currently using Oracle EBS ver 11.5.10.2 and I've look into the forms personalization feature you mentioned.
I'm not familiar with the forms personalization feature. Do you think I'm able to get guidance from you?
Thank you.
Rgds,
chijperng
Good day. Thank you for your prompt reply. we are currently using Oracle EBS ver 11.5.10.2 and I've look into the forms personalization feature you mentioned.
I'm not familiar with the forms personalization feature. Do you think I'm able to get guidance from you?
Thank you.
Rgds,
chijperng
Thanks for the information provided.
I have tried to follow the mentioned documentation to test out the Form Personalization for Requisition Form.
I've tried using Forms Personalization but unfortunately I couldn't figure out the correct parameters to set in order to have no errors.
My Form Personalization Setup in Requisition:
1. Function Name: PO_POXRQERQ
2. Form Name: POXRQERQ
3. Debug Mode: Off
4. Seq = 1
5. Description = Disable Price Field in Requisition
6. level = Function
7. Enabled = Yes
Condition Region:-
8. Trigger Event: WHEN-NEW-FORM-INSTANCE
9. Trigger Object: nil
10. Condition: nil
11. Processing Mode: Not in Enter-Query Mode
12: Level = Site
Actions Region:
13. Seq = 1
14. Type = Property
15. Description: Disable Price
16. Language: All
17. Enabled: Yes
18. Object Type: Item
19. Target oBject: LINES.UNIT_PRICE
20. Property Name: ENABLED
21. VALUE: FALSE
Then [save] and [Apply Now].
But once I'm in the Requisition Screen and go into Requisition Line Item, an error message prompt and shows the below message:
"FRM-41316: Canot set Insert Allowed property of disabled item LINES.UNIT_PRICE"
Kindly advise on the my forms personalization setup. Something went wrong somewhere.
Thank you.
Rgds,
chijperng
I have tried to follow the mentioned documentation to test out the Form Personalization for Requisition Form.
I've tried using Forms Personalization but unfortunately I couldn't figure out the correct parameters to set in order to have no errors.
My Form Personalization Setup in Requisition:
1. Function Name: PO_POXRQERQ
2. Form Name: POXRQERQ
3. Debug Mode: Off
4. Seq = 1
5. Description = Disable Price Field in Requisition
6. level = Function
7. Enabled = Yes
Condition Region:-
8. Trigger Event: WHEN-NEW-FORM-INSTANCE
9. Trigger Object: nil
10. Condition: nil
11. Processing Mode: Not in Enter-Query Mode
12: Level = Site
Actions Region:
13. Seq = 1
14. Type = Property
15. Description: Disable Price
16. Language: All
17. Enabled: Yes
18. Object Type: Item
19. Target oBject: LINES.UNIT_PRICE
20. Property Name: ENABLED
21. VALUE: FALSE
Then [save] and [Apply Now].
But once I'm in the Requisition Screen and go into Requisition Line Item, an error message prompt and shows the below message:
"FRM-41316: Canot set Insert Allowed property of disabled item LINES.UNIT_PRICE"
Kindly advise on the my forms personalization setup. Something went wrong somewhere.
Thank you.
Rgds,
chijperng
Hi,
Even I tried to Display that Field but it accepted for that particular instance.
When I try to enter new Po - It says an ORA-00920 error so the False Property could not be saved.
U try to make that particular Fields Enterable - property is set to True, Set it to False and update allowed : set it to False
Try it and let all of us know.
I tried with Vision Instance and got the above error.
Try it in Test instance or in Vision instance
TIA
Even I tried to Display that Field but it accepted for that particular instance.
When I try to enter new Po - It says an ORA-00920 error so the False Property could not be saved.
U try to make that particular Fields Enterable - property is set to True, Set it to False and update allowed : set it to False
Try it and let all of us know.
I tried with Vision Instance and got the above error.
Try it in Test instance or in Vision instance
TIA
Who is online
Users browsing this forum: No registered users and 0 guests