Technology Stack - EBS (MOSC)

MOSC Banner

Quality Plan Form Not Working with RAISE FORM_TRIGGER_FAILURE

Hi All,

I have done below form personalization on 'Quality Plan' form to restrict Quantity Column should not be less than 100.

Seq: 1

Description: Validate Quantity

Level: Function
Enabled: Yes


Condition
---------
Event Trigger: WHEN-VALIDATE-RECORD
Trigger Object: Q_RES
Condition: :Q_RES.CHARACTER10< TO_NUMBER(100) AND :Q_RES_HEAD.NAME = 'PACKING ORDER LINES'

Processing Mode: Both

Actions
-------
Seq: 1 [Working]
Type: Message
Language: All
Enabled: Yes

Message Type: Error
Message Text: QUANTITY SHOULD BE GREATER THAN 100.

Seq: 2 [Not Working]
Type: Builtin
Language: All
Enabled: Yes

Builtin Type: RAISE FORM_TRIGGER_FAILURE

It is still getting save, although error message is working absolutely fine.

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