| Custom form LOV is not working properly? (merged 3 by jd) [message #659030] |
Wed, 04 January 2017 11:53  |
 |
P1Oracle
Messages: 60
Registered: August 2014
Location: Hyderabad
|
Member |
|
|
One of custom form 'lov' is not working properly after it upgrade to 10g,
The form is about to add customers against Price exception, i am able to add 11i customers to the price exception without any issues but when it comes to Newly created R12 customer the lov form is repeating twice and saving, how to avoid this and where i am doing wrong??
Below is the query for lov, from which i am getting the column 'SITE_USE_ID' and 'LOCATION' values are same of 11i customer but it is getting different values for Newly created R12 customer.
Note: I have attached my custom fmb,please help me on this..
Select distinct hloc.ADDRESS1, suse.SITE_USE_ID,
suse.LOCATION,
hloc.ADDRESS2,
hloc.ADDRESS3,
hloc.ADDRESS4,
hloc.CITY,
hloc.STATE
from hz_cust_acct_sites_all site,
hz_cust_site_uses_all suse,
HZ_CUST_ACCOUNTS acct,
HZ_PARTIES prty,
HZ_PARTY_SITES psit,
HZ_LOCATIONS hloc
where site.CUST_ACCT_SITE_ID = suse.CUST_ACCT_SITE_ID
and site.CUST_ACCOUNT_ID = acct.CUST_ACCOUNT_ID
and acct.PARTY_ID = prty.PARTY_ID
and suse.SITE_USE_CODE = 'SHIP_TO'
and site.PARTY_SITE_ID = psit.PARTY_SITE_ID
and psit.LOCATION_ID = hloc.LOCATION_ID
AND site.org_id =111--:parameter.operating_unit
AND prty.party_name='XXX'--:XBSI_MFG_PRICE_EXCEPTION_CUST.CUSTOMER
AND suse.SITE_USE_ID=SITE_USE_ID--NVL(:xbsi_mfg_price_exception_cust.site_use_id,suse.SITE_USE_ID)
order by prty.PARTY_NAME |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Custom form LOV is not working properly? (merged 3 by jd) [message #659086 is a reply to message #659030] |
Thu, 05 January 2017 16:35  |
|
P1Oracle
Messages: 60
Registered: August 2014
Location: Hyderabad
|
Member |
|
|
In the above screen i was trying to insert customer details (Customer name, Ship to Adress and SHip to) against price exception
1. When i take 11i customer it is accepting at first attempt only
2.But When i query newly Created R12 customer Ship_to lov (at this particular lov only) it is asking double time (lov form ) and accepting record, this was the issue
for the Shipto lov , the record group query which is used is
Select distinct suse.SITE_USE_ID,
suse.LOCATION,
hloc.ADDRESS1,
hloc.ADDRESS2,
hloc.ADDRESS3,
hloc.ADDRESS4,
hloc.CITY,
hloc.STATE
from hz_cust_acct_sites_all site,
hz_cust_site_uses_all suse,
HZ_CUST_ACCOUNTS acct,
HZ_PARTIES prty,
HZ_PARTY_SITES psit,
HZ_LOCATIONS hloc
where site.CUST_ACCT_SITE_ID = suse.CUST_ACCT_SITE_ID
and site.CUST_ACCOUNT_ID = acct.CUST_ACCOUNT_ID
and acct.PARTY_ID = prty.PARTY_ID
and suse.SITE_USE_CODE = 'SHIP_TO'
and site.PARTY_SITE_ID = psit.PARTY_SITE_ID
and psit.LOCATION_ID = hloc.LOCATION_ID
AND site.org_id =XXX--:parameter.operating_unit
AND prty.party_name='XXXXX'--:XXI_MFG_PRICE_EXCEPTION_CUST.CUSTOMER
order by prty.PARTY_NAME
Action plan i did:
1.I have changed some lov properties for shipto lov(Functional) where i am getting issue by using form builder
2.Added one more join in the above query
and site.org_id=suse.org_id
3.when i execute the above code in taod for all 11i customers both columns SITE_USE_ID and location values are same but it is different for R12 CUstomer, i am assuming this may be problem because Customer tables have been changed in 11i and R12
but no luck, suggest me is anything i am missing.
[Updated on: Thu, 05 January 2017 17:03] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
