R12.0.6: Refresh Trade Management Activities (Offers and Schedules) Errors With ORA-00903: Invalid Table Name (Doc ID 1643675.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Trade Management - Version 12.0.6 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.

Symptoms

The concurent program Refresh Trade Management Activities (Offers and Schedules) errors with the following error message:

ORA-00903: invalid table name 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,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 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 (() 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_BIND18 AND list_line_id = :FND_BIND19 and product_attribute <> 'PRICING_ATTRIBUTE1' AND excluder_flag = 'N')
ORA-00903: invalid table name 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,
object_type,object_status,object_class,object_desc,parent_id,paren

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