Significance of current status of Serial number in MTL_SERIAL_NUMBERS

We have serial number table (MTL_SERIAL_NUMBERS) the column ‘CURRENT_STATUS’ indicates the status of a serial number. The column is populated with a number. For example, 3 means resides in stores. This means that the serial number has an associated onhand quantity and should be available to transact.

Once you ship the order and serial number got used , then current status got set to 4 !!

Here is a list of common serial number statuses and ids:

Current Status Codes (ID and Description)
————————————————–
1 Defined but not used
3 Resides in stores 
4 Issued out of stores
5 Resides in intransit
6 Pending status
7 Resides in receiving
8 Resides in WIP

How to available Switch User options in user Login page for Users Oracle apps – functional set up

1.  To make available Switch User options for Users perform the flowing steps
2.  Login as Sysadmin User
3. Go to Workflow Administrator>Administrator Workflow>Status Monitor
4. Open Status Monitor form.
5. Go to tab Notifications
6. Click on TIP Worklist link in bottom left.
7. Click on Grant Worklist Access.
8. Fill the user name over there for the specific user
9. Press Go button and the Select.
10. Press Apply in Grant Worklist Access
11. Add the user name and save the work

Unix solution : How to send a mail with subject, attachment and mail body using command ‘uuencode’

Here is the command to send a mail with Subject, Body along with Attachment.

(echo #BODY uuencode #ATTACHMENT_FILE  ‘#ATTACHMENT_FILE_NAME’ | mail –s #SUBJECT #MAIL_RECEICER  

For example-(echo $5 uuencode $4 ‘Purchase Order.pdf’) | mail -s  $1

Here

• $5 is the parameter which contain Body part.
• $4 is the parameter which says about the Location of file to be mailed.
• $2 is the parameter which says about Subject
• $1 is the mail recipient.