FUN Tables (78)
FUN - Financials Common Modules — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
FUN_BALANCE_ACCOUNTS |
27 | FUN_BALANCE_ACCOUNTS table stores the intracompany accounts defined between each trading and transacting balancing segment value. These acco |
FUN_BALANCE_OPTIONS |
32 | FUN_BALANCE_OPTIONS table stores the ledger, journal source and category information for which the Intracompany balancing rules have been de |
FUN_BAL_ERRORS_GT |
15 | |
FUN_BAL_ERRORS_T |
15 | FUN_BAL_ERRORS_T is a temporary table used internally by the Intercompany Balancing API. |
FUN_BAL_GENERATE_LINES |
2 | FUN_BAL_GENERATE_LINES is a temporary table used internally by the Intercompany balancing API. |
FUN_BAL_HEADERS_GT |
20 | FUN_BAL_HEADERS_GT is a global temporary table used by the Intercompany Balancing API. Calling modules like SLA and GL populate this table w |
FUN_BAL_HEADERS_T |
20 | FUN_BAL_HEADERS_T is a temporary table used internally by the Intercompany Balancing API. |
FUN_BAL_INTER_BSV_MAP_T |
26 | FUN_BAL_INTER_BSV_MAP_T is a temporary table used internally by the Intercompany balancing API. |
FUN_BAL_INTER_INT2_GT |
25 | |
FUN_BAL_INTER_INT2_T |
25 | |
FUN_BAL_INTER_INT_GT |
25 | FUN_BAL_INTER_INT_GT is a global temporary table used internally by the Intercompany Balancing API. |
FUN_BAL_INTER_INT_T |
25 | FUN_BAL_INTER_INT_T is a temporary table used internally by the Intercompany Balancing API. |
FUN_BAL_INTRA_BSV_MAP_T |
26 | FUN_BAL_INTRA_BSV_MAP_T is a temporary table used internally by the Intercompany balancing API. |
FUN_BAL_INTRA_INT_GT |
24 | FUN_BAL_INTRA_INT_GT is a global temporary table used internally by the Intercompany Balancing API |
FUN_BAL_INTRA_INT_T |
24 | FUN_BAL_IINTRA_INT_T is a temporary table used internally by the Intercompany Balancing API. |
FUN_BAL_LE_BSV_MAP_GT |
26 | FUN_BAL_LE_BSV_MAP_GT is a global temporary table used internally by the Intercompany Balancing API |
FUN_BAL_LINES_GT |
13 | FUN_BAL_LINES_GT is a global temporary table used by the Intercompany Balancing API. Calling modules like SLA and GL populate this table wit |
FUN_BAL_LINES_T |
13 | FUN_BAL_LINES_T is a temporary table used internally by the Intercompany Balancing API. |
FUN_BAL_RESULTS_GT |
22 | FUN_BAL_RESULTS_GT is a global temporary table used by the Intercompany balancing API. After balancing an Intercompany journal, the Intercom |
FUN_BAL_RESULTS_T |
22 | FUN_BAL_RESULTS_T is a temporary table used internally by the Intercompany balancing API. |
FUN_BATCH_DISTS |
28 | FUN_BATCH_DISTS stores the distribution details if user has chosen to enter distributions using the automatic proration mode. The amounts en |
FUN_CONTACTUS_REQUEST_DATA |
9 | This table contains information about the question or problem submitted by the end user that is stored in a prompt-value pair format. |
FUN_CONTACTUS_SETUP |
24 | This table contains the definition for the behavior of the Contact Us global button. |
FUN_CUSTOMER_MAPS |
25 | FUN_CUSTOMER_MAPS stores the details of the customer to which an Intercompany organization is mapped. When an invoice is created in receivab |
FUN_DIST_LINES |
34 | FUN_DIST_LINES stores the distributions for the Intercompany transactions. Both recipient and initiator distributions are stored in this tab |
FUN_INTERFACE_BATCHDISTS |
28 | /*# * Intercompany Batch Distributions Interface * @rep:scope public * @rep:lifecycle active * @rep:displayname Intercompany Batch Distr |
FUN_INTERFACE_BATCHES |
45 | /*# * Open interface table for Intercompany Batches. * @rep:scope public * @rep:lifecycle active * @rep:displayname Intercompany Batches |
FUN_INTERFACE_CONTROLS |
4 | /*# * Intercompany Open Interface Control table. * @rep:scope public * @rep:lifecycle active * @rep:displayname Intercompany Control Interfa |
FUN_INTERFACE_DIST_LINES |
33 | /*# * Intercompany Distributions Open Interface * @rep:scope public * @rep:lifecycle active * @rep:displayname Intercompany Distribution |
FUN_INTERFACE_HEADERS |
37 | /*# * Intercompany Transactions Open Interface * @rep:scope public * @rep:lifecycle active * @rep:displayname Intercompany Transaction H |
FUN_INTERFACE_REJECTIONS |
6 | |
FUN_INTER_ACCOUNTS |
33 | FUN_INTER_ACCOUNTS table stores the Intercompany receivables and payables accounts defined for each transacting and trading legal entity rel |
FUN_INTER_ACCOUNTS_ADDL |
33 | FUN_INTER_ACCOUNTS_ADDL table stores the accounts generated by replacing the intercompany and balancing segment value from the defined Inter |
FUN_NET_AGREEMENTS_ALL |
45 | FUN_NET_AGREEMENTS_ALL stores general information about Netting Agreements |
FUN_NET_AP_INVS_ALL |
40 | FUN_NET_AP_INVS_ALL stores information about Payables invoices included in Netting Batch. |
FUN_NET_AP_INV_TYPES_ALL |
30 | FUN_NET_AP_INV_TYPES_ALL stores information about the Payables Invoice Types that are included in a Netting Agreement |
FUN_NET_AR_TRX_TYPES_ALL |
30 | FUN_NET_AR_TRX_TYPES_ALL stores information about the ReceivablesTransaction Types that are included in a Netting Agreement. |
FUN_NET_AR_TXNS_ALL |
40 | FUN_NET_AR_TXNS_ALL stores information about Receivables Transactions included in Netting Batch. |
FUN_NET_BATCHES_ALL |
43 | FUN_NET_BATCHES_ALL stores information about Netting Batches. |
FUN_NET_CUSTOMERS_ALL |
33 | FUN_NET_CUSTOMERS_ALL stores information about the Customers that are included in a Netting Agreement. |
FUN_NET_SUPPLIERS_ALL |
33 | FUN_NET_SUPPLIERS_ALL stores information about the Suppliers that are included in a Netting Agreement. |
FUN_PERIOD_STATUSES |
37 | FUN_PERIOD_STATUSES stores the Intercompany period statuses if an Intercompany calendar has been defined in system options. Intercompany per |
FUN_RICH_MESSAGES_B |
9 | Stores information about rich messages which may contain HTML tags for pretty formatting. |
FUN_RICH_MESSAGES_TL |
10 | Stores information about rich messages which may contain HTML tags for pretty formatting. |
FUN_RULE_BULK_RESULT_GT |
5 | Global temporary table used by the bulk API to store the result values. |
FUN_RULE_CRITERIA |
13 | Stores a single criteria for a rule. |
FUN_RULE_CRIT_PARAMS_B |
16 | Stores the available criteria parameters for a Rule Object. |
FUN_RULE_CRIT_PARAMS_TL |
13 | Stores the available criteria parameters for a Rule Object. |
FUN_RULE_DETAILS |
15 | Stores details about a rule. |
FUN_RULE_OBJECTS_B |
22 | Stores information about Rule Objects. |
FUN_RULE_OBJECTS_TL |
11 | Stores information about Rule Objects. |
FUN_RULE_OBJ_ATTRIBUTES |
9 | Stores additional Rule Object attributes. |
FUN_RULE_PARAM_VALUES |
10 | Stores the multiple criteria parameter values that are used in evaluation of a criteria. If a criteria uses a parameters that is based on an |
FUN_RULE_TESTS |
11 | Stores test cases for the Financials Rules Engine |
FUN_RULE_TEST_MULTIRULE |
8 | Stores the test results for a test if multiple results are allowed for the Rule Object |
FUN_RULE_TEST_MVAL_RES |
24 | |
FUN_RULE_TEST_PARAMS |
9 | Stores parameter values for tests. |
FUN_RULE_TEST_RESULTS |
9 | |
FUN_SEQ_ASSIGNMENTS |
22 | |
FUN_SEQ_CONTEXTS |
19 | |
FUN_SEQ_ENTITIES |
9 | |
FUN_SEQ_HEADERS |
12 | |
FUN_SEQ_REQUESTS |
8 | |
FUN_SEQ_RULES |
14 | |
FUN_SEQ_VERSIONS |
17 | |
FUN_SUBSIDIARY_PARTY_MAPPINGS |
9 | FUN_SUBSIDIARY_PARTY_MAPPINGS is used to upgrade GL Subsidiaries as Intercompany Organizations. This table is not used once the organization |
FUN_SUPPLIER_MAPS |
25 | FUN_SUPPLIER_MAPS stores the details of the supplier to which an Intercompany organization is mapped. When an invoice is created in payables |
FUN_SYSTEM_OPTIONS |
37 | FUN_SYSTEM_OPTIONS stores setup options defined at the system level which applies across the whole system. This table will always contain o |
FUN_TRADE_RELATIONS |
31 | FUN_TRADE_RELATIONS stores the association of an Intercompany organization as a customer or a supplier. These associations are used when the |
FUN_TRANSFERS |
31 | This table is no longer used. |
FUN_TRX_ACCT_DEFINITIONS |
9 | FUN_TRX_ACCT_DEFINITIONS stores the association between a ledger and SLA transaction account definition. This association is used to indicat |
FUN_TRX_BATCHES |
44 | FUN_TRX_BATCHES stores information about the Intercompany transaction batches. The BATCH_NUMBER and INITIATOR_ID together form a unique key. |
FUN_TRX_HEADERS |
46 | FUN_TRX_HEADERS stores the transactions that make up an Intercompany transaction batch. The INITIATOR_ID, RECIPIENT_ID, BATCH_ID together fo |
FUN_TRX_LINES |
14 | FUN_TRX_LINES stores some line level information for an intercompany transaction.Each row in FUN_TRX_HEADERS currently maps to 1 row in FUN_ |
FUN_TRX_TYPES_B |
29 | FUN_TRX_TYPES_B stores the Intercompany transaction types defined. |
FUN_TRX_TYPES_TL |
11 | FUN_TRX_TYPES_TL stores the translatable column details for the Intercompany transaction types. |
FUN_TRX_TYPE_AR_MAPS |
27 | FUN_TRX_TYPE_AR_MAPS stores the mapping between the Intercompany transaction type and the Receivables Transaction Type and Receivables Memo |
FUN_XLA_TAB_GT |
112 |