My Oracle Support Banner

Depot Repair: Service Activity is not showing in LOV on the Repair Order Form (Doc ID 2421013.1)

Last updated on JULY 16, 2018

Applies to:

Oracle Depot Repair - Version 12.2.6 and later
Information in this document applies to any platform.

Goal

On : 12.2.6  Depot Setup

The Service Activity code is not showing in the List of values(LOV) for the logistics lines on the Repair Order Form.

The following is the SQL used for displaying the service activity values in the LOV.

=======
SELECT DISTINCT
cs_transaction_types_vl.name,
cs_transaction_types_vl.description,
cs_transaction_types_vl.revision_flag,
cs_transaction_types_vl.new_cp_return_required,
cs_transaction_types_vl.new_cp_status_code,
cs_transaction_types_vl.installed_cp_return_required,
cs_transaction_types_vl.installed_status_code,
cs_transaction_types_vl.no_charge_flag,
cs_transaction_types_vl.line_order_category_code line_category_code ,
cs_bus_process_txns.transaction_type_id
FROM csd_repair_types_b,
cs_bus_process_txns,
cs_transaction_types_vl,
cs_txn_billing_types,
CS_TXN_BILLING_OETXN_ALL,
CSI_TXN_TYPES itt,
CSI_TXN_SUB_TYPES ist,
fnd_lookup_values flv ,
cs_billing_type_categories cbtc
WHERE csd_repair_types_b.repair_type_id = <repair_type_id>
AND cs_bus_process_txns.business_process_id =csd_repair_types_b.business_process_id
AND cs_transaction_types_vl.transaction_type_id = cs_bus_process_txns.transaction_type_id
AND itt.source_application_id(+) = 660
AND itt.transaction_type_id = ist.transaction_type_id
AND ist.cs_transaction_type_id = cs_bus_process_txns.transaction_type_id
AND (to_date(sysdate) BETWEEN NVL(cs_bus_process_txns.start_date_active,to_date(sysdate))AND NVL(cs_bus_process_txns.end_date_active,to_date(sysdate)))
AND cs_transaction_types_vl.transaction_type_id = cs_txn_billing_types.transaction_type_id
/*and cs_txn_billing_types.billing_type='M' */
AND cs_txn_billing_types.billing_type = cbtc.billing_type
AND cbtc.billing_category ='M'
AND cbtc.billing_type = flv.lookup_code
AND flv.lookup_type = 'MTL_SERVICE_BILLABLE_FLAG'
AND flv.language = userenv('LANG')
AND CS_TXN_BILLING_OETXN_ALL.txn_billing_type_id = cs_txn_billing_types.txn_billing_type_id
AND NVL(CS_txn_billing_oetxn_all.org_id, -99999) =<org_id>
AND cs_transaction_types_vl.line_order_category_code = 'RETURN'
AND NVL(cs_transaction_types_vl.depot_repair_flag ,'N')='Y'
ORDER BY cs_transaction_types_vl.name
=======

In this particular case the condition which is failing due to incorrect setup.
=============
AND ist.cs_transaction_type_id = cs_bus_process_txns.transaction_type_id
=============

 


 

Solution

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

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


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