Home » Applications » Oracle Fusion Apps & E-Business Suite » Form Personalization-Check Duplicate AP Invoice
Form Personalization-Check Duplicate AP Invoice [message #390929] Tue, 10 March 2009 06:23 Go to next message
Messages: 1
Registered: March 2009
Junior Member

I have created a table (invoice_test) which consist of 3 important fields namely: Vendor_ID, Invoice_Num, Invoice_Amt

In the AP invoice screen, when the user enter the Supplier Number and Invoice Number, the system would be able to check this invoice from the invoice_test table. If the the Vendor_ID and Invoice_Num is matched to what they have entered, prompt the msg: Invoice was previously entered in the Old system'.

How can I use Form Personalization to customize this function? Appreciate if someone can guide me. Thanks in advance.

Re: Form Personalization-Check Duplicate AP Invoice [message #393813 is a reply to message #390929] Tue, 24 March 2009 08:14 Go to previous message
Messages: 19
Registered: March 2009
Junior Member
Follow the below steps
1. Open the Invoice Entry screen.
2. Choose from the menu, Help-> Diagnostics -> Custom Code -> Personalize. The personalization window will appear
3. Enter seq (any seq number), Description (Description about this customization), Level (choose function), Enabled (Checked).
4. On the Condition tab, choose, Trigger Event -> WHEN-VALIDATE-RECORD. Trigger Object -> INV_SUM_FOLDER (Invoice Block).
5. Enter the below text on the condition text field.
:system.record_status != 'QUERY'
AND (1 = (SELECT 1
FROM dual
FROM invoice_test invtst
WHERE invtst.vendor_id = :inv_sum_folder.VENDOR_NUMBER
AND invtst.invoice_num = :inv_sum_folder.invoice_num
The above code checks, if the form is not in query mode, then check if the vendor details already exists in the invoice_test table.
6. Choose processing mode -> "Not in Enter-Query Mode".
7. On the Action Tab, Enter Seq (Any seq number), Type -> Message, Description (Any meaninful description), Languages -> All, Enabled -. Checked.
8. On the Message Type, choose "Error", Message Text -> <Enter any message that you want to display>.
9. Save the changes.

The form has now be personalized to check for vendor and invoice details from the invoice_test table.

Previous Topic: Oracle HRMS( iRecruitment)
Next Topic: Automatic Sales Order Version
Goto Forum:

Current Time: Tue Jul 25 13:57:27 CDT 2017

Total time taken to generate the page: 0.10496 seconds