R12: OIE: ORA-00904: "NOTE_SOURCE": invalid identifier Error Occurs When Verify Receipts and Complete Audit (Doc ID 2102949.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Internet Expenses - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

After Applying Patch 10204263:R12.OIE.C receive the error, 'ORA-00904: "NOTE_SOURCE": invalid identifier' when verifying receipts and complete audit.

Steps to Reproduce

  1. Created new expense report
  2. Login as Manager and approve expense report
  3. Choose the Internet Expenses Audit Manager responsibility and query the expense report
  4. Original Receipts Package Status shows as Required
    Enter a date into the 'Original Receipts Package Received Date'
    Save
    Original Receipts Package Status now shows as Received
  5. Remove the date in the 'Original Receipts Package Received Date' field
    Save
    Original Receipts Package Status now shows as Required
  6. Enter a date again into the 'Original Receipts Package Received Date'
    Save
    Original Receipts Package Status now shows as Received

    There is no error on the Audit page.

  7. Click on Mark Receipts as Verified button.
  8. Select Complete Audit on the 'Expense Report Action' drop down
  9. Click on Apply and the following error occurs:

 



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