Depot Repair - EBS (MOSC)

MOSC Banner

Duplicate instance in depot repair

edited May 30, 2017 5:01AM in Depot Repair - EBS (MOSC) 1 commentAnswered

Hi Team,

I find that somehow users where able to use serial numbers which looks same when checked in front end but have different instance number.

Below are the details

SELECT a.description "User", b.last_updated_by,

  b.last_update_date,

  b.source_serial_number,

  b.source_instance_id

FROM csd_product_transactions b,

fnd_user a

WHERE b.repair_line_id IN ( 401048 , 402318)

and a.user_id = b.last_updated_by;

User

LAST_UPDATED_BY

LAST_UPDATE_DATE

SOURCE_SERIAL_NUMBER

SOURCE_INSTANCE_ID

Jayesh Kapadia

37314

27-OCT-16

M53C16001793

46549292

Jason Almeida

38061

07-DEC-16

"M53C16001793

"

47966417

If you see the serial number is somehow created with junk characters and was not intentional I believe but how was this created in first place where the serial number block in both Details and Logistics tab doesnt take junk characters.

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 Depot Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center