Monday, 23 November 2015

Order Import request did not return with error when even the order is not imported

Explanation:-

Oracle Order Management - Version: 11.5 to 12.1.3 - Release: 11.5 to 12.1

Order import program will not error out if validation for some attributes fail.
In case of failure, child concurrent program 'Order Import Child Req1 (Order Import)' will not get spawn. Secondly, the log file will tell the total number of orders processed
This is the expected behavior.

Order Import corrections form will show records in red color under the following scenarios :

Case 1.

If the validation for any of the header attribute fails, it doesn't matter whether the validation of lines under it passes/fails. In this case the header record will be set as error_flag='Y' and shown in red where as the lines will NOT be in red color (even though a line contains invalid attributes)

Case 2.

If the header validation passes and any of the line validation fails, then both the header record and the line will be marked as erred and shown in red color.

For example :

If there is an invalid price list at line level, there will be many error occurred at header level. So as per Case1, it will not show the line record in red color. If there are no errors at header level and if there occurs at error at line level then only the line will be shown in red color.

If the order has more than one line and you want to find which line has failed in validation, first you have to ensure that all the validation for the header record is successful. After the header validation is successful and if there is any validation failure for a line, then that particular line will be shown in red color (the header record will also be in red).

No comments:

Post a Comment