How to create Business Rules & Database Triggers:

--------------------------------------------------
Environment Headstart utility

  1. go to the Function Hierarchy Diagramer
  2. select the container that you wish to create the business rule in, or just create a new sheet
  3. click on Function icon "small white square on the right top of the screen", then place it in the sheet
  4. type the lable and short definition of that function.

Note:

in this step you are building your business rules tree, so you may keep the root as a description for your business rules to be grouped under. Ex: for PMS, first we start with the root BR_PMS, and its definition is PMS Business Rules. Then for each system model, we have a group of business rules, like Funds/Portfolios Business Rules, or Securities Business Rules...etc.

  1. pick again the function icon, and type the label according to the following convention:

· BR_TableShortName001_CEV (change event)

· BR_TableShortName002_TRS (transition event)

· BR_TableShortName003_IER (inter-relation event)

· BR_TableShortName004_ENT (entity event)

· BR_TableShortName005_DEL (delete event)

· BR_TableShortName006_UPD (update event)

· BR_TableShortName007_TPL (topple event, used to verify between columns on the table)

è for more description on those event, please reference the oracle manual.

  1. double click on the function and assign the Entity Usage.
  2. assign Attribute Usage
  3. Save the diagram
  4. go to the Repository Object Navigator
  5. under the selected container, go to Process Events
  6. select the event on which you want to fire the trigger, either on the table or a specific column, usually the STATUS column.

Note:

If you do not find your table there, then do the following:

- go to the http://iai2.iai.org.kw:7778/forms/frmservlet?config=hsd65_utilities

- Productivity Booster --> Analysis --> Maintain Default Events for Entities

- pick your table and run.

- this will generate the needed events for the table.

  1. under Triggering Functions, right click --> create reference --> select the business rule name that you created in the Function Hierarchy Diagramer, and save
  2. go to the http://iai2.iai.org.kw:7778/forms/frmservlet?config=hsd65_utilities
  3. Productivity Boosters --> Business Logic Layer --> Rule Layer
  4. select the Business Rule Design Transformer
  5. Select the Business Rule Function that you have created, and run
  6. from the Server Model, refresh your table triggers and you will find your trigger assigned.
  7. Edit trigger logic, and then generate table CAPI from the utilities and then table API.

Comments

Post a Comment

Popular posts from this blog

Another user has changed the row with primary key oracle.jbo.Key[12 ].

Image
Try these solutions:  make sure that you check "refresh after insert" and refresh after update" for the primary key column in you entity object. in the application module tab Click the Properties tab and select jbo.locking.mode. Double click the “pessimistic”value next to the property to open the field editor and type “optimistic” over the value.Press enter. if error still exist then you must set "refresh after insert" and refresh after update" as true for all attributes in the entity object another way is to execute the View Object after the commit operation to bring back updated data to ViewObject. For this we need to override the  afterCommit()  of ViewObject class as follows:                  public void afterCommit(TransactionEvent){                         executeQuery();                       }              5- another way to solve this error is to overide the lock() method of the EntityImpl class       public void lock() {    
Read more

weblogic windows JPS-01050: Opening of wallet based credential store failed. Reason java.io.IOException: Failed to lock cwallet.sso.lck

Integreated weblogic serer cannot be started and retuen this error weblogic windows JPS-01050: Opening of wallet based credential store failed. Reason java.io.IOException: Failed to lock cwallet.sso.lck Solution is simple  just remove the cwallet.sso file and cwallet.sso.lck located in C:\Users\tarek.DHAMAN\AppData\Roaming\JDeveloper\system12.2.1.4.42.190911.2248\o.jdeveloper.rescat2.model Then open jevveloper again and start weblogic again
Read more

Working With File Throgh WebUtill

-------------------------------------------------- Required Configuraion : By default the file transfer is disabled in webutil for a security measure. So, you have to enable File transfer configuration in webutil.cfg file. The webutil.cfg file is located in  forms\server. Open The webuil.cfg file and edit the following parameters : transfer.database.enabled=FALSE   Change To TRUE transfer.appsrv.enabled=FALSE       Change to TRUE WebUtil_File contains APIs to manipulate files and directories on the client. These Functions Or APIs are: Copy_File :  Copies a file Returns a Boolean to indicate success.  Syntax :   Webutil_File.Copy_File(SourceFileName in Varchar2 , Destination In Varchar2) Return Boolean  Example   Declare  vCopied Boolean;  Begin   vCopied :=  Webutil_File.Copy_File('C:\temp\mypic.jpg','X:\destination_folder');  If vCopied = true Then    Message('File copied Successfully');  Else   Message('Error in Copying File');  End if; Delete_File:
Read more