You are html tracking Visitor

Friday, January 22, 2010

Install base creation issue approach

Install base creation issue approach:-
-----------------------------------------------

I have made some package which could help creating the Install base for the sales order.

You can find above package posting under (OM) Ready scripts.

http://alloracletech.blogspot.com/2009/04/install-base-creation-for-all-sales.html

This posting helps you understand Install base issues.

After running the program, if we are still not able to see the Install base created. Check the following steps.

1) Query for the item in the Master item Form and Under Service Tab, you could find option "Installed Base Tracking" Option. This should be enabled for the Install base Creation.

2) Transaction's should be there for the Orders to created the Install base.

You can use the following Query to know the transaction ID's for your Order.

SELECT transaction_id
FROM mtl_material_transactions
WHERE trx_source_line_id IN (select line_id from oe_order_lines_all
where header_id IN (select header_id from oe_order_headers_all
where order_number = 'Your Order Number'))
AND transaction_type_id = 33

Note:- Transaction_type_id is 33 in my instance. This value is Instance dependent.

3) If Transactions are created for the Order but still there is no Install base created then check if there is any error for the Transaction in the Error Table.

You can use the following Query to get Error Information.

select * from csi.csi_txn_errors where TRANSACTION_ID IN (SELECT transaction_id--, trx_source_line_id
FROM mtl_material_transactions
WHERE trx_source_line_id IN (select line_id from oe_order_lines_all
where header_id IN (select header_id from oe_order_headers_all
where order_number = 'Your Order Number'))
AND transaction_type_id = 33);

Note:- Transaction_type_id is 33 in my instance. This value is Instance dependent.

Based on the Error Message, you can go ahead for the Solution. Metalink would be best to get the Solution with the complete error message you found.

4) If there is no errors for this transaction then there is possibility that records are in Interface tables.

In this case you can run the following program to hit records from Interface tables to the Install base tables.

Program Name: Resubmit Interface Process

You can verify if the Install base created or not from the following Query.

select * from csi.csi_item_instances
where last_oe_order_line_id IN (Your Order Line ID);

Example:-

select * from csi.csi_item_instances
where last_oe_order_line_id IN (6912858, 6912859, 6912860);

I hope you find the above information help full.

Note:- I have tested above script in the 11i Instances.

Wednesday, January 20, 2010

Know Instance Name

Know Instance Name:-
-------------------------

Following Query can be used to know the Instance Name you are working from the Backend.

SELECT UPPER(sys_context('USERENV','DB_NAME')) "Instance"
FROM DUAL;