Last updated on AUGUST 21, 2016
Applies to:Oracle Purchasing - Version 12.0.6 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
Some supplier sites have a fax number defined as the default communication method. When using the new profile option "PO: Communication Email Default" (PO_COMM_EMAIL_DEFAULT) set to "Contact" and the supplier in the purchase order defaults its contact value at the header level, the email field in the approval window gets disabled and is not updateable unless the supplier contact field is removed in the po header. An Forms Runtime Diagnostic (FRD) shows an Unhandled Exception ORA-100501 occurs when the WHEN-CHECKBOX-CHANGED event is called internally in the form.
CLICK POXPOEPO PO_APPROVE EMAIL_CHECK
WHEN-CHECKBOX-CHANGED Trigger Fired:
Unhandled Exception ORA-100501
POXPOEPO, 22, Trigger, Exit, 299209899, WHEN-CHECKBOX-CHANGED
Library = POXAPAPC.pll
PACKAGE BODY PO_APPROVE_C1
This is the select with the unhandled exception because the
SELECT â¦ INTO x_emailaddress, returns TWO ROWS !!!
NVL(pvc.email_address, pvs.email_address))) EMAIL,
pvs.vendor_site_id SITE_VENDOR_SITE_ID , pvc.vendor_site_id CONTACT_VENDOR_SITE_ID
FROM po_headers_ALL poh,
WHERE poh.vendor_site_id = pvs.vendor_site_id
AND poh.vendor_contact_id = pvc.vendor_contact_id (+)
AND poh.segment1 = '545468'
AND poh.type_lookup_code = 'STANDARD'
The email address should become updatable so the user can enter an email address of their choice.
1. Create PO via Purchasing > Purchase Orders > Purchase Orders
2. Enter data on the PO
3. Click Approve, check the email check box
4. The email address field is not enabled
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms