My Oracle Support Banner

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

Last updated on APRIL 06, 2022

Applies to:

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

Symptoms

On : 12.2.10 version,

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

 

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.