My Oracle Support Banner

How to Rewind After Error Occurs When Approving Work Confirmations - ORA-20002: 3103: Attribute 'LNOTE' Does Not Exist For Item 'WCAPPRV' (Doc ID 2699986.1)

Last updated on NOVEMBER 21, 2024

Applies to:

Oracle iSupplier Portal - Version 12.2.5 and later
Oracle iProcurement - Version 12.2.5 and later
Oracle Services Procurement - Version 12.2.5 and later
Oracle Purchasing - Version 12.2.5 and later
Information in this document applies to any platform.

Goal

After upgrade, user cannot approve work confirmations (WC) due to the following error:
  

ORA-20002: 3103: Attribute 'LNOTE' does not exist for item 'WCAPPRV/xxxxx-xxxxx'


The error happens only with work confirmations created before the upgrade.  The work confirmations created after the upgrade will not face this error.


Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.