Transaction Workbench Error: After Applying Patch 9019542: EU VAT 2010 - 11I Tax Changes, Various FRM Errors When Querying Transactions (Doc ID 1437001.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Symptoms

After <patch 9019542>, EU VAT 2010 - 11I Tax Changes, various errors are encountered when querying a transaction in the Transactions form. Following are the various types of errors encountered:

• Gap in sequence
  When changing transaction type on an existing transaction, the AR Document number is incremented even when the old and new transaction type both use the same sequence. The expectation is that the sequence should not be incremented.

• FRM-40202, FRM-41050 errors are raised in Transaction and Transaction Summary form
  These errors are raised when querying a transaction using the regular Receivables Responsibility
• FRM-41050: You cannot update this record -- error message comes up for every record in selection
  This error is raised when querying a transaction using the Receivables Inquiry Responsibility

• Error message when Crediting a Transaction

 ORA-01403: no data found
 ORA-06512: at "APPS.ARP_PROCESS_HEADER_POST_COMMIT", line 910
 ORA-06512: at "APPS.ARP_PROCESS_HEADER", line 1747
 FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-01403

Changes

Applied <patch 9019542>, EU VAT 2010 - 11I Tax Changes

Cause

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