Demantra Solutions - EBS (MOSC)

MOSC Banner

Return history loaded to is_fictive location

edited Oct 30, 2012 8:03AM in Demantra Solutions - EBS (MOSC) 13 commentsAnswered
Hi,

SQL

SELECT location_id, loc_status, is_fictive, t_ep_organization_ep_id, last_update_date FROM CCWDMP.LOCATION WHERE LOCATION_ID IN (3, 7, 8, 9) ORDER BY T_EP_ORGANIZATION_EP_ID

shows t_ep_organization_ep_id of 3 corresponds to multiple location_id 3, 7, 8, 9 but the only combination of location_id 3 and t_ep_organization_ep_id of 3 has is_fictive as 0 (the details are attached).

I loaded one item to t_ep_organization_id of 3 with return history of 11. The integration interface has insert combination feature checked. However, the sales data table shows all the location_id of 3, 7, 8, 9 have return history of 11 so the total return history for this organization becomes 44, which should only be 11 for this organization. What i shall do to make return history to load for the combination of location_id 3 and t_ep_organization_ep_id?

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center