Depot Repair: API call to CSD_LOGISTICS_PUB.Create_Logistics_Line Fails With: The Txn billing type Id passed is invalid (Doc ID 2015451.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On 12.1.3 -

On the repair order logistics lines:
When trying to create a logistics ship line using the below API call.

..


ERROR
------------
Following error message is returned:
    =============
      Return Status of call : E
      Msg Count : 1
      Msg Data : CSD CSD_API_INV_TXN_BILL_TYPE_ID N TXN_BILLING_TYPE_ID 44
      Number of Error Messages : 1
      message data =The Txn billing type Id(44) passed is invalid
    =============

FND Log shows:
  =============
  CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN.BEGIN 2 Entered CREATE_PRODUCT_TXN
  CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN 1 ?]
  CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN 1 Before calling validate_product_txn_Rec
  CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.BEGIN 2 Entered Validate_Product_Txn_Rec
  CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.BEGIN 1 Checking mandatory parameters
  CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC 1 Validate repair line id
  CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC 1 Validate action type
  CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC 1 Validate action code
  CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC 1 Validate product txn qty
  CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.BEGIN 1 p_product_txn_rec.quantity =1
  CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC 1 Validate product txn status
  CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.BEGIN 1 ?
  CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.END 2 Leaving Validate_Product_Txn_Rec
  CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN 1 l_incident_id    =136
  CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN 1 l_bus_process_id =1000
  CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN 1 contract_line_id =9.990000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000E+125
  CSD.PLSQL.CSD_MASS_RCV_PVT.log_error_stack 5 error[The Txn billing type Id(44) passed is invalid]
  CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN 5 ?????]


  =============
STEPS
------------
In the Repair Order based on repair type setups the 'Return' and 'Ship' lines are already created.
We are trying to add new 'SHIP' line in the logistics lines using "CSD_LOGISTICS_PUB.Create_Logistics_Line" API.


Cause

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 hundreds of Community platforms