Inventory Items (APC/PLM/PIM) - EBS (MOSC)

MOSC Banner

How do I understand the behavior of oracle in accepting serial numbers?

edited Feb 26, 2015 10:01AM in Inventory Items (APC/PLM/PIM) - EBS (MOSC) 2 commentsAnswered

We created an IO that all items need to define serial numbers with 10 characters. Upon loading the serial numbers in Miscellaneous Transaction, oracle won't accept the serials unless we put "-" before the last 4 digits.

In example serial number 0123456789, oracle won't accept this unless I make it 012345-6789. But like I said half of the data I loaded oracle accepted it in same format, example serial number 0987654321. There are some that oracle does not accept the serials with dash in the last 4 digits and the original serial number, that's why we put the dash in the 5th digit of the serial number.

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