其它差异

1. 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.

1. 供应商银行信息表变化

11i	R12
AP_BANK_ACCOUNTS_ALL	IBY_EXTERNAL_PAYEES_ALL
	IBY_EXT_BANK_ACCOUNTS
	IBY_PMT_INSTR_USES_ALL

1. 付款银行表变化

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):

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）:

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:

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_invoice_lines_interface

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是如何从业务模块数据取数的。