My Oracle Support Banner

Refresh Trade Management Activities Completed In Error "ORA-01722: invalid number INSERT INTO OZF_ACTIVITY_PRODUCTS" (Doc ID 2853214.1)

Last updated on MARCH 04, 2022

Applies to:

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

Symptoms

On : 12.2.10 version, Budget Concurrent Requests

The Refresh Trade Management Activities completed in following error



ERROR
-----------------------
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,object_id,object_type,object_status,object_class,object_desc,parent_id,parent_class,parent_desc,ask_for_flag,active_flag,source_code,currency_code,marketing_medium_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

where 1=1

and mtl1.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')

and mtl1.organization_id=mtl2.organization_id

and mtl1.item_type='NDC'

and mtl2.item_type='BRAND_NAME'

and mtl1.attribute1=mtl2.segment1 AND mtl2.inventory_item_id = :FND_BIND18) UNION ALL SELECT distinct null items_category, to_number(decode(product_attr_value,'ALL','-9999',product_attr_value)) product_id, product_attribute product_type FROM qp_pricing_attributes WHERE list_header_id = :FND_BIND19 and product_attribute <> 'PRICING_ATTRIBUTE1' AND excluder_flag = 'N')




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Applications
2. Go to Oracle Trade Management responsibility
3. Navigate to Offers page and make changes and also end dated some unused brands
4.Run the Refresh Trade Management ActiviItes (Offers and Schedules) program



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.