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)