HOW TO Check whether a given table is used in any of the oracle form

-

To Check whether a given table is used in any of the oracle form

Using unix command: Login to you host using Putty/ SSH tectia, after connection

cd <your fmb location, this is AU or Custom AU Path>
grep -Hrn MTL_SYSTEM_ITEMS_B 

  • -H causes the filename to be printed (implied when multiple files are searched)
  • -r does a recursive search
  • -n causes the line number to be printed
  • mtl_system_items_b table name to search
path/to/files can be . to search in the current directory
Further options that I find very useful:
  • -I ignore binary files (complement: -a treat all files as text)
  • -F treat search term as a literal, not a regular expression
  • -i do a case-insensitive search
  • --color=always to force colors even when piping through less. To make less support colors, you need to use the -r option:
    grep -Hrn search . | less -r
  • --exclude-dir=dir useful for excluding directories like .svn and .git.

Result


[yourUser@host US]$ cd /apps/dbName/run_edition_directory/EBSapps/appl/au/12.0.0/forms/US
[yourUser@host US]$ grep -Hrn MTL_SYSTEM_ITEMS_B
Binary file ARXTWLIN.fmb matches
Binary file ASTSLOVW.fmb matches
Binary file ASTSLPUR.fmb matches
Binary file BOMFDMCO.fmb matches
Binary file BOMFDONW.fmb matches
Binary file BOMFDORS.fmb matches
Binary file BOMFDPFI.fmb matches
Binary file BOMFDRTG.fmb matches
Binary file BOMFQBIN.fmb matches
Binary file BOMFQVPI.fmb matches
Binary file BOMFQWIN.fmb matches
Binary file CHVSSCUM.fmb matches
Binary file CMBRDED.fmb matches
Binary file CMCSDED1.fmb matches
Binary file CMRLPED.fmb matches
Binary file CMWHSED2.fmb matches
Binary file CPGACQCE.fmb matches
Binary file CSFDCMAI.fmb matches
Binary file CSIIEXTA.fmb matches
Binary file CSIMASSL.fmb matches
Binary file CSTACCWO.fmb matches
Binary file CSTFITCT.fmb matches
Binary file CSTFQWTX.fmb matches
Binary file CSTFVWLC.fmb matches
Binary file CSTQICCG.fmb matches
Binary file CSXSEBC.fmb matches
Binary file EAMCRACT.fmb matches
Binary file EAMFANDF.fmb matches
Binary file FLMMMMWB.fmb matches
Binary file FLMSSWRP.fmb matches
Binary file FMINQDB.fmb matches
Binary file GMDCHSTS.fmb matches
Binary file GMDFMAVW.fmb matches
Binary file GMDFMSUB.fmb matches
Binary file GMDFRMED.fmb matches
Binary file GMDFRMSM.fmb matches
Binary file GMDLCFSG.fmb matches
Binary file GMDQATST.fmb matches
Binary file GMDQCCOA.fmb matches
Binary file GMDQCDIS.fmb matches
Binary file GMDQCMPR.fmb matches
Binary file GMDQCSTS.fmb matches
Binary file GMDQMASS.fmb matches
Binary file GMDQMSMP.fmb matches
Binary file GMDQMSPC.fmb matches
Binary file GMDQRSTA.fmb matches
Binary file GMDQSLSM.fmb matches
Binary file GMDQSMGP.fmb matches
Binary file GMDQSMPL.fmb matches
Binary file GMDQSPEC.fmb matches
Binary file GMDQSSPA.fmb matches
Binary file GMDQSSTD.fmb matches
Binary file GMDQSSVT.fmb matches
Binary file GMDQTREE.fmb matches
Binary file GMDRCPED.fmb matches
Binary file GMDRVRSM.fmb matches
Binary file GMDSERCH.fmb matches
Binary file GMESTPED.fmb matches
Binary file GMETTMTX.fmb matches
Binary file GMEWKBCH.fmb matches
Binary file GMPAPSCL.fmb matches
Binary file GMPAPSNW.fmb matches
Binary file GMPAPSRS.fmb matches
Binary file GMPSQSTP.fmb matches
Binary file GRDDHIST.fmb matches
Binary file GRFRM923.fmb matches
Binary file ICITMED.fmb matches
Binary file ICR01USR.fmb matches
Binary file INVCCEOI.fmb matches
Binary file INVCCEXP.fmb matches
Binary file INVCNSUP.fmb matches
Binary file INVGENLT.fmb matches
Binary file INVGITMT.fmb matches
Binary file INVIDICG.fmb matches
Binary file INVIDITM.fmb matches
Binary file INVISDST.fmb matches
Binary file INVMATWB.fmb matches
Binary file INVMWBIV.fmb matches
Binary file INVSDODS.fmb matches
Binary file INVSDOIS.fmb matches
Binary file INVSDOPR.fmb matches
Binary file INVSDSUB.fmb matches
Binary file JAIN57F4.fmb matches
Binary file JAINADRB.fmb matches
Binary file JAINBOEI.fmb matches
Binary file JAINBOMFG.fmb matches
Binary file JAINCDRB.fmb matches
Binary file JAINCSHP.fmb matches
Binary file JAINDMAN.fmb matches
Binary file JAINDSHP.fmb matches
Binary file JAINEORD.fmb matches
Binary file JAINGEORD.fmb matches
Binary file JAINIBOE.fmb matches
Binary file JAINIOPR.fmb matches
Binary file JAINIRGI.fmb matches
Binary file JAINITCL.fmb matches
Binary file JAINMREC.fmb matches
Binary file JAINMVAT.fmb matches
Binary file JAINPLAM.fmb matches
Binary file JAINPO.fmb matches
Binary file JAINQTAN.fmb matches
Binary file JAINRGAC.fmb matches
Binary file JAINRGCL.fmb matches
Binary file JAINRGMT.fmb matches
Binary file JAINUEXT.fmb matches
Binary file JAINUICL.fmb matches
Binary file JLBRRCOI.fmb matches
Binary file JLBRREIL.fmb matches
Binary file JLZZTATC.fmb matches
Binary file MRPFFDIF.fmb matches
Binary file MRPFSDMS.fmb matches
Binary file MRPSCPWB.fmb matches
Binary file OEXOEBSO.fmb matches
Binary file OEXOEMCG.fmb matches
Binary file OEXOEORD.fmb matches
Binary file OEXPRAVA.fmb matches
Binary file OEXSSDTF.fmb matches
Binary file OKSAUDET.fmb matches
Binary file OKSITMSL.fmb matches
Binary file OTAENINS.fmb matches
Binary file PAXSUMPS.fmb matches
Binary file PJMFBRPY.fmb matches
Binary file PJMFEIUN.fmb matches
Binary file POXPOERL.fmb matches
Binary file POXRQERQ.fmb matches
Binary file POXSCASL.fmb matches
Binary file PSACTDB1.fmb matches
Binary file PSACTDB2.fmb matches
Binary file QOTLNDET.fmb matches
Binary file QPXPRLST.fmb matches
Binary file QPXPRMLS.fmb matches
Binary file QPXSSDAF.fmb matches
Binary file RCVRCMUR.fmb matches
Binary file WIPTXCMP.fmb matches
Binary file WMSRLSIM.fmb matches
Binary file WMSRLTRC.fmb matches
Binary file WSHFCNIR.fmb matches
Binary file WSHFDPSD.fmb matches
Binary file WSMSERAS.fmb matches
Binary file ZXTAXDETFACTORS.fmb matches 

Comments

Post a Comment

Popular posts from this blog

HOW TO auto approve workflow WF notification procedure

-
API to approve workflow notifications using a procedure in Oracle Apps R12 API: wf_notification Oracle Workflow communicates with users by sending notifications . Notifications contain messages that may request users to take some type of action and/or provide users with information. You define the notification activity and the notification message that the notification activity sends in the Workflow Builder. --To auto approve workflow notifications using a procedure. PROCEDURE approve_reject_proc (pAction IN VARCHAR2, --APPROVE/REJECT pComments IN VARCHAR2, -- User Comments -- Optional pNotification_id IN NUMBER, -- Notification ID pStatus OUT VARCHAR2, pMessage OUT VARCHAR2 ) IS l_user_name VARCHAR2(250); BEGIN BEGIN SELECT RECIPIENT_ROLE INTO l_user_name FROM WF_NOTIFICATIONS WHERE notification_id = pNotification_id; EXCEPTION WHEN OTHERS THEN l_user_name := NULL; END; wf_notification.SETATTRTEXT(pNotification_id,'RESULT',pAction); wf_notification.Respond(pNotif...
Read more

HOW TO register table in oracle apps

-
API to register table in Oracle Apps R12 API: ad_dd.register_table You register your custom application tables using a PL/SQL routine in the AD_DD package. Flexfields and Oracle Alert are the only features or products that depend on this information. Therefore you only need to register those tables (and all of their columns) that will be used with flexfields or Oracle Alert. You can also use the AD_DD API to delete the registrations of tables and columns. You should delete the column registration first, then the table registration. To alter a registration you should first delete the registration, then re-register the table or column.  The AD_DD API does NOT check for the existence of the registered table or column in the database schema, but only updates the required AOL tables. You must ensure that the tables and columns registered actually exist and have the same format as that defined using the AD_DD API. You need NOT register views. You should include call...
Read more

HOW TO update an existing user in oracle apps

-
API to create Accounting Key Flexfield Concatenated Segment description in Oracle Apps R12 API: GL_FLEXFIELDS_PKG.GET_CONCAT_DESCRIPTION Update an existing Oracle User in R12 Oracle Apps using API -- FND_USER_PKG.UPDATEUSER We will try to update the email address for an existing user ‘DEMOUSER’ using the API.  There was no email_address populated to the user ‘DEMOUSER’ prior to running the API. DECLARE    v_user_name     VARCHAR2 (100)    := 'WIPUSER';    v_email_address  VARCHAR2 (100) := 'test@WIPRO.com'; BEGIN    fnd_user_pkg.updateuser                            (x_user_name                    => v_user_name,          ...
Read more