|
by oracleguru
NAME: Create Data Mart Analytic Workspace
SHORT CODE: QPRCREATEAW
MODULE: Oracle Deal Management
Description:
Navigation: Oracle Deal Management Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.
Report Parameters:
by oracleguru
Oracle Deal Management Profile Options
| PROFILE OPTION SHORT CODE | PROFILE OPTION NAME |
| QPR_VOL_BAND_DEAL | QPR: Volume band transformation group |
| QPR_PULL_UOM_CONV_TO_ODS | QPR: Pull UOM Conversion Rates |
| QPR_MRG_SCORE_WT | QPR: Margin Score Weight |
| QPR_INVPR_SCORE_WT | QPR: Recommended Price Score Weight |
| QPR_REPORT_ROUNDING_PRECISION | QPR : Reports Rounding Precision Type |
| QPR_CATEGORY_SET_NAME | QPR: Category Set Name |
| QPR_CONVERSION_TYPE | QPR: Conversion Type |
| QPR_CURRENCY_CODE | QPR: Currency Code |
| QPR_CUSTOMER_ATTRIBUTE | QPR: Customer Attribute |
| QPR_LOAD_NO_CURR_CON | QPR: Include Transactions without Currency Conversion |
| QPR_LOAD_NO_UOM_CON | QPR: Include Transactions without UOM Conversion |
| QPR_MASTER_ORG | QPR: Master Organization |
| QPR_QT_COMMENT_ATTRIBUTE | QPR: Attribute for Requestor Comment |
| QPR_QT_COMP_NAME_ATTRIBUTE | QPR: Attribute for Competitor Name |
| QPR_QT_COMP_PRIC_ATTRIBUTE | QPR: Attribute for Competitor Price |
| QPR_MODEL_COST_MRG_PERC | QPR: Default Cost Allocation to Base Model |
| QPR_DEAL_DIFF_MODIFIER | QPR: Price Difference Modifier |
| QPR_DEFAULT_POLICY | QPR: Default Pricing Policy |
| QPR_INTERNAL_CUST | QPR: Collect Internal Customers |
| QPR_ATRANSF_FUNC | QPR: Transformation Function for Recommended Price Derivation |
| QPR_PARAM_FUNC | QPR: Argument for Transformation Function |
| QPR_TRANSF_FUNC | QPR: Transformation Function for Regression |
| QPR_CURRENT_INSTANCE | QPR: Instance Id of this Server |
| QPR_PN_DBLINK | QPR: DB link to Price Negotiation server |
| QPR_PN_URL | QPR: Price Negotiation Web server |
| QPR_ALLOC_MDL_HIST_COST | QPR: Allocate Historical cost to Model/Option class |
| QPR_ALLOW_VOL_UPD | QPR: Allow Volume update in Deal |
| QPR_PULL_CURR_CONV_TO_ODS | QPR: Pull Currency Conversion Rates |
by oracleguru
Oracle Deal Management Concurrent Programs
| CONCURRENT PROGRAM SHORT CODE | CONCURRENT PROGRAM NAME |
| QPRUCCRB | Collect Currency Rates |
| QPRREPDSBCP | Generate Default Dashboard And Reports For Datamart |
| QPRUC2AWB | Create Price Plan/ Data Mart Analytic Workspace |
| QPRUCTMGRE | Build Gregorean Calendar |
| QPRUCTMB | Collect Time Data based on Fiscal Calendar |
| QPRUCPPB | Copy Price Plan/Data Mart Definition |
| QPRUCAWB | Create Price Plan/ Data Mart Analytic Workspace Template |
| QPRUFMDB | Collect Measure Data |
| QPRUPOLB | Evaluate transactions against Pricing Policies |
| QPRUMNTB | Load data to Pricing Datamart |
| QPRUDAWB | Delete Price Plan/Data Mart Analytic Workspace |
| QPRUDLDB | Collect Dimensions Data |
| QPRUTRNB | Perform Dimension to Dimension Transformation |
| QPRUTRNBM | Perform Measure to Dimension Transformation |
| QPRUSPLCOST | Collect Cost data from Oracle Costing |
| QPRUSPLOAD | Collect off-invoice adjustments data from Oracle Receivables |
| QPRUCUMB | Collect UOM Conversions |
| QPRURGRB | Determine Regression Coefficients for Pricing Segments |
| QPRUSPLBM | Consolidate and Update Transaction Data |
| QPRUFMDQT | Submit Pricing Review Request from Quoting |
| QPRUFMDOQ | Submit Pricing Review Request from Order Management |
| QPRUDPRB | Process Quote Request |
| QPRUDODBD | Purge Dimension Data from Interface tables |
| QPRUDODBM | Purge Measure Transaction data from Interface tables |
| QPRDEMOB | Create Demo Data |
| QPRSPLPSG | Evaluate transactions to determine Pricing Segments |
| QPRCREATEAW | Create Data Mart Analytic Workspace |