85
The analysis is always about, “I am seeing a posting of $1M as CIP amount for an asset, how did I
get this amount, why it is high/low” and It is simply not possible to get answer to these questions
just from Financials, even if we have Project and Task dimension on Financials side. While
Projects is not a true sub ledger, it is just like any other sub ledger like AR and AP where you
cannot get all the information just from GL
W_PROJ_ASSET_DS / W_PROJ_ASSET_D
W_PROJ_CAPITAL_EVENT_DS/ W_PROJ_CAPITAL_EVENT_D
W_PROJ_ASSET_DS_TL/ W_PROJ_ASSET_D_TL
W_PROJ_CIP_HDR_FS/ W_PROJ_CIP_HDR_F
W_PROJ_CIP_DTL_FS/ W_PROJ_CIP_DTL_F
12) What tables have records added
NA
13) What issue/bug fixes are covered
No major design changes
This section lists the upgrade changes after 11.1.1.8.1 to 11.1.1.9.2 Upgrade for PSFTx
adaptors
1) What tables are truncated or records deleted
NA
2) What new columns are included in base fact/dimension
W_PROJECT_D.CAPITAL_COST_TYPE_CODE
3) What new tables have been introduced
A construction-in-process (CIP) asset is an asset you construct over a period of time. Create and
maintain your CIP assets as you spend money for raw materials and labor to construct them. Since
a CIP asset is not yet in use, it does not depreciate and is only in the corporate book. When you
finish building the CIP asset, you can place it in service and begin depreciating it. Customers need
visibility on the Project CIP costs with drill to Project Cost fact and Integration to the Finance
Fixed Assets subject area via the Fixed Asset dimension (W_FIXED_ASSET_D).
The analysis is always about, “I am seeing a posting of $1M as CIP amount for an asset, how did I
get this amount, why it is high/low” and It is simply not possible to get answer to these questions
just from Financials, even if we have Project and Task dimension on Financials side. While
Projects is not a true sub ledger, it is just like any other sub ledger like AR and AP where you
cannot get all the information just from GL
W_PROJ_ASSET_DS / W_PROJ_ASSET_D
W_PROJ_CAPITAL_EVENT_DS/ W_PROJ_CAPITAL_EVENT_D
W_PROJ_ASSET_DS_TL/ W_PROJ_ASSET_D_TL
W_PROJ_CIP_HDR_FS/ W_PROJ_CIP_HDR_F
W_PROJ_CIP_DTL_FS/ W_PROJ_CIP_DTL_F
4) What tables have records added
W_PROJ_REVENUE_LINE_F - Amount Based Revenue support for PSFT