You are browsing the archive for Oracle Financials Common Modules.

Oracle Intercompany Account Details Report

 

NAME: Oracle Intercompany Account Details Report
SHORT CODE: FUNARPT
MODULE: Oracle Finance Common Modules

Description: Oracle Intercompany Account Details Report
Navigation: Oracle Finance Common Modules Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • INITIATOR_FROM : Initiator from
  • INITIATOR_TO : Initiator to
  • TRANSACT_LE : Transacting Legal Entity
  • TRANSACT_LEDGER : Transacting Ledger
  • RECIPIENT_FROM : Recipient from
  • RECIPIENT_TO : Recipient to
  • TRADING_LE : Trading Partner Legal Entity
  • TRADING_LEDGER : Trading Partner Ledger
  • GL_DATE_FROM : GL Date From
  • GL_DATE_TO : GL Date To
  • BATCH_TYPE : Intercompany Batch Types
  • BATCH_NUMBER_FROM : Batch Number From
  • BATCH_NUMBER_TO : Batch Number To
  • BATCH_STATUS : Batch Status
  • TRANSACT_STATUS : Transaction Status
  • TRANSACT_TYPE : Transaction Type
  • CURRENCY : Currency
  • ACCOUNT_TYPE : Account Type
  • COA_INITIATOR : Chart of accounts ID of Initiator
  • COA_RECIPIENT : Chart of accounts ID of Recipient
  • AR_INVOICE_NUMBER : AR Invoice number

 

Transfer Intercompany Transactions to Payables

 

NAME: Transfer Intercompany Transactions to Payables
SHORT CODE: FUNAPTRR
MODULE: Oracle Finance Common Modules

Description: Transfer Intercompany Transactions to Payables
Navigation: Oracle Finance Common Modules Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_ORG_ID : Operating Unit
  • P_LE_ID : Legal Entity ID
  • P_DATE_LOW : GL Date From
  • P_DATE_HIGH : GL Date To
  • P_RUN_PAYABLES_IMPORT : Submit Payables Import Program

 

Oracle Financials Common Modules Tables

Oracle Financials Common Modules – Database Tables

FUN_BALANCE_ACCOUNTS
FUN_BALANCE_OPTIONS
FUN_BAL_ERRORS_GT
FUN_BAL_ERRORS_T
FUN_BAL_GENERATE_LINES
FUN_BAL_HEADERS_GT
FUN_BAL_HEADERS_T
FUN_BAL_INTER_BSV_MAP_T
FUN_BAL_INTER_INT_GT
FUN_BAL_INTER_INT_T
FUN_BAL_INTRA_BSV_MAP_T
FUN_BAL_INTRA_INT_GT
FUN_BAL_INTRA_INT_T
FUN_BAL_LE_BSV_MAP_GT
FUN_BAL_LINES_GT
FUN_BAL_LINES_T
FUN_BAL_RESULTS_GT
FUN_BAL_RESULTS_T
FUN_BATCH_DISTS
FUN_CONTACTUS_REQUEST_DATA
FUN_CONTACTUS_SETUP
FUN_CUSTOMER_MAPS
FUN_DIST_LINES
FUN_INTERFACE_BATCHDISTS
FUN_INTERFACE_BATCHES
FUN_INTERFACE_CONTROLS
FUN_INTERFACE_DIST_LINES
FUN_INTERFACE_HEADERS
FUN_INTERFACE_REJECTIONS
FUN_INTER_ACCOUNTS
FUN_NET_AGREEMENTS_ALL
FUN_NET_AP_INVS_ALL
FUN_NET_AP_INV_TYPES_ALL
FUN_NET_AR_TRX_TYPES_ALL
FUN_NET_AR_TXNS_ALL
FUN_NET_BATCHES_ALL
FUN_NET_CUSTOMERS_ALL
FUN_NET_SUPPLIERS_ALL
FUN_PERIOD_STATUSES
FUN_RICH_MESSAGES_B
FUN_RICH_MESSAGES_TL
FUN_RULE_BULK_RESULT_GT
FUN_RULE_CRITERIA
FUN_RULE_CRIT_PARAMS_B
FUN_RULE_CRIT_PARAMS_TL
FUN_RULE_DETAILS
FUN_RULE_OBJECTS_B
FUN_RULE_OBJECTS_TL
FUN_RULE_OBJ_ATTRIBUTES
FUN_RULE_PARAM_VALUES
FUN_RULE_TESTS
FUN_RULE_TEST_MULTIRULE
FUN_RULE_TEST_MVAL_RES
FUN_RULE_TEST_PARAMS
FUN_RULE_TEST_RESULTS
FUN_SEQ_ASSIGNMENTS
FUN_SEQ_CONTEXTS
FUN_SEQ_ENTITIES
FUN_SEQ_HEADERS
FUN_SEQ_REQUESTS
FUN_SEQ_RULES
FUN_SEQ_VERSIONS
FUN_SUBSIDIARY_PARTY_MAPPINGS
FUN_SUPPLIER_MAPS
FUN_SYSTEM_OPTIONS
FUN_TRADE_RELATIONS
FUN_TRANSFERS
FUN_TRX_ACCT_DEFINITIONS
FUN_TRX_BATCHES
FUN_TRX_HEADERS
FUN_TRX_LINES
FUN_TRX_TYPES_B
FUN_TRX_TYPES_TL
FUN_TRX_TYPE_AR_MAPS
FUN_XLA_TAB_GT

FUN – Financials Common Modules
TableFUN_BALANCE_ACCOUNTS
TableFUN_BALANCE_OPTIONS
TableFUN_BAL_ERRORS_GT
TableFUN_BAL_ERRORS_T
TableFUN_BAL_GENERATE_LINES
TableFUN_BAL_HEADERS_GT
TableFUN_BAL_HEADERS_T
TableFUN_BAL_INTER_BSV_MAP_T
TableFUN_BAL_INTER_INT_GT
TableFUN_BAL_INTER_INT_T
TableFUN_BAL_INTRA_BSV_MAP_T
TableFUN_BAL_INTRA_INT_GT
TableFUN_BAL_INTRA_INT_T
TableFUN_BAL_LE_BSV_MAP_GT
TableFUN_BAL_LINES_GT
TableFUN_BAL_LINES_T
TableFUN_BAL_RESULTS_GT
TableFUN_BAL_RESULTS_T
TableFUN_BATCH_DISTS
TableFUN_CONTACTUS_REQUEST_DATA
TableFUN_CONTACTUS_SETUP
TableFUN_CUSTOMER_MAPS
TableFUN_DIST_LINES
TableFUN_INTERFACE_BATCHDISTS
TableFUN_INTERFACE_BATCHES
TableFUN_INTERFACE_CONTROLS
TableFUN_INTERFACE_DIST_LINES
TableFUN_INTERFACE_HEADERS
TableFUN_INTERFACE_REJECTIONS
TableFUN_INTER_ACCOUNTS
TableFUN_NET_AGREEMENTS_ALL
TableFUN_NET_AP_INVS_ALL
TableFUN_NET_AP_INV_TYPES_ALL
TableFUN_NET_AR_TRX_TYPES_ALL
TableFUN_NET_AR_TXNS_ALL
TableFUN_NET_BATCHES_ALL
TableFUN_NET_CUSTOMERS_ALL
TableFUN_NET_SUPPLIERS_ALL
TableFUN_PERIOD_STATUSES
TableFUN_RICH_MESSAGES_B
TableFUN_RICH_MESSAGES_TL
TableFUN_RULE_BULK_RESULT_GT
TableFUN_RULE_CRITERIA
TableFUN_RULE_CRIT_PARAMS_B
TableFUN_RULE_CRIT_PARAMS_TL
TableFUN_RULE_DETAILS
TableFUN_RULE_OBJECTS_B
TableFUN_RULE_OBJECTS_TL
TableFUN_RULE_OBJ_ATTRIBUTES
TableFUN_RULE_PARAM_VALUES
TableFUN_RULE_TESTS
TableFUN_RULE_TEST_MULTIRULE
TableFUN_RULE_TEST_MVAL_RES
TableFUN_RULE_TEST_PARAMS
TableFUN_RULE_TEST_RESULTS
TableFUN_SEQ_ASSIGNMENTS
TableFUN_SEQ_CONTEXTS
TableFUN_SEQ_ENTITIES
TableFUN_SEQ_HEADERS
TableFUN_SEQ_REQUESTS
TableFUN_SEQ_RULES
TableFUN_SEQ_VERSIONS
TableFUN_SUBSIDIARY_PARTY_MAPPINGS
TableFUN_SUPPLIER_MAPS
TableFUN_SYSTEM_OPTIONS
TableFUN_TRADE_RELATIONS
TableFUN_TRANSFERS
TableFUN_TRX_ACCT_DEFINITIONS
TableFUN_TRX_BATCHES
TableFUN_TRX_HEADERS
TableFUN_TRX_LINES
TableFUN_TRX_TYPES_B
TableFUN_TRX_TYPES_TL
TableFUN_TRX_TYPE_AR_MAPS
TableFUN_XLA_TAB_GT