My Oracle Support Banner

Sales Orders: ORA-01403: no data found in Package OE_Order_Cache Procedure Load_Cust_Trx_Type (Doc ID 1336575.1)

Last updated on JUNE 20, 2018

Applies to:

Oracle Order Management - Version and later
Information in this document applies to any platform.
Form:OEXOEORD.FMB - Sales Orders
***Checked for relevance on 18-Jun-2014***


On : version, Transaction Entry

When attempting to create a sales order from the Sales Order (OEXOEORD) form,
get the following errors
Unconfirmed if issue is only for new customer (operating unit) or for previously installed customers (operating units)

"ORA-01403: no data found in Package OE_Order_Cache Procedure Load_Cust_Trx_Type"
"User-Defined Exception in Package OE_Order_Cache Procedure get_tax_calculation_flag"

The issue can be reproduced at will with the following steps:
1. Open sales order form
2. Add header information, including order type = Example: ABCD
3. Tab to Line item
4. Receive error


Added a new operating unit.


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

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

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.