Oracle Inventory
Oracle Purchasing (PO)-Tables:-
Oracle Financials:General Ledger(GL)
Oracle AR
customer accounts, this table may contain several records for a single party.
HZ_CUST_SITE_USES_ALL stores information about the business
purposes assigned to a customer account site.
HZ_CUST_ACCOUNT_ROLES stores information about a role or function that a party performs as related to a
customer account. For example, Jane Doe might be the Legal Contact for Corporation ABC.
The HZ_PERSON_PROFILES table stores personal and family information about a party of the Person type.
The HZ_ORGANIZATION_PROFILES table stores a variety of information about a party.
RA_CUSTOMER_TRX_ALL stores invoice header information. RA_CUSTOMER_TRX_LINES_ALL stores information about invoice, debit memo, credit memo, bills receivable, and commitment lines.
The AR_PAYMENT_SCHEDULES_ALL table stores all transactions except adjustments and miscellaneous cash receipts.
RA_CUST_TRX_LINE_GL_DIST_ALL stores accounting distribution records for all transaction lines except bills receivable.
The RA_CUST_TRX_LINE_GL_DIST_ALL table stores the accounting records for revenue, unearned revenue, and unbilled receivables for each invoice or credit memo line.
AR_CASH_RECEIPTS_ALL stores one record for each receipt entry.
AR_CASH_RECEIPT_HISTORY_ALL stores all of the activity that is contained for the life cycle of a receipt.
• Each row represents one step., Possible statuses are Approved, Cleared,Confirmed, Remitted, and Reversed.
AR_MISC_CASH_DISTRIBUTIONS_ALL stores all accounting entries for miscellaneous cash applications.
AR_DISTRIBUTIONS_ALL stores the accounting distributions for cash receipts, miscellaneous receipts, adjustments,credit memo applications, cash receipt applications, and bills receivable transactions.
AR_RECEIVABLE_APPLICATIONS_ALL stores all accounting entries for cash and credit memo applications.
• Each row includes the amount applied, status, and accounting flexfield information.
Oracle AP
AP_ACCOUNTING_EVENTS_ALL
An event is an entity whose role is to map transaction data to the
accounting created for it. Every accounting entry needs to be identified
with the event that created it. Conceptually, an event provides
information about the timing and the reason for which the document
created the accounting entries. Every event will result in one, and only
one, accounting entry header in each set of books. Also, transaction data
is stamped with the event that accounted for it.
AP_AE_HEADERS_ALL
An accounting entry header is an entity grouping all accounting entry
lines created for a given accounting event and a particular set of books.
An accounting entry header can either be transferred over to GL or not
at all. That is, either all its accounting entry lines are transferred or none
at all. The transferred to GL status is marked in the
GL_TRANSFER_FLAG. Possible values for GL_TRANSFER_FLAG are
Y, N, or E. Y indicates that the accounting entry header has been
transferred to GL. N indicates that the accounting entry header has not
been transferred to GL due to 2 possible reasons: either the transfer
process has not run or it has run but the accounting entry had an
accounting error on it. E indicates that an error was encountered during the transfer to GL process.
AP_CHECKS_ALL
AP_CHECKS_ALL stores information about payments issued to
suppliers or refunds received from suppliers. You need one row for
each payment you issue to a supplier or refund received from a supplier.
AP_INVOICE_PAYMENTS_ALL
AP_INVOICE_PAYMENTS_ALL contains records of invoice payments
that you made to suppliers. There is one row for each payment you
make for each invoice. There is one payment and one invoice for each
payment in this table.
AP_CHECK_STOCKS_ALL
AP_CHECK_STOCKS_ALL stores information about payment
documents you defined for bank accounts.
AP_AE_LINES_ALL
An accounting entry line is an entity containing a proper accounting
entry with debits or credits both in transaction currency as well as
functional currency along with an account and other reference
information pointing to the transaction data that originated the
accounting entry line. An accounting entry line is grouped with other
accounting entry lines for a specific accounting entry header. Any such
group of accounting entry lines should result in balanced entries in the functional currency.
Oracle Fixed Assets Tables
FA_BOOK_CONTROLS contains the definition of an asset book.
FA_CATEGORIES_B contains information about asset categories. Asset categories are a key flexfield.
FA_CATEGORY_BOOKS provides cost and reserve accounts for a book and category combination.
FA_CATEGORY_BOOK_DEFAULTS provides defaults for the depreciation rules when you add an asset.
FA_MASS_ADDITIONS stores information on assets you want to automatically add to Oracle Assets from another system. ******** FA_ADDITIONS_B contains descriptive information to help you identify your assets. Oracle Assets does not use this table to calculate depreciation.When you add an asset, Oracle Assets inserts a row into this table and
into FA_ASSET_HISTORY.When you change the asset information stored in this table, Oracle Assets updates it in this table. It also creates a new row in FA_ASSET_HISTORY.
FA_BOOKS contains most of the information that Oracle Assets needs to calculate depreciation for a specific asset and book. • A record is created when a new asset is added and when an asset is modified.
• The current record is always the one where DATE_INEFFECTIVE is NULL.
FA_TRANSACTION_HEADERS tracks all the transactions performed within Oracle Assets.
FA_ASSET_HISTORY contains information about asset reclassification, capitalizations, unit adjustments,
and partial unit retirements. • Each change creates a record in the table for auditing. However, the DATE_INEFFECTIVE field of the last entry is populated when a new record is added. • The current active record can always be found by looking for DATE_INEFFECTIVE is NULL.
FA_DISTRIBUTION_HISTORY contains information about the employee, location, and accounting flexfield
values you assign to an asset.• The depreciation program uses this information to allocate depreciation expenses, and the Transfers form uses it to maintain an audit trail of asset transfers. • The current record is the one where
DATE_INEFFECTIVE is NULL.
FA_DEPRN_DETAIL contains the depreciation amounts that the depreciation program charges to the depreciation expense account for a particular asset and accounting period.
Key FlexFields
FND_IFS: FND_ID_FLEX_SEGMENTS FND_SAV:FND_SEGMENT_ATTRIBUTE_VALUES
FND_SFA:FND_SHORTHAND_FLEX_ALIASES
FND_FVS:FND_FLEX_VALUE_SETS FND_FVRS:FND_FLEX_VALIDATION_RULE_STATS
FND_FERL:FND_FLEX_EXCLUDE_RULE_LINES FND_FVR:FND_FLEX_VALIDATION_RULES
FND_FVQ: FND_FLEX_VALIDATION_QUALIFIERS FND_FVRL: FND_FLEX_VALIDATION_RULE_LINES FND_VAT:FND_VALUE_ATTRIBUTE_TYPES FND_FIRL:FND_FLEX_INCLUDE_RULE_LINES FND_CIFS:FND_COMPILED_ID_FLEX_STRUCTS FND_SAT:FND_SEGMENT_ATTRIBUTE_TYPES FND_CIF:FND_COMPILED_ID_FLEXS
FND_APP:FND_APPLICATION
WF_RPV:WF_RUNNABLE_PROCESSES_V
FND_IF:FND_ID_FLEXS
FND_TAB:FND_TABLES
FND_FWP:
FND_FLEX_WORKFLOW_PROCESSES
FND_IFS: FND_ID_FLEX_SEGMENTS FND_SAV:FND_SEGMENT_ATTRIBUTE_VALUES
FND_SFA:FND_SHORTHAND_FLEX_ALIASES FND_IFSTR:FND_ID_FLEX_STRUCTURE
FND_FVS:FND_FLEX_VALUE_SETS FND_FVRS:FND_FLEX_VALIDATION_RULE_STATS
FND_FERL:FND_FLEX_EXCLUDE_RULE_LINES FND_FVR:FND_FLEX_VALIDATION_RULES
FND_FVQ: FND_FLEX_VALIDATION_QUALIFIERS FND_FVRL: FND_FLEX_VALIDATION_RULE_LINES FND_VAT:FND_VALUE_ATTRIBUTE_TYPES FND_FIRL:FND_FLEX_INCLUDE_RULE_LINES FND_CIFS:FND_COMPILED_ID_FLEX_STRUCTS FND_SAT:FND_SEGMENT_ATTRIBUTE_TYPES FND_CIF:FND_COMPILED_ID_FLEXS FND_IF:FND_ID_FLEXS
FND_APP:FND_APPLICATION FND_TAB:FND_TABLES
WF_RPV:WF_RUNNABLE_PROCESSES_V FND_FWP: FND_FLEX_WORKFLOW_PROCESSES
FND_FVH: FND_FLEX_VALUE_HIERARCHIES FND_FVS: FND_FLEX_VALUE_SETS
FND_IFS: FND_ID_FLEX_SEGMENTS FND_FVNH: FND_FLEX_VALUE_NORM_HIERARCHY
FND_FH:FND_FLEX_HIERARCHIES FND_FV: FND_FLEX_VALUES
FND_FVE: FND_FLEX_VALIDATION_EVENTS FND_FVRL: FND_FLEX_VALUE_RULE_LINES
FND_FVR: FND_FLEX_VALUE_RULES FND_FVRU: FND_FLEX_VALUE_RULE_USAGES
FND_RESP:FND_RESPONSIBILITY FND_TAB:FND_TABLES
FND_FVT:FND_FLEX_VALIDATION_TABLES
FND_FVH: FND_FLEX_VALUE_HIERARCHIES FND_FVS: FND_FLEX_VALUE_SETS
FND_IFS: FND_ID_FLEX_SEGMENTS FND_FVNH: FND_FLEX_VALUE_NORM_HIERARCHY
FND_FH:FND_FLEX_HIERARCHIES FND_FV: FND_FLEX_VALUES
FND_FVE: FND_FLEX_VALIDATION_EVENTS FND_FVRL: FND_FLEX_VALUE_RULE_LINES
FND_FVR: FND_FLEX_VALUE_RULES FND_FVRU: FND_FLEX_VALUE_RULE_USAGES
FND_RESP:FND_RESPONSIBILITY FND_TAB:FND_TABLES
FND_FVT:FND_FLEX_VALIDATION_TABLES
Concurrent Managers Tables
FND_CCR:FND_CONCURRENT_COMPLEX_RULES FND_CCL:FND_CONCURRENT_COMPLEX_LINES
FND_CPG: FND_CONCURRENT_PROGRAMS FND_CRC: FND_CONCURRENT_REQUEST_CLASS
FND_OID:FND_ORACLE_USERID FND_USER:FND_USER
FND_CGC: FND_CONCURRENT_QUEUE_CONTENT FND_CR: FND_CONCURRENT_REQUESTS
FND_NDS:FND_NODES FND_CPR: FND_CONCURRENT_PROCESSES
FND_DG:FND_DATA_GROUPS FND_CQP: FND_CONCURRENT_QUEUE_PARAMS
FND_CQ: FND_CONCURRENT_QUEUES FND_CPP:FND_CONC_PROCESSOR_PROGRAMS
FND_CPS: FND_CONCURRENT_PROCESSORS FND_CQS: FND_CONCURRENT_QUEUE_SIZE
FND_CTP: FND_CONCURRENT_TIME_PERIODS FND_APP:FND_APPLICATION
FND_CCR:FND_CONCURRENT_COMPLEX_RULES FND_CCL:FND_CONCURRENT_COMPLEX_LINES
FND_CPG: FND_CONCURRENT_PROGRAMS FND_CRC: FND_CONCURRENT_REQUEST_CLASS
FND_OID:FND_ORACLE_USERID FND_USER:FND_USER
FND_CGC: FND_CONCURRENT_QUEUE_CONTENT FND_CR: FND_CONCURRENT_REQUESTS
FND_NDS:FND_NODES FND_CPR: FND_CONCURRENT_PROCESSES
FND_DG:FND_DATA_GROUPS FND_CQP: FND_CONCURRENT_QUEUE_PARAMS
FND_CQ: FND_CONCURRENT_QUEUES FND_CPP:FND_CONC_PROCESSOR_PROGRAMS
FND_CPS: FND_CONCURRENT_PROCESSORS FND_CQS: FND_CONCURRENT_QUEUE_SIZE
FND_CTP: FND_CONCURRENT_TIME_PERIODS FND_APP:FND_APPLICATION
FND_CPA:FND_CONC_PP_ACTIONS FND_CRA:FND_CONC_REQUEST_ARGUMENTS
FND_RRL:FND_RUN_REQ_LANGUAGES FND_CR: FND_CONCURRENT_REQUESTS
FND_CD:FND_CONFLICT_DOMAINS FND_RES:FND_RESPONSIBILY
FND_CRC:FND_CONC_RELEASE_CLASSES FND_DGU:FND_DATA_GROUP_UNITS
FND_LOG:FND_LOGINS FND_DG:FND_DATA_GROUPS
FND_OID:FND_ORACLE_USERID FND_USR:FND_USER
FND_CRC: FND_CONCURRENT_REQUEST_CLASS FND_CPS: FND_CONCURRENT_PROGRAM-SERIAL
FND_CPG: FND_CONCURRENT-PROGRAMS FND_EXE:FND_EXECUTABLES
FND_CPA:FND_CONC_PP_ACTIONS FND_CRA:FND_CONC_REQUEST_ARGUMENTS
FND_RRL:FND_RUN_REQ_LANGUAGES FND_CR: FND_CONCURRENT_REQUESTS
FND_CD:FND_CONFLICT_DOMAINS FND_RES:FND_RESPONSIBILY
FND_CRC:FND_CONC_RELEASE_CLASSES FND_DGU:FND_DATA_GROUP_UNITS
FND_LOG:FND_LOGINS FND_DG:FND_DATA_GROUPS
FND_OID:FND_ORACLE_USERID FND_USR:FND_USER
FND_CRC: FND_CONCURRENT_REQUEST_CLASS FND_CPS: FND_CONCURRENT_PROGRAM-SERIAL
FND_CPG: FND_CONCURRENT-PROGRAMS FND_EXE:FND_EXECUTABLES
FND_RGU:FND_REQUEST_GROUP_UNITS FND_RS:FND_REQUEST_SETS
FND_RSS:FND_REQUEST_SET_STAGES FND_RRA:FND_RUN_REQ_PP_ACTIONS
FND_RG: FND_REQUEST_GROUPS FND_RSP: FND_REQUEST_SET_PROGRAMS
FND_RSA: FND_REQUEST_SET_PROGRAM_ARGS FND_RR:FND_RUN_REQUESTS
FND_DF:FND-DESCRIPTIVE_FLEXS FND_CPG:FND_CONCURRENT_PROGRAMS
FND_RES:FND_RESPONSIBILITY FND_APP:FND_APPLICATION
FND_RGU:FND_REQUEST_GROUP_UNITS FND_RS:FND_REQUEST_SETS
FND_RSS:FND_REQUEST_SET_STAGES FND_RRA:FND_RUN_REQ_PP_ACTIONS
FND_RG: FND_REQUEST_GROUPS FND_RSP: FND_REQUEST_SET_PROGRAMS
FND_RSA: FND_REQUEST_SET_PROGRAM_ARGS FND_RR:FND_RUN_REQUESTS
FND_DF:FND-DESCRIPTIVE_FLEXS FND_CPG:FND_CONCURRENT_PROGRAMS
FND_RES:FND_RESPONSIBILITY FND_APP:FND_APPLICATION
FND_URG:FND_USER_RESP_GROUPS FND_RES:FND_RESPONSIBILITY
FND_SG:FND_SECURITY_GROUPS FND_APP:FND_APPLICATION
FND_DGU:FND_DATA_GROUP_UNITS FND_AS:FND_APPLICATION_SERVERS
FND_OID:FND_ORACLE_USERID FND_DG:FND_DATA_GROUPS
FND_SESS:FND_SESSIONS FND_LRF:FND_LOGIN_RESP_FORMS
FND_LR:FND_LOGIN_RESPONSIBILITIES FND_LOG:FND_LOGINS
FND_UL:FND_UNSUCCESSFUL_LOGINS FND_USER:FND_USER
FND_URG:FND_USER_RESP_GROUPS FND_RES:FND_RESPONSIBILITY
FND_SG:FND_SECURITY_GROUPS FND_APP:FND_APPLICATION
FND_DGU:FND_DATA_GROUP_UNITS FND_AS:FND_APPLICATION_SERVERS
FND_OID:FND_ORACLE_USERID FND_DG:FND_DATA_GROUPS
FND_SESS:FND_SESSIONS FND_LRF:FND_LOGIN_RESP_FORMS
FND_LR:FND_LOGIN_RESPONSIBILITIES FND_LOG:FND_LOGINS
FND_UL:FND_UNSUCCESSFUL_LOGINS FND_USER:FND_USER
No comments:
Post a Comment