training apps

8/3/2019 Training Apps

1/29

INDEX

Installing the template file 2-3

Adding a report to oracle application 4-10

Adding forms to existing module 11-17

Adding a new module to oracle applications 18-23

Adding a responsibility 24-25

Technical Notes 26-29


2/29

Installing the Template Form

FIRST STEP: DOWNLOAD RESOURCE FROM THE SERVER

1) Download the folder resource from the server from thefollowing path:

/e1/vision/visionappl/au/11.5.0/resource

2) Copy Template.fmb and appstand.fmb from /e1/vision/visionappl/au/11.5.0/forms/us (the template forinherits some packages from the appstand.fmb)

3) Put the two fmb files into resource that you downloadedin the first step. (Not necessary)

4) Open regedit and add the path of resource into form60-path.

SECOND STEP: OPEN THE TEMPLATE FORM

Open form builder and open TEMPLATE form and do thefollowing steps:

1) Delete the detail block if you dont want a master detailrelation.2) Rename the block blockname block to the name of your data block you are intending to add.3) Delete its fields and insert the fields of your block.4) Change the canvas name to the name of your first block.5) Change window name to the name of your first block.6) Change the block name in the pre-form trigger app_window.set_window_position('BLOCKNAME','FIRST_WINDOW');


3/29

7) change the app_custom package body, find the followingstatement

if (wnd = '') then

change to the first block name.

NOTE: if you want to add any new block you are free to addit manually.

Third STEP: SETTING ITEMS PROPERITES

In most cases your items must have standard properties, inorder to make any item standard item do the following:

1) Open the item property palette.2) Press the button beside the subclass

information field.3) Select the property class.4) From the property class name select the proper

type of your item.

Do the same above steps for all your items and finally savethe form and exit.

NOTE: make sure that you dont save on the same templateform.


4/29

Adding a report to oracle application

1) create the report using report builder and from

administration go to convert and do the following:

a) Determine the path of the source report(RDF)b) determine the path of the destination report(RDF)c) From option tab set the destination unit value to

character.

2) open oracle application and go to system administrator responsibility

3) go to concurrent to program to executable and set thefollowing:

a) executable: name of the original report(i.e. TSTOM 002).

b) Short name: the same name above.c) Application: the application you want to add your

report to

(I.e. Order Management).d) Execution Method: set it to Oracle Reports.( it will

be set auto )e) Execution file name: same as executable

name(TST OM 002)f) All remaining are optional. ( non colored fields is

optional ) .


5/29

4) go to define and set the following:

a) program: the report name that will appear to the

user.b) Short name: the same name.c) Application: order management.d) Style: landscape.e) Executable name: TST OM 002f) Executable method: oracle reports.


6/29

Note: if your report has no parameters stop here.

5) push parameter button and set the following:

a) set parameter sequence number and nameb) value set: the set of accepted values of the

parameter.c) Token: the name of the parameter on the original

report.


7/29


8/29

6) go to Security to responsibility to request and do the

following:

a) Search for the application request groups (pressF11 and put Order Management in the applicationfield).

b) Select the OM REPORTS group.c) Press new and select the program name and

application.

7) switch responsibility to order management applicationand go to reports, Requests to run report to singlerequest and do the following:

a) Select the report name.b) Set the parameters if the report has.c) Press submit.


9/29

8) The report will not work because he cant find the repfile on the server.

9) Press VIEW-- LOG to see the error where you will find the path that your report should be.

10) Open FTP and copy the rep file to the locationspecified on the previous step.

11) Rerun the report it shall work now.


10/29

NOTE: from view press requests you will see the entirerequests submitted.

NOTE: from help press record history which views the source

view of a markedfield.

NOTE: from help press diagnosis then examine to see thequery that generated the screen


11/29

Adding forms to existing module

FIRST STEP: GENERATING THE FMX

1) You need to have FTP software and a tool to connect to aserver.

2) Add your form to au forms (i.ee1/vision/visionappl/au/forms/US/ORDER.fmb)

The AU directory contains all the FMB files for all theapplications.

3) Go to the application top (i.e e1/vision/visionappl)

4) run the APPSVISION_(server name).env file(i.e . APPSVISION_oracle-server.env where oracle-server

is the server name)

5) Go to au/11.5.0/forms/US

6) Generate the form on the desired destination using

f60gen

The following session generate the ORDER.fmb under ont(order management application)

$ cd /$ cd e1$ cd vision$ cd visionappl

$ ls *.env$ . APPSVISION_oracle-server.env$ cd au$ cd 11.5.0$ cd forms$ cd US


12/29

$ f60gen Userid=APPS/APPSModule=$AU_TOP/forms/US/XX_FDC_SETUP.fmb output_file=/e1/vision/visionappl/ap/11.5.0/forms/US/XX_FDC_SETUP.fmx module_type=FORM

batch=no compile_all=special

You shall see the following

. . . . .Created form file

/e1/vision/visionappl/ont/11.5.0/forms/US/ORDER_INFO.fmx

SECOND STEP: ADDING THE FORM TO ORACLE APPLICATION

1) Go to application developer responsibility.

2) Go to applications to form and do the following:

a) Set the form value to the form name without the

extension.b) Select the application name.c) Set the user form name which will be the form name

that will be used in the next steps. ( the text that willappear to the user ) .

d) Save and exit.


13/29

3) Go to application to function

a) In the description tab set the function name that will beused in the next steps.

b) Select the user form name that you determined in theprevious step.

c) Go to form tab the function name you determined in awill appear set your function and application name.d) Save and exit.


14/29


15/29

4) Go to application to menu

a) select the menu of the application you are intending toadd the function to

b) Press add new button.c) Set the sequence to any valid unique value.d) Prompt will determine what will be the function name in

the menu.e) Because we are adding a function leave the submenu

field empty and put the function name in the functionfield.

f) Make sure that grant checkbox is checked and save.g) Pressing view tree button will allow you to make sure

that the function was added to the correct place.h) exit.


16/29

5) Next time you logon on the application you will see theform.


17/29

Note: if you dont know the menu of your application dothe following:

1) Switch to system admin responsibility2) go to security to responsibility to define.3) press F11 and set the application field to the name of the

application you are intending to add your and pressCTRL+F11 the menu name will appear in the menu name.


18/29

ADDING A NEW MODULE TO ORACLEAPPLICATIONS

FIRST STEP: adding a folder for your new module

a. Make directory with the name of the new moduleyou are intending to create undere1/vision/visionappl (i.e. XX_TEST). Itsrecommended to prefix it with XX to avoidduplication with oracle modules for future. Insidethe directory make a new directory and name it tothe version number (i.e. 11.5.0).

b. Inside the version number directory adddirectories according oracle standard.

c. Inside form and reports directories add a directoryfor each language your system has.


19/29

SECOND STEP: ADDING THE CUSTOM APPLICATION ON UNIX

1) Go to the path where you created the file (i.e.

/e1/vision/visionappl).2) List the environment files.

The shell commands :

$ pwd /export/home/vision$ cd ../../..$ pwd

/$ cd e1$ cd vision$ cd visionappl$ ls *.envAPPSORA.env VISION_oracle-server.envAPPSVISION_oracle-server.env VISION.env

3) open APPSVISION_oracle-server.env using the more

command

$ more APPSVISION_oracle-server.env:# $Header: APPSORA_ux.env 115.5 2003/04/01 07:38:39isikdar ship $#==========================================================================

===# NAME# APPSORA.env## DESCRIPTION# Execute environment for Oracle and APPL_TOP#


20/29

# NOTES## HISTORY#

#=============================================================================# This file is automatically generated by AutoConfig. It willbe read and# overwritten. If you were instructed to edit this file, or if you are not# able to use the settings created by AutoConfig, refer to

Metalink document# 165195.1 for assistance.#################################################################

## Source the custom file if it exists

customfile=/e1/vision/visionappl/customVISION_oracle-server.envif [ -f $customfile ]; then. /e1/vision/visionappl/ customVISION_oracle-server.env fi. /e1/vision/visionora/8.0.6/VISION_oracle-server.env. /e1/vision/visionappl/VISION_oracle-server.env

4) Create the file mentioned above in red

$ vi customVISION_oracle-server.env

5) Add the following

OM_TEST_TOP="/e1/vision/visionappl/OM_TEST/11.5.0"export OM_TEST_TOP


21/29

Assuming our new module name is OM_TEST.

6) Press (:) and (wq!) To save the file and go back to the

shell prompt.

7) to make sure that the environment file was created listthe environment files

again the customVISION_oracle-server.env shall appear.

8) run the APPSVISION_oracle-server.env file using thefollowing command:

$ . APPSVISION_oracle-server.env

THIRD STEP: RESTARTING THE ORACLE SERVER

In order for the oracle application to see your newapplication you shall restart the server to do so follow thesesteps:

1) go to e1/vision/visioncomn/admin/scripts/VISION_oracle-server/

2) run adstpall.sh

Using the command $ adstpall.sh apps/apps

3) run adstrtal.sh

Using the command $ adstrtall.sh apps/apps


22/29

Fourth step: adding the new module on the oracleapplications

1) Go to system administrator responsibility.

2) Go to application to register and set the following:

a) application: the name you want for your applicationb) short name: the directory name (i.e. OM_TEST)c) Base path: the variable name we defined in the

customVISION_oracle-server.env files (i.e.OM_TEST_TOP)

3) Go to security to oracle to data group and do thefollowing:

a) Set the data group field to standard.b) Add the application to the data group.


23/29

4) Go to oracle to register and set the following:

a) Database user name: the user name of the databaseyou created.

b) Password: the password of the database youcreated.c) Save and exit.

HINT: dont use apps/apps because it just store a referenceto other applications Schemas


24/29

ADDING A RESPONSIBILITY

Adding a responsibility

When you create a new module you shall grantprivilege to users to do so you shall do the following:

1) Define a responsibility on the new module menu.

To define a responsibility on the menu switch tosystem administrator responsibility, then go to securityto responsibility to define and set the following:

a) responsibility name: any name

b) application: set the application name you areintending to add

the responsibility name.c) responsibility key: same as responsibility name.d) menu: select the menu name.e) data group: standard.


25/29

2) Grant the responsibility to users

Go to security to define and do the following:

a) Search for the user F11 name CTRL+F11 if youare trying to add the responsibility to anexisting user or enter the user name directly if you want to assign the responsibility to existinguser.

b) Go to direct responsibilities tab and add theresponsibility

c) Save and exit.


26/29

Technical Notes

Flex fields

Flexfield is a set of segments each segment holds a value of varchar2, the flexfield is used to avoid the need to changethe oracle applications source forms if you want to addadditional fields to your form, you define the flexfield in thedatabase as a row in a table called combination table whichhave the following description (Unique ID, structure id,segments(from segment1 to segment n)).

ID STRUCTRE ID Seg1 Seg2 Seg3 segn

Form triggers

Some of the main forms triggers

Post login, when check box changed, when image pressed,when list activated, when radio changed, when tab pagechanged, when window closed, when window resized.


27/29

Report builder

In the report builder each group represent a database table.

Reports types according to the groups the report holds:

1) Tabular in the tabular report the report consist of onegroup the report just list some or all the report fields

Employee number employee name employee salary

. . .. . .

. . .

2) Master detailed in master detailed report the reportconsist of two groups one is the

Master and the other is the detailed.

Department number .

Employee number employee name employee salary

. . .

. . .

. . .

3) Matrix two masters and one detailed

Customer Product . .

4) form like report in this report each record appears ondifferent page.


28/29

Reports types according to how report appears

1) group left

Master ...

2) group above

Master

3) tabular the same as above.

Notes

in the data model if you want to create a master-detailrelationship between two group make a data link from

the master group to the detailed group or you may getall the master and detailed fields on one group andthen drag all the master group fields in a new groupabove

In the layout model if you want to create a master-detail relationship between two group draw a repeatingvariable frame for the master group then inside theframe draw another repeating variable frame for the

detailed group.

Conditional formatting allow you to set some fieldsproperties according to some conditional statement.


29/29

Object elasticity:

1) fixed keep field on original size.

2) Expand >=original size.3) Contract original size.

training apps

Documents