You are browsing the archive for AP.

Accounts Payables R12 enhancements

R12 enhancements in AP module

1) New user Interface to Supplier entry & maintenance

  • A new HTML form is available in R12 for entering and updating Suppliers.

2) Suppliers, Supplier sites and contacts

  • Suppliers, sites and contacts are part of TCA (Trading Community Architecture).
  • Each supplier site, contact is defined in TCA globally and any site can use it. Any changes to supplier sites/contacts can be done at TCA level that will reflect automatically in every site (OU), in R11 manually every site/contact should be updated whenever needed.

3) Accounts Payable Invoice Lines

  • R11 Invoices will have only invoice headers and distributions, now in R12 Invoices will have invoice lines and invoice lines will have distributions. Freight, special charges are captured at line level giving the functionality to capture more details at distribution levels.
  • This help in better data visibility/integration with other modules.

4) Banks and Bank Details

  • Bank data model is migrated to TCA architecture. Banks and Bank branches are TCA parties in R12. Bank account information is moved to Cash management

5) Integration with Oracle E-Business Tax

  • A new module ‘E-Business Tax’ is used to configure and manage taxation rules. This determines the tax for each transaction. In R11 descriptive flex fields are used for country specific tax attributes.

6) Multi Org Access Control

  • In R11 each responsibility is associated with an Operating Unit (OU), to access data from different OU, user has to switch responsibility. In R12 while it still maintains the data restriction across OUs, but user can access different OU without changing the responsibility as long as he was given access to different OU.

 

Oracle Accounts Payables Tables

  • AP_1096_DATA_ALL
  • AP_1099_TAPE_DATA_ALL
  • AP_ACCOUNTING_EVENTS_ALL
  • AP_AE_HEADERS_ALL
  • AP_AE_LINES_ALL
  • AP_AGING_PERIODS
  • AP_AGING_PERIOD_LINES
  • AP_ALLOCATION_RULES
  • AP_ALLOCATION_RULE_LINES
  • AP_APINV_APPROVERS
  • AP_AUD_AUDITORS
  • AP_AUD_AUDIT_REASONS
  • AP_AUD_AUTO_AUDITS
  • AP_AUD_QUEUES
  • AP_AUD_RULE_ASSIGNMENTS_ALL
  • AP_AUD_RULE_SETS
  • AP_AUD_WORKLOADS
  • AP_AWT_BUCKETS_ALL
  • AP_AWT_GROUPS
  • AP_AWT_GROUP_TAXES_ALL
  • AP_AWT_TAX_RATES_ALL
  • AP_AWT_TEMP_DISTRIBUTIONS_ALL
  • AP_BANK_ACCOUNTS_ALL
  • AP_BANK_ACCOUNT_USES_ALL
  • AP_BANK_BRANCHES
  • AP_BANK_CHARGES
  • AP_BANK_CHARGE_LINES
  • AP_BANK_TRANSMISSIONS
  • AP_BATCHES_ALL
  • AP_CARDS_ALL
  • AP_CARD_CODES_ALL
  • AP_CARD_CODE_SETS_ALL
  • AP_CARD_CURRENCIES
  • AP_CARD_DETAILS
  • AP_CARD_EMP_CANDIDATES
  • AP_CARD_GL_ACCTS_ALL
  • AP_CARD_GL_SETS_ALL
  • AP_CARD_PARAMETERS
  • AP_CARD_PROFILES_ALL
  • AP_CARD_PROFILE_LIMITS_ALL
  • AP_CARD_PROGRAMS_ALL
  • AP_CARD_REQUESTS_ALL
  • AP_CARD_SUPPLIERS_ALL
  • AP_CC_ACCEPTORS
  • AP_CC_TRX_DETAILS
  • AP_CHECKRUN_CONC_PROCESSES_ALL
  • AP_CHECKRUN_CONFIRMATIONS_ALL
  • AP_CHECKS_ALL
  • AP_CHECK_FORMATS
  • AP_CHECK_INTEGERS
  • AP_CHECK_STOCKS_ALL
  • AP_CHECK_TRANSMISSIONS
  • AP_CHRG_ALLOCATIONS_ALL
  • AP_CHRG_ALLOCATIONS_ALL_EFC
  • AP_CREDIT_CARD_TRXNS_ALL
  • AP_CURRENCY_GROUP
  • AP_DBI_LOG
  • AP_DISTRIBUTION_SETS_ALL
  • AP_DISTRIBUTION_SET_LINES_ALL
  • AP_DOC_SEQUENCE_AUDIT
  • AP_DUPLICATE_VENDORS_ALL
  • AP_ENCUMBRANCE_LINES_ALL
  • AP_ENCUMBRANCE_LINES_ALL_EFC
  • AP_EXPENSE_FEED_DISTS_ALL
  • AP_EXPENSE_FEED_LINES_ALL
  • AP_EXPENSE_PARAMS_ALL
  • AP_EXPENSE_REPORTS_ALL
  • AP_EXPENSE_REPORT_HEADERS_ALL
  • AP_EXPENSE_REPORT_LINES_ALL
  • AP_EXPENSE_REPORT_PARAMS_ALL
  • AP_EXP_LOCATIONS
  • AP_EXP_REPORT_DISTS_ALL
  • AP_FLEX_SEGMENT_MAPPINGS_ALL
  • AP_HISTORY_CHECKS_ALL
  • AP_HISTORY_INVOICES_ALL
  • AP_HISTORY_INV_PAYMENTS_ALL
  • AP_HOLDS_ALL
  • AP_HOLD_CODES
  • AP_IDENT_PARTY_SITE_GT
  • AP_INCOME_TAX_REGIONS
  • AP_INCOME_TAX_TYPES
  • AP_INTEREST_PERIODS
  • AP_INTERFACE_CONTROLS
  • AP_INTERFACE_REJECTIONS
  • AP_INVOICES_ALL
  • AP_INVOICES_INTERFACE
  • AP_INVOICES_UPG_CONTROL
  • AP_INVOICE_DISTRIBUTIONS_ALL
  • AP_INVOICE_DISTRIBUTIONS_GT
  • AP_INVOICE_KEY_IND_ALL
  • AP_INVOICE_LINES_ALL
  • AP_INVOICE_LINES_INTERFACE
  • AP_INVOICE_PAYMENTS_ALL
  • AP_INVOICE_PREPAYS_ALL
  • AP_INVOICE_RELATIONSHIPS
  • AP_INVOICE_TRANSMISSIONS
  • AP_INV_APRVL_HIST_ALL
  • AP_INV_DISTS_UPDATE
  • AP_INV_SELECTION_CRITERIA_ALL
  • AP_LE_GROUP
  • AP_LIABILITY_BALANCE
  • AP_LINES_UPG_SYNC_DATA
  • AP_LINE_APRVL_HIST_ALL
  • AP_MAP_CODES
  • AP_MAP_TYPES_B
  • AP_MAP_TYPES_TL
  • AP_MATCHED_RECT_ADJ_ALL
  • AP_MC_CHECKS
  • AP_MC_INVOICES
  • AP_MC_INVOICE_DISTS
  • AP_MC_INVOICE_PAYMENTS
  • AP_MC_PAYMENT_HISTORY
  • AP_NEGOTIATION_HIST
  • AP_NOTES
  • AP_NO_MATCH_TRXNS
  • AP_ORG_ATTRIBUTES_GT
  • AP_ORG_COUNTRY_GT
  • AP_OTHER_PERIODS
  • AP_OTHER_PERIOD_TYPES
  • AP_OU_GROUP
  • AP_PARTY_CONTACT_SITES_GT
  • AP_PAYCARD_TRX_FEE_HEADER_ALL
  • AP_PAYCARD_TRX_FEE_LINES
  • AP_PAYMENT_DISTRIBUTIONS_ALL
  • AP_PAYMENT_HISTORY_ALL
  • AP_PAYMENT_HIST_DISTS
  • AP_PAYMENT_KEY_IND_ALL
  • AP_PAYMENT_PROGRAMS
  • AP_PAYMENT_REP_ITF
  • AP_PAYMENT_SCHEDULES_ALL
  • AP_PAYMENT_TEMPLATES
  • AP_PAY_GROUP
  • AP_PBATCH_SETS_ALL
  • AP_PBATCH_SET_LINES_ALL
  • AP_PERIOD_CLOSE_EXCPS_GT
  • AP_POL_CAT_OPTIONS_ALL
  • AP_POL_CONTEXT
  • AP_POL_EXRATE_OPTIONS_ALL
  • AP_POL_EXRATE_TOLERANCES
  • AP_POL_HEADERS
  • AP_POL_ITEMIZATIONS
  • AP_POL_LINES
  • AP_POL_LINES_HISTORY
  • AP_POL_LOCATIONS_B
  • AP_POL_LOCATIONS_TL
  • AP_POL_SCHEDULE_OPTIONS
  • AP_POL_SCHEDULE_PERIODS
  • AP_POL_VIOLATIONS_ALL
  • AP_PPA_INVOICES_GT
  • AP_PPA_INVOICE_DISTS_GT
  • AP_PPA_INVOICE_LINES_GT
  • AP_PREPAY_APP_DISTS
  • AP_PREPAY_HISTORY_ALL
  • AP_PRODUCT_REGISTRATIONS
  • AP_PRODUCT_SETUP
  • AP_PURGE_INVOICE_LIST
  • AP_R115_UPGRADE
  • AP_RECON_CHECK_RESULTS
  • AP_RECON_DETAILS
  • AP_RECON_DISTRIBUTIONS_ALL
  • AP_RECON_ERROR_CHK_GROUPS
  • AP_RECON_ERROR_CHK_GROUP_LINES
  • AP_RECON_LOCKS
  • AP_RECON_RECORD_CODES
  • AP_RECON_RECORD_SPECS
  • AP_RECON_SUMMARIES
  • AP_RECON_TRANSACTION_CODES
  • AP_RECURRING_PAYMENTS_ALL
  • AP_REPORTING_ENTITIES_ALL
  • AP_REPORTING_ENTITY_LINES_ALL
  • AP_SELECTED_INVOICES_ALL
  • AP_SELECTED_INVOICE_CHECKS_ALL
  • AP_SELF_ASSESSED_TAX_DIST_ALL
  • AP_SUPPLIERS
  • AP_SUPPLIERS_INT
  • AP_SUPPLIER_BALANCE_ITF
  • AP_SUPPLIER_CONTACTS
  • AP_SUPPLIER_INT_REJECTIONS
  • AP_SUPPLIER_SITES_ALL
  • AP_SUPPLIER_SITES_INT
  • AP_SUP_SITE_CONTACT_INT
  • AP_SYSTEM_PARAMETERS_ALL
  • AP_TAX_CODES_ALL
  • AP_TAX_DERIVATIONS
  • AP_TAX_RECVRY_RATES_ALL
  • AP_TAX_RECVRY_RULES_ALL
  • AP_TB_BALANCES_TMP
  • AP_TEMP_APPROVAL_ALL
  • AP_TERMS_LINES
  • AP_TERMS_TL
  • AP_TOLERANCES_ALL
  • AP_TOLERANCE_TEMPLATES
  • AP_TRANSMISSIONS_SETUP
  • AP_TRIAL_BAL
  • AP_TRIAL_BALANCE
  • AP_TRIAL_BALANCE_LEDGERS
  • AP_UNSELECTED_INVOICES_ALL
  • AP_USER_EXCHANGE_RATES
  • AP_VENDOR_AUDIT_TMP
  • AP_VENDOR_KEY_IND_ALL
  • AP_WEB_ACCFLEX_SEGMENTS
  • AP_WEB_AMEX_PARAMS
  • AP_WEB_DISC_LINES_GT
  • AP_WEB_EMPLOYEE_INFO_ALL
  • AP_WEB_PREFERENCES
  • AP_WEB_PROXY_ASSIGNMENTS
  • AP_WEB_SIGNING_LIMITS_ALL
  • AP_WEB_VAT_SETUP_ALL
  • AP_WHT_ITF
  • FINANCIALS_PURGES
  • FINANCIALS_PURGES_ALL
  • FINANCIALS_SYSTEM_PARAMS_ALL
  • OIE_ADDON_MILEAGE_RATES
  • OIE_ALLOCATION_PREFS
  • OIE_ATTENDEES_ALL
  • OIE_CURRENT_PAGE_SETTING
  • OIE_DATA_CAPTURE_FIELDS
  • OIE_DATA_CAPTURE_OPTIONS
  • OIE_DATA_CAPTURE_RULES
  • OIE_DISTRIBUTION_SETS_ALL
  • OIE_PDM_DAILY_BREAKUPS
  • OIE_PDM_DESTINATIONS
  • OIE_POL_RATES_INTERFACE
  • OIE_SET_DISTRIBUTIONS

Oracle Payables Forms

Oracle Accounts Payables module forms:

FORM SHORT CODE ORACLE FORM NAME
APXALLOC Charge Allocations
APXAMDOP Define Periods
APXAMDPT Define Period Types
APXCUMSP Define System Options and Defaults
APXIIFIX Fix Open Interface Invoices
APXIISIM Quick Invoices
APXIMTCH Correct Unmatched Invoice
APXINAWT Projected Withholding Tax
APXINWKB Invoice Workbench
APXIWALL Invoice Overview
APXPAWKB Payment Workbench
APXPBSET Payment Batch Set
APXPGSUB Submit Purge
APXPMTCH Match to Purchase Order
APXPWALL Payment Overview
APXRICAD Recurring Invoices
APXRMTCH Match to Receipts
APXSPDPF Define Payment Formats
APXSSFSO Define Financials Options
APXSSSOB Set of Books
APXSUAPL Set Up Aging Periods
APXSUDAP Define Automatic Payment Programs
APXSUDBC Define Bank Charges
APXSUDCC Maintain Countries and Territories
APXSUDIP Define Payment Interest Rates
APXSUIAC Define Invoice Approvals
APXSUMBA Set Up Bank Information
APXSUMDS Maintain Distribution Sets
APXSUMMT Define Tolerances
APXSUMPS Control Period Statuses
APXSUMVT Define Payment Terms
APXTADRR Define Tax Recovery Rules
APXTADTC Define Tax Names
APXTADTR Define Income Tax Regions
APXTBCKT View Period-to-Date Withheld Amounts
APXTCERT Tax Certificates and Exceptions
APXTGRPS Withholding Tax Groups
APXTRDRE Define Reporting Entities
APXUPDAE Update Accounting Entries
APXVDDUP Vendor Merge
APXVDMVD Enter Vendor
APXVWENC View Encumbrances
APXWCARD Credit Cards
APXWCODE Credit Card Code Sets
APXWCTRX Credit Card Transactions
APXWGSET Credit Card GL Sets
APXWPROF Credit Card Profiles
APXWPROG Credit Card Programs
APXWSLMT Employee Signing Limits
APXXXDER Define Expense Reports
APXXXEER XpenseXpress
APXSYSOP Define Payables System Setup
APXPRCOR Correct Matched Invoice
APXIAWHS Invoice Approval History
APXTVBNK View Transmissions Form
APXTSBNK Define Bank Transmission Setup Information
APXWTRXF Transaction Fees