Script to update salespersons customer site wise in oracle apps R12

SELECT * FROM HZ_PARTIES
WHERE PARTY_NAME LIKE 'DEENA VISION%';

SELECT * FROM HZ_CUST_ACCOUNTS_ALL
WHERE PARTY_ID =94043 ;

SELECT * FROM HZ_CUST_ACCT_SITES_ALL
WHERE CUST_ACCOUNT_ID =62040;

SELECT * FROM HZ_CUST_SITE_USES_ALL
WHERE CUST_ACCT_SITE_ID = 62041;

==============================================================================

select * from jtf_rs_salesreps
where SALESREP_ID =100004040 ;

SELECT SALESREP_ID,A.RESOURCE_NAME,B.ORG_ID
FROM JTF_RS_RESOURCE_EXTNS_TL A,
               jtf_rs_salesreps B
WHERE 1=1
--AND SALESREP_ID =100004040
AND  A.RESOURCE_ID = B.RESOURCE_ID
AND A.RESOURCE_NAME LIKE 'D SENTHIL%';

==================================================

SELECT HCSUA.CUST_ACCT_SITE_ID,HCSUA.ORG_ID,AC.CUSTOMER_ID,AC.CUSTOMER_NAME,CUSTOMER_NUMBER,HCSUA.PRIMARY_SALESREP_ID,
(SELECT  A.RESOURCE_NAME FROM JTF_RS_RESOURCE_EXTNS_TL A,
               jtf_rs_salesreps B
WHERE SALESREP_ID =HCSUA.PRIMARY_SALESREP_ID  --100004040
AND  A.RESOURCE_ID = B.RESOURCE_ID) SALESREP_NAME
FROM AR_CUSTOMERS AC,
              HZ_CUST_ACCOUNTS_ALL HCAA,
              HZ_CUST_ACCT_SITES_ALL HCASA,
              HZ_CUST_SITE_USES_ALL HCSUA
WHERE AC.CUSTOMER_ID = HCAA.CUST_ACCOUNT_ID
AND   HCAA.CUST_ACCOUNT_ID = HCASA.CUST_ACCOUNT_ID
AND   HCASA.CUST_ACCT_SITE_ID = HCSUA.CUST_ACCT_SITE_ID
AND  AC.CUSTOMER_NUMBER = 'RDD1078';

UPDATE THE TABLE:-

UPDATE HZ_CUST_SITE_USES_ALL
SET PRIMARY_SALESREP_ID = 100018070
WHERE ORG_ID = 182
AND CUST_ACCT_SITE_ID= 62041;

commit;

sql query for list all users who have not logged on in oracle apps r12

We can use this query for your requirement.

SELECT pap.full_name,user_name,to_char(last_logon_date,'DD-MON-YYYY HH24:MI:SS AM') last_logon_date,

to_char(end_date,'DD-MON-YYYY HH24:MI:SS AM') end_date

FROM fnd_user fu,

     per_all_people_f pap

WHERE fu.employee_id = pap.person_id

AND fu.user_name NOT IN (SELECT user_name

                                         FROM   fnd_user

                                         WHERE  1=1

                                          AND end_date IS NULL

                                           AND  last_logon_date >= TRUNC(sysdate)-2)

ORDER BY pap.full_name

hr_operating_units table data in oracle apps is not coming in windows 10-Oracle Views return no data due to NLS LANGUAGE Settings

I faced some issues when I query the below table data is not fetching in my query:
SELECT * FROM hr_operating_units
SELECT * FROM MTL_CATEGORIES

Solution:

You just need to check the USER ENV Language from the below query.

SELECT USERENV('LANGUAGE') Language FROM DUAL;

After that run the below query(alter language)
ALTER session SET nls_language='AMERICAN'

then check in your table query output:

ex: SELECT * FROM hr_operating_units

------------------------------

SELECT USERENV('LANG') FROM DUAL;

                         USERENV(‘LANG’)

                        ------------------------------

                         S

     

SELECT * FROM V$NLS_PARAMETERS

where parameter in('NLS_LANGUAGE','NLS_TERRITORY');   

PARAMETER                   VALUE

--------------------------------------------------                                  

NLS_LANGUAGE SWEDISH

NLS_TERRITORY   SWEDEN

            

b.      Set NLS_LANG value in client (This is permanent Solution)

Windows:

                                                  i.      Go to Start-> run

                                                ii.      Type regedit and click ok

                                              iii.      Drill Down to HKEY_LOCAL_MACHINE->SOFTWARE->ORACLE-> KEY_OraClientxxx_homeX (xxx is the oracle client version and X is the currently used home)

                                              iv.      Double click NLS_LANG and change Value data. For example in the example scenario updated NLS_LANG value to SWEDISH_SWEDEN.WE8MSWIN1252

                                                v.      Close regedit

Make sure you have backup windows registry before modifying it.     

Or

                                                      i.      Click on Computer, select Properties.

                                                      ii.      Select Advance system settings

                                                     iii.      In the Advance tab, select Environment Variables

                                                      iv.      Select New

                                                        v.      Set variable name NLS_LANG and variable value SWEDISH_SWEDEN.WE8MSWIN1252

                                                       vi.      Select ok and you should now see the new environment variable that you just created.

 Linux:

 setenv NLS_LANG <NLS_LANG>

Example: setenv NLS_LANG SWEDISH_SWEDEN. WE8MSWIN1252

3.       Restart the client. Examples, if you are using Toad restart TOAD for the changes to take effect.

http://www.nazmulhuda.info/setting-nls_lang-environment-variable-for-windows-and-unix-for-oracle-database