Home » Developer & Programmer » Forms » Validation of Value in Sales Order Form (Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production)
Validation of Value in Sales Order Form [message #674302] Thu, 17 January 2019 13:43
vharish006
Messages: 68
Registered: August 2015
Location: Chicago
Member
I have requirement with respect to Forms. This is my First time working on Form Changes.Could you please guide me in detail how I can achieve below


Based on a Value in a Custom table I want to Validate the "Invoice Delivery Method"(Additional Header Information is DFF).
on the Sales Order Form .

The Relation between Sales order form and Custom table is the Customer Number on SO form and the Account_Number in Custom table.

1) changing from either "Hard Copy" or "Email" to "Email & EDI" or "EDI" will be possible only if the EDI Status field on the custom form is "Active".

A validation will check this and notify "Account EDI configuration is not active yet"

2)changing back from either "Email & EDI" or "EDI" to "Hard Copy" or "Email" will be possible only if the EDI Status field on the custom form is "Inactive".


I have created a TEST Table to hold the "EDI STATUS" FIELD.


CREATE TABLE TEST_TABLE

(ACCOUNT_NUMBER  VARCHAR2(50)

,ACCOUNT_NAME    VARCHAR2(250)

,REQUESTER_NAME  VARCHAR2(250)

,PHONE           VARCHAR2(50)

,PHONE_EXTENSION VARCHAR2(50)

,EMAIL           VARCHAR2(100)

,IT_REPRESENTATIVE_NAME  VARCHAR2(100)

,IT_REPRESENTATIVE_EMAIL VARCHAR2(100)

,IT_REPRESENTATIVE_PHONE VARCHAR2(50)

,MESSAGE_FORMAT      VARCHAR2(50)

,CUSTOMER_TYPE       VARCHAR2(50)

,EINVOICE_PROVIDER   VARCHAR2(50)

,STANDARD_IDENTIFICATION_NUMBER VARCHAR2(50)

,REMARK            VARCHAR2(50)

,EDI_STATUS       VARCHAR2(50)

,CREATION_DATE     DATE         

,CREATED_BY        INTEGER       

,LAST_UPDATE_DATE  DATE          

,LAST_UPDATED_BY   INTEGER);

Please let me know how this can be achieved or let me know if you need more details.


  • Attachment: Capture.PNG
    (Size: 160.79KB, Downloaded 320 times)
Previous Topic: Add library file in batch
Next Topic: LOV again change value on same row in oracle form
Goto Forum:
  


Current Time: Sat Aug 08 10:23:20 CDT 2020