The below query extracts the list of employee users along with their user status and employee status SELECT pu.username USER_NAME ,papf.person_number EMPLOYEE_NUMBER ,ppn.first_name EMPLOYEE_FIRST_NAME ,ppn.last_name EMPLOYEE_LAST_NAME ,DECODE(SUSPENDED,'Y', 'Inactive User','N', 'Active…
Read MoreThe below query extracts the list of data accesses given for any user in Oracle Cloud Application ————————————————–***************——————————————– SELECT gl.name "Security Context Value", pr.role_name"Job Role Name", pu.username "User Name", role.ACTIVE_FLAG…
Read MoreTransmission Configuration AP payments made in Oracle Could sends payment files to banks to make the real payment to vendors. In such cases, file transfer link has to be enabled…
Read MoreHow to take Thread dump from weblogic administration console. Login in to the console Under Domain Structure Go to Environments Click on servers( It will display the list of servers)…
Read MoreJAVA_PROPERTIES configuraion in SetDomainEnv.sh:- login to particular server Go to Domain/bin Take backup of SetDomainEnv.sh vi SetDomainEnv.sh Edit SetDomainEnv.sh and replace the JAVA_PROPERTIES url as per requested save and…
Read MorePGP Key Encryption in AP Payments Generally, the PGP keys will be used to Encrypt and Decrypt the messages transferred between one system to another to enable the security. In…
Read MoreCloud Enterprise Contract Clause Query ============================ select ch.contract_number, cab.label||’ ‘||caa.article_title from okc_k_headers_vl ch,okc_k_articles_b cab,okc_articles_all caa, okc_article_versions cv where ch.id = cab.document_id and cab.article_version_id = cv.article_version_id and cv.article_id = caa.article_id
Read Moreselect hp.party_name customer_name, a1.account_number customer_number, a3.STATUS site_status, SITE_USE_CODE,LOCATION,PRIMARY_FLAG ,PARTY_SITE_NUMBER,A5.ADDRESS1,A5.ADDRESS2,A5.ADDRESS3,A5.ADDRESS4,A5.CITY,A5.POSTAL_CODE,A5.STATE,A5.COUNTRY from hz_cust_accounts a1,hz_cust_acct_sites_all a2, hz_cust_site_uses_all a3,HZ_PARTY_SITES A4,HZ_LOCATIONS A5, hz_parties hp where a1.CUST_ACCOUNT_ID=a2.CUST_ACCOUNT_ID and a1.party_id=hp.party_id and a2.CUST_ACCT_SITE_ID=a3.CUST_ACCT_SITE_ID and nvl(A1.STATUS,’A’)=’A’ and nvl(A3.STATUS,’A’)=’A’ AND A2.PARTY_SITE_ID=A4.PARTY_SITE_ID AND A4.LOCATION_ID=A5.LOCATION_ID
Read MoreGlobal Human Resources Views EEC_CONTEST_TEMPLATE_HDR_VL EEC_METRICS_VL EEC_REWARDS_VL HCM_EXTENDED_LOOKUP_CODES_VL HR_ALL_ORGANIZATION_UNITS HR_ALL_ORGANIZATION_UNITS_F_VL HR_ALL_ORGANIZATION_UNITS_TL HR_ALL_ORGANIZATION_UNITS_VL HR_ALL_ORGANIZATION_UNITS_X HR_ALL_POSITIONS HR_ALL_POSITIONS_F_VL HR_ALL_POSITIONS_X HR_BU_LOCATIONS_X HR_COMPANY_VS_V HR_COST_CENTER_VS_V HR_DOCUMENT_TYPES_VL HR_LEGAL_ENTITIES HR_LOCATIONS HR_LOCATIONS_ALL HR_LOCATIONS_ALL_F HR_LOCATIONS_ALL_F_VL HR_LOCATIONS_ALL_TL HR_LOCATIONS_ALL_VL HR_LOCATIONS_ALL_X HR_LOCATION_EXTRA_INFO HR_LOCATION_EXTRA_INFO_F…
Read MoreSOLUTION Below are some sample payload for findCustomerAccountOperation: <soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”http://xmlns.oracle.com/apps/cdm/foundation/parties/customerAccountService/applicationModule/types/” xmlns:typ1=”http://xmlns.oracle.com/adf/svc/types/”> <soapenv:Header/> <soapenv:Body> <typ:findCustomerAccount> <typ:findCriteria> <typ1:fetchStart>0</typ1:fetchStart> <typ1:fetchSize>1</typ1:fetchSize> <typ1:filter> <typ1:conjunction/> <typ1:group> <typ1:conjunction/> <typ1:upperCaseCompare>false</typ1:upperCaseCompare> <typ1:item> <typ1:conjunction/> <typ1:upperCaseCompare>false</typ1:upperCaseCompare> <typ1:attribute>AccountNumber</typ1:attribute> <typ1:operator>=</typ1:operator> <typ1:value>GB000557</typ1:value> </typ1:item>…
Read More