R12 AP
PAYABLES
TABLE
NAME
|
FEATURE
AREA
|
CE_BANK_ACCOUNTS
|
INTERNAL BANK ACCOUNTS
|
CE_PAYMENT_DOCUMENTS
|
PAYMENT DOCUMENTS TO BE USED
FOR PRINTED TYPE PAYMENTS
|
IBY_EXTERNAL_PAYEES_ALL
|
PAYEE (TRADING PARTNER INFO
FOR PAYING INVOICES
|
IBY_PMT_INSTR_USES_ALL
|
USED FOR REMIT TO BANK
ACCOUNTS
|
AP_INVOICE_LINES_ALL
|
INVOICE LINES
|
AP_ALLOCATION_RULES
|
INVOICE LINES
|
AP_INVOICE_LINES_ALL
|
INVOICE LINES
|
AP_ALLOCATION_RULES
|
INVOICE LINES
|
AP_ALLOCATION_RULE_LINES
|
INVOICE LINES
|
AP_ALLOCATION_RULE_LINES_GT
|
GLOBAL TEMP TABLE FOR
INVOICE LINES – ALLOCATIONS
|
AP_SELF_ASSESSED_TAX_DIST_ALL
|
E-BUSINESS TAX
|
AP_PRODUCT_REGISTRATIONS
|
INVOICE LINES
|
AP_PRODUCT_SETUP
|
MULTI ORG ACCESS CONTROL
|
AP_TOLERANCE_TEMPLATES
|
SUPPORT OF COMPLEX PO
CONTRACTS
|
AP_NEGOTIATION_HIST
|
INVOICE REQUESTS
|
AP_NEGOTIATION_HIST
|
HOLDS RESOLUTION WORKFLOW
|
TABLE
NAME
|
FEATURE
AREA
|
BRIEF
DESCRIPTION OF CHANGE
|
AP_INVOICES_ALL
|
INVOICE LINES, EBUSINESS
TAX, PAYMENTS, SLA, COMPLEX WORK POS…
|
NUMEROUS COLUMNS WERE ADDED
TO THIS TABLE DUE TO ALMOST ALL THE PROJECTS DONE FOR R12, FOR LIST OF
COLUMNS ADDED PLEASE REFER TO THE TDD OF THE RESPECTIVE PROJECTS.
|
AP_INVOICE_DISTRIBUTIONS_ALL
|
INVOICE LINES, EBUSINESS
TAX…
|
NUMBER OF COLUMNS WERE ADDED
TO THIS TABLE DUE TO ALMOST ALL THE PROJECTS DONE FOR R12, FOR LIST OF
COLUMNS ADDED PLEASE REFER TO THE TDD OF THE RESPECTIVE PROJECTS.
|
AP_INV_APRVL_HIST_ALL
|
HOLDS RESOLUTION WORKFLOW
|
HOLD_ID COLUMN WAS ADDED.
|
AP_CHECKS_ALL
|
PAYABLES PAYMENTS DATA
|
SOME NEW COLUMNS ARE ADDED
TO AP_CHECKS_ALL TABLE FOR MAINTAINING REAL TIME SYNCHRONIZATION WITH ORACLE
PAYMENTS AND CASH MANAGEMENTS. SOME EXISTING COLUMNS FROM THE SAME TABLES
HAVE BEEN MADE OBSOLETE.
|
AP_HOLDS_ALL
|
HOLDS RESOLUTION WORKFLOW
|
NEW COLUMNS ADDED WERE:
HOLD_ID AND WF_STATUS.
|
AP_HOLD_CODES
|
HOLDS RESOLUTION WORKFLOW
|
NEW COLUMNS ADDED WERE:
HOLD_INSTRUCTION, WAIT_BEFORE_NOTIFY_DAYS, REMINDER_DAYS
|
AP_INV_APRVL_HIST_ALL
|
HOLDS RESOLUTION AND INVOICE
APPROVAL WORKFLOW
|
THIS WILL BE USED TO RECORD
HISTORY FOR BOTH THE INVOICE LEVEL APPROVALS AND INVOICE LINE LEVEL
APPROVALS. NEW COLUMNS ADDED WERE:LINE_NUMBER, HOLD_ID AND HISTORY_TYPE
|
AP_APINV_APPROVERS
|
INVOICE APPROVAL WORKFLOW
|
NEW COLUMNS ADDED
WERE:CHILD_PROCESS_ITEM_KEY, CHILD_PROCESS_ITEM_TYPE, ITEM_TYPE AND ITEM_KEY.
|
OBSOLETE TABLES
TABLE
NAME
|
FEATURE
AREA
|
REPLACED
BY
|
AP_BANK_BRANCHES
|
BANK/BANK BRANCHES
|
CE_BANK_BRANCHES_V
|
AP_BANK_ACCOUNTS_ALL
|
BANK ACCOUNTS INCLUDING
INTERNAL AND EXTERNAL
|
CE_BANK_USES_OU_V/IBY_EXT_BANK_
ACCOUNTS_V
|
AP_BANK_ACCOUNTS_USES_ALL
|
REMIT TO BANK ACCOUNT USES
|
|
AP_CHECK_STOCKS_ALL
|
PAYMENTS DOCUMENTS
|
CE_PAYMENT_DOCUMENTS
|
AP_CHECK_FORMATS
|
PAYMENTS FORMAT
|
|
AP_TAX_RECVRY_RULES_ALL
|
EBUSINESS TAX
|
REPLACED BY RELEVANT EBTAX
TABLES/VIEWS.
|
AP_TAX_RECVRY_RATES_ALL
|
EBUSINESS TAX
|
REPLACED BY RELEVANT EBTAX
TABLES/VIEWS.
|
AP_CHRG_ALLOCATIONS_ALL
|
INVOICE LINES - ALLOCATIONS
|
THIS FEATURE IS REPLACED BY
DISTRIBUTIONS ITSELF, DISTRIBUTIONS ITSELF REPRESENT THE ALLOCATION OF
CHARGES.
|
AP_TAX_DERIVATIONS
|
EBUSINESS TAX
|
REPLACED BY RELEVANT EBTAX
TABLES/VIEWS.
|
AP_LINE_APRVL_HIST_ALL
|
INVOICE APPROVAL WORKFLOW
|
AP_INV_APRVL_HIST_ALL
|
|
VIEW NAME
|
FEATURE AREA
|
|
AP_INVOICES_V
|
ALL
THE COLUMNS THAT WERE ADDED TO THE BASE TABLE DUE TO THE VARIOUS PROJECTS
WERE ADDED TO THIS VIEW TOO.
|
|
AP_INVOICE_DISTRIBUTIONS_V
|
ALL
THE COLUMNS THAT WERE ADDED TO THE BASE TABLE DUE TO THE VARIOUS PROJECTS
WERE ADDED TO THIS VIEW TOO.
|
|
PO_LINE_LOCATIONS_AP_V
|
PO MATCHING
|
|
AP_PO_DISTRIBUTIONS_AP2_V
|
PO
MATCHING AT DISTRIBUTION LEVEL.
|
|
PO_AP_RECEIPT_MATCH_V
|
RECEIPT
MATCHING VIEW
|
|
AP_APPLY_PREPAYS_V
|
INVOICE
LINES – PREPAYMENT APPLICATION
|
|
AP_UNAPPLY_PREPAYS_V
|
INVOICE
LINES – PREPAYMENT APPLICATION
|
|
AP_WF_APPROVAL_HISTORY_V
|
INVOICE
APPROVAL WORKFLOW
|
OBSOLETE
VIEWS
VIEW NAME
|
FEATURE AREA
|
AP_BANK_ACCOUNTS
|
INTERNAL/EXTERNAL
BANK ACCOUNTS MULTI-ORG VIEW
|
AP_BANK_ACCOUNT_USES
|
EXTERNAL
BANK ACCOUNT USES MULTI-ORG VIEW
|
AP_BANK_ACCOUNT_USES_V
|
EXTERNAL
BANK ACCOUNTS USES REFERENCE VIEW
|
THE FOLLOWING ARE THE NEW TABLES ADDED IN RELEASE 12 AS A PART OF
THIS INITIATIVE.
REFER TO THE ORACLE E-BUSINESS SUITE ELECTRONIC TECHNICAL REFERENCE
MANUAL FOR THE TABLE AND COLUMN DESCRIPTIONS..
· AP_SUPPLIERS
· AP_SUPPLIER_SITES_ALL
· AP_SUPPLIER_CONTACTS
· AP_SUPPLIER_INT_REJECTIONS
NEW VIEWS
THE FOLLOWING ARE THE NEW VIEWS ADDED IN RELEASE 12 AS A PART OF
THIS INITIATIVE.
THESE ARE BACKWARDS COMPATIBLE VIEWS THAT JOIN THE SUPPLIERS TABLE
IN PAYABLES AND THE TCA TABLES,
SO THAT ANY TEAMS USING THE OLD SUPPLIERS TABLES HAVE NO IMPACT.
· PO_VENDORS
· PO_VENDOR_SITES_ALL
· PO_VENDOR_CONTACTS
THE FOLLOWING TABLES ARE OBSOLETED:
· PO_VENDORS
· PO_VENDOR_SITES_ALL
· PO_VENDOR_CONTACTS
No comments:
Post a Comment