Not much this month... Can you tell I was on vacation most of the
time? :-)
Table names ending in _TL are transalation tables. One example is MTL_SYSTEM_ITEMS_TL:
INVENTORY_ITEM_ID
NOT NULL NUMBER
ORGANIZATION_ID
NOT NULL NUMBER
LANGUAGE
NOT NULL VARCHAR2(4)
SOURCE_LANG
NOT NULL VARCHAR2(4)
DESCRIPTION
VARCHAR2(240)
LAST_UPDATE_DATE
NOT NULL DATE
LAST_UPDATED_BY
NOT NULL NUMBER
CREATION_DATE
NOT NULL DATE
CREATED_BY
NOT NULL NUMBER
LAST_UPDATE_LOGIN
NUMBER
LONG_DESCRIPTION
VARCHAR2(4000)
Where you can see that for each item we can have a DESCRIPTION and
a LONG_DESCRIPTION per LANGUAGE.
To Find the FNDLOAD scripts can be found in /fnd/11.5.0/admin/import
and are usefull to findout about the tables that hold certain objects and
how they link together. For example in afcpexec.lct we can find a query
on executables linked with application data:
select v.EXECUTABLE_NAME,
a.APPLICATION_SHORT_NAME,
decode(v.LAST_UPDATED_BY,
1, 'SEED', 'CUSTOM') OWNER,
v.EXECUTION_METHOD_CODE,
v.EXECUTION_FILE_NAME,
v.SUBROUTINE_NAME,
v.USER_EXECUTABLE_NAME,
v.DESCRIPTION
from fnd_executables_vl v, fnd_application a
where ((:EXECUTABLE_NAME is
null) or
((:EXECUTABLE_NAME is not null) and
(v.EXECUTABLE_NAME like :EXECUTABLE_NAME)))
and ((:APPLICATION_SHORT_NAME
is null) or
((:APPLICATION_SHORT_NAME is not null) and
(a.APPLICATION_SHORT_NAME like :APPLICATION_SHORT_NAME)))
and a.APPLICATION_ID = v.APPLICATION_ID "
RDBMS
To test if a DB listener for external procedure calls works, here is
the command:
tnsping EXTPROC_CONNECTION_DATA
Open cursors check:
SELECT name, value FROM v$parameter WHERE name = `open_cursors';