Friday, June 5, 2009

11i Specific path subdirectory locations where Inventory modules reside within the Oracle directory structure and on your OS file system

There are a variety of commands specifics that can be used. Here are the most common:
strings -a grep -i '$header'
strings -a grep '$Head'
strings -a grep -i '$Header: in'
ident $INV_TOP/java/jar/

To find a module on the file system:
find . -name -print
Example:
find . -name POXBWVRP.* -print

Where Inventory Modules reside on the file system:
In General:
cd $AU_TOP/resource – is where *.pld and *.plx files reside
cd $BOM_TOP/bin – is where *.ppc, *.pls, *.lpc files reside
cd $ENG_TOP/bin – is where *.ppc, *.pls, *.lpc files reside
cd $FND_TOP/bin – is where *.ppc, *.pls, *.lpc files reside
cd $INV_TOP/bin – is where *.ppc, *.pls, *.lpc files reside
cd $INV_TOP/lib – is where *.a and *.o [libinv.a] files reside
cd $INV_TOP/forms – is where *.fmx and *.fmb files reside
cd $INV_TOP/srw – is where *.rdf files reside
cd $PO_TOP/bin – is where *.ppc, *.pls, *.lpc files reside
General directions on how to navigate with in UNIX and get the version of a report, form, module, or library:
a) To get to report version, at UNIX prompt:type
cd $INV_TOP
cd srw
strings -a .rdf grep -i '$Header'
b) To get a module version, at UNIX prompt:type
cd $INV_TOP
cd bin
strings -a grep -i '$Header'
c) To get a library version, at UNIX prompt:type
cd $INV_TOP
cd lib
strings -a .a grep -i '$Header'

Specially where Inventory Modules reside on the file system:
Cycle Counting:
Obtain the version of any Cycle Count FORMS:
Define ABC Compiles (INVAAACP):
Assign ABC Items (INVADAAS):
Update ABC Assignments (INVADACA):
Assign ABC Classes (INVADACL):
Define ABC Groups (INVADAGR):
Enter Manual Schedule Requests (INVADCSC):
Define Cycle Count (INVADCYC):
Approve Cycle Count Adjustments (INVAMCAP):
Enter Cycle Counts (INVATCEN):
cd $INV_TOP/forms/US
strings -a INVAAACP.fmx grep -i 'INVAAACP.fmb'
strings -a INVADAAS.fmx grep -i 'INVADAAS.fmb'
strings -a INVADACA.fmx grep -i 'INVADACA.fmb'
strings -a INVADACL.fmx grep -i 'INVADACL.fmb'
strings -a INVADAGR.fmx grep -i 'INVADAGR.fmb'
strings -a INVADCSC.fmx grep -i 'INVADCSC.fmb'
strings -a INVADCYC.fmx grep -i 'INVADCYC.fmb'
strings -a INVAMCAP.fmx grep -i 'INVAMCAP.fmb'
strings -a INVATCEN.fmx grep -i 'INVATCEN.fmb'
cd $AU_TOP/resource
strings -a INVATCEN.plx grep -i ' INVATCEN.pld'
strings -a INVAMCAP.plx grep -i 'INVAMCAP.pld'
strings -a INVADPTE.plx grep -i 'INVADPTE.pld'

Obtain the version of any Cycle Count REPORTS:
ABC Assignments (INVARAAS):
ABC Descending Value (INVARADV):
Cycle Count Listing (INVARCLI):
Cycle Count Pending Approval (INVARCPA):
Cycle Count Entries and Adjustments (INVARCTA):
Cycle Count Hit/Miss Analysis (INVARHMA):
Cycle Count Open Requests Listing (INVARORE):
Cycle Count Schedule Requests (INVARRTA):
Cycle Count Unscheduled Items (INVARUIR):
cd $INV_TOP/reports/US
strings -a INVARAAS.rdf grep -i '$Header'
strings -a INVARADV.rdf grep -i '$Header'
strings -a INVARCLI.rdf grep -i '$Header'
strings -a INVARCPA.rdf grep -i '$Header'
strings -a INVARCTA.rdf grep -i '$Header'
strings -a INVARHMA.rdf grep -i '$Header'
strings -a INVARORE.rdf grep -i '$Header'
strings -a INVARRTA.rdf grep -i '$Header'
strings -a INVARUIR.rdf grep -i '$Header'

Obtain the version of any Cycle Count CONCURRENT PROGRAMS:
Compile ABC analysis (INCAAC):
Define ABC assignments (INCAAA):
Purge ABC Information (INCAAP):
Generate Cycle Count Requests (INCACG):
Initialize Cycle Count Items (INCACI):
Purge Cycle Count Information (INCACP):
Schedule Cycle Count Headers (INCACS):
cd $INV_TOP/bin
strings -a INCAAC grep -i 'incaac.opp'
strings -a INCAAA grep -i 'incaaa.opp'
strings -a INCAAP grep -i 'incaap.opp'
strings -a INCACG grep -i 'incacg.opp'
strings -a INCACI grep -i 'incaci.opp'
strings -a INCACP grep -i 'incacp.opp'
strings -a INCACS grep -i 'incacs.opp'
strings -a INCAPF grep -i ' incapf.opp'

Intercompany Invoicing:
$INV_TOP/bin/INCIAR
$INV_TOP/bin/INCIAP
$INV_TOP/lib/
strings -a INCIAP grep -i inliap
strings –a $INV_TOP/lib/inliar.o grep -i inliar.lpc
strings -a $INV_TOP/lib/inlico.o grep -i inlico.lpc
strings -a $INV_TOP/lib/inciar.o grep -i inciar.opc
strings -a $INV_TOP/lib/inlico.o grep -i inlico.opc

Kanban
Obtain the version of any Kanban FORM having problems:
cd $INV_TOP/forms/US
strings -a INVKBPSQ.fmx grep -i '$Header'
strings -a INVKBCRD.fmx grep -i '$Header'
Obtain the version of any Kanban CONCURRENT PROGRAM and .pls PL/SQL PROGRAM having problems:
cd $INV_TOP/patch/115/sql
strings -a INVVKBNS.pls grep -i '$Header'
strings -a INVVKBNB.pls grep -i '$Header'
strings -a INVKBCGS.pls grep -i '$Header'
strings -a INVKBCGB.pls grep -i '$Header'
cd $INV_TOP/patch/115/import/US
strings -a invkbcgn.ldt grep -i '$Header'
strings -a invkbcpr.ldt grep -i '$Header'
strings -a invkflx.ldt grep -i '$Header'

Min Max Replenishment Planning:
cd $INV_TOP/reports/US
strings -a INVISMMX.rdf grep -i '$Header'
cd $AU_TOP/plsql
strings -a INVISMMX.pll grep -i '$Header'
cd $INV_TOP/patch/115/sql
strings -a INVVMILB.pls grep -i '$Header'
strings -a INVVMILS.pls grep -i '$Header'
strings -a INVVMMXB.pls grep -i '$Header'
strings -a INVVMMXS.pls grep -i '$Header'
strings -a INVMMXWB.pls grep -i '$Header'
strings -a INVMMXWS.pls grep -i '$Header'
cd $INV_TOP/reports/US
strings -a INVISMMX.rdf grep -i '$Header'
cd $AU_TOP/plsql
strings -a INVISMMX.pll grep -i '$Header'
cd $INV_TOP/patch/115/sql
strings -a INVVMILB.pls grep -i '$Header'
strings -a INVVMILS.pls grep -i '$Header'
strings -a INVVMMXB.pls grep -i '$Header'
strings -a INVVMMXS.pls grep -i '$Header'
strings -a INVMMXWB.pls grep -i '$Header'
strings -a INVMMXWS.pls grep -i '$Header'


Movement Statistics:
$INV_TOP/resource/INVTTMVE.pld
$INV_TOP/forms/us/INVTTMVE.pld

Physical Inventory:
FORMS USED BY PHYSICAL INVENTORY
INVADPAP - Approve Physical Inventory Adjustments
INVADPPI - Define Physical Inventory
INVADPTE - Enter Physical Inventory Counts
INVADPVT - Void Physical Inventory Tags
INVARPGT - Generate Physical Inventory Tags
cd $INV_TOP/forms
INVADPAP.fmb
INVADPPI.fmb
INVADPTE.fmb
INVADPVT.fmb
INVARPGT.fmb
cd $AU_TOP/resource
strings -a INVADPTE.plx grep -i '$Header'
strings -a INVADPA1.plx grep -i '$Header'
strings -a INVADPTE.plx grep -i '$Header'

CONCURRENT PROCESSES USED BY PHYSICAL INVENTORY
INCAPA - Perform physical inventory Adjustments
INCAPF - Freeze physical inventory
INCAPP - Purge physical inventory information
INCAPT - Generate physical inventory tags
strings -a $INV_TOP/bin/INCAPA grep -i incapa.opp
strings -a $INV_TOP/bin/INCAPF grep -i incapf.opp
strings -a $INV_TOP/bin/INCAPA grep -i incapp
strings -a $INV_TOP/bin/INCAPA grep -i inltgp

Obtain the version of any Physical Inventory REPORTS:
Physical Inventory Adjustments Report INVARPAR
Generate Physical Inventory Tag INVARPGT
Physical Inventory Tags INVARPTP
Physical Inventory Missing Tag Listing INVARPMT
Physical Inventory counts Report INVARPSL
Physical Inventory Item accuracy Report INVARPIA
Physical Inventory Trend and summary Report INVARPTS
Approve Physical inventory adjustments INVADPAP
Define Physical Inventory INVADPPI
Enter Physical Inventory counts INVADPTE
Void Physical Inventory Tags INVADPVT (only in 10.7)
Freeze Physical Inventory program INCAPF
INVARPAR.rdf -$INV_TOP/reports/US
INVARPGT.fmb $INV_TOPforms/US
INVARPMT.rdf -$INV_TOP/reports/US
INVARPSL.rdf - -$INV_TOP/reports/US
INVARPIA.rdf - $INV_TOP/reports/US
INVARPTS.rdf -$INV_TOP/reports/US
INVARPTS.rdf -$INV_TOP/reports/US

JAVA FILES USED BY PHYSICAL INVENTORY
PhyInvButton.java
PhyInvCreateLPNFListener.java
PhyInvCreateLPNPage.java
PhyInvFListener.java
PhyInvFunction.java
PhyInvPage.java
(all java files reside at java/count/server/ )

Miscellaneous additional modules and their subdirectory structure path where they reside:
To find version of inltpu.ppc
$INV_TOP/lib
strings -a inltpu.o grep Header grep inltpu
Subdirectory Path Locations of Various Modules:
$AU_TOP/resource/INVSLENT.plx
$INV_TOP/bin/INCTCC grep '$Head'
$INV_TOP/bin/INCTCM grep '$Head'
$INV_TOP/bin/INLTCP grep '$Head'
$INV_TOP/bin/INLTUQ grep '$Head'
$INV_TOP/forms/US/INVADPAP.fmx
$INV_TOP/forms/US/INVSDSUB.fmx
$INV_TOP/forms/US/INVTTESR.fmx
$INV_TOP/forms/US/INVTVQOH.fmb
$INV_TOP/lib/inctgl.o
$INV_TOP/lib/libinv.a
$INV_TOP/patch/115/import/US/invqueue.ldt
$INV_TOP/patch/115/sql/ INVCLRMO.sql
$INV_TOP/patch/115/sql/INVICIVB.pls
$INV_TOP/patch/115/sql/INVICIVS.pls
$INV_TOP/patch/115/sql/INVPICTB.pls
$INV_TOP/reports/US/INVARCLI.rdf
$INV_TOP/sql/INCDPG.sql
$INV_TOP/sql/INCDPG.sql
$INV_TOP/sql/INCDPG.sql
$INV_TOP/sql/INCDPG.sql
$INV_TOP/sql/INVCLRMO.sql
$MPP_TOP/sql/mrppgupd.sql
$MPP_TOP/sql/mrppgupd.sql
$PO_TOP/bin/POXRQCNB.pls
$PO_TOP/bin/POXRQCNB.pls
$PO_TOP/bin/POXRQREB.pls
$PO_TOP/bin/rvsrq.lpc
$PO_TOP/resource/POXBWVRP.pld

1 comment:

tikitodo said...

there are many ways of download sql server 2005 .mdf, try this application if you’d like to get better results