My Oracle Support Banner

R12: AP: Data Fix Script ap_undo_cmplt_inv.sql Ends in Error (Doc ID 2380852.1)

Last updated on APRIL 16, 2018

Applies to:

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

Symptoms

On : 12.1.3 version, EB Tax

Invoice went on hold even when it was already validated and paid.
Now when trying to validate again , it went on distribution hold and is giving frozen distribution error.

To solve the issue, you executed script ap_undo_cmplt_inv.sql to undo accounting of the invoice,
and got the following error:
[[
 ORA-06550: line 4, column 53:
 PLS-00103: Encountered the symbol "3" when expecting one of the following:

  . ( * @ % & = - + ; < / > at in is mod remainder not rem
   <> or != or ~= >= <= <> and or like like2
  like4 likec between || multiset member submultiset
 The symbol "*" was substituted for "3" to continue.
]]

Changes

 

Cause

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
Symptoms
Changes
Cause
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.