You are browsing the archive for Order Management.

Advanced Pricing Tables

Oracle Advanced Pricing Tables:

  • QP_LIST_HEADERS_TL
  • QP_LIST_HEADER_PHASES
  • QP_LIST_LINES
  • QP_LIST_LINES_EBS_LOG
  • QP_LIST_LINES_TEMP
  • QP_PARAMETERS_B
  • QP_PARAMETERS_TL
  • QP_PARAMETER_VALUES
  • QP_PATTERNS
  • QP_PATTERN_PHASES
  • QP_PB_INPUT_HEADERS_B
  • QP_PB_INPUT_HEADERS_TL
  • QP_PB_INPUT_LINES
  • QP_PRC_CONTEXTS_B
  • QP_PRC_CONTEXTS_TL
  • QP_PREQ_LINES_TMP_T
  • QP_PREQ_LINE_ATTRS_TMP_T
  • QP_PREQ_QUAL_TMP_T
  • QP_PRICE_BOOK_ATTRIBUTES
  • QP_PRICE_BOOK_BREAK_LINES
  • QP_PRICE_BOOK_HEADERS_ALL_B
  • QP_PRICE_BOOK_HEADERS_TL
  • QP_PRICE_BOOK_LINES
  • QP_PRICE_BOOK_LINE_DETAILS
  • QP_PRICE_BOOK_MESSAGES
  • QP_PRICE_FORMULAS_B
  • QP_PRICE_FORMULAS_TL
  • QP_PRICE_FORMULA_LINES
  • QP_PRICE_REQ_SOURCES
  • QP_PRICING_ATTRIBUTES
  • QP_PRICING_ATT_EBS_LOG
  • QP_PRICING_PHASES
  • QP_PTE_REQUEST_TYPES_B
  • QP_PTE_REQUEST_TYPES_TL
  • QP_PTE_SEGMENTS
  • QP_PTE_SOURCE_SYSTEMS
  • QP_QUALIFIERS
  • QP_QUALIFIERS_EBS_LOG
  • QP_QUALIFIERS_FWK_DUMMY
  • QP_QUALIFIER_RULES
  • QP_RLTD_MODIFIERS
  • QP_RLTD_MOD_EBS_LOG
  • QP_SEGMENTS_B
  • QP_SEGMENTS_TL
  • QP_SOURCESYSTEM_FNAREA_MAP
  • QP_UI_QUERIES_TL
  • QP_UI_QUERY_COLUMNS
  • QP_UPGRADE_ERRORS
  • QP_UPG_LINES_DISTRIBUTION
OE_AGREEMENTS
OE_AGREEMENTS_B
OE_AGREEMENTS_TL
OE_ITEM_GROUPS
OE_ITEM_GROUP_LINES
OE_PRC_COPY_PARAMETERS
OE_PRC_RULE_LINE_VALUES
OE_PRICE_LISTS
OE_PRICING_CONTRACTS
OE_PRICING_RULES_B
OE_PRICING_RULES_TL
OE_PRICING_RULE_LINES
OE_RULE_FORMULA_COMPTS
QP_ADV_MOD_PRODUCTS
QP_ARCH_CRITERIA_HEADERS
QP_ARCH_CRITERIA_LINES
QP_ARCH_LIST_HEADERS_B
QP_ARCH_LIST_HEADERS_TL
QP_ARCH_LIST_LINES
QP_ARCH_PRICING_ATTRIBUTES
QP_ARCH_QUALIFIERS
QP_ARCH_RLTD_MODIFIERS
QP_ARCH_ROW_COUNTS
QP_ATTRIBUTE_DEFNS
QP_ATTRIBUTE_GROUPS
QP_ATTRIBUTE_SOURCING
QP_CACHE_DO_SIZES
QP_CACHE_KEY_STATS
QP_CACHE_STATS
QP_COUPONS
QP_CURRENCY_DETAILS
QP_CURRENCY_LISTS_B
QP_CURRENCY_LISTS_TL
QP_DEBUG_FORMULA_STEP_VALUES
QP_DEBUG_REQ
QP_DEBUG_REQ_LDETS
QP_DEBUG_REQ_LINES
QP_DEBUG_REQ_LINE_ATTRS
QP_DEBUG_REQ_RLTD_LINES
QP_DEBUG_TEXT
QP_DISCOUNT_MAPPING
QP_EVENT_PHASES
QP_FACTOR_LIST_ATTRS
QP_FORMULAS_EBS_LOG
QP_FORMULA_LN_EBS_LOG
QP_FWK_DELAYED_REQUESTS
QP_GRANTS
QP_INTERFACE_ERRORS
QP_INTERFACE_LIST_HEADERS
QP_INTERFACE_LIST_LINES
QP_INTERFACE_PRICING_ATTRIBS
QP_INTERFACE_QUALIFIERS
QP_INT_FML_STEP_VALS_T
QP_INT_LDETS_T
QP_INT_LINES_T
QP_INT_LINE_ATTRS_T
QP_INT_PROFS_T
QP_INT_RLTD_LINES_T
QP_JSESSIONS
QP_LIMITS
QP_LIMIT_ATTRIBUTES
QP_LIMIT_BALANCES
QP_LIMIT_TRANSACTIONS
QP_LIST_HEADERS_B
QP_LIST_HEADERS_EBS_LOG
QP_LIST_HEADERS_TL
QP_LIST_HEADER_PHASES
QP_LIST_LINES
QP_LIST_LINES_EBS_LOG
QP_LIST_LINES_TEMP
QP_PARAMETERS_B
QP_PARAMETERS_TL
QP_PARAMETER_VALUES
QP_PATTERNS
QP_PATTERN_PHASES
QP_PB_INPUT_HEADERS_B
QP_PB_INPUT_HEADERS_TL
QP_PB_INPUT_LINES
QP_PRC_CONTEXTS_B
QP_PRC_CONTEXTS_TL
QP_PREQ_LINES_TMP_T
QP_PREQ_LINE_ATTRS_TMP_T
QP_PREQ_QUAL_TMP_T
QP_PRICE_BOOK_ATTRIBUTES
QP_PRICE_BOOK_BREAK_LINES
QP_PRICE_BOOK_HEADERS_ALL_B
QP_PRICE_BOOK_HEADERS_TL
QP_PRICE_BOOK_LINES
QP_PRICE_BOOK_LINE_DETAILS
QP_PRICE_BOOK_MESSAGES
QP_PRICE_FORMULAS_B
QP_PRICE_FORMULAS_TL
QP_PRICE_FORMULA_LINES
QP_PRICE_REQ_SOURCES
QP_PRICING_ATTRIBUTES
QP_PRICING_ATT_EBS_LOG
QP_PRICING_PHASES
QP_PTE_REQUEST_TYPES_B
QP_PTE_REQUEST_TYPES_TL
QP_PTE_SEGMENTS
QP_PTE_SOURCE_SYSTEMS
QP_QUALIFIERS
QP_QUALIFIERS_EBS_LOG
QP_QUALIFIERS_FWK_DUMMY
QP_QUALIFIER_RULES
QP_RLTD_MODIFIERS
QP_RLTD_MOD_EBS_LOG
QP_SEGMENTS_B
QP_SEGMENTS_TL
QP_SOURCESYSTEM_FNAREA_MAP
QP_UI_QUERIES_TL
QP_UI_QUERY_COLUMNS
QP_UPGRADE_ERRORS
QP_UPG_LINES_DISTRIBUTION

Configurator Profile Options

Oracle Configurator Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
CZ_CONFIG_ENGINE_NEW_MODELS CZ: Configurator Engine for New Models
CZ_PUBLICATION_USAGE CZ: Publication Usage
CZ_DEFAULT_MAX_QTY_DEC CZ: Default Max Quantity Decimal
CZ_BOM_DEFAULT_QTY_DOMN CZ: Use BOM Default Quantity as Domain
CZ_PROCESSING_PAGE_DELAY CZ:Auto-Complete Processing Page Delay
CZ_DEV_ENABLE_CONFIG_ENGINE CZ: Enable Configurator Engine
CZ_ENABLE_SBL_ELIG_AND_COMP CZ: Enable Siebel Eligiblity and Compatibility
CZ_FCE_CORE_TRACE_DIRECTORY CZ: FCE Core Trace Directory
CZ_ADD_MODEL_ROUTING_COOKIE CZ: Add Model Routing Cookie
CZ_DEV_FCE_DEBUG_LOGIC CZ: Generate FCE Logic in Debug Mode
CZ_DEV_BOM_NODE_DISPLAY_NAME CZ: BOM Node Display Name
CZ_DEV_NON_BOM_DISPLAY_NAME CZ: Non-BOM Node Display Name
CZ_DEV_ASSOC_OBJECT_BOM_NODES CZ: BOM Structure DIsplay Method
CZ_DEV_ASSOC_OBJ_NON_BOM_NODES CZ: Non-BOM Structure Display Method
CZ_DEV_ASSOC_DISPLAY_OBJ_PATH_PG CZ: Display Object path in Edit and Read only pages
CZ_DEV_ASSOC_DISPLAY_PATH_PR_PG CZ: Display Object Path in Printable pages
CZ_DEV_STRUCT_RULE_FILTER_DATE CZ: Structure and Rules Effectivity
CZ_DEV_PREFERENCES_PARMS CZ: Custom Initialization Parameters
CZBOMTREEEXPANSIONSTATE CZ: BOM Tree Expansion State
CZ_SEGS_FOR_ITEMTYPE_NAME CZ: Create Item Type Name Method
CZGENERICBOMUIPROFILE CZ: Use Generic Configurator UI
CZ_RETR_CFG_FOR_STRUCT_CHG CZ: Use Alternate Retraction Algorithm Before Structure Changes
CZBOMHGRIDMAXCHILDROWSPERNODE CZ: Generic Configurator UI Max Child Rows
CZ_ONLY_OUTPUT_SEL_NODES CZ: Only Create CZ Config Items for Selected Nodes
CZ_DEV_EDIT_READ_ONLY_PAGE CZ: DIsplay Object Path in Edit and Read Only Pages
CZ_OUTPUT_IB_UNCHD_CHILD_ITEMS CZ: Include Unchanged Install Base Items
CZ_DEV_NUMROWS_IN_HGRID CZ: Number of Rows Displayed in Hierarchical Tables
CZ_DEV_ALLOW_FUNC_COMP_CREATION CZ: Enable Creation of Functional Companions
CZEFFECTIVITYFILTER CZ: Effectivity Date Filter
CZ_REQUIRE_LOCKING CZ: Require Locking
CZ_GENERIC_UI_TYPE CZ: Generic Configurator UI Type
CZ_ENABLE_LIST_PRICE CZ: Enable List Prices
CZ_ENABLE_SELLING_PRICE CZ: Enable Selling Prices
CZ_ENABLE_ATP CZ: Enable ATP
CZ_DISABLE_CONGIF_EXTN CZ: Disable Configurator Extensions
CZ_ENABLE_SBL_ELIG_AND_COMP_VAL_FAIL CZ: Enable Siebel Eligiblity and Compatibility Validation Failure
CZ_BV_DELTA CZ: Fail BV if Configuration Changed
CZ_SUPPRESS_BASELINE_ERRORS CZ: Suppress Baseline Errors
CZ_REPORT_ALL_BASELINE_CONFLICTS CZ: Report all Baseline Conflicts
CZ_IB_INTERFACE CZ: Configurator Install Base
CZ_IB_AUTO_EXPIRATION CZ: Auto-expire discontinued IB trackable items
CZ_SKIP_VALIDATION_PROC CZ: Skip Validation Procedure
CZ_ALLOW_GLOBAL_OPERATIONS_WITHOUT_LOCK CZ: Allow Global Operations without Locking
CZ_ALLOW_PUBLISH_TO_PRODUCTION_WHEN_LOCKED CZ: Allow Publishing in Production Mode when Locked
CZ_ALLOW_PUBLISH_TO_TEST_WHEN_LOCKED CZ: Allow Publishing in Test Mode when Locked
CZ_DEFAULT_MODEL_ACCESS CZ: Default Access for Model Creator
CZ_EDIT_MODELS_NO_LOCK CZ: Allow Edit without Locking
CZ_USE_ENTITY_ACCESS_CONTROL CZ: Use Enable Access Control
CZ_BV_FAIL_IF_INPUTS_NOT_MAINTAINED CZ: Fail BV If Input Quantities Not Maintained
CZ_DEV_NUMROWS_IN_TABLE CZ: Number of Table Rows Displayed
CZ_IMP_DECIMAL_QTY_FLAG CZ: Populate Decimal Quantity Flags
CZ_USE_SIMPLE_CONFIGURATOR CZ: Use Simple Configurator
CZ_PUBLICATION_MODE CZ: Publication Lookup Mode
CZ_DEFAULT_MAX_QTY_INT CZ: Default Max Quantity Integer

iStore Concurrent Programs

Oracle iStore Concurrent Programs

CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME
IBESERINS Concurrent Program to insert into Search table
IBEONECLK To scan thru quotes table and submit eligible Express Checkout orders.
IBEVMPAP iStore Product Autoplacement Program
IBESERSCT Concurrent program to refresh IBE_SECTION_SEARCH table.
IBEPURLOG Delete inactive records from IBE_ECR_MVLOG
IBEXUPPL Concurrent program to  Upload Price lists
IBEXDPPL Concurrent Program to Downloadt Price lists
IBEXUORD Concurrent program to  Upload Orders
IBEFACTREF iStore Reports Fact Tables Refresh
FNDRSSUB765 iStore Reports Data Refresh Set
IBEXDORD Current Program to Download Orders
IBEREFMV iStore Reports Materialized Views Refresh
IBEXDCAT Concurrent Program  Downdload catalog
IBEECRALERT iStore Reports Alerts
IBEXUCAT Concurrent Program Upload catalog
IBEORDLI Concurrent Program for Lead Import of iStore Orders
IBEXDCUS Concurrent Progarm Download Customer
IBEQTELI Concurrent Program for Lead Import of iStore Quotes
IBEVMOCM iStore Content Manager Integration Migration Program
IBE_BI_CART_ORD_REFRESH iStore DBI Cart and Order MV Refresh Program
IBE_BI_CART_REFRESH iStore DBI Carts MV Refresh Program
IBE_BI_CAT_REFRESH iStore DBI Categories MV’s Refresh Program
IBE_BI_CUST_MV_REFRESH iStore DBI New Customers MVs’ Refresh Program
IBE_BI_MSITE_MIG_PROG iStore Minisite Migration Program
IBE_BI_MSITE_REFRESH iStore DBI Minisite-Org MV Refresh Program
IBE_BI_ORDERBOM_REFRESH iStore DBI Orders Rolled up MV Refresh Program
IBE_BI_ORDERS_REFRESH iStore DBI Orders MV Refresh Program
IBE_BI_PRD_MV_REFRESH iStore DBI Products MV Refresh Program
IBE_BI_TOP_CARTS_REFRESH iStore DBI Top Carts MV Refresh Program
IBE_BI_TOP_CUST_REFRESH iStore DBI Topm Customers MV Refresh Program
IBE_BI_TOP_ORD_REFRESH iStore DBI Top Orders MV Refresh Program
IBEVMTEX iStore Template Mapping Export Program
IBEVMTIM iStore Template Mapping Import Program
IBEIBYFC To migrate Credit Card foreign key references for Primary Credit Cards and Express Checkout Preferences
IBEVSLAY Concurrent Program to Cascade Section Layout Mapping  to all children sections
IBEVSDUP Concurrent Program to Duplicate one Section