Demantra Solutions - EBS (MOSC)

MOSC Banner

Error while getting baseline item-month level:ORA-00001: unique constraint (SYS.I_SQLOBJ$NAME_TYPE)

edited Dec 4, 2014 10:00AM in Demantra Solutions - EBS (MOSC) 1 commentAnswered

Hi All,

We are doing a custom procedure which does a select on sales_data and then inserts back into a custom series. We are getting error which does not look like a data/logical error.

It looks like a database error. We are able to reproduce it and the procedure is erroring at the same place. We are able to run the query outside.

 

It looks like some database related error.

**************************

select sum(nvl(FORE_0,0) * nvl(mdp.unit_cost,0)) bln_fcst_amt, sum(nvl(FORE_0,0)) bln_fcst_qty  from sales_data sd ,mdp_matrix mdp  where sd.item_id = 16855 and mdp.item_id = sd.item_id  and mdp.location_id = sd.location_id  and nvl(mdp.cie_npi_flag,0) <> 1  and sd.sales_date >= to_date('30-AUG-15','DD-MON-YY') and sd.sales_date <= to_date('26-SEP-15','DD-MON-YY')

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Demantra Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center