General Ledger Profile Options

User Profile Option Name	Description / Purpose
GL: Applications Coexistence Fusion User	(null)
GL: Applications Coexistence System Identifier	(null)
GL: Archive Journal Import Data	(null)
GL: Auto Allocation Rollback Allowed	(null)
GL: DRM API Adapter URL	URL of the Hyperion DRM web-service API.
GL: DRM Property for Value Set Name	Name of the DRM attribute, against which the value set override must be checked.
GL: DRM Property to Allow Hierarchy Export	Name of the DRM attribute, against which the hierarchy override must be checked.
GL: DRM Property to Allow Version Export	Name of the DRM attribute, against which the version override must be checked.
GL: DRM Template for Hierarchy Export	Template name to be used for exporting hierarchies from DRM.
GL: DRM Template for Version Export	Export template name to be used for exporting segment values from DRM.
GL: DRM Username	Login username for Hyperion DRM
GL: DRM WSDL URL	URL for the WSDL of the Hyperion DRM web-service.
GL: Data Access Set	(null)
GL: Debug Log Directory	Directory where log files for AutoAllocation are created
GL: Debug Mode	Indicates if General Ledger programs are run in debug mode; in debug mode, additional messages are printed to the log file.
GL: Income Statement Accounts Revaluation Rule	indicates if PTD or YTD revaluation balances should be used for Revenue and Expense accounts
GL: Journal Entry Purge Set Size	Number of journal entries purged in one transaction
GL: Journal Line Purge Set Size	Number of journal entry lines purged in one transaction
GL: Journal Review Required	Journal review required before posting
GL: Launch AutoReverse After Open Period	Launch AutoReversal program after period is opened.
GL: Number of Accounts In Memory	(null)
GL: Number of Average Balance Post Workers	The number of parallel SQL workers to be used when posting average balance journals.
GL: Number of Purge Workers	The number of processes to be spawned while purging
GL: Number of Records to Process at Once	(null)
GL: Number of formulas to validate for each MassAllocation batch	Number of formulas to be validated for each MassAllocation batch
GL: Number of formulas to validate for each Recurring Journal batch	Number of formulas to be validated for each Recurring Journal batch
GL: Owner's Equity Translation Rule	Indicates the method to use when translating Owner's Equity accounts
GL: Reverse Transaction Codes on Un-natural Balances	Reverse Transaction Codes on Un-natural Balances
GL:Create Encumbrance Entries for Budgetary Accounts	GL:Create Encumbrance Entries for Budgetary Accounts
GL:Create Interfund Entries	Creates balancing Interfund entries during journal import
GL:Enforce Account Category Balancing	Enforce journals to balance by account category in Posting

Function Key Triggers in Oracle Forms

Function key triggers are associated with individual Runform function keys. A function key trigger fires only when an operator presses the associated function key. The actions defined in a function key trigger replace the default action that the function key would normally perform. The following table shows all function key triggers and the corresponding Runform function keys.

Key Trigger	Associated Function
Key Key-CLRBLK	[Clear Block]
Key-CLRFRM	[Clear Form]
Key-CLRREC	[Clear Record]
Key-COMMIT	[Accept]
Key-CQUERY	[Count Query Hits]
Key-CREREC	[Insert Record]
Key-DELREC	[Delete Record]
Key-DOWN	[Down]
Key-DUP-ITEM	[Duplicate Item]
Key-DUPREC	[Duplicate Record]
Key-EDIT	[Edit]
Key-ENTQRY	[Enter Query]
Key-EXEQRY	[Execute Query]
Key-EXIT	[Exit]
Key-HELP	[Help]
Key-LISTVAL	[List of Values]
Key-MENU	[Block Menu]
Key-NXTBLK	[Next Block]
Key-NXT-ITEM	[Next Item]
Key-NXTKEY	[Next Primary Key]
Key-NXTREC	[Next Record]
Key-NXTSET	[Next Set of Records]
Key-PRINT	[Print]
Key-PRVBLK	[Previous Block]
Key-PRV-ITEM	[Previous Item]
Key-PRVREC	[Previous Record]
Key-SCRDOWN	[Scroll Down]
Key-SCRUP	[Scroll Up]
Key-UP	[Up]

Move Order Status in Oracle Apps(mtl_txn_request_headers.header_status)

SELECT *
  FROM mfg_lookups
 WHERE lookup_type = 'MTL_TXN_REQUEST_STATUS'

Status	Meaning
1	Incomplete
2	Pending Approval
3	Approved
4	Not Approved
5	Closed
6	Canceled
7	Pre Approved
8	Partially  Approved
9	Canceled by Source

FORMS_DDL('COMMIT') in Oracle Forms

FORMS_DDL('COMMIT')
-------------------
Only DML operations/transactions within the form awaiting COMMIT are committed to the database.