其它差异
R12新增加ap_invoice_lines表；
官方解释：
Oracle Payables introduces invoice lines as an entity between the invoice header and
invoice distributions. With the new model, the invoice header remains unchanged, and continues to store information about the supplier who sent the invoice, the invoice attributes, and remittance information.Invoice lines represent the goods (direct or indirect materials), service(s), and/orassociated tax/freight/miscellaneous charges invoiced. Invoice distributions store theaccounting, allocation and other detail information that makes up the invoice line. Thecharge allocation table used in prior releases to manage accounting allocations is obsolete.During the upgrade, Oracle Payables creates invoice lines for all existing invoices,creating one line for every distribution available in the Release 11i distributions table,except in the case of reversal pairs. In those cases, Payables creates one line with a zero amount.
供应商银行信息表变化
11i
R12
AP_BANK_ACCOUNTS_ALL
IBY_EXTERNAL_PAYEES_ALL
IBY_EXT_BANK_ACCOUNTS
IBY_PMT_INSTR_USES_ALL
付款银行表变化
11i
R12
AP_BANK_ACCOUNTS_ALL
CE_BANK_ACCOUNTS
AP_BANK_ACCOUNT_USES_ALL
CE_BANK_ACCT_USES_ALL
AP_BANK_BRANCHES
CE_BANK_BRANCHES_V
取付款银行信息sql(R12):
View Code
4.供应商表变化
11i
R12
PO_VENDORS
AP_SUPPLIERS
PO_VENDOR_SITES_ALL
AP_SUPPLIER_SITES_ALL
PO_VENDOR_CONTACTS
AP_SUPPLIER_CONTACTS
5.Payment Documents 表变化
11i
R12
AP_CHECK_STOCKS_ALL
CE_PAYMENT_DOCUMENTS
取Payment Documents SQL（R12）:
View Code
6.Payment Batch
表变化:
11i
R12
AP_CHECKS_ALL
AP_CHECKS_ALL
AP_INV_SELECTION_CRITERIA_ALL
AP_INV_SELECTION_CRITERIA_ALL
AP_SELECTED_INVOICES_ALL
AP_SELECTED_INVOICES_ALL
AP_SELECTED_INVOICE_CHECKS_ALL
IBY_PAY_SERVICE_REQUESTS
IBY_PAY_INSTRUCTIONS_ALL
IBY_PAYMENTS_ALL
批付款操作界面变化:
11i:
7.税
R11版本按照设置税码税率计算税；在R12版以后，在计税方面有了重大改变，税也成为一个独立的模块。其计税的逻辑也从以前单纯的税码和税率的关联转换为通过税则，来建 立会计分类代码（fiscal classification code）与税率的联系。会计分类代码可以应用至交易方（Party）、产品（Product）以及事务处理（Transaction）之上。 具体介绍请参 照<<TAX专题>>
官方解释：
Oracle E-Business Tax manages tax across the E-Business Suite. In prior releases, the
setup, defaulting, and calculation of tax for Payables was managed within Payables
using tax codes, their associated rates, and a hierarchy of defaulting options. This method is still available in this release. During the upgrade, E-Business Tax migrates the tax codes as appropriate within E-Business Tax so that your tax processing can work the same way after the upgrade as it did before.New fields are added to the supplier, invoice, and invoice lines entities to track tax attributes used by E-Business Tax. Many of these attributes were implemented withglobal descriptive flexfields in prior releases and are upgraded to regular fields on these entities.
表变化:
11i
R12
AP_TAX_CODES_ALL
ZX_LINES_SUMMARY
ZX_LINES
ZX_RATES_TL
PO税查询sql:
View Code
AP Invoices应付发票【Open Interface】
以R12为例，具体介绍应付发票导入，R12导入应付发票较11i有部分不同，比如:
11i,ap_invoice_lines_interface弹性域写入发票分配行，r12默认写入发票行，可能过profile设定，把行上的弹性域带到分配行上，profile:AP_COPY Invoice Lines Flex fied 设为Y;
发票税导入：
11i通过税码，税率产生税，R12按照发票行上的税信息产生税，具体的规则见下表：
ITEM1
ITEM2
TAX1
TAX2
LINE_NUMBER
1
2
3
4
LINE_GROUP_NUMBER
1
2
1
2
TAX_REGIME_CODE
The set of tax rules that determines the treatment of one or
more taxes administered by a tax authority
TAX
A classification of a charge imposed by a government through a fiscal or tax authority.
TAX_RATE_CODE
Tax rate name associated with tax rate identifier
TAX_STATUS_CODE
Tax status code
TAX_JURISDICTION_CODE
Internal ID of the Tax Jurisdiction
TAX_RATE
TAX_RATE
TAX_RATE_ID
TAX_RATE_ID is unique while the TAX_RATE_CODE may have different tax rates based on date ranges
PRORATE_ACROSS_FLAG
Y
Y
Y
Y
接口表，错误信息表
接口表
数据表
说明
ap_invoices_interface
ap_invoices_all
AP头
ap_invoice_lines_interface
ap_invoice_distributions_all
AP行
ap_interface_rejections
错误信息表
并发程序Payables Open Interface Import
参数
说明
Operating Unit
ou
Source
来源
Group
组ID，放空代表全部
Batch Name
批名
Hold Name
放空即可
Hold Reason
放空即可
GL Date
放空即可
Purge
Y，是否删除成功导入的记录
Trace Switch
N，是否启用Trace，隐藏的参数
Debug Switch
N，是否启用调式信息，隐藏的参数
Summarize Report
N，是否打印汇总报表，隐藏的参数
Commit Batch Size
放空即可，隐藏的参数
User ID
放空即可，隐藏的参数
Login ID
放空即可，隐藏的参数
关键字段
ap_invoices_interface
字段
说明
org_id
经营单位ID
invoice_id
来自ap_invoices_interface_s
invoice_num
发票号
invoice_type_lookup_code
STANDARD是标准发票，CREDIT是Credit Memo
invoice_date
发票日期
vendor_id
供应商ID
vendor_site_id
供应商地点
invoice_amount
发票金额
invoice_currency_code
发票币种
exchange_xxx
如果是外币，需要输入汇率类型、日期、汇率
SOURCE
来源，来自快速编码SOURCE
group_id
组ID，可直接用invoice_id
5个who字段
习惯上都给
ap_invoice_lines_interface
字段
说明
org_id
经营单位ID
invoice_id
=ap_invoices_interface.invoice_id
invoice_line_id
来自ap_invoice_lines_interface_s
accounting_date
财务日期
line_number
行号
line_type_lookup_code
行类型
amount
金额
dist_code_combination_id
账户ID
5个who字段
习惯上都给
View Code
AP常用API
使用API可在开发中得到便利，下面介绍AP模块几个常用的API:
AP_INVOICES_PKG
AP_INVOICES_INTERFACE_PKG
AP_INVOICE_LINES_INTERFACE_PKG
AP_IMPORT_INVOICES_PKG
AP_IMPORT_VALIDATION_PKG
R11
R12
附 ：R12中子模块的帐是如何产生的
1) 在FORM:ARXRWMAI 的按钮 SLACEXEC.OK_BP 触发器中有提交创建的代码:
arp_sla_submit.which_case;
2)包arp_sla_submit在pll文件ARSLAOLS.pll中。
3)在arp_sla_submit.which_case中执行以下过程，将FORM界面上的信息传入过程
submit_xla_accounting
4) submit_xla_accounting过程调用以下数据库package创建会计科目
XLA_ACCOUNTING_PUB_PKG.accounting_program_document
5)在XLA_ACCOUNTING_PUB_PKG中根据p_offline_flag的取值，分别调用
xla_accounting_pkg.accounting_program_document
或者调用创建会计科目的请求
6)在xla_accounting_pkg中调用下面过程
xla_accounting_pkg.accounting_program_events
7)在events_processor在调用handle_accounting_hook调根据application_id分别调用
CASE
WHEN p_application_id = 200 THEN
xla_ap_acct_hooks_pkg.main
WHEN p_application_id = 222 THEN
xla_ar_acct_hooks_pkg.main
WHEN p_application_id = 140 THEN
xla_fa_acct_hooks_pkg.main
WHEN p_application_id = 260 THEN
xla_ce_acct_hooks_pkg.main
WHEN p_application_id = 555 THEN
xla_gmf_acct_hooks_pkg.main
WHEN p_application_id = 801 THEN
xla_pay_acct_hooks_pkg.main
ELSE
END CASE;
其中event_name为extract。然后调用arp_xla_extract_main_pkg.extract 来取子模块的分配。其主要作用是将来自子模块的分配。AR的发票、调整、收款、核销等子模块的帐的分配插入 ar_xla_lines_extract临时表，在这个package中可以看到xla是如何从业务模块数据取数的。
