Invalid Account Sites Created When Quote Is Created From Opportunity
(Doc ID 1097531.1)
Last updated on FEBRUARY 24, 2019
Applies to:Oracle Quoting - Version 12.0.6 and later
Information in this document applies to any platform.
If an opportunity has a contact with an address and the opportunity is converted to quote, Quoting creates contact account sites in TCA for bill-to and ship-to during opportunity to quote conversion. This is happening because sold-to contact's party site was automatically copied to ship-to and bill-to. Since account site does not exist for these uses, eventually they get created during quote saving flow.
Expect quoting not to create bill-to, ship-to account sites when only sold-to contact was populated, but not bill-to/ship-to contact.
The issue can be reproduced at will with the following steps:
1. Resp: Customer Online SuperUser
2. Query Account
3. "Relationships" > Create Org Contact > create a contact -> enter any address
select * from hz_party_sites
order by creation_date desc
--> Note that party site gets created, note down this party_site_id
4. Sales Dashboard (or you can use Telesales Agent if you want to test forms UI)
5. Create opportunity by entering above contact
7. Convert opportunity to quote
After saving is complete, you will account site and two usages
select * from hz_cust_acct_sites_all where party_site_id =
--> a row was created
select site_use_code from hz_cust_site_uses_all where cust_acct_site_id =
--> two rows
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document