Issue With Patch 8730324 on Dynamic Chaining NPI of Release 7.3 ORA-20000: OnGoing Copy terminated! LastOnGoingDate is not set
Last updated on DECEMBER 18, 2017
Applies to:Oracle Demantra Demand Management - Version 7.3.0 to 7.3.0 [Release 7.3.0]
Information in this document applies to any platform.
On 7.3 in Test:
Applied the patch (8730324) on top of Demantra 7.3 and am testing the scenarios of Dynamic Chaining.
After this patch is applied, the process works fine first time when we create a new product. It fails next time onwards when it tries to copy the history of existing product to the new product (NPI ongoing copy). It fails in the EBS Full download workflow with the following error:
ORA-20000: OnGoing Copy terminated! LastOnGoingDate is not set and the format expected is mm-dd-yyyy.
The value of LastOngoingDate is null in the SYS_PARAMS table. If we update this field manually, it works fine only once and again fails in the same step. Actually, the process is always updating this parameter with NULL.
Found that the internal procedure ONGOING_COPY is using the variable NOW to update the parameter LastOngoingDate. The variable NOW is never populated in this procedure.
STEP TO REPRODUCE
1. Create a new product using NPI Dynamic Chaining with data copy as yes with launch date as Future date
2. Load the data of the existing product (source product) for next period so that ongoing data is also get copied to the new product
3. The EBS full download fails with the message
ORA-20000: OnGoing Copy terminated! LastOnGoingDate is not set and the format expected is mm-dd-yyyy
It is not allowing us to use Dynamic Chaining at all.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms