Oracle Apps Tables list (INV,PO,GL,AR,AP,FA,Flexfield,)

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_IFSTR:FND_ID_FLEX_STRUCTURE
 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:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf&#...