Last updated on MARCH 08, 2017
Applies to:Oracle Trade Management - Version 12.1.3 and later
Information in this document applies to any platform.
We have some data issues in our Oracle Channel Revenue Management and below are the details.
The Batch header status in OZF_SD_BATCH_HEADERS_ALL is ‘PENDING_CLOSE’ but the lines in OZF_SD_BATCH_LINES_ALL table is ‘NEW’. Looks like our business did a write-off on the below batches and we need to close these batches as the header status is pending close and the lines are still in New.
Batch #: 846
Batch#: 888, Claim#: C13277-4
There are some Batches where the header status is ‘PENDING_CLOSE’ but the lines are in ‘SUBMITTED’.
• 1143 - C13277-4
• 1909 - C13186-1
• 2157 - C13388-2
Please advise on cleaning this data.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms