4.3 AXF_COMMANDS Table

Use the AXF_COMMANDS table to describe the actions to be taken based on user activity. This table works with the AXF_CONFIGS Table.

4.3.1 Column Description

Table 4-3 Column Description for AXF_COMMANDS Table

Column Name Description Data Type Nullable

FORMID

Links to the AXF_CONFIGS Table.

Number

No

EVENTID

Primary key of the table.

Number

Yes

EVENTNAME

Name of the Event command to be invoked (for example, ZOOM, POST-INSERT).

Varchar2(100 byte)

Yes

DISPLAYMENU

Displays text of the menu for the command.

Varchar2(100 byte)

Yes

COMMANDNAMESPACE

Request command to be passed to the back-end when the menu is selected.

Varchar2(100 byte)

Yes

REQUIRESCONVERSATION

Indicates if the command requires a valid conversation or not.

Varchar2(10 byte)

Yes

SORTBY

Order in which the menu is displayed.

Number

Yes

SOLUTIONNAMESPACE

Name of the solution.

Varchar2(100 byte)

Yes

MENUTYPE

Specify the menu type to display to users in E-Business Suite. You can choose:

  • ZOOM: Displays a Zoom menu in the toolbar.

  • ZOOMANDSPECIAL: Displays both a Zoom menu and a Special menu. (Enter a special key in the SPECIAL column.)

  • SPECIAL: Displays a Special menu on the toolbar. (Enter a special key in the Special column.)

Varchar2(25 byte)

Yes

SPECIAL

Create new menu entries by entering a unique number for the Special type menu, where:

  • SPECIAL1-15 creates entries in the Tools menu.

  • SPECIAL16-30 creates entries in the Reports menu.

  • SPECIAL31-45 creates entries in the Actions menu.

(Consult the E-Business Suite Documentation for further information.)

Varchar2(10 byte)

Yes

RESPONSIBILITY

Reserved for future use.

Varchar2(100 byte)

Yes

4.3.2 Example Implementation

This example shows two commands invoked from the Zoom menu (Attach Supplemental and Process Invoices). Each command is listed twice because the commands are enabling the same functionality, but on two different screens.

In addition, the solution has been configured to invoke the SaveInvoice command during the POST-INSERT event, which specifies that whenever an action inserts a new E-Business Suite transaction record, the integration automatically invokes the SaveInvoice command on the back-end, performing the actions associated with the command. Note that POST-INSERT is not called by a subsequent save of the same transaction record in E-Business Suite.

Fields not shown: SOLUTION_NAMESPACE=InvoiceProcessing, SPECIAL=(null), RESPONSIBILITY=(null)

Table 4-4 Example AXF_COMMANDS Table

EVENTID FORMID EVENTNAME DISPLAYMENU COMMANDNAMESPACE REQUIRESCONVERSATION SORTBY MENUTYPE

16

1

ZOOM

Attach Supplemental

AttachSupplemental

YES

2

ZOOM

14

6

ZOOM

Attach Supplemental

AttachSupplemental

YES

2

ZOOM

13

6

ZOOM

Process Batch Invoices

StartInvoiceProcessing

NO

1

ZOOM

10

1

ZOOM

Process Invoices

StartInvoiceProcessing

NO

1

ZOOM

11

1

POST-INSERT

(null)

SaveInvoice

YES

0

(null)

15

6

POST-INSERT

(null)

SaveInvoice

YES

0

(null)