Script tax_asset_add_sel.sql Failed With "ORA-20000: ORU-10027: Buffer Overflow
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.