Invoice Price Variance (IPV) For A Serialized Normal Item (Doc ID 1555771.1)
Invoice Price Variance (IPV) For A Serialized Normal Item (Doc ID 1555771.1)
Invoice Price Variance (IPV) For A Serialized Normal Item (Doc ID 1555771.1)
In this Document
Purpose
Scope
Details
Test Case Overview
Test Case Pre-requisites
Test Case Steps
Step 1: Create The Asset
CheckPoint
Step 2: Create an Invoice
Step 3: Create Accounting Entries
CheckPoint
Step 4: Interface Invoice Price Variance to Oracle Projects
CheckPoint
Step 5: Import IPV Transaction into Projects
CheckPoint
Step 6: Adjust Asset Cost in Projects
CheckPoint
Step 7: Interface Project Asset Line to Oracle Fixed Assets
CheckPoint
Step 8: Update Asset in Oracle Fixed Assets
CheckPoint
Further Reading
References
APPLIES TO:
PURPOSE
To provide a test case example showing how to adjust the cost in Projects
and Fixed Assets for an asset created for a serialized normal item, which is
purchased from a supplier and received into a project task. It covers:
SCOPE
DETAILS
The following test case shows how to adjust the cost in Projects and Fixed
Assets for an asset created for a serialized normal item. Using Oracle Asset
Tracking responsibility, Vision Operations will adjust the asset cost in Projects
and Fixed Assets by the IPV value. The test case will mainly cover the
following business flows:
Test Case Pre-requisites
Complete all mandatory setup steps as per Test Case: How to Complete
Mandatory Setups For Oracle Asset Tracking [ID 1550972.1]
Instance: VISBDE07
Release: 12.1.3
User: operations
Step 1: Create The Asset
Create an asset for a serialized normal item as per Test Case: PO Receipt to
Project For a Serialized Normal Item [ID 1550645.1]
CheckPoint
2) Asset Number = 113917 has cost = 150 in Projects (same as cost PO cost)
as shown below:
2) Asset Number = 113917 has cost = 150 in Fixed Assets (same as cost PO
cost) as shown below:
1) When assets are procured through Oracle Purchasing they are created
with purchase order costs. After the invoice is created, any cost difference
must be adjusted in project accounting or fixed asset applications.
2) For normal items, the adjustment is done first in Oracle Projects and
transfered to Fixed Assets.
1) The asset is created in Projects and Fixed Assets with cost = 150.
However, the invoice is created with Total Amount = 160.35 (PO Cost: 150 +
Tax: 10.35). The cost different of 10.35 has to be adjusted in Projects and
Fixed Assets.
Open Invoice Number = 124, click on Actions button, then select 'Create
Accounting' checkbox as shown below:
CheckPoint
Run the Oracle Asset Tracking program 'Interface Invoice Price Variance to
Oracle Projects' for PO Number = 6054. This program basically takes the
various amounts from ap_invoice_distributions_all and finds all
expenditure_item IDs with same PO_DISTRICTION_ID, then creates invoice
price variance data in pa_transaction_interface_all.
CheckPoint
select *
from PA_TRANSACTION_INTERFACE_ALL
where ATTRIBUTE6 = 'OAT_SRL_ITEM'
and ATTRIBUTE7 = 'TC01';
CheckPoint
2) New Expenditures are created for the IPV adjustment as shown below:
Searched for project = IT Project 2 and I could see the new expenditures
created as shown below:
select *
from PA_TRANSACTION_INTERFACE_ALL
where ATTRIBUTE6 = 'OAT_SRL_ITEM'
and ATTRIBUTE7 = 'TC01';
select *
from PA_EXPENDITURE_ITEMS_ALL
where ATTRIBUTE6 = 'OAT_SRL_ITEM'
and ATTRIBUTE7 = 'TC01';
select *
from PA_COST_DISTRIBUTION_LINES_ALL
where EXPENDITURE_ITEM_ID in (102955,102956);
Result:2 new records are created to reflect the total IPV and Tax
amount of 10.35
Run 'PRC: Generate Asset Lines for a Single Project'. This program ties the
new expenditure items for IPV adjustement to the existing asset header and
creates project asset line with the IPV value.
CheckPoint
1) 'PRC: Generate Asset Lines for a Single Project' program output shows that
Asset Line has been created under section "Capital Asset Lines Generated"
as shown below:
2) Total Asset cost is adjusted by the IPV value in Projects. Now, Asset has
Total Cost = 160.35 (Original Cost: 150 + IPV: 10.35) as shown below:
Searched for project = IT Project 2 and I could see a new Asset Line with
Amount = 10.35 (IPV adjustment) has been created for Asset Name = Task 1-
125 as shown below:
3) The asset record in pa_project_assets_all table is updated with new cost =
160.35, one new record is created in pa_project_asset_lines_all table, no
record in pa_reporting_exceptions:
select *
from pa_project_assets_all
where ATTRIBUTE6 = 'OAT_SRL_ITEM'
and ATTRIBUTE7 = 'TC01';
select *
from pa_project_asset_lines_all
where project_asset_id = 2504;
select *
from pa_project_asset_line_details
where project_asset_line_detail_id = 4469;
Result: 2 records are returned showing that this Asset Line has been
created for EXPENDITURE_ITEM_IDs = 104955 & 104956
Run the Oracle Projects program 'PRC: Interface Assets to Oracle Assets'. This
program sends new asset lines to Oracle Assets to update the exesiting asset
in fixed assets. The process creates one mass addition line in Oracle Assets
for each asset line in Oracle Projects, assigning the asset information entered
for the CIP asset to the mass addition line in Oracle Assets.
CheckPoint
1) 'PRC: Interface Assets to Oracle Assets' program output shows Capital
Asset Name = Task 1-125 has been interfaced to Oracle Fixed Assets as
shown below:
select *
from fa_mass_additions
where project_asset_line_id = 4481;
Run 'Post Mass Additions' program for Asset Book = 'OPS CORP' to create the
Asset in Oracle Fixed Asset as shown below:
CheckPoint
1) Post Mass Additions Report output shows Asset Number = 113917 has
been adjusted by 10.35 as shown below:
2) Total Asset cost is adjusted by the IPV value in Fixed Assets. Now, Asset
has Total Cost = 160.35 (Original Cost: 150 + IPV: 10.35) in Asset Workbench
as shown below: