My Oracle Support Banner

Item Status Is Not Changing In Asset Tracking -When Item Cost Transferred From Inventory To Project (Doc ID 2512285.1)

Last updated on MAY 19, 2020

Applies to:

Oracle Asset Tracking - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms

Oracle Asset Tracking release 12.2.8+ supports PO receive into inventory with project to create asset flow with following steps

  1. Create a Purchase order for a normal item and approve it.
  2. Perform Receipt of the item with project into inventory.
  3. Submit ‘Interface Install Base Lines’ program.
  4. Check if item instance is created.  Select * from csi_item_instances where serial_number = :srl_num;
  5. Run : ‘Create Accounting – Cost Management’ from ‘Cost Management – SLA’
  6. Check if costing is created for PO Receipt transaction.
  7. Run : ‘Projects Cost Collection Manager’
  8. Check if records are inserted into PA transaction interface table:

              select * from pa_transaction_interface_all where transaction_source like 'CSE%';

  1. Run: ‘PRC: Transaction Import’ with transaction source as ‘CSE_INV_PO
  2. Check if expenditure is created:

              select * from pa_expenditure_items_all where attribute7 = :srl_num;

  1. Perfom Misc Transaction : "eIB Misc. Issue to Project"
  2. Install the item and put it into service from ‘Asset Tracking Super User’
  3. Run: ‘Interface In-Service Transactions to Oracle Projects - Normal Items’
  4. Run 'PRC: Transaction Import' with transaction source as ‘CSE_INV_PO
  5. Run: ‘Create Asset Headers in Oracle Projects - Normal Items’
  6. Run: ‘PRC: Generate Asset Lines for a Single Project’
  7. Run: ‘PRC: Interface Assets to Oracle Assets’
  8. Run: Post Mass Additions from Fixed Assets > Mass Additions > Post Mass Additions
  9. Create Payables Invoice against the PO created above. Asset Tracking Super User >> Payables >> Invoices >> Entry >> Invoices
  10. Validate the Invoice and create accounting entries
  11. Run: 'Interface Invoice Price Variance to Oracle Projects'
  12. Run: ‘PRC: Transaction Import’ with transaction source as ‘CSE_INV_AP_POSTED’
  13. Run 'PRC: Generate Asset Lines for a Single Project'.
  14. Run: 'PRC: Interface Assets to Oracle Assets'
  15. Run: Post Mass Additions from Fixed Assets > Mass Additions > Post Mass Additions


However, after installed R12.2.8 patchset, found Instance created from PO is in the inventory location (suppose in project), therefore, cannot do deployment

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.