List of Oracle E-Business Suite Tax Tables

ZX_ACCOUNT_RATES

ZX_ACCOUNTS

ZX_ACCT_TX_CLS_DEFS_ALL

ZX_API_CODE_COMBINATIONS

ZX_API_OWNER_STATUSES

ZX_API_REGISTRATIONS

ZX_COMPOUND_ERRORS

ZX_COMPOUND_ERRORS_T

ZX_CONDITION_GROUPS_B

ZX_CONDITION_GROUPS_TL

ZX_CONDITIONS

ZX_CONTENT_CHOICES_TMP

ZX_CONTENT_SOURCES

ZX_DATA_UPLOAD_DISCARD

ZX_DATA_UPLOAD_INTERFACE

ZX_DET_FACTOR_TEMPL_B

ZX_DET_FACTOR_TEMPL_DTL

ZX_DET_FACTOR_TEMPL_TL

ZX_DET_FACTORS_TL

ZX_DETAIL_TAX_LINES_GT1

ZX_DETERMINING_FACTORS_B

ZX_DIST_BKP_12345

ZX_DISTCCID_DET_FACTS_GT

ZX_DISTRIBUTION_LINES_GT

ZX_DISTS_B12345

ZX_ERRORS_GT

ZX_ERRORS_INT

ZX_EVENT_CLASS_PARAMS

ZX_EVENT_CLASSES_B

ZX_EVENT_CLASSES_TL

ZX_EVNT_CLS_MAPPINGS

ZX_EVNT_CLS_OPTIONS

ZX_EVNT_CLS_TYPS

ZX_EVNT_TYP_MAPPINGS

ZX_EXCEPTIONS

ZX_EXEMPTIONS

ZX_EXEMPTIONS_INT

ZX_FC_CODES_B

ZX_FC_CODES_CATEG_ASSOC

ZX_FC_CODES_DENORM_B

ZX_FC_CODES_TL

ZX_FC_COUNTRY_DEFAULTS

ZX_FC_TYPES_B

ZX_FC_TYPES_REG_ASSOC

ZX_FC_TYPES_TL

ZX_FORMULA_B

ZX_FORMULA_DETAILS

ZX_FORMULA_TL

ZX_ID_TCC_MAPPING_ALL

ZX_IMPORT_TAX_LINES_GT

ZX_ITM_DISTRIBUTIONS_GT

ZX_JURISDICTIONS_B

ZX_JURISDICTIONS_GT

ZX_JURISDICTIONS_TL

ZX_LINES

ZX_LINES_B12345

ZX_LINES_BKP_12345

ZX_LINES_DET_FACTORS

ZX_LINES_SUMMARY

ZX_MRC_GT

ZX_PARAM_DETAILS

ZX_PARAMETERS_B

ZX_PARAMETERS_TL

ZX_PARTY_TAX_PROFILE

ZX_PARTY_TAX_PROFILE_INT

ZX_PARTY_TYPES

ZX_PO_REC_DIST

ZX_PROCESS_RESULTS

ZX_PRODUCT_OPTIONS_ALL

ZX_PRODUCT_OPTIONS_ALL_A

ZX_PRVDR_HDR_EXTNS_GT

ZX_PRVDR_LINE_EXTNS_GT

ZX_PTNR_LOCATION_INFO_GT

ZX_PTNR_NEG_LINE_GT

ZX_PTNR_NEG_TAX_LINE_GT

ZX_PURGE_TRANSACTIONS_GT

ZX_RATES_B

ZX_RATES_TL

ZX_REC_NREC_DIST

ZX_REC_NREC_DIST_GT

ZX_RECOVERY_TYPES_B

ZX_RECOVERY_TYPES_TL

ZX_REGIME_RELATIONS

ZX_REGIMES_B

ZX_REGIMES_TL

ZX_REGIMES_USAGES

ZX_REGISTRATIONS

ZX_REGISTRATIONS_INT

ZX_REP_ACTG_EXT_T

ZX_REP_CONTEXT_T

ZX_REP_MATRIX_EXT_T

ZX_REP_TRX_DETAIL_T

ZX_REP_TRX_JX_EXT_T

ZX_REPORT_CODES_ASSOC

ZX_REPORT_CODES_ASSOC_INT

ZX_REPORT_TYPES_USAGES

ZX_REPORTING_CODES_B

ZX_REPORTING_CODES_TL

ZX_REPORTING_TYPES_B

ZX_REPORTING_TYPES_TL

ZX_REV_TRX_HEADERS_GT

ZX_REVERSE_DIST_GT

ZX_REVERSE_TRX_LINES_GT

ZX_RULES_B

ZX_RULES_TL

ZX_SERVICE_TYPES

ZX_SIM_CONDITIONS

ZX_SIM_PROCESS_RESULTS

ZX_SIM_PURGE

ZX_SIM_RULE_CONDITIONS

ZX_SIM_RULES_B

ZX_SIM_RULES_TL

ZX_SIM_TRX_DISTS

ZX_SRVC_SBSCRPTN_EXCLS

ZX_SRVC_SUBSCRIPTIONS

ZX_SRVC_TYP_PARAMS

ZX_STATUS_B

ZX_STATUS_TL

ZX_SUBSCRIPTION_DETAILS

ZX_SUBSCRIPTION_OPTIONS

ZX_SUMMARY_B12345

ZX_SUMMARY_BKP_12345

ZX_SUMMARY_TAX_LINES_GT

ZX_TAX_DIST_ID_GT

ZX_TAX_PRIORITIES_T

ZX_TAX_RELATIONS_T

ZX_TAXES_B

ZX_TAXES_TL

ZX_TEST_API_GT

ZX_TRANSACTION

ZX_TRANSACTION_LINES

ZX_TRANSACTION_LINES_GT

ZX_TRANSACTIONS_GT

ZX_TRX_HEADERS_GT

ZX_TRX_LINE_APP_REGIMES

ZX_TRX_PRE_PROC_OPTIONS_GT

ZX_TRX_TAX_LINK_GT

ZX_UPDATE_CRITERIA_RESULTS

ZX_VALDN_STATUSES_GT

ZX_VALIDATION_ERRORS_GT

Overview of Oracle Financials

Below is a quick diagram of the Oracle Financials Cloud Modules and how they all interact with each other. Note that most of these modules are also found in Oracle E-Business Suite.

Below summarizes some of the important modules in Oracle Financials:

General Ledger (usually abbreviated to GL)

• The Financial application that records all the finalized transactions of an organization
• Deals with Ledgers, Periods, Currencies, Accounting Convention (sometimes called SubLedger Accounting Method) and finalized financial reporting

SubLedger Accounting (usually called SLA)

• A subset application of the General Ledger that holds all the finalized transactions of the other modules (somewhat like an interface).
• Transferring data from Subledgers to the General Ledger can be done on the Balances, Journal and Subledger Level (Lowest to Highest, respectively)
• More information on a separate article: Overview of Subledger Accounting in Oracle Fusion Applications

Payables (sometimes called Accounts Payables or AP)

• The Financial application that deals with Suppliers and Payments
• Also linked to the Procurement Module via Purchase Orders and Requisitions
• Invoices can be automatically created once a Supplier has delivered the ordered goods and the organization has confirmed it.
• The Payment process can then be initiated and electronically transmitted to the Bank for Processing.
• Run Create Accounting to Transfer to SubLedger Accounting (SLA)

Expenses

• A subset application of Payables that deals with employee expense reimbursement such as Travel, Food, Accomodation, etc.
• Expenses Can be entered via Spreadsheets, Mobile Application and usually goes through an approval process
• Once approved, the expense will become a Payment Request in Payables for Reimbursement to be paid to the Employee
• Follows the same process of "Create Accounting" through Payables

Assets (sometimes called Fixed Assets in EBS)

• The Financial application that deals with Company Assets and how their value fluctuates over time.
• Can be linked to Payables when an organization orders goods that are tagged as an Asset.
• Assets can then be posted into the "Asset Book" and starts the Asset life cycle (Appreciation, Depreciation, Transfer, Adjustments, Retire, etc.).
• Run Create Accounting to Transfer to SubLedger Accounting (SLA)

Receivables (sometimes called Accounts Receivables or AR)

• The Financial application that creates and sends Invoices to Customers (can be created Manually or interfaced via AutoInvoice from Projects, third-party applications, etc.)
• Receipts are then issued once customers have paid the Invoices
• Run Create Accounting to Transfer to SubLedger Accounting (SLA)

Advanced Collections

• A subset application of receivables that deals with customer payment collection.
• Collectors can review delinquent, non-paying Customers and issue a reminder in the form of Dunning.
• Customers can then issue a Promise to Pay letter or raise a Dispute on payments.
• Every action a collector and customer is recorded in the application and can automatically raise flags/reminders when thresholds are not met.

Cash Management (usually abbreviated to CM)

• Reconcile Bank Statements to and from the Bank and link up to transactions within the application such as receipts
• Includes Miscellaneous Transactions such as Bank Interest and charges
• Cash Forecast and Positions
• Transactions such as External Transactions (Bank Charges or Interest Income) and Bank Account Transfers initiated from the Cash Management application goes into SubLedger Accounting

Tax (called E-Business Tax in EBS)

• Module responsible for the Calculation for Tax for both AR and AP
• Can be automatically linked to third-party tax providers such as Vertex
• Defines the Tax Regimes, Rates and Tax Recovery Rates, depending on the geographical area

For more full-detailed Tutorials and Tips, check out #TheOracleProdigy at https://lifeofanoracleprodigy.blogspot.com/

Follow The Oracle Prodigy on Facebook (https://www.facebook.com/theOracleProdigy/) and Twitter (https://twitter.com/D_OracleProdigy)