Email Address In Po Approval Window Is Disabled When Email Is Checked (Doc ID 1265074.1)

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.
POXAPAPC.pll


Symptoms

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.

ERROR

# 20 - POXPOEPO:PO_APPROVE.RESERVE.1285096733306784056
CLICK POXPOEPO PO_APPROVE EMAIL_CHECK

WHEN-CHECKBOX-CHANGED Trigger Fired:
Form: POXPOEPO
Block: PO_APPROVE
Item: EMAIL_CHECK
...
...
Unhandled Exception ORA-100501
State Delta:
POXPOEPO, 22, Trigger, Exit, 299209899, WHEN-CHECKBOX-CHANGED



ENVIRONMENT

Library = POXAPAPC.pll
PACKAGE BODY PO_APPROVE_C1
procedure EMAIL_CHECK

This is the select with the unhandled exception because the
SELECT … INTO x_emailaddress, returns TWO ROWS !!!


SELECT NVL(poh.email_address,
DECODE(FND_PROFILE.VALUE('PO_COMM_EMAIL_DEFAULT'),
'SITE', pvs.email_address,
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,
po_vendor_sites_all pvs,
po_vendor_contacts pvc
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'



EXPECTED BEHAVIOR
The email address should become updatable so the user can enter an email address of their choice.

STEPS
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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms