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 SEPTEMBER 14, 2023

Applies to:

Symptoms

On 12.1.3 -

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

..

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.

Changes

Cause

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