系列之五：ORACLE EBS 系统主数据管理(J)

1、.：.；系列之五：ORACLE EBS 系统主数据管理J热度 3已有 172 次阅读 2021/5/17 21:40 |系统分类：: HYPERLINK hi.erp100/home.php?mod=space&do=blog&view=all&catid=4 专业内容|关键词:EBS ORACLE 数据管理 系统 二十 HYPERLINK hi.erp100/link.php?url=hi.erp100%2Flink.php%3Furl%3Dhttp%3A%2F%2Fhi.erp100%252Flink.php%253Furl%253Dhttp%253A%252F%252Fhi.erp100

2、%25252Flink.php%25253Furl%25253Dhttp%25253A%25252F%25252Fhi.erp100%2525252Flink.php%2525253Furl%2525253Dhttp%2525253A%2525252F%2525252Fhi.erp100%252525252Flink.php%252525253Furl%252525253Dhttp%252525253A%252525252F%252525252Fhi.erp100%25252525252Flink.php%25252525253Furl%25252525253Dhttp%25252525253

3、A%25252525252F%25252525252Fhi.erp100%2525252525252Flink.php%2525252525253Furl%2525252525253Dhttp%2525252525253A%2525252525252F%2525252525252Fhi.erp100%252525252525252Feditor.php%252525252525253Fop%252525252525253Dblank%2525252525252526amp%252525252525253Bcharset%252525252525253Dgbk%2525252525252523%

4、25252525252525A3%25252525252525A8%25252525252525B6%25252525252525FE%25252525252525CA%25252525252525AE%25252525252525A3%25252525252525A9%25252525252525A1%25252525252525A2%25252525252525BF%25252525252525CD%25252525252525BB%25252525252525A7%25252525252525D5%25252525252525CB%25252525252525BB%25252525252

5、525A7%25252525252525B2%25252525252525E3%25252525252525C5%25252525252525E4%25252525252525D6%25252525252525C3%25252525252525CE%25252525252525C4%25252525252525BC%25252525252525FE%25252525252525A3%25252525252525BA%25252525252525D2%25252525252525B5%25252525252525CE%25252525252525F1%25252525252525C4%25252

6、525252525BF%25252525252525B5%25252525252525C4%25252525252525CA%25252525252525F4%25252525252525D0%25252525252525D4 t _blank 客户账户的“地址地点与业务目的属性二十一 HYPERLINK hi.erp100/link.php?url=hi.erp100%2Flink.php%3Furl%3Dhttp%3A%2F%2Fhi.erp100%252Flink.php%253Furl%253Dhttp%253A%252F%252Fhi.erp100%25252Flink.php%25

7、253Furl%25253Dhttp%25253A%25252F%25252Fhi.erp100%2525252Flink.php%2525253Furl%2525253Dhttp%2525253A%2525252F%2525252Fhi.erp100%252525252Flink.php%252525253Furl%252525253Dhttp%252525253A%252525252F%252525252Fhi.erp100%25252525252Flink.php%25252525253Furl%25252525253Dhttp%25252525253A%25252525252F%252

8、52525252Fhi.erp100%2525252525252Flink.php%2525252525253Furl%2525252525253Dhttp%2525252525253A%2525252525252F%2525252525252Fhi.erp100%252525252525252Feditor.php%252525252525253Fop%252525252525253Dblank%2525252525252526amp%252525252525253Bcharset%252525252525253Dgbk%2525252525252523%25252525252525A3%2

9、5252525252525A8%25252525252525B6%25252525252525FE%25252525252525CA%25252525252525AE%25252525252525D2%25252525252525BB%25252525252525A3%25252525252525A9%25252525252525A1%25252525252525A2R12%25252525252525BF%25252525252525CD%25252525252525BB%25252525252525A7%25252525252525D5%25252525252525CB%252525252

10、52525BB%25252525252525A7%25252525252525B2%25252525252525E3%25252525252525CA%25252525252525F4%25252525252525D0%25252525252525D4 t _blank R12客户的账户层与地点层属性二十二 HYPERLINK hi.erp100/link.php?url=hi.erp100%2Flink.php%3Furl%3Dhttp%3A%2F%2Fhi.erp100%252Flink.php%253Furl%253Dhttp%253A%252F%252Fhi.erp100%25252F

11、link.php%25253Furl%25253Dhttp%25253A%25252F%25252Fhi.erp100%2525252Flink.php%2525253Furl%2525253Dhttp%2525253A%2525252F%2525252Fhi.erp100%252525252Flink.php%252525253Furl%252525253Dhttp%252525253A%252525252F%252525252Fhi.erp100%25252525252Flink.php%25252525253Furl%25252525253Dhttp%25252525253A%25252

12、525252F%25252525252Fhi.erp100%2525252525252Flink.php%2525252525253Furl%2525252525253Dhttp%2525252525253A%2525252525252F%2525252525252Fhi.erp100%252525252525252Feditor.php%252525252525253Fop%252525252525253Dblank%2525252525252526amp%252525252525253Bcharset%252525252525253Dgbk%2525252525252523%2525252

13、5252525A3%25252525252525A8%25252525252525B6%25252525252525FE%25252525252525CA%25252525252525AE%25252525252525B6%25252525252525FE%25252525252525A3%25252525252525A9%25252525252525A1%25252525252525A2%25252525252525BF%25252525252525CD%25252525252525BB%25252525252525A7%25252525252525CA%25252525252525FD%2

14、5252525252525BE%25252525252525DD%25252525252525BA%25252525252525CF%25252525252525B2%25252525252525A2 t _blank 客户数据的合并二十三 HYPERLINK hi.erp100/link.php?url=hi.erp100%2Flink.php%3Furl%3Dhttp%3A%2F%2Fhi.erp100%252Flink.php%253Furl%253Dhttp%253A%252F%252Fhi.erp100%25252Flink.php%25253Furl%25253Dhttp%2525

15、3A%25252F%25252Fhi.erp100%2525252Flink.php%2525253Furl%2525253Dhttp%2525253A%2525252F%2525252Fhi.erp100%252525252Flink.php%252525253Furl%252525253Dhttp%252525253A%252525252F%252525252Fhi.erp100%25252525252Flink.php%25252525253Furl%25252525253Dhttp%25252525253A%25252525252F%25252525252Fhi.erp100%2525

16、252525252Flink.php%2525252525253Furl%2525252525253Dhttp%2525252525253A%2525252525252F%2525252525252Fhi.erp100%252525252525252Feditor.php%252525252525253Fop%252525252525253Dblank%2525252525252526amp%252525252525253Bcharset%252525252525253Dgbk%2525252525252523%25252525252525A3%25252525252525A8%2525252

17、5252525B6%25252525252525FE%25252525252525CA%25252525252525AE%25252525252525C8%25252525252525FD%25252525252525A3%25252525252525A9%25252525252525A1%25252525252525A2%25252525252525BF%25252525252525CD%25252525252525BB%25252525252525A7%25252525252525CA%25252525252525FD%25252525252525BE%25252525252525DD%2

18、5252525252525C6%25252525252525E4%25252525252525CB%25252525252525FC%25252525252525B9%25252525252525A6%25252525252525C4%25252525252525DC t _blank 客户数据的其它管理功能五、结语二十客户账户的“地址地点与业务目的属性 每个客户账户Account可以有多个地址地点Site编号，每个地址地点Site的真实物理地址Address可以一样。每个地点可以有假设干个不同的“用途Usage，每个用途有其对应的“地点Location编号。每个地址地点Site的不同“用途还

19、可以有其“详细资料、账户、订单管理的附加属性详细内容取决于确定的“用途，如以下图102所示： “用途的LOV值是在AR系统的Lookup Code中定义的访问级别“可扩展，系统预置了“收一方Bill To、“付款人Drawee、“收货方Deliver To、“收货方(1) Ship To、“对账单Statement、“催款Dunning、“法定Legal、“市场营销Marketing、“购货方Sold To、“发票 Invoice、“提单Bills of Lading、“信誉联络人Credit Contact、“贷项通知单Credit Memos、“确认Acknowledgments、“自助用

20、户Self Service User的常用类型的业务用途。 每个客户Account只能有一个“主要Primary且“有效Active的用途Location。并且，每个客户Account只能有一个有效的“对账单Statement、“催款Dunning用途Location。当用途为“收一方Bill To时，可以为之在附加属性窗口“帐户Tab页中输入“收入、应收等账户代码主要供AR的“自动会计运用。 当用途为“收货方(1) Ship To时，可以为之选择一个“收一方Bill To的Location。并且在附加属性窗口“详细资料Tab页中输入“内部地点、“销售人员等。“内部地点在定义“发运网络、“在途

21、时间以及OM系统方案发运时间时必需存在。如以下图103所示： 上图中，每个“内部地点只能被分配给独一的“客户地点，它还被用于将“内部组织与“内部客户自动链接。“内部订单或“公司间事务流功能运用相关业务表单中的“内部地点，自动寻觅并将“内部组织与“内部客户关联，以便生成内部订单或公司间发票。“税区域，只需在“用途为收一方Bill To，且“AR系统选项窗口“税务标签区域中的“允许改写设置为“是时，才可以在其中输入值。在此处输入的值将优先于在客户或AR系统选项层定义的值。 用途的附加属性Tab页“订单管理的内容与客户账户层“订单管理Tab页内容完全一样，如以下图104所示： “订单管理Tab页中输

22、入的值主要用于为OM系统的销售订单提供默许值。在多组织环境下，其中的“订单类型与“发运方法字段，只能在客户账户地点层而非客户账户层输入。其中的“仓库实践是指“库存组织。二十一R12客户的账户层与地点层属性 R12的账户层与账户地点层属性的内容及关系根本一样，区别仅在于账户地点层与确定的业务虚体OU关联。如以下图105是R12的客户账户层Web界面： R12的属性Tab页分组方式与R11略有区别，其中的“附件Tab页在R11中位于工具栏的“附件也是仅在Account层才有，Site层无。R12的Account Site层的属性Tab页内容也与Account层根本类似比R11多了一个地点称号Sit

23、e Name输入，未知有何用？，如以下图106所示：二十二客户数据的合并 包括买卖方合并与客户账户合并两方面内容，如以下图107所示买卖方合并操作界面，建立“合并批，将需合并的买卖方设置好后，先保管再“运转批启动后台并发恳求： 客户账户合并的情况稍复杂R12还添加了业务虚体OU字段，如以下图108所示客户账户合并界面： “客户合并功能可以合并一样客户账户的地点用途，也可以合并两个不同客户账户的一切地点用途。但不论要合并的是不同客户账户还是一样客户账户的两个地点，都只能将收单地点和收单地点合并，将收货地点和收货地点合并。在合并胜利完成之后，以前与原有客户账户或地点关联的一切活动，此时将与新的客户

24、账户或地点关联。这些活动包括订单、发票、借项通知单、承付款、贷项、收款、调整和拖欠款项等。在合并流程完成之后，合并的原有客户账户和地点用途将会处于“无效形状。无效客户账户不能生成新的事务处置，但随时可以在“客户窗口中查看其信息或将其重新激活。二十三客户数据的其它管理功能EBS的中心业务模块OM/AR所运用到的有关客户数据内容只是其中一部分，在TCA架构下，为了满足其他运用模块如CRM的需求，“客户数据管理作为一个为相关业务模块提供调用效力、曾经独立的功能模块，在有关客户间关系、分类、合并字典、数据质量管理、第三方数据访问集成等方面还有诸多的系统设置，如以下图109所示的“管理设置界面： 由于这些客户数据的有关管理设置与中心业务系统OM/AR普通运用的关系不是太大，故这里不再赘述。此外，需求指出的