WEB Application Development Integrator: App settings

1.1. System Installation Application

Oracle EBS WEB Application Development Integrator

• WEB ADI is configured differently in the Oracle EBS 11.5.10.* version;
• WEB Adi is installed by default in the Oracle EBS R12.0.4 version;

Duty

1. In the Oracle EBS 11.5.10.2 Environment, the duty name of the Web adi:Oracle Web Adi;
2. In the Oracle EBS R12.0.4 Environment, the duty name of the WEB adi:Desktop integration;
3. Identify the functions sub-features that have been acquired to HR ADI seeded Integrator Form, if not, need to add.

• That is: There is no HR Integrator setup in the "Create Document", "Integrator", and you need to add a submenu "HR ADI implanted generator form" to the menu of the Desktop Integrator responsibility;

1.2. Setup Initial System profile Setup

Configuration file Profile Name	Description Description	Value Value
BNE Allow No Security Rule (BNE allow no security rules)	Allow not set Security Rule Access Integrator	Y:	No security rule is created and can be accessed; If there is security rule, it needs to be verified by the safety rules.
		N:	Integrator must create a security Rule; otherwise, you will not have the permission to access this functionality.
Adi:use Function Security (using security controls)	Whether functional security is enabled	Y:	The menu needs to include the appropriate features.

1.3. How to apply Web ADI application

1. How to import data into a personalized development table:

• You need to build tables and views, and the corresponding PKG to insert, UPDATE, delete table data. If you are importing data from an Oracle EBS Interface table or another table, skip create TABLE, but you need to create the relevant view and Pkg.

2. How to import data directly:

• Instead of creating a view, you can develop WEB ADI to import data directly. The original view is used for data modification and deletion when data is used from the database.

1.4. Set function A. Establish function

The type selection sub-function.

• If Adi:use function security (ADI: Using security Control) chooses ' yes ' then this feature needs to be added to the WEB ADI menu.

B. Establishing integrator and function associations

1. Application product Abbreviation: that is the abbreviation of application development;
2. Integrator User name: The name of the integrator created earlier;
3. Set integrator and function correspondence;

1.5. Set up integrator A. Select Integrator

Using the Create DOCUMENT in the WEB ADI role, select "HR Integrator Settings":

B. Select content

Finally, in open Excel, the parameters are set as follows:

Parameters	Description
Loading meta data types	Create only new, download only query, update query and modify; Select Create only when importing;
Application abbreviation	Cux (Example: Cux customer application);
Integrator User Name	is the integrator name shown in Adi;
View Name	Use the view name under apps, and you don't need to create a view if you're just importing data.
Table sole Name	General
API Package Name	The name of the package that Adi wants to invoke;
API Procedure Name	The procedure name of the function package called by ADI;
Interface User Name
Interface parameter list name	ADI Interface
API type	Procedure or function
API return type	Procedure or function, if it is a function, the return type must be filled in

1.6. Set layout web ADI Setup Layout

1. Click the "Define Layout" feature and select the integrator you created earlier to find it. If there is no layout, a prompt will appear. You can add, update, or delete a layout, a builder can have multiple layouts, and of course the hints for the fields in the layout can be set.

   1) The field name is the set of parameters and view fields in the package, and any fields that need to be displayed and changed are selected arbitrarily.

2) The arrangement method can be selected in the first row context three kinds. If you have a default value, you must select the default type. The default values are selected as follows:

Default Type	Description
Constant	Defaults to default values when entering content in the default value area of the spreadsheet
Environment	When set to the default value for a zone, the values that are used to correlate an environment variable are as follows:	proved not to be useful
	Sysdate: System Time
	Database: Current DB name
	Oauser.id: User ID for the current Oracle app
Parameters	When you use the Create document, the parameter used to refer to a system administrator's stored in the form function can be referenced by each integrator
Sql	Used to run an SQL statement to determine the default value for the zone. WEB ADI runs SQL statements and automatically populates the results in a zone if multiple values are queried, it returns the first value. You can use the following markup in an SQL statement:
	$profiles $.profilename: Returns the value of the current user when the preset file name is entered
	$env $.userid: Returns the ID of the current user
	$env $.appid: Returns the ID of the current reference
	$env $.respid: Returns the ID of the current duty
	$env $.language: Returns the language of the current session
Formula	You can enter a formula that is compatible with Excel as the default value.
	Follow the syntax of the Excel formula and include the name in square brackets: for example __[credit]+[debit]

A. Fields with default values in the parameters and fields in the view can be selected to not display or display, and fields that do not have default values in the parameters must be displayed.

B. If the view has this field and the procedure parameter is not present, only as the display content, no modification is allowed.

C. Set the style sheet, whether it is protected, and the location of each field, whether it is read-only, width, etc.

1.7. Set the mapping Web ADI settings Mapping

1. Defining the mappings is primarily for the display of the fields in the view, which can be used without setting if the metadata type selected on the Excle interface created is create.
2. When the field name of the view is inconsistent with the procedure parameter name, it must be made manually.
3. The system automatically matches all parameters of the procedure (clipping the first 2 characters) to the field name of the view, if there are inconsistencies or where special mappings are required, it needs to be specified manually.

1.8. Set Font fonts Modify field to display in Chinese

1. The generated WEB ADI Excel field name is the same as the parameter in English, need to modify the table to change to Chinese;
2. In Plsql, if WEB ADI is done in the Chinese environment:

• Definition: ALTER SESSION SET nls_language= ' Simplified Chinese ';
• Determine Adi:select * from BNE_INTEGRATORS_VL t;

1.9. Apply the transplant Save

1. To create the last step of the document, click Save: Enter the name of the shortcut, which is the function abbreviation to be defined. and tick save to form function. Click Apply.
2. Then add the defined shortcut name to the menu.

Transplantation

Re-configure the new environment again, you can also use Fndload to complete.

1.10. browser Settings IE Setup

ie/tools/option/security/internet/ Custom Level

Set the "Initialize and script run for Activvex controls that are not marked as safe" to prompt.

1.11. Excel set up Excel Setup

1. You need to set Excel macro security to low and check "Trust access to Visual Basic projects."

• If no Office installs VBA, the greet system prompts you to insert the installation disk.
• Clients using Web Adi need to install Excel and have VBA components installed. Because Excel communicates with EBS is actually implemented by a VBA program. However, there is no need to master VBA programming during development, and VBA programs are generated automatically by the EBS system. VBA uses XMLHTTP to communicate with the Web server (Apache) instead of using JDBC and ODBC to communicate with the database (Oracle), bypassing these, so you do not need to install these database drivers on the client.

excel/tools/ Macro / Security