Unexpected Error ORA-1403 ORA-6512 at POR_UTIL_PKG and AttrValException: JBO-27019 for Attribute "HdrAttachmentKey" in ReceiveItemsTxnVO When Selecting Express Receive or Receive Button after Applying Receipt Attachment Patch 19531123 (Doc ID 1983508.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle iProcurement - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

New feature of Add Attachment to iProcurement receipt as provided by Patch 19531123:R12.ICX.B works with one navigation, but gets unexpected error with two other navigations.

Users expect any of the various Receive Items navigations to work, but some are getting exception as described and preventing the user from creating the receipt using that navigation option.

ERROR
You have encountered an unexpected error.

The debug log shows the exception details

icx.por.rcv.server.ReceiveItemsTxnVORowImpl setReceiptDate.start
icx.por.rcv.util.ReceiveItemsTxnVOHelper validateDate.start
icx.por.rcv.uti.RcvUtil validateDateWithLaterJOBReleaseDate.start
icx.por.rcv.uti.RcvUtil.POR_UTIL_PKG VALIDATE_JOB_RELEASED_DATE.start
po.plsql.PO_LOG.REFRESH_LOG_FLAGS.END End of subprogram.
po.plsql.po_message_s.VALIDATE_JOB_RELEASED_DATE.1.EXCEPTION ;SQLERRM =
ORA-1403: no data found
icx.por.rcv.uti.RcvUtil "validateDateWithLaterJOBReleaseDate: Exception :
ORA-1403: no data found
ORA-6512: at ""APPS.POR_UTIL_PKG"", line 3835
ORA-6512: at line 1

fnd.framework.OAException oracle.jbo.AttrValException: JBO-27019: Get method for attribute "HdrAttachmentKey" in ReceiveItemsTxnVO could not be resolved.
fnd.framework.webui.OAPageErrorHandler OAF LOG: Event : Check Errors, in: oracle.apps.fnd.framework.webui.OAPageErrorHandler: Exception: oracle.jbo.AttrValException: JBO-27019: Get method for attribute "HdrAttachmentKey" in ReceiveItemsTxnVO could not be resolved. ,In VO: null

STEPS TO REPRODUCE

1. Method 1:
     a. Select iProcurement responsibility
     b. Click on Requisition 94162
     c. Click the Receive Button
     - get error
     You have encountered an unexpected error

2. Method 2:
     a. Select iProcurement responsibility
     b. Click on the express receive icon for 94157
     - get error
     You have encountered an unexpected error
 
3. Method 3:
     a. Select iProcurement responsibility
     b. Click on the Receiving Tab
     c. Click on the Receive Items link
     d. Select the checkbox for 94157
     e. Click the attachments icon
     f. Add attachment and click apply
     View confirmation message
     Attachment iProc Requirements Meeting Day 1 10-22-14.docx has been added successfully but not committed; it would be committed when you commit the rest of the current transaction.
     g. Click next
     h. Here you can add another attachment. For now click next.
     i. Review and Click the Submit button
     View Confirmation
     Receipt 576660 has been created for you


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