Payables and Cash Management - EBS (MOSC)

MOSC Banner

Script tax_asset_add_sel.sql Failed With "ORA-20000: ORU-10027: Buffer Overflow

edited Jan 18, 2013 6:40AM in Payables and Cash Management - EBS (MOSC) 1 commentAnswered ✓

Script tax_asset_add_sel.sql script cancelled with "ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes" error. 
This is in support of applying patch 14273383.
README document for patch 14273383 refers to Note 1341317.1 - R12:Performance Issue with Mass Additions Create (ALL Customers).

Script tax_asset_add_sel.sql script cancelled with the error indicating buffer overflow, limit of 2000 bytes. 
I tried rerunning several times. 
Since this is a select script, I assumed it could be rerun, although I felt I needed to drop the apps.wrg_asst_add_flag_US_1 table so that it would not double up the records.

I tried rerunning tax_asset_add_sel.sql attempting to resolve the error and eventually found if I used "set  serveroutput on size 1000000", then tax_asset_add_sel.sql would finish without any errors.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center