Receiving Transaction Processor Has Errors Impacting Subledger Accounting When Receiving Transactions (Doc ID 1326274.1)

Last updated on JULY 16, 2017

Applies to:

Oracle Cost Management - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Form:RCVRCERC.FMB - Enter Receipts
Form:RCVTXERT.FMB - Enter Receiving Transactions
Executable:RVCTP - Receiving Transaction Processor


Symptoms

On :  12.1 version  

When attempting to perform any receive transaction
the following errors occur:

RVTTH-445: Subroutine User-Defined Exception in Package CST_XLA_PVT
Procedure Create_RCVXLAEventStatement -300: : SQL Error: User-Defined
Exception returned error
Cause:        Subroutine User-Defined Exception in Package CST_XLA_PVT Proc
Concurrent program RVCTP returned error

or

RVTTH-448: Subroutine User-Defined Exception in Package CST_XLA_PVT
Procedure Create_RCVXLAEventStatement -300: : SQL Error: User-Defined
Exception returned error


Steps 
The issue can be reproduced at will with the following steps:
Purchasing or Inventory Responsibility
N: Receiving / Receipts 
Receive purchase order

After setting debug profile options per  <Note 299497.1>
. Inventory debug log file does not show any error and only shows

[19-MAY-11 08:32:44] inv_receiving_transaction: TXN_COMPLETE - Parameters passed : 10.1: p_group_id - 5004
[19-MAY-11 08:32:44] inv_receiving_transaction: TXN_COMPLETE - Parameters passed : 10.2: p_txn_status - FALSE
[19-MAY-11 08:32:44] inv_receiving_transaction: TXN_COMPLETE - Parameters passed : 10.3: p_txn_mode - PROCESSOR


. fnd_log_messages shows


END of procedure accounting_program_events
xla_accounting_pub_pkg.accounting_program_events Create_AccountingEntry :300
l_event_type_code :RECEIVE
error buffer:Accounting Program completed Normal with some events in error
error code:1
Create_AccountingEntry: 260 : Error raising SLA Event
Insert_RAEEvents : 50 : Error in Create_AccountingEntry API
Create_ReceiveEvents : 150 : Error inserting events into RAE
Create_ReceivingEvents : 80 : Error creating event
Create_AccountingEvents : 120 : Error creating event
"              RVTTH:441DEBUG l_org_id 283
"              RVTTH:443 error in  Create_AccountingEvents


. in po_interface_errors table the records have


Column_Name INTERFACE_TRANSACTION_ID
Error_Message
RVTTH-445: Subroutine User-Defined Exception in Package CST_XLA_PVT
Procedure Create_RCVXLAEventStatement -300: : SQL Error: User-Defined
Exception returned error Cause: Subroutine User-Defined Exception in
Package CST_XLA_PVT Proc
Table_Name RCV_TRANSACTIONS_INTERFACE 

Changes

 

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