Thread: Alert for Excise Reg.
- 08-25-2009 04:00 AM #1
Alert for Excise Reg. 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.



Plz, Plz, Plz help with solution URGENTLY.
Regards,
Viral Panday
- Club-Oracle Complementary E-Books and Magazines
Get your free Complementary Copy of Oracle Magazine
You can also browse the Free Magazines and E-Books section to see the complete list of free magazines, e-books and Whitepapers.
- 08-27-2009 03:10 AM #2
Re: Alert for Excise Reg. Request to all experts!!!!
Please help me out...
- 08-27-2009 12:30 PM #3
Re: Alert for Excise Reg. You might be able to achieve it with form personalization, but it's impossible to say anything with the little detail you have given.
- 08-27-2009 12:39 PM #4
Re: Alert for Excise Reg. 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...
- 01-05-2010 11:29 AM #5
Re: Alert for Excise Reg. 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..Mallikarjun
Similar Threads
-
write into alert.log using UTL_FILE
By Sanjay MD in forum Security, Backup and RecoveryReplies: 5Last Post: 07-16-2009, 11:30 AM -
where to keep Alert message while rejects workflow content ??
By yaznesh in forum Oracle Fusion MiddlewareReplies: 1Last Post: 05-02-2009, 12:37 PM


LinkBack URL
About LinkBacks
Reply With Quote

