My Oracle Support Banner

R12 AP: 1099 Electronic Media (APTCMT) Runs For Hours and Then Fails With ORA-01555: snapshot too old (Doc ID 2233043.1)

Last updated on JANUARY 01, 2021

Applies to:

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


1099 Electronic Media (APTCMT) report performance problem.

It runs for 3+ hours and then it fails with the following error.


ORA-01555: snapshot too old: rollback segment number XX with name "XXXXXXX" too small
==> SELECT rownum C_rownum,
MSG-00020: After SRWEXIT
REP-0069: Internal error
In-process job terminated:Terminated with error:
REP-300: MSG-00003: After Get_NLS_Strings
MSG-00004: After Get_Base_Curr_Data
MSG-00008: After Get_combined_flag
MSG-00009: After delete_ap_1099_tape_data
MSG-00010: After insert_ap_1099_tape_data
MSG-00011: After perform_state_tests
MSG-00012: After perform_federal_reporting_updates
MSG-00013: After do_awt_withholding_update
MSG-00014: After clear_region_totals
MSG-00015: After update_state_totals
MSG-00016: After get_transmitter_i

INSERT INTO ap_1099_tape_data (vendor_id,region_code,misc1,misc2,misc3,misc4,mis
Program exited with status 1




The SQL Statement that is taking long time is the following:







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

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