Advanced Pricing Seeded Object(s) are Invalid After R12.2.5 Upgrade ORA-00904: "QPT"."SUBSCRIPTION_TEMPLATE_ID": invalid identifier

(Doc ID 2174586.1)

Last updated on NOVEMBER 15, 2017

Applies to:

Oracle Advanced Pricing - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

Upgrading from R12.1.X to R12.2.5, there are invalid objects. Looking at errors, there is a problem with temp table, QP_PREQ_LINES_TMP_T and the column, QPT.SUBSCRIPTION_TEMPLATE_ID.


NAME
------------------------------
TEXT
--------------------------------------------------------------------------------
QP_NPREQ_LINES_TMP
ORA-00904: "QPT"."SUBSCRIPTION_TEMPLATE_ID": invalid identifier

CREATE OR REPLACE FORCE VIEW "APPS"."QP_NPREQ_LINES_TMP" ("REQUEST_TYPE_CODE", "LINE_ID", "LINE_INDEX", "LINE_TYPE_CODE", "PRICING_EFFECTIVE_DATE", "LINE_QUANTITY", "LINE_UOM_CODE", "PRICED_QUANTITY", "PRICED_UOM_CODE", "UOM_QUANTITY", "CURRENCY_CODE", "UNIT_PRICE", "PERCENT_PRICE", "ADJUSTED_UNIT_PRICE", "PARENT_PRICE", "PARENT_QUANTITY", "PARENT_UOM_CODE", "PROCESSING_ORDER", "PROCESSED_FLAG", "PROCESSED_CODE", "PRICE_FLAG", "PRICING_STATUS_CODE", "PRICING_STATUS_TEXT", "START_DATE_ACTIVE_FIRST", "ACTIVE_DATE_FIRST_TYPE", "START_DATE_ACTIVE_SECOND", "ACTIVE_DATE_SECOND_TYPE", "GROUP_QUANTITY", "GROUP_AMOUNT", "LINE_AMOUNT", "ROUNDING_FLAG", "ROUNDING_FACTOR", "UPDATED_ADJUSTED_UNIT_PRICE", "PRICE_REQUEST_CODE", "HOLD_CODE", "HOLD_TEXT", "PRICE_LIST_HEADER_ID", "VALIDATED_FLAG", "QUALIFIERS_EXIST_FLAG", "PRICING_ATTRS_EXIST_FLAG", "PRIMARY_QUALIFIERS_MATCH_FLAG", "USAGE_PRICING_TYPE", "LINE_CATEGORY", "CONTRACT_START_DATE", "CONTRACT_END_DATE", "LINE_UNIT_PRICE", "REQUEST_ID", "PROCESS_STATUS", "EXTENDED_PRICE", "ORDER_UOM_SELLING_PRICE", "CATCHWEIGHT_QTY", "ACTUAL_ORDER_QUANTITY", "HEADER_ID", "PRICING_EVENT", "CALCULATE_FLAG", "SIMULATION_FLAG", "GSA_CHECK_FLAG", "GSA_DUP_CHECK_FLAG", "MANUAL_DISCOUNT_FLAG", "SOURCE_ORDER_AMOUNT_FLAG", "MANUAL_ADJUSTMENTS_CALL_FLAG", "GET_FREIGHT_FLAG", "VIEW_CODE", "CHECK_CUST_VIEW_FLAG", "FULL_PRICING_CALL", "USE_MULTI_CURRENCY", "USER_CONVERSION_RATE", "USER_CONVERSION_TYPE", "FUNCTION_CURRENCY", "LIST_PRICE_OVERRIDE_FLAG", "CHARGE_PERIODICITY_CODE", "SERVICE_DURATION", "SERVICE_PERIOD", "SUBSCRIPTION_SERVICE_FLAG", "SUBSCRIPTION_TEMPLATE_ID") AS
SELECT QPT.REQUEST_TYPE_CODE,QPT.LINE_ID,QPT.LINE_INDEX,QPT.LINE_TYPE_CODE,QPT.PRICING_EFFECTIVE_DATE,QPT.LINE_QUANTITY,QPT.LINE_UOM_CODE,QPT.PRICED_QUANTITY,QPT.PRICED_UOM_CODE,QPT.UOM_QUANTITY,QPT.CURRENCY_CODE,QPT.UNIT_PRICE,QPT.PERCENT_PRICE,QPT.ADJUSTED_UNIT_PRICE,QPT.PARENT_PRICE,QPT.PARENT_QUANTITY,QPT.PARENT_UOM_CODE,QPT.PROCESSING_ORDER,QPT.PROCESSED_FLAG,QPT.PROCESSED_CODE,QPT.PRICE_FLAG,QPT.PRICING_STATUS_CODE,QPT.PRICING_STATUS_TEXT,QPT.START_DATE_ACTIVE_FIRST,QPT.ACTIVE_DATE_FIRST_TYPE,QPT.START_DATE_ACTIVE_SECOND,QPT.ACTIVE_DATE_SECOND_TYPE,QPT.GROUP_QUANTITY,QPT.GROUP_AMOUNT,QPT.LINE_AMOUNT,QPT.ROUNDING_FLAG,QPT.ROUNDING_FACTOR,QPT.UPDATED_ADJUSTED_UNIT_PRICE,QPT.PRICE_REQUEST_CODE,QPT.HOLD_CODE,QPT.HOLD_TEXT,QPT.PRICE_LIST_HEADER_ID,QPT.VALIDATED_FLAG,QPT.QUALIFIERS_EXIST_FLAG,QPT.PRICING_ATTRS_EXIST_FLAG,QPT.PRIMARY_QUALIFIERS_MATCH_FLAG,QPT.USAGE_PRICING_TYPE,QPT.LINE_CATEGORY,QPT.CONTRACT_START_DATE,QPT.CONTRACT_END_DATE,QPT.LINE_UNIT_PRICE,QPT.REQUEST_ID,QPT.PROCESS_STATUS,QPT.EXTENDED_PRICE,QPT.ORDER_UOM_SELLING_PRICE,QPT.CATCHWEIGHT_QTY,QPT.ACTUAL_ORDER_QUANTITY,QPT.HEADER_ID,QPT.PRICING_EVENT,QPT.CALCULATE_FLAG,QPT.SIMULATION_FLAG,QPT.GSA_CHECK_FLAG,QPT.GSA_DUP_CHECK_FLAG,QPT.MANUAL_DISCOUNT_FLAG,QPT.SOURCE_ORDER_AMOUNT_FLAG,QPT.MANUAL_ADJUSTMENTS_CALL_FLAG,QPT.GET_FREIGHT_FLAG,QPT.VIEW_CODE,QPT.CHECK_CUST_VIEW_FLAG,QPT.FULL_PRICING_CALL,QPT.USE_MULTI_CURRENCY,QPT.USER_CONVERSION_RATE,QPT.USER_CONVERSION_TYPE,QPT.FUNCTION_CURRENCY,QPT.LIST_PRICE_OVERRIDE_FLAG,QPT.CHARGE_PERIODICITY_CODE, QPT.service_duration,QPT.service_period,QPT.SUBSCRIPTION_SERVICE_FLAG,QPT.SUBSCRIPTION_TEMPLATE_ID FROM QP_PREQ_LINES_TMP_T QPT WHERE REQUEST_ID = nvl(sys_context('qp_context','request_id'),1);

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