Demo data for supplier organization.

[Rishi Solanki]

Hi Folks,
Recently I was looking into the supplier data for an organization and its
associated roles.
Please have a look at -
https://demo-trunk.ofbiz.apache.org:8443/partymgr/control/viewroles?partyId=DemoSupplier

Roles associated to this party are ACCOUNT, SUPPLIER_AGENT, SUPPLIER,
BILL_FROM_VENDOR, and SHIP_FROM_VENDOR.
I'm fine with the SUPPLIER, BILL_FROM_VENDOR and SHIP_FROM_VENDOR roles,
just wanted to discuss on the ACCOUNT and SUPPLIER_AGENT role.

I'm not sure about the ACCOUNT role and SUPPLIER_AGENT role assigned to
DemoSupplier, for SUPPLIER_AGENT role is sub type of ORGANIZATION_ROLE
(refer RoleType entity) as per data setup for roleTypeId, so this should not
be role of an organization. Do not have points on ACCOUNT role, but wanted
to know why will need to add this role and which functionality needs this
role for supplier.

 Please let me know If I can delete the SUPPLIER_AGENT role from data and
submit the patch. And also let me know what is the purpose of ACCOUNT role
here.

Thanks!

Rishi Solanki
Manager, Enterprise Software Development
HotWax Media Pvt. Ltd.
Direct: [phone]
http://www.hotwaxmedia.com

[Rishi Solanki]

In line correction.

Rishi Solanki
Manager, Enterprise Software Development
HotWax Media Pvt. Ltd.
Direct: [phone]
http://www.hotwaxmedia.com


On Thu, Oct 20, 2011 at 6:32 PM, Rishi Solanki <[hidden email]>wrote:

> Hi Folks,
> Recently I was looking into the supplier data for an organization and its
> associated roles.
> Please have a look at -
> https://demo-trunk.ofbiz.apache.org:8443/partymgr/control/viewroles?partyId=DemoSupplier
>
> Roles associated to this party are ACCOUNT, SUPPLIER_AGENT, SUPPLIER,
> BILL_FROM_VENDOR, and SHIP_FROM_VENDOR.
> I'm fine with the SUPPLIER, BILL_FROM_VENDOR and SHIP_FROM_VENDOR roles,
> just wanted to discuss on the ACCOUNT and SUPPLIER_AGENT role.
>
> I'm not sure about the ACCOUNT role and SUPPLIER_AGENT role assigned to
> DemoSupplier, for SUPPLIER_AGENT role is sub type of ORGANIZATION_ROLE
> (refer RoleType entity)

SUPPLIER_AGENT role is sub type of PERSON_ROLE ******

> as per data setup for roleTypeId, so this should not be role of an
> organization. Do not have points on ACCOUNT role, but wanted to know why
> will need to add this role and which functionality needs this role for
> supplier.
>
>  Please let me know If I can delete the SUPPLIER_AGENT role from data and
> submit the patch. And also let me know what is the purpose of ACCOUNT role
> here.
>
> Thanks!
>
> Rishi Solanki
> Manager, Enterprise Software Development
> HotWax Media Pvt. Ltd.
> Direct: [phone]
> http://www.hotwaxmedia.com
>

[Adrian Crum-3]

Some of those roles are the result of relations in various tables
pointing to PartyRole instead of RoleType. So, no - you can't delete
those roles without generating foreign key violations.

An alternative that I like to use is redefining the problematic tables
to drop the relation to PartyRole and relate them to RoleType instead.
With that approach, a party can be related to a bit of data in a certain
role without the party being in that role within the enterprise.

-Adrian

On 10/20/2011 2:02 PM, Rishi Solanki wrote:

> Hi Folks,
> Recently I was looking into the supplier data for an organization and its
> associated roles.
> Please have a look at -
> https://demo-trunk.ofbiz.apache.org:8443/partymgr/control/viewroles?partyId=DemoSupplier
>
> Roles associated to this party are ACCOUNT, SUPPLIER_AGENT, SUPPLIER,
> BILL_FROM_VENDOR, and SHIP_FROM_VENDOR.
> I'm fine with the SUPPLIER, BILL_FROM_VENDOR and SHIP_FROM_VENDOR roles,
> just wanted to discuss on the ACCOUNT and SUPPLIER_AGENT role.
>
> I'm not sure about the ACCOUNT role and SUPPLIER_AGENT role assigned to
> DemoSupplier, for SUPPLIER_AGENT role is sub type of ORGANIZATION_ROLE
> (refer RoleType entity) as per data setup for roleTypeId, so this should not
> be role of an organization. Do not have points on ACCOUNT role, but wanted
> to know why will need to add this role and which functionality needs this
> role for supplier.
>
>   Please let me know If I can delete the SUPPLIER_AGENT role from data and
> submit the patch. And also let me know what is the purpose of ACCOUNT role
> here.
>
> Thanks!
>
> Rishi Solanki
> Manager, Enterprise Software Development
> HotWax Media Pvt. Ltd.
> Direct: [phone]
> http://www.hotwaxmedia.com
>

[Rishi Solanki]

Thank you Adrian,
Here I'm concluding your words, will not delete the SUPPLIER_AGENT role from
party role because it has foreign key constraints with other tables. But we
are clear here that SUPPLIER_AGENT role is not suitable for organization
parties. Am I understanding correctly?

Apart from this, ACCOUNT role is fine and we can set it to an organization,
but just to be adding as additional information its parent type is SFA_ROLE
which in turn only used in SFA, may be this is useful their, so we can
ignore it let keep this role with organization.

Thanks!

Rishi Solanki
Manager, Enterprise Software Development
HotWax Media Pvt. Ltd.
Direct: [phone]
http://www.hotwaxmedia.com


On Thu, Oct 20, 2011 at 8:06 PM, Adrian Crum <
[hidden email]> wrote:

> Some of those roles are the result of relations in various tables pointing
> to PartyRole instead of RoleType. So, no - you can't delete those roles
> without generating foreign key violations.
>
> An alternative that I like to use is redefining the problematic tables to
> drop the relation to PartyRole and relate them to RoleType instead. With
> that approach, a party can be related to a bit of data in a certain role
> without the party being in that role within the enterprise.
>
> -Adrian
>
>
> On 10/20/2011 2:02 PM, Rishi Solanki wrote:
>
>> Hi Folks,
>> Recently I was looking into the supplier data for an organization and its
>> associated roles.
>> Please have a look at -
>> https://demo-trunk.ofbiz.**apache.org:8443/partymgr/**
>> control/viewroles?partyId=**DemoSupplier<https://demo-trunk.ofbiz.apache.org:8443/partymgr/control/viewroles?partyId=DemoSupplier>
>>
>> Roles associated to this party are ACCOUNT, SUPPLIER_AGENT, SUPPLIER,
>> BILL_FROM_VENDOR, and SHIP_FROM_VENDOR.
>> I'm fine with the SUPPLIER, BILL_FROM_VENDOR and SHIP_FROM_VENDOR roles,
>> just wanted to discuss on the ACCOUNT and SUPPLIER_AGENT role.
>>
>> I'm not sure about the ACCOUNT role and SUPPLIER_AGENT role assigned to
>> DemoSupplier, for SUPPLIER_AGENT role is sub type of ORGANIZATION_ROLE
>> (refer RoleType entity) as per data setup for roleTypeId, so this should
>> not
>> be role of an organization. Do not have points on ACCOUNT role, but wanted
>> to know why will need to add this role and which functionality needs this
>> role for supplier.
>>
>>  Please let me know If I can delete the SUPPLIER_AGENT role from data and
>> submit the patch. And also let me know what is the purpose of ACCOUNT role
>> here.
>>
>> Thanks!
>>
>> Rishi Solanki
>> Manager, Enterprise Software Development
>> HotWax Media Pvt. Ltd.
>> Direct: [phone]
>> http://www.hotwaxmedia.com
>>
>>