Proport Is Failing - ORA-00909: invalid number of arguments Error in PROCEDURE line 362 (Doc ID 2141579.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Technical

When attempting to execute proport procedure,
the following error occurs.

ERROR
-----------------------
Error starting at line : 10 in command -
begin
update mdp_matrix set prop_changes = 1 where item_id = xxx and location_id = yyy;
commit;
proport;
end;
Error report -
ORA-20002: -20003 ORA-20003: Error in PROCEDURE PROPORT line 1214
  executing dynamic_proc('DYN_PROPORT_SALES_1(' WHERE prop_changes = 1')')
ORA-06512: at "DEMANTRA.PROPORT", line 1533
ORA-06512: at line 4

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into demantra schema using some SQL Tool like SQL Developer.
2. Manually execute proport procedure:
begin
  update mdp_matrix set prop_changes = 1 where item_id = 12013 and location_id = 1587;
  commit;
  proport;
end;
3. It fails.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot execute Proport procedure. This will impact the forecast generated by engine and all the entire planning process.

Cause

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