Retail Price Management (MOSC)

MOSC Banner

ORA error

edited Nov 12, 2015 10:00AM in Retail Price Management (MOSC) 1 commentAnswered

Hi,

getting the below error message on running a batch in Oracle Retail Allocation.


error_messages_1443106841427.log:<problem>[null, null, The credential doesnt exist for the given key/userNameAlias(rpm13).]</problem>

#### <Date / Time:  03 Nov 2015 17:14:33,589><Severity Level:  DEBUG><Host Name: lnxql99v0135><DB User:  alloc13><DB URL: jdbc:oracle:thin:@lnxql99v0066.qualif.fr.auchan.com:1521:RETAIL><Location: com.retek.alloc.db.alc.AuAlcItemLocDao><Message:  select decode((select pack_ind from item_master where item = ail.item_id) , 'Y', (select sum(aippd.pmd*pb.item_qty)||'^'||sum(aippd.pcm*pb.item_qty)||'^'||sum(aippd.tpl*pb.item_qty) from au_item_pmd_pcm_details aippd,PACKITEM_BREAKOUT pb,rpm_zone_location rzl,rpm_zone rz where pb.item=aippd.item and pb.pack_no=ail.item_id and rzl.zone_id=rz.zone_id and rz.zone_display_id=aippd.zone_id and rzl.location=ail.location_id and aippd.effective_date = (select max(effective_date) from au_item_pmd_pcm_details aippd2 where aippd2.item = aippd.item and aippd2.zone_id = aippd.zone_id and aippd2.effective_date <= ail.release_date)),(select distinct aippd.pmd||'^'||aippd.pcm||'^'||aippd.tpl from au_item_pmd_pcm_details aippd,rpm_zone_location rzl,rpm_zone rz where aippd.item=ail.item_id and rzl.zone_id=rz.zone_id and rz.zone_display_id=aippd.zone_id and rzl.location=ail.location_id and aippd.effective_date = (select max(effective_date) from au_item_pmd_pcm_details aippd2 where aippd2.item = aippd.item and aippd2.zone_id = aippd.zone_id and aippd2.effective_date <= ail.release_date))) org_pmd, app.adj_pmd from AU_ALC_PMD_PCM app, alc_item_loc ail where app.item_loc_id = ? and app.item_loc_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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center