EBS Customizations (MOSC)

MOSC Banner

How To Fire Alert Based on Single column update R12.1.3

edited May 8, 2020 5:03AM in EBS Customizations (MOSC) 4 commentsAnswered

Good  Morning !!!

Hope all are safe at Home  !!!

We have a requirement in project module -

When the new project is created the status will be UNAPPROVED

After project manager approve the status will be APPROVED

Upon the project is Approved - we need to fire alter notification to project coordinator.

For this  we crated  Alert with table -PA_PROJECTS_ALL /after update.

This is ok till now.

But some time project manager is changing  the  Project name or project description - in such case ALERT should not fire

How to restrict  the alert to fire only if the ' previous value should be UNAPPROVED and current value should be APPROVED.

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center