Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1802076
  • 博文数量: 334
  • 博客积分: 11301
  • 博客等级: 上将
  • 技术积分: 3452
  • 用 户 组: 普通用户
  • 注册时间: 2006-10-18 10:19
个人简介

路虽弥,不行不至;事虽少,不做不成。

文章分类

全部博文(334)

文章存档

2013年(4)

2012年(19)

2011年(27)

2010年(71)

2009年(45)

2008年(15)

2007年(84)

2006年(69)

分类: Oracle

2010-05-11 11:18:00

Credit Checking Limits Hierarchy
 
In Oracle Receivables, you can setup Credit limit (which is nothing but the overall credit limit) and order credit limit at the following levels:
1. Item category level
2. Site level
3. Customer level
4. Party level (This level is applicable only if Credit Management is installed)
5. Operating Unit Default level.

For Customers in
11.5.10 - Before 11.5.10 CU2 (If OEXUCRCB.pls is less than 115.82.11510.2)
11.5.9   - Before Patch 4473667 (If OEXUCRCB.pls is less than 115.69.1159.14)
 
1.Item category level
If Credit Check not enabled => Go for Site Level
If Credit Check is enabled and both credit limit and order credit limit are NULL/BLANK => Go for Site Level
If Credit Check is enabled and either credit limit or order credit limit is NOT NULL => Use them
 
2.Site level
If Credit Check not enabled => Go for Customer level
If Credit Check is enabled and both credit limit and order credit limit are NULL/BLANK => No Credit Check
If Credit Check is enabled and either credit limit or order credit limit is NOT NULL => Use them
 
3.Customer level
If Credit Check not enabled => Go for Party level is
Credit Management is installed else go for Operating unit default level
If Credit Check is enabled and both credit limit and order credit limit are NULL/BLANK => No Credit Check
If Credit Check is enabled and either credit limit or order credit limit is NOT NULL => Use them
 
4.Party level (This level is applicable only if Credit Management is installed)
If Credit Check not enabled => Go for Parent Party,if any available, else go to Operating Unit Default limits.
If Credit Check is enabled and both credit limit and order credit limit are NULL/BLANK => No Credit Check
If Credit Check is enabled and either credit limit or order credit limit is NOT NULL => Use them
 
5. Operating Unit Default Level
If both credit limit and order credit limit are NULL/BLANK => No Credit Check
If either credit limit or order credit limit is NOT NULL => Use them
 
For customers in
11.5.10 - After 11.5.10 CU2 (if OEXUCRCB.pls is equal or higher than 115.82.11510.2)
11.5.9   - After Patch 4473667 (if OEXUCRCB.pls is equal or higher than 115.69.1159.14)
 
1.Item category level
If Credit Check not enabled => Go for Site Level
If Credit Check is enabled and both credit limit and order credit limit are NULL/BLANK => Go for Site Level
If Credit Check is enabled and either credit limit or order credit limit is NOT NULL => Use them
 
2.Site level
If Credit Check not enabled => No Credit Check
If Credit Check is enabled and both credit limit and order credit limit are NULL/BLANK => Go for Customer level
If Credit Check is enabled and either credit limit or order credit limit is NOT NULL => Use them
 
3.Customer level
If Credit Check not enabled => No Credit Check
If Credit Check is enabled and both credit limit and order credit limit are NULL/BLANK => Go for Party level is
Credit Management is installed else go for Operating unit default level
If Credit Check is enabled and either credit limit or order credit limit is NOT NULL => Use them
 
4.Party level (This level is applicable only if Credit Management is installed)
If Credit Check not enabled => No Credit Check
If Credit Check is enabled and both credit limit and order credit limit are NULL/BLANK => Go for Parent Party,
if any available, else go to Operating Unit Default limits.If party hierarchy is setup using Trading Community
Architecture, then credit checking will look into this hierarchy also, to check if there is any parent available.
If yes, then it looks into the limits of the parent also. If parent limits are also NULL, then it goes for
Operating Unit Default level
If Credit Check is enabled and either credit limit or order credit limit is NOT NULL => Use them
 
5. Operating Unit Default Level
If both credit limit and order credit limit are NULL/BLANK => No Credit Check
If either credit limit or order credit limit is NOT NULL => Use them
 
$ strings -a $ONT_TOP/patch/115/sql/OEXUCRCB.pls |grep '$Header'
阅读(1114) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~