1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Alert for Excise Reg.

Discussion in 'Oracle Apps Technical' started by virurids, Aug 25, 2009.

  1. virurids

    virurids Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    For Order Management, I want to create an alert, if product is not registered under any Excise Template, it give some msg or not allow user to book the order.:confused::confused::confused:

    Plz, Plz, Plz help with solution URGENTLY.

    Regards,
    Viral Panday
     
  2. virurids

    virurids Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    Request to all experts!!!!
    Please help me out...
     
  3. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    You might be able to achieve it with form personalization, but it's impossible to say anything with the little detail you have given.
     
  4. virurids

    virurids Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    This is to elimate the unwanted return procedure.

    part of india localization.

    a product is not registered in excise tariff. and our data entry operater created one order for the complete ship confirm. after running excise invoice generation request we found excise invoice is not generated for the said sales order and we have to take the material return. this is very common problem we are facing.

    so i want to create an alert or something by which operater come to know that the entered product is not registered in excise. and they can ask concern person to take nacessary action.

    hope this detais is sufficient.

    waiting for reply...
     
  5. malli_18arjun

    malli_18arjun Active Member

    Messages:
    36
    Likes Received:
    3
    Trophy Points:
    110
    Location:
    Hyderabad
    Hi

    Create an event alert by following the below steps

    1.Prepare a sql query which would return the Sales orders entered with Unregistered Excise Product.

    2.Create event alert by using the prepared query.

    3.Prepare the email distribution list to whom to notify and add the list to alert.

    4.In alert message provide the details of entered order like sales order , Product ..

    Hope this helps..