My Oracle Support Banner

Refresh Trade Management Activities Completed In Error ORA-01555: Snapshot Too Old (Doc ID 2860876.1)

Last updated on JUNE 03, 2022

Applies to:

Oracle Trade Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

Issue:

Refresh Trade Management Activities Program erroring.  This program is required as needed for Net Accrual Offers.


Error:

ORA-01555: snapshot too old: rollback segment number  with name "" too small
INSERT INTO
ozf_activity_products_temp(creation_date,created_by,last_update_date,
last_updated_by,last_update_login,confidential_flag,custom_setup_id,object_id,obje ...

ORA-01722: invalid number INSERT INTO
ozf_activity_products(activity_product_id,creation_date,created_by,last_update
_date,last_updated_by,last_update_login,confidential_flag,custom_setup_id,obje
ct_id,object_type,object_status,object_class,object_desc,parent_id,parent_clas
s,parent_desc,ask_for_flag,active_flag,source_code,currency_code,marketing_med
ium_id,start_date,end_date,items_category,item,item_type) SELECT
ozf_activity_products_s.nextval,SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.
user_id,FND_GLOBAL.conc_login_id,:FND_BIND1,:FND_BIND2,:FND_BIND3,:FND_BIND4,:
FND_BIND5,:FND_BIND6,:FND_BIND7,:FND_BIND8,:FND_BIND9,:FND_BIND10,:FND_BIND11,
:FND_BIND12,:FND_BIND13,:FND_BIND14,:FND_BIND15,:FND_BIND16,:FND_BIND17,items_
category, product_id, product_type FROM (( select null items_category,
mtl1.inventory_item_id product_id, 'PRICING_ATTRIBUTE25' product_type from
mtl_system_items mtl1,mtl_system_items mtl2



Steps:

The issue can be reproduced at will with the following steps:
1. Oracle Trade Management Administrator responsibility
2. Run program, Refresh Trade Management Activities
3. Check log for error


Business Impact
--------------------
Users are unable to run program successfully which will impact offer functionality flow.

Changes

Issue occurs after upgrade from 12.1.3 to 12.2.5 or higher.

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.