Installations/Configurations-Applications

August 1, 2017 Oracle financials interface tables

Accounts PayablesAccounts ReceivablesAPPS DBAConfigurations-APConfigurations-ARConfigurations-CMConfigurations-FAConfigurations-GLFixed AssetsGeneral LedgerInstallations/Configurations-ApplicationsOracle FunctionalScripts

General Ledger Interface Tables

GL_BUDGET_INTERFACE
GL_DAILY_RATES_INTERFACE
GL_DRM_HIERARCHY_INTERFACE
GL_DRM_SEGVALUES_INTERFACE
GL_IMP_COA_ERR_INTERFACE
GL_IMP_COA_NORM_HIER_INTERFACE
GL_IMP_COA_SEG_VAL_INTERFACE
GL_IEA_INTERFACE
GL_INTERFACE
GL_INTERFACE_CONTROL
GL_INTERFACE_HISTORY
GL_REPORT_INTERFACE
GL_XFR_INTERFACE

Account Payables (AP) Interface Tables

AP_INTERFACE_CONTROLS
AP_INTERFACE_REJECTIONS
AP_INVOICE_INTERFACE
AP_INVOICE_LINES_INTERFACE
OIE_POL_RATES_INTERFACE

Account Receivables (AR) Interface Tables

AR_PAYMENTS_INTERFACE_ALL
AR_TAX_INTERFACE
HZ_PARTY_INTERFACE
HZ_PARTY_INTERFACE_ERRORS
RA_CUSTOMERS_INTERFACE_ALL
RE_INTERFACE_DISTRIBUTION_ALL
RA_INTERFACE_ERRORS_ALL
RA_INTERFACE_LINES_ALL
RA_INTERFACE_SALESCREDITS_ALL
AR_INTERFACE_CONTS_ALL
AR_PMTS_INTERFACE_HEADER_GT
AR_PMTS_INTERFACE_LINES_GT
AR_PMTS_INTERFACE_LINE_DETAILS
HZ_DQM_SH_SYNC_INTERFACE
HZ_DQM_SYNC_INTERFACE
RA_INTERFACE_REQID_GT

Fixed Assets (FA) Interface Tables

FA_BUDGET_INTERFACE
FA_INV_INTERFACE
FA_PRODUCTION_INTERFACE
FA_TAX_INTERFACE
FA_TRANSACTION_INTERFACE

Cash Management (CE) Interface Tables

CE_ARCH_INTERFACE_HEADERS
CE_ARCH_INTERFACE_HEADERS_ALL
CE_ARCH_INTERFACE_LINES
CE_HEADER_INTERFACE_ERRORS
CE_LINE_INTERFACE_ERRORS
CE_STATEMENT_LINES_INTERFACE
CE_UK_VALIDATIONS_INTERFACE

June 25, 2017 Oracle EBS Application R12 Short Keys

APPS DBAInstallations/Configurations-Applications

Oracle EBS Application R12 Short Keys

Function	Key	Function	Key
Actions LOV	Shift + Ctrl + F8	Help	Ctrl + H
Block Menu	Ctrl + B	Insert Record	Ctrl + Down
Clear Block	F7	List of Values	Ctrl + L
Clear Field	F5	List Tab Pages	F2
Clear Form	F8	Next Block	Shift + Page Down
Clear Record	F6	Next Field	Tab
Commit	Ctrl + S	Next Primary Key	Shift + F7
Copy	Ctrl + C	Next Record	Down
Count Query	F12	Next Set of Records	Shift + F8
Cut	Ctrl + X	Paste	Ctrl + V
Delete Record	Ctrl + Up	Previous Block	Shift + Page Up
Display Error	Shift + Ctrl + E	Previous Field	Shift + Tab
Duplicate Field	Shift + F5	Previous Record	Up
Duplicate Record	Shift + F6	Print	Ctrl + P
Edit	Ctrl + E	Prompt Value LOV	Shift + Ctrl + F9
Enter Query / Query Mode	F11	Return	Return
Execute Query / Run Query	Ctrl + F11	Scroll Down	Page Down
Exit/Cancel Query	F4	Scroll Up	Page Up
Function 0	Shift + Ctrl + F10	Show Keys	Ctrl + K
Function 1	Shift + Ctrl + F1	Undo Typing	Ctrl + Z
Function 2	Shift + Ctrl + F2	Update Records	Ctrl + U
Function 3	Shift + Ctrl + F3
Function 4	Shift + Ctrl + F4
Function 5	Shift + Ctrl + F5
Function 6	Shift + Ctrl + F6
Function 7	Shift + Ctrl + F7
Help	Ctrl + H
Insert Record	Ctrl + Down
List of Values	Ctrl + L
List Tab Pages	F2
Next Block	Shift + Page Down
Next Field	Tab
Next Primary Key	Shift + F7
Next Record	Down
Next Set of Records	Shift + F8
Paste	Ctrl + V
Previous Block	Shift + Page Up
Previous Field	Shift + Tab
Previous Record	Up
Print	Ctrl + P
Prompt Value LOV	Shift + Ctrl + F9
Return	Return
Scroll Down	Page Down
Scroll Up	Page Up
Show Keys	Ctrl + K
Undo Typing	Ctrl + Z
Update Records	Ctrl + U

June 25, 2017 Tkprof – Convert Trace .trc to Readable

APPS DBAInstallations/Configurations-ApplicationsOracle APPS DBA

Tkprof – Convert Trace .trc to Readable

tkprof <file.trc> <file.tkprof> explain=<apps_user>/<pswd>

Where,

tkprof: is command
<file.trc>: is file name of trace file with location (if currently not in same directory)
<file.tkprof>: is output file name
explain= <apps_user>/<pswd>: provide apps user name and password.

Example:

tkprof /tmp/oracle.trc /tmp/output.tkprof explain=apps/****

June 25, 2017 FRM-92050 failed to connect to Server /forms/servlet -1

APPS DBAErrors/Workarounds-ApplicationsInstallations/Configurations-ApplicationsOracle APPS DBA

ERROR

FRM-92050 failed to connect to Server /forms/servlet -1

(more…)