EBS R12 中国本地化报表使用设置

根据官方文档介绍,存在5张APAC本地化报表

1. Voucher Printing Report 凭证打印报表

2. General Ledger Voucher/Subledger Transaction Mapping Report

3. Daily Cash/Cash In Bank Report  现金/银行日记账报表

4. Ledger Report  明细账报表

5. Supplier/Customer Balance Detail Report  供应商客户余额明细报表

6. Supplier/Customer Balance Summary Report  供应商客户余额汇总报表

7. Inventory In Out On-Hand Report  库存收发存报表


这里重点说5/6需要怎样的设置,以下是官方原文:

If you plan to use these two reports, please make sure following steps have been completed:

1. Control Account segment qualifier should be defined for balance sheet accounts, for example, Receivable or Liability, to retrieve balance information for Third parties, including customers and suppliers. See: Defining Segment Qualifiers, Oracle General Ledger Implementation Guide.

将对应的科目段弹性域属性设置为应收或者负债科目

2. Run “Program – Inherit Segment Value Attribute” program to propagate Control Account attribute of the accounts defined in above step to all relevant account combinations. See: Segment Value Inheritance, Defining Segment Qualifiers, Oracle General Ledger Implementation Guide.

在GL模块运行请求Program – Inherit Segment Value Attribute(注意名字不同版本会略有差异)

3. Run “Subledger accounting balance updates” program under AP and AR to update third party balance.

在AP和AR模块运行请求Subledger accounting balance update(注意名字不同版本会略有差异)

4. MO: security profile should be set for the responsibility level to run these reports. See: Multiple Organizations in Oracle Applications

MO安全配置文件应该配置在职责层。


目前存在的问题:

1. 报表可以打印,但是没有数据产生(实际是存在未结应付和应收的)

20160621进度:已经提交SR,等待回复。

20160623进度:Oracle Support建议查看对应的标准报表是否有数据,名字为:Third Party Balances Report,但是实际情况是此表有值,而本地化报表没有值。

20160711进度:官方建议打补丁,更新XML的版本,具体patch为21878776:R12.CLA.B,下载链接

本文标题:EBS R12 中国本地化报表使用设置

本文链接:https://catonisland.cn/post/213.html

本文版权归作者所有,欢迎转载,转载请以文字链接的形式注明文章出处。

相关文章