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 FEBRUARY 13, 2017

Applies to:

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

Symptoms



1099 Electronic Media (APTCMT) report performance problem.

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

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:

 

 

 




Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms