You Must Supply Payment Terms For Your Non-Credit Transaction

Applies to:

Oracle Receivables – Version: 11.5.10 to 11.5.10.3 – Release: 11.5 to 11.5
Information in this document applies to any platform.
Checked for relevance on 21-Oct-2009.
EXECUTABLE:RAXTRX – Autoinvoice Import Program

Symptoms

This note has been archived, as it has been consolidated into notes <<111267.1>> and <<1083494.1>>

Transaction are not getting imported from Order Management.
The payment terms, sales credit type and salesperson names are
not getting sent over from Order Management.

Autoinvoice Validation report shows following validation errors:

Errors: 1) You must supply payment terms for your non-credit transaction
Errors: 1)Invalid sales credit type name (SALES_CREDIT_TYPE_NAME) ((Null))
2)Invalid salesrep number (SALESREP_NUMBER) ((Null))

Cause

Batch Source setup should be “Id” for Payment Term and Sales information
since data coming from Order Management.   These were setup as “Value”.

Solution

Since data is coming from Order Management (OM), need to modify Transaction Source Setup
as OM only populates ‘ID’ columns.

Under Receivables responsibility, navigate to Setup, Transactions, Sources
Query Source = <enter Order Management batch source name>

1. Under Accounting tab, make following setting change:
Select Payment Term = ‘ID’

2. Under Sales Credit tab, make following setting changes
Select Salesperson = ID
Select Sales Credit Type = ID

Save changes

Rerun Autoinvoice and should no longer receive reported validation errors.

Advertisements

Bug 8636919 : ENG: INVENTORY TRANSACTION WORKER PROCESS (INCTCW) ENDS WITH ERROR UESTNT

Type B – Defect Fixed in Product Version 11.5.10.2
Severity 2 – Severe Loss of Service Product Version 11.5.10.2
Status 93 – Closed, Not Verified by Filer Platform 226 – Linux x86-64
Created Jun 26, 2009 Platform Version NO DATA
Updated Sep 25, 2009 Base Bug N/A
Database Version 10.2 Affects Platforms Generic
Product Source Oracle
Hdr: 8636919 10.2 TRNSACTION 11.5.10.2 PRODID-508 PORTID-226

Abstract: ENG: INVENTORY TRANSACTION WORKER PROCESS (INCTCW) ENDS WITH ERROR UESTNT

*** 06/26/09 10:33 am *** (ADD: Impact/Symptom->FUNCTIONAL )
*** 06/26/09 10:33 am ***

  BUG TYPE CHOSEN
  ===============
  Data Fix

  Product: Oracle Inventory Management (508)
  ==========================================
  PROBLEM STATEMENT
  =================
  Customer from Brazil

  On 11.5.10.2 in Production:

  Customer have 5802 records in MTI stuck with some errors.
  There are 4080 records of the above, with error code "ERRO ORACLE"
  The log of the concurrent request shows for one of this tarnsactions
  the message: Inventory:(INCTCW) with the error UESTNT.

  DATA COLLECTED
  =================
  1) Inventory Debug file shows the following error:

  INV_TXN_MANAGER_GRP: Error in tmpinsert: sqlerrm : ORA-1: unique
  constraint (INV.MTL_MATERIAL_TRANS_TEMP_U1) violated

  2) Running the standard duplicate transactions script, the log shows the
  following:

  select a.transaction_temp_id,
  a.picking_line_id from mtl_material_transactions b,
  mtl_material_transactions_temp a
  where a.picking_line_id = b.picking_line_id
  and a.trx_source_line_id = b.trx_source_line_id
  and a.inventory_item_id = b.inventory_item_id
  and b.transaction_type_id = a.transaction_type_id
  and b.transaction_source_type_id in ( 2,8)
  and b.picking_line_id is not null;

  => 26 records found...
  This records were deleted with:

  delete from mtl_material_transactions_temp where transaction_temp_id in
  (select transaction_temp_id from mmt_mmtt_records_v );

  => 26 records found.

  There are still a huge quantity of transactions stuck with the error above.

  WORKAROUNDS
  ===========
  None

*** 06/26/09 10:42 am ***
*** 06/26/09 10:45 am *** (CHG: Sta->16 Pri->1)
*** 06/26/09 10:45 am ***
*** 06/26/09 10:49 am ***
*** 06/26/09 11:49 am *** (CHG: Sta->11 Pri->2)
*** 06/26/09 11:49 am ***
*** 06/26/09 11:51 am *** ESCALATED
*** 06/26/09 01:56 pm ***
*** 06/26/09 02:58 pm *** 
*** 06/26/09 04:36 pm *** (CHG: Sta->30)
*** 06/26/09 04:36 pm ***
*** 07/02/09 01:24 pm *** (CHG: Sta->11)
*** 07/02/09 01:24 pm ***
*** 07/03/09 06:09 am ***
*** 07/06/09 11:28 am *** (CHG: Sta->30)
*** 07/06/09 11:28 am ***
*** 07/08/09 06:07 am ***
*** 07/08/09 06:17 am ***
*** 07/08/09 06:18 am *** (CHG: Sta->11)
*** 07/08/09 06:18 am ***
*** 07/08/09 11:49 am *** (CHG: Sta->30)
*** 07/08/09 11:49 am ***
*** 07/08/09 11:51 am ***
*** 07/09/09 06:06 am *** (CHG: Sta->11)
*** 07/09/09 06:06 am ***
*** 07/09/09 11:24 am *** (CHG: Sta->30)
*** 07/09/09 11:24 am ***
*** 07/09/09 12:36 pm *** (CHG: Sta->11)
*** 07/09/09 12:36 pm ***
*** 07/10/09 11:34 am *** (CHG: Sta->30)
*** 07/10/09 11:34 am ***
*** 07/10/09 01:03 pm ***
*** 07/10/09 01:03 pm *** (CHG: Sta->11)
*** 07/10/09 04:37 pm *** (CHG: Sta->30)
*** 07/10/09 04:37 pm ***
*** 07/10/09 04:39 pm ***
*** 07/16/09 02:04 pm ***
*** 07/16/09 02:04 pm *** (CHG: Sta->11)
*** 07/16/09 05:35 pm ***
*** 07/17/09 02:50 pm *** (CHG: Sta->30)
*** 07/17/09 02:50 pm ***
*** 07/27/09 02:30 pm *** (CHG: Sta->33)
*** 07/27/09 02:30 pm ***
*** 07/27/09 04:39 pm ***
*** 08/04/09 05:49 am *** ESCALATION -> CLOSED
*** 08/04/09 07:51 am ***
*** 09/25/09 01:33 pm *** 
*** 09/25/09 01:33 pm *** (CHG: Sta->93)
*** 09/25/09 01:33 pm ***
Solution

delete mtl_material_transactions_temp;

commit;