This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.
The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend
This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.
Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.
| Description: |
|---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Index | Type | Tablespace | Column |
|---|---|---|---|
| FPA_OBJECTS_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
OBJECT
ID NAME LANGUAGE ZD_EDITION_NAME |
| FPA_OBJECTS_TL_N1 | NONUNIQUE | APPS_TS_TX_IDX | ID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| OBJECT | VARCHAR2 | (30) | Y | Object type |
| ID | NUMBER | (15) | Y | Object ID |
| NAME | VARCHAR2 | (80) | Object name | |
| DESCRIPTION | VARCHAR2 | (240) | Object description | |
| LANGUAGE | VARCHAR2 | (4) | Y | Object language |
| SOURCE_LANG | VARCHAR2 | (4) | Y | Source language for the object |
| CREATED_BY | NUMBER | (15) | Y | Standard Who column |
| CREATION_DATE | DATE | Y | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column |
| LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
FPA.FPA_OBJECTS_TL does not reference any database object
FPA.FPA_OBJECTS_TL is referenced by following:
| Description: |
|---|
Stores all translatable data for Strategic Criteria Objectives.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PROJECT_ID | NUMBER | Y | Project Identifier | |
| STRATEGIC_OBJ_ID | NUMBER | Y | Strategic Objective Identifier | |
| COMMENTS | VARCHAR2 | (2000) | Comments | |
| LANGUAGE | VARCHAR2 | (4) | Y | Translated language |
| SOURCE_LANG | VARCHAR2 | (4) | Y | Source language |
| CREATED_BY | NUMBER | (15) | Y | Standard Who column |
| CREATION_DATE | DATE | Y | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column |
| LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| SCENARIO_ID | NUMBER | Scenario Identifier |
FPA.FPA_SCORECARDS_TL does not reference any database object
FPA.FPA_SCORECARDS_TL is referenced by following:
| Description: |
|---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| VALIDATION_ID | NUMBER | (15) | Y | Validation Identifier |
| HEADER_ID | NUMBER | (15) | Header Identifier | |
| OBJECT_ID | NUMBER | (15) | Y | Object Identifier |
| OBJECT_TYPE | VARCHAR2 | (30) | Object type | |
| VALIDATION_TYPE | VARCHAR2 | (30) | Y | Validation type |
| MESSAGE_ID | VARCHAR2 | (30) | Message Identifier | |
| SEVERITY | VARCHAR2 | (1) | Severity | |
| CREATED_BY | NUMBER | (15) | Y | Standard Who column |
| CREATION_DATE | DATE | Y | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column |
| LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who column |
FPA.FPA_VALIDATION_LINES does not reference any database object
FPA.FPA_VALIDATION_LINES is referenced by following:
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CALENDAR_NAME | VARCHAR2 | (30) | ||
| PERIOD_TYPE | VARCHAR2 | (30) | ||
| CAL_HIERARCHY_NAME | VARCHAR2 | (55) |
APPS.FPA_AW_CALENDARS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_AW_INV_CRITERIA_INFO_V I s a view containing Strategic Criteria information: hierarchical, level within hierarchy, status and weight.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| STRATEGIC_OBJ | NUMBER | Investment Criteria IDs | ||
| STRATEGIC_OBJ_PARENT | NUMBER | Parent ID for the Investment Criteria | ||
| STRATEGIC_OBJ_LEVEL | VARCHAR2 | (30) | Investment Criteria Objective Level : Group/Inidividual/Category/Root | |
| STRATEGIC_OBJ_STATUS | VARCHAR2 | (30) | Flag to determine if its deletable objective | |
| STRATEGIC_OBJ_WEIGHT | NUMBER | Investment Criteria weights in % |
APPS.FPA_AW_INV_CRITERIA_INFO_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| STRATEGIC_OBJ | NUMBER | Investment Criteria ID | ||
| STRATEGIC_OBJ_PARENT | NUMBER | Parent ID for the Investment Criteria |
APPS.FPA_AW_INV_CRITERIA_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_AW_PCLASS_FIN_METRICS_V is a view containing financial metric data at the Scenario and Class Category level.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CLASS_CODE | NUMBER | Class code | ||
| SCENARIO | NUMBER | Scenario ID | ||
| FUNDS_AVAILABLE | NUMBER | Funds available | ||
| FUNDS_REQUIRED | NUMBER | Funds required | ||
| FUNDING_VARIANCE | NUMBER | Funding variance | ||
| TOTAL_BENEFIT | NUMBER | Total benefit | ||
| NET_PRESENT_VALUE | NUMBER | Net Present Value | ||
| INTERNAL_RATE_RETURN | NUMBER | Internal Rate of Return | ||
| RETURN_ON_INV | NUMBER | Return on Investment | ||
| PAYBACK_PERIOD | NUMBER | Payback Period | ||
| SCE_CLASS_CODE_VALID | NUMBER | Valid scenario class code flag |
APPS.FPA_AW_PCLASS_FIN_METRICS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CLASS_CODE | NUMBER | Class Codes | ||
| SCENARIO | NUMBER | Scenario Identifier | ||
| PLANNING_CYCLE | NUMBER | Planning Cycle Identifier | ||
| FUNDS_AVAILABLE | NUMBER | Funds available | ||
| FUNDS_REQUIRED | NUMBER | Funds required | ||
| FUNDING_VARIANCE | NUMBER | Funding Variance | ||
| TOTAL_BENEFIT | NUMBER | Total benefit | ||
| SCE_CLASS_CODE_VALID | NUMBER | Valid Scenario Class code combination flag |
APPS.FPA_AW_PCLASS_FUNDS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_AW_PCLASS_STR_SCORES_V is a view containg Strategic Criteria Objective data at the Scenario Class Code level
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CLASS_CODE | NUMBER | Class Code | ||
| SCENARIO | NUMBER | Scenario ID | ||
| PLANNING_CYCLE | NUMBER | Planning Cycle ID | ||
| INVESTMENT_CRITERIA | NUMBER | Investment Criteria ID | ||
| WEIGHTED_SCORE | NUMBER | Weighted Score | ||
| COST_WEIGHTED_SCORE | NUMBER | Cost Weighted Score | ||
| SCE_CLASS_CODE_VALID | NUMBER | Valid scenario class code flag |
APPS.FPA_AW_PCLASS_STR_SCORES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PLANNING_CYCLE | NUMBER | Planning Cycle ID | ||
| PORTFOLIO | NUMBER | Portfolio ID for the Planning Cycle ID |
APPS.FPA_AW_PCS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PLANNING_CYCLE | NUMBER | Planning Cycle ID | ||
| PC_DISCOUNT_RATE | NUMBER | Discount Rate for the Planning Cycle | ||
| PC_FUNDING | NUMBER | Funds Available for the Planning Cycle | ||
| PC_DISPLAY_FACTOR | VARCHAR2 | (30) | Display Factor for all financial fields in the Planning Cycle |
APPS.FPA_AW_PC_DISC_FUNDS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_AW_PC_FINANCIAL_TARGETS_V is a view containing Financial Targets data for Planning Cycles.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PLANNING_CYCLE | NUMBER | Planning Cycle ID | ||
| FINANCIAL_METRICS | VARCHAR2 | (30) | Financial Metrics like NPV/ IRR/ PAYBACKPERIOD/ ROI | |
| FINANCIAL_TARGET_FROM | NUMBER | Targets From range for Financial Metrics | ||
| FINANCIAL_TARGET_TO | NUMBER | Targets To range for Financial Metrics |
APPS.FPA_AW_PC_FINANCIAL_TARGETS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PLANNING_CYCLE | NUMBER | Planning Cycle ID | ||
| PORTFOLIO | NUMBER | Portfolio ID for the Planning Cycle | ||
| PC_STATUS | VARCHAR2 | (30) | Status of Planning Cycle | |
| CALENDAR_NAME | VARCHAR2 | (80) | Name of the Calendar | |
| PERIOD_TYPE | VARCHAR2 | (80) | Period Type for the Calendar | |
| SUBMISSION_DUE_DATE | DATE | Planning Cycle Submission Due Date | ||
| INITIATE_DATE | DATE | Planning Cycle Initiation Date | ||
| CONVERSION_RATE_DATE | DATE | Date of Currency Conversion | ||
| CURRENCY_CODE | VARCHAR2 | (30) | Currency Code | |
| CONVERSION_RATE_TYPE | VARCHAR2 | (30) | Conversion Rate Type | |
| FUNDING_PERIOD_FROM | VARCHAR2 | (30) | Funding Period From - for the Calendar and Period Type combination | |
| FUNDING_PERIOD_TO | VARCHAR2 | (30) | Funding Period to - for the Calendar and Period Type combination | |
| EFFECTIVE_PERIOD_TO | VARCHAR2 | (30) | Effective Period To - for Calendar and Period Type combination | |
| PC_CATEGORY | NUMBER | Investment Class Category | ||
| SCENARIO_COUNT | NUMBER | Number of scenarios present in the Planning Cycle | ||
| LAST_APPROVED_FLAG | NUMBER | Last approved Planning Cycle in the Portfolio | ||
| LAST_FLAG | NUMBER | Last Planning Cycle in the Portfolio | ||
| CAL_PERIOD_TYPE | VARCHAR2 | (60) | Calendar and Period Type combination |
APPS.FPA_AW_PC_INFO_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_AW_PC_INV_CRITERIA_V is a view containing Strategic Criteria Objective data for Planning Cycles.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PLANNING_CYCLE | NUMBER | Planning Cycle ID | ||
| INVESTMENT_CRITERIA | NUMBER | Investment Criteria ID | ||
| IS_VALID_PC_INV_CRITERIA | NUMBER | Valid PC Investment Criteria flag | ||
| PC_INV_CRITERIA_WEIGHT | NUMBER | Investment Criteria weight | ||
| PC_INV_CRIT_SCORE_TARGET_FROM | NUMBER | Target Score from | ||
| PC_INV_CRIT_SCORE_TARGET_TO | NUMBER | Target Score to |
APPS.FPA_AW_PC_INV_CRITERIA_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PLANNING_CYCLE | NUMBER | Planning Cycle ID | ||
| INVESTMENT_CRITERIA | NUMBER | Investment Criteria ID | ||
| IS_VALID_PC_INV_CRITERIA | NUMBER | Valid PC Investment Criteria flag | ||
| PC_INV_CRITERIA_WEIGHT | NUMBER | Investment Criteria Weight | ||
| PC_INV_CRIT_SCORE_TARGET_FROM | NUMBER | Target Score From | ||
| PC_INV_CRIT_SCORE_TARGET_TO | NUMBER | Target Score To |
APPS.FPA_AW_PC_INV_CRIT_SETUP_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_AW_PC_INV_MATRICES_V is a view containing Investment Mix targets for Planning Cycles.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PLANNING_CYCLE | NUMBER | Planning Cycle ID | ||
| PC_CATEGORY | NUMBER | Investment Mix Class Category | ||
| CLASS_CODE | NUMBER | Investment Mix Class Codes | ||
| INVESTMENT_MIX | NUMBER | Investment Mix Fund percentage | ||
| IS_VALID_PC_CLASS_CODE | NUMBER | Valid PC Class code flag |
APPS.FPA_AW_PC_INV_MATRICES_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_AW_PC_PROJECTS_V is a view containing projects collected in Planning Cycles
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PLANNING_CYCLE | NUMBER | Planning Cycle ID | ||
| PROJECT | NUMBER | Project ID |
APPS.FPA_AW_PC_PROJECTS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_AW_PC_SCORE_INFO_V is a view containing score information for Planning Cycles. Score source and score scale.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PLANNING_CYCLE | NUMBER | Planning Cycle ID | ||
| PC_PROJECT_SCORE_SOURCE | VARCHAR2 | (30) | Project Score Source | |
| PC_PROJECT_SCORE_SCALE | NUMBER | Project Score Scale |
APPS.FPA_AW_PC_SCORE_INFO_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CAL_HIER | VARCHAR2 | (30) | ||
| PERIOD | VARCHAR2 | (30) | ||
| PERIOD_PARENT | VARCHAR2 | (30) | ||
| PERIOD_NUMBER | NUMBER | (15) | ||
| START_DATE | DATE | |||
| END_DATE | DATE |
APPS.FPA_AW_PERIOD_ATTS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PORTFOLIO | NUMBER |
APPS.FPA_AW_PORTFS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_AW_PORTF_HEADERS_V is a view containing Portfolio information. Owner, Organization and Class Category.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PORTFOLIO | NUMBER | Portfolio ID | ||
| OWNER | NUMBER | Owner ID | ||
| PORTFOLIO_ORGANIZATION | NUMBER | Portfolio Organization | ||
| PORTFOLIO_CLASS_CODE | NUMBER | Portfolio Class Code |
APPS.FPA_AW_PORTF_HEADERS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_AW_PROJECT_SETS_V is a view containing the Project Set Ids being used by Portfolios.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PORTFOLIO | NUMBER | Portfolio identifier | ||
| INIT_PROJECT_SET_ID | NUMBER | Initial Project Set ID for the given portfolio | ||
| APPR_PROJECT_SET_ID | NUMBER | Approved Project Set ID for the given portfolio |
APPS.FPA_AW_PROJECT_SETS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_AW_PROJS_V is a view containing Project information, its class code, its Portfolio and the Planning Cycles where it has been collected.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PROJECT | NUMBER | Unique identifier for Projects | ||
| CLASS_CODE | NUMBER | Class Code | ||
| PORTFOLIO | NUMBER | Portfolio ID for the project | ||
| PLANNING_CYCLE | NUMBER | Planning Cycle ID for the project |
APPS.FPA_AW_PROJS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_AW_PROJ_CASHFLOWS_V is a view containing financial information at the Scenario Project level.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PROJECT | NUMBER | Project Identifier | ||
| CLASS_CODE | NUMBER | Class code | ||
| SCENARIO | NUMBER | Scenario identifier | ||
| FUNDS_REQUIRED | NUMBER | Funds required | ||
| TOTAL_BENEFIT | NUMBER | Total benefit | ||
| SUNK_COST | NUMBER | Sunk cost | ||
| TOTAL_COST | NUMBER | Total cost | ||
| CURRENT_FUNDING_STATUS | NUMBER | Current funding status | ||
| RECOMMENDED_FUNDING_STATUS | VARCHAR2 | (30) | Recommended funding status | |
| USER_RANK | VARCHAR2 | (30) | User ranks | |
| SCENARIO_PROJECT_VALID | NUMBER | Valid scenario project combination flag |
APPS.FPA_AW_PROJ_CASHFLOWS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_AW_PROJ_FIN_METRICS_V is a view containing financial information at the Scenario Project level.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PROJECT | NUMBER | Unique identifier for Projects | ||
| CLASS_CODE | NUMBER | Class Code | ||
| SCENARIO | NUMBER | Scenario ID | ||
| FUNDS_REQUIRED | NUMBER | Funds required | ||
| TOTAL_BENEFIT | NUMBER | Total benefit | ||
| SUNK_COST | NUMBER | Sunk cost | ||
| TOTAL_COST | NUMBER | Total cost | ||
| USER_RANK | NUMBER | User rank | ||
| NET_PRESENT_VALUE | NUMBER | Net Present Value | ||
| INTERNAL_RATE_RETURN | NUMBER | Internal Rate of Return | ||
| RETURN_ON_INV | NUMBER | Return on Investment | ||
| FIN_PERCENTILE | NUMBER | Financial Percentile | ||
| STR_PERCENTILE | NUMBER | Strategic Percentile | ||
| RISK_PERCENTILE | NUMBER | Risk Percentile | ||
| INVESTMENT_INDEX | NUMBER | Investment Index | ||
| PAYBACK_PERIOD | NUMBER | Payback Period | ||
| RECOMMENDED_FUNDING_STATUS | VARCHAR2 | (30) | Recommended Funding Status | |
| CURRENT_FUNDING_STATUS | VARCHAR2 | (30) | Current Funding Status | |
| SCENARIO_PROJECT_VALID | NUMBER | Valid Scenario Project combination flag |
APPS.FPA_AW_PROJ_FIN_METRICS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_AW_PROJ_INFO_V is a view containing Funding Status at the Scenario Project level.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PROJECT | NUMBER | Unique project identifier | ||
| SCENARIO | NUMBER | Scenario identifier | ||
| RECOMMENDED_FUNDING_STATUS | VARCHAR2 | (30) | Recommended funding status | |
| CURRENT_FUNDING_STATUS | VARCHAR2 | (30) | Current funding status | |
| SCENARIO_PROJECT_VALID | NUMBER | Valid scenario project combination flag |
APPS.FPA_AW_PROJ_INFO_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_AW_PROJ_INV_CRITERIA_V is a view containing Strategic Criteria Objective data at Scenario Project level.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PLANNING_CYCLE | NUMBER | Planning Cycle identifier | ||
| PROJECT | NUMBER | Project identifier | ||
| INVESTMENT_CRITERIA | NUMBER | Investment Criteria Identifier | ||
| WEIGHT_PERCENT | NUMBER | Weight in percentage | ||
| WEIGHT_SCORE | NUMBER | Weighted Score | ||
| APPROVED_SCORE | NUMBER | Approved score | ||
| NEW_SCORE | NUMBER | New Score | ||
| CRITERIA_LEVEL | VARCHAR2 | (30) | Investment Criteria level | |
| IS_VALID_INV_CRITERIA | NUMBER | Valid Investment criteria flag |
APPS.FPA_AW_PROJ_INV_CRITERIA_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PROJECT | NUMBER | |||
| SCENARIO | NUMBER | |||
| NET_PRESENT_VALUE | NUMBER | |||
| SCENARIO_PROJECT_VALID | NUMBER |
APPS.FPA_AW_PROJ_NPVS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_AW_PROJ_STR_SCORES_V is a view containing strategic scores at the Scenario Project level.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PROJECT | NUMBER | Project Identifier | ||
| SCENARIO | NUMBER | Scenario Identifier | ||
| PLANNING_CYCLE | NUMBER | Planning Cycle Identifier | ||
| INVESTMENT_CRITERIA | NUMBER | Investment Criteria ID | ||
| CRITERIA_LEVEL | VARCHAR2 | (30) | Investment Criteria Level | |
| WEIGHTED_SCORE | NUMBER | Weighted scores | ||
| NEW_SCORE | NUMBER | New Score | ||
| SCE_PROJECT_VALID | NUMBER | Valid Scenario Project flag |
APPS.FPA_AW_PROJ_STR_SCORES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CAL_HIER | VARCHAR2 | (30) | ||
| QUARTER | VARCHAR2 | (30) | ||
| QUARTER_PARENT | VARCHAR2 | (30) | ||
| QUARTER_NUMBER | NUMBER | (15) | ||
| START_DATE | DATE |
APPS.FPA_AW_QUARTER_ATTS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_AW_SCES_V is a view containing Scenario to Planning Cycle assignments.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SCENARIO | NUMBER | Scenario Identifier | ||
| PLANNING_CYCLE | NUMBER | Planning Cycle Identifier |
APPS.FPA_AW_SCES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SCENARIO | NUMBER | |||
| FUNDS_REQUIRED | NUMBER | |||
| TOTAL_BENEFIT | NUMBER | |||
| SUNK_COST | NUMBER | |||
| TOTAL_COST | NUMBER |
APPS.FPA_AW_SCE_CASHFLOWS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_AW_SCE_FIN_METRICS_V is a view containg Financial Metric data at the Scenario level.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SCENARIO | NUMBER | Scenario Identifier | ||
| PLANNING_CYCLE | NUMBER | Planning Cycle Identifier | ||
| RECOMMENDED_FLAG | NUMBER | Scenario recommended flag | ||
| APPROVED_FLAG | NUMBER | Scenario approved flag | ||
| IS_INITIAL_SCENARIO | NUMBER | Is initial scenario flag | ||
| IS_WORKING_SCENARIO | NUMBER | Is working scenario flag | ||
| DISCOUNT_RATE | NUMBER | Discount rate | ||
| FUNDS_AVAILABLE | NUMBER | Funds available | ||
| FUNDS_REQUIRED | NUMBER | Funds required | ||
| FUNDING_VARIANCE | NUMBER | Funding variance | ||
| PLANNED_BENEFIT | NUMBER | Planned benefit | ||
| NET_PRESENT_VALUE | NUMBER | Net Present Value | ||
| INTERNAL_RATE_RETURN | NUMBER | Internal Rate of Return | ||
| PAYBACK_PERIOD | NUMBER | Payback period | ||
| RETURN_ON_INV | NUMBER | Return on Investment |
APPS.FPA_AW_SCE_FIN_METRICS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_AW_SCE_FUNDS_V is a view containing Funding information at the Scenario level.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SCENARIO | NUMBER | Scenario Identifier | ||
| PLANNING_CYCLE | NUMBER | Planning Cycle Identifier | ||
| FUNDS_AVAILABLE | NUMBER | Funds available | ||
| FUNDS_REQUIRED | NUMBER | Funds required | ||
| FUNDING_VARIANCE | NUMBER | Funding variance |
APPS.FPA_AW_SCE_FUNDS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_AW_SCE_INFO_V is a view containing basic information on Scenarios.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SCENARIO | NUMBER | Unique Scenario Identifier | ||
| PLANNING_CYCLE | NUMBER | Planning Cycle Identifier | ||
| RECOMMENDED_FLAG | NUMBER | Recommended flag | ||
| APPROVED_FLAG | NUMBER | Approved flag | ||
| IS_INITIAL_SCENARIO | NUMBER | Is initial scenario flag | ||
| IS_WORKING_SCENARIO | NUMBER | Is working scenario flag | ||
| DISCOUNT_RATE | NUMBER | Discount rate | ||
| FUNDS_AVAILABLE | NUMBER | Funds available | ||
| FUNDS_REQUIRED | NUMBER | Funds required |
APPS.FPA_AW_SCE_INFO_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SCENARIO | NUMBER | |||
| DISCOUNT_RATE | NUMBER | |||
| NET_PRESENT_VALUE | NUMBER |
APPS.FPA_AW_SCE_NPVS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_AW_SCE_STR_SCORES_V is a view containing Strategic Score information at the Scenario level.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SCENARIO | NUMBER | Scenario Identifier | ||
| PLANNING_CYCLE | NUMBER | Planning Cycle Identifier | ||
| INVESTMENT_CRITERIA | NUMBER | Investment Criteria ID | ||
| WEIGHTED_SCORE | NUMBER | Weighted score | ||
| COST_WEIGHTED_SCORE | NUMBER | Cost weighted score |
APPS.FPA_AW_SCE_STR_SCORES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CAL_HIER | VARCHAR2 | (30) | ||
| YEAR | VARCHAR2 | (30) | ||
| YEAR_NUMBER | NUMBER | (15) | ||
| START_DATE | DATE |
APPS.FPA_AW_YEAR_ATTS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_BUDGET_FORECAST_INFO_V is a view containg Financial Plan information for Projects.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORG_ID | NUMBER | (15) | Y | Organization Identifier |
| PROJECT_ID | NUMBER | (15) | Y | Project Identifier |
| VERSION_ID | NUMBER | (15) | Y | Version ID |
| BUDGET_TYPE_CODE | VARCHAR2 | (30) | Budget type code | |
| PERIOD_START_DATE | DATE | Y | Period start date | |
| BURDENED_COST | NUMBER | Burdened cost | ||
| REVENUE | NUMBER | Revenue |
APPS.FPA_BUDGET_FORECAST_INFO_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_INV_CRITERIA_VL is a view containing translatable data for Investment Criteria Objectives.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| STRATEGIC_OBJ | NUMBER | Investment Criteria Identifier | ||
| NAME | VARCHAR2 | (80) | Investment Criteria name | |
| DESCRIPTION | VARCHAR2 | (240) | Investment Criteria description | |
| CREATED_BY | NUMBER | (15) | Y | Created by |
| CREATION_DATE | DATE | Y | Creation date | |
| LAST_UPDATED_BY | NUMBER | (15) | Y | Last updated by |
| LAST_UPDATE_DATE | DATE | Y | Last update date | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Last update login |
APPS.FPA_INV_CRITERIA_VL is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LOOKUP_TYPE | VARCHAR2 | (30) | Y | Lookup type |
| LOOKUP_CODE | VARCHAR2 | (30) | Y | Lookup code |
| MEANING | VARCHAR2 | (80) | Y | Lookup meaning |
| DESCRIPTION | VARCHAR2 | (240) | Description | |
| ENABLED_FLAG | VARCHAR2 | (1) | Y | Enabled flag |
| START_DATE_ACTIVE | DATE | Active start date | ||
| END_DATE_ACTIVE | DATE | Active end date | ||
| TAG | VARCHAR2 | (150) | Tag order |
APPS.FPA_LOOKUPS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_PCS_VL is a view containing translatable data for Planning Cycles.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PLANNING_CYCLE | NUMBER | Planning Cycle Identifier | ||
| NAME | VARCHAR2 | (80) | Planning Cycle name | |
| DESCRIPTION | VARCHAR2 | (240) | Planning Cycle description | |
| CREATED_BY | NUMBER | (15) | Y | Created by |
| CREATION_DATE | DATE | Y | Creation date | |
| LAST_UPDATED_BY | NUMBER | (15) | Y | Last updated by |
| LAST_UPDATE_DATE | DATE | Y | Last update date | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Last update login |
APPS.FPA_PCS_VL is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_PORTFS_VL is a view containing translatable data for Portfolios.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PORTFOLIO | NUMBER | Unique Portfolio Identifier | ||
| NAME | VARCHAR2 | (80) | Portfolio name | |
| DESCRIPTION | VARCHAR2 | (240) | Portfolio description | |
| CREATED_BY | NUMBER | (15) | Y | Created by |
| CREATION_DATE | DATE | Y | Creation date | |
| LAST_UPDATED_BY | NUMBER | (15) | Y | Last updated by |
| LAST_UPDATE_DATE | DATE | Y | Last update date | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Last update login |
APPS.FPA_PORTFS_VL is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
FPA_SCES_VL is a view containing translatable data for Scenarios.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SCENARIO | NUMBER | Scenario Identifier | ||
| NAME | VARCHAR2 | (80) | Scenario name | |
| DESCRIPTION | VARCHAR2 | (240) | Scenario description | |
| CREATED_BY | NUMBER | (15) | Y | Created by |
| CREATION_DATE | DATE | Y | Creation date | |
| LAST_UPDATED_BY | NUMBER | (15) | Y | Last updated by |
| LAST_UPDATE_DATE | DATE | Y | Last update date | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Last update login |
APPS.FPA_SCES_VL is not referenced by any database object
|
|
|
| Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |