![]() ![]() Is a perfectly satisfactory HTTP request. PATCH /a?b=c HTTP/2.0Ĭontent-Type: application/merge-patch+json Yes, but probably not the way that you mean. This will test your knowledge on various frontsĬoncurrent Manager Queries :This page contains awesome top 30 Concurrent Manager Queries for Concurrent Manager troubleshooting ,resolution ,run time, detailsĤ0 Adpatch question every DBA should know : Every Apps DBA has to work with adpatch utility to performance patch maintenance.Can i use query parameters in http PATCH method in my Rest API, instead of sending a partial request body? Oracle dba interview questions and answers: check out awesome oracle dba interview questions and answers to succeed in any oracle database interviews. Oracle apps queries for DBA: This page contains the very useful and practical Top 30 Useful oracle apps queries for APPS DBA to help in day-to-day administration activities o file version adident Header FNDCRM | grep afpcrm.oc ![]() If it returns something like 9.0.3.6.0_# then you are on OAF 5.7. Select jdr_mds_internal.getRepositoryVersion from dual You can tell if you’re on OAF 5.7 version OAF 5.10 on the database tier by running the following SQL: How to Finds the version information of any Oracle Database Package Information select text To_char(to_date('00:00:00','HH24:MI:SS') +(c.end_date - c.start_date), 'HH24:MI:SS') DurationĪnd c.patch_driver_id = d.patch_driver_idĪnd d.applied_patch_id = e.applied_patch_idĪnd b.patch_run_bug_id = f.patch_run_bug_idĪnd f.patch_file_version_id = g.file_version_id To_char(c.end_date,'DD-MON-YYYY HH:MI:SS')end_time, To_char(c.start_date,'DD-MON-YYYY HH:MI:SS')start_time, Select a.bug_number,h.filename,g.version, Input is the FILE NAME whose VERSION is to be determined set linesize 1000 This script helps in identifying the various versions of a particular file, the associated BUG NUMBERS, the Date on which it was applied. Where fpi.application_id = a.application_id(+) To_char(fpi.last_update_date,'dd-Mon-RRRR') "Update Date"įrom fnd_oracle_userid o, fnd_application a, fnd_product_installations fpi Nvl(fpi.patch_level,'- Not Available -') Patchset, 'Not Found','id '||to_char(fpi.application_id),ĭecode(fpi.status,'I','Installed','S','Shared', Select decode(nvl(a.APPLICATION_short_name,'Not Found'), How to find the installed status of all the products set linesize 1000 Group by a.application_id,a.application_short_name,a.basepath,at.application_name,at.language Where at.application_id = a.application_id How to list out the various information of various product set linesize 1000Ĭolumn application_id format a999999 heading "APPL|ID"Ĭolumn application_short_name format a10 heading "APPL|SHORT NAME"Ĭolumn application_name format a50 heading "APPLICATION NAME" How to find the EWT version unzip -l $FND_TOP/java/jar/fndewt.jar | grep 3_ Select patch_level from fnd_product_installations where patch_level LIKE ('%&1%') = pi.application_id and Application_short_name like '&App_Short_Name' How to find the patch level of a particular application select pi.patch_level, Application_short_name fromįnd_product_installations pi, fnd_application fa where fa.application_id How to find if the bug number or patch is applied to Apps EBS select substr(APPLICATION_SHORT_NAME,1,10) Product,substr(BUG_NUMBER,1,10),Version,last_update_date applied_date from ad_bugs where BUG_NUMBER= to_char('&bug_no') How to find the installed status of all the products.How to list out the various information of various product.How to find the patch level of a particular application.How to find if the bug number or patch is applied to Apps EBS. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |