My Oracle Support Banner

Transactions In The CN_COMM_LINES_API_ALL Where Adjust_Status Is Null Are Not Processed (Doc ID 943674.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Oracle Incentive Compensation - Version 12.0.4 and later
Information in this document applies to any platform.

Goal

Transactions in the API table where adjust_status is NULL, are not getting processed by the
transaction loader program.

Recently, <Patch 8814038> was applied for credit allocation issues.  In this patch the package CN_TRANSACTION_LOAD_PUB was updated to -- $Header: cnploadb.pls 120.2.12000000.9 2009/06/03 12:22:38 ppillai ship $

In this version, the following has been commented out of the logical_batches cursor
(api.adjust_status <> 'SCA_PENDING' ) AND -- OR api.adjust_status IS NULL) AND

Why was this commented out? Transactions are now not getting loaded if adjust_status is NULL.

 

Solution

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
Goal
Solution
References

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