Total Pageviews

July 15, 2017

7/15/2017 02:53:00 AM

 Oracle Applications :Forms Personalization: AP invoices

Oracle Applications Form Personalization

Business Scenario:  The requirement is  where all the users who are having AP Accountant level responsibilities should only be able to validate the Invoices but they should not be able to create NEW invoices... Is this possible? 


Solution:

The idea is to personalize the Invoices Entry form. You can do it this way: 

Condition Tab 
Trigger Event->WHEN-NEW-ITEM-INSTANCE 
Trigger Object->INV_SUM_FOLDER.INVOICE_TYPE 
Condition->:SYSTEM.RECORD_STATUS = 'NEW' 

(Pay attention to colon) 

Context 
In this area you must enter the responsibilities you want to be affected by this personalization 

Actions Tab 
Type->Builtin 
Builtin Type->DO_KEY 
Argument->ENTER_QUERY 

Save the work, close all forms, re-open the invoices form and test. 

I'm assuming that the first field on you form is the Invoice Type. Each time the form opens, the user is forced to enter a query, instead of being able to enter a new record. To close the form without performing any query, the user must choose, from the menu, File/Close Form

for support/recruitment Call us at +91 9632266314
 
Related Posts Plugin for WordPress, Blogger...