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.
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.
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