My Oracle Support Banner

"CUST_TRX_TYPE_SEQ_ID" Is Being Set As Null On Duplicated Subscription For Newly added Products Causing Errors When Interface Data With AR (Doc ID 2934688.1)

Last updated on MARCH 13, 2023

Applies to:

Oracle Fusion Subscription Management Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Billing

When duplicating a subscription and adding new products "CUST_TRX_TYPE_SEQ_ID" is set as Null and generates an error when user tries to interface the data with Account Receivables (AR)


The transaction type ID {CUST_TRX_TYPE_ID is invalid.

The issue can be reproduced at will with the following steps:
1. Search for an existing subscription
2. Use the duplicate subscription option
3. Remove the products from the old subscription or keep one
4. Add a new product
5. The new product added will be linked to the random transaction type. In the UI will choose the correct transaction type. The initial transaction type cannot be seen in the UI
6. As a result the lines for the new product added in the duplicated subscription are stuck in the AR interface with the error message: The transaction type ID {CUST_TRX_TYPE_ID is invalid.


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

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