inventory transaction一直不能transfer到GL的原因

原因是,我在关闭inventory的会计期中找到了这这些pending的记录,tansaction肯定是已经生成的,但是MTL_MATERIAL_TRANSACTIONS 中Costed Flag='N'.

SQL:

SELECT COSTED_FLAG
~K+D G*aW0FROM MTL_MATERIAL_TRANSACTIONSITPUB个人空间az-v'o&M]K
WHERE --ORGANIZATION_ID = &OrgID AND TRANSACTION_DATE <= '&EndPeriodDate' AND

Br%z5QN.iE
x"f0COSTED_FLAG IS NOT NULL

所以原因是Cost Manager没有运行,就前几天说的被我们的DBA强行拿掉的,但是测试环境1一直没有人去recover 这个.

同时Metalink中的doc:111729.1 对此有详细Interface Manager有详细的介绍,至此由Inferface Manager引发的问题终于可以告一段落了:

This document was checked for relevance on 21-FEB-2005ITPUB个人空间&w {Qp J*D+s2t
ITPUB个人空间2DeFeMO%D6V
PURPOSEITPUB个人空间M*D"Q+As@#t
==============
` L.M#C#G peX:J0This article provides technical overviews and details of the fourITPUB个人空间6UO[,B/vWx
interface managers that can be controlled from the Interface Managers form. as
Gq*Sn._#g0part of the setup procedures:ITPUB个人空间{Oj0_.`Fmn}

`ok7J7OhdU,~01. Material transaction manager
*nW qtn(G?G S*t02. Demand reservation manager
7K#^)B&o1hK+^}0aya03. Cost ManagerITPUB个人空间3ka2r.`.v1_+[fe
4. Move transaction managerITPUB个人空间y(y5O%ihtH:[S
ITPUB个人空间u?6@|&{s"t
ITPUB个人空间p6\ IV7YHN7q-Ff
SCOPE & APPLICATIONITPUB个人空间J4P*P;ZC3T7I"D7}
ITPUB个人空间5]6S2r!q5Q'Q s#l aG,}
This bulletin is intended for system administrators of Oracle
\f.O,`cySdl0Applications and users that are involved with setting up Oracle Inventory 11.0.3 and higher.ITPUB个人空间xC+Tu `&c9v&b$M

sz,~ Clj&c*N0ITPUB个人空间.BsF(E;v3dx,A4{
RELATED DOCUMENTSITPUB个人空间.cU)|3J8B
==================ITPUB个人空间:vecy'b
Oracle Inventory User Guide - Transaction SetupITPUB个人空间N f3|K)y+cW
ITPUB个人空间 j'hcrS

}+}*Y4{8jv0These four managers execute the following processes: materialITPUB个人空间F"u5x#Xx
transaction, demand reservation, resource & material cost transactions and move
T{V!ef(h_0transactions. Generally these managers are running continuously at regular
C%c'Z
B*|3s+Np2U%k0process intervals as determined on starting the managers.ITPUB个人空间(b0ZusB8M

:?Hk.[8{)v[#R0They control the number of transaction workers, processing intervals and number of transactions
`:?1NUA7w6^0processed by the worker. The mode of operation for these managers is governed by the setting of
Hs5[&x L,?Ti"C0profile options prefixed by the letters TP (transaction processing).ITPUB个人空间%^%Q[`t#on$`
ITPUB个人空间{URNA
vJ
o For example:ITPUB个人空间3WS9|b'ms]s&~
ITPUB个人空间'x(l$P?1V
Setting profile TP:INV Transaction Processing Mode to a value of
/K%?r"[4D0Background Processing, will mean that Inventory and WIP transactions areITPUB个人空间M
yK\Y6nN.}$?
periodically transacted upon by the Material transaction manager. The transaction
E
JjY1GhV\0manager requests will appear on the concurrent managers queue at regularITPUB个人空间wL$eZMl9od
processing intervals.ITPUB个人空间3voh\N q0QN5\

Fgb4m9Y z6Hl
c*f:n6E0ITPUB个人空间L Q\hYX&y
Resolving Problems
7_,Cf&DI0uRz0------------------ITPUB个人空间Q*@O-gv&z&O?^&l `
As transactions are processed, the respective inventory and work in
MD5N9hO'P0progress tables are updated to reflect these changes. If for some reason the
EB"r%So_)jF0results viewed in inquiry forms and reports do not reflect these updates, itITPUB个人空间GcsG3a)U w ?n
will then be necessary to review and correct the errors. This can be done in partITPUB个人空间&z?|d6i~9|*hzv
using the Transaction Interface & Pending Transations forms, however there areITPUB个人空间f^)v$ZWFoTp,v
often cases when sqlplus will be required to effect a resolution, in theseITPUB个人空间;Y'P
?{rEd+l#^
cases it may be helpful to refer to the notes below.ITPUB个人空间*\j3eWZ%Tuy

0R1y2Vl:S^Jl'Wv!G!Y0
S6jw"`6fcB%~0Material Transaction Interface
*jk*E j3t Q {.ON(E0------------------------------
,S Z1gj1c(?0ITPUB个人空间n~"g!G_GJ M
o INCTCM module: Process transactions interface
5Qt$~K(E"PmC5m0ITPUB个人空间C5V)VV&W*V
This program processes material transactions following changes in any of
nU(e#?/t1F^0p7SD0the transactions form. For optimal processing speed the system managerITPUB个人空间Q'HuJZ2~?
responsibility should be used to tune the Inventory Manager. The initial
"Yx f
SN(^3n0setup for this is defaulted with a single target process setup.
a L0rF+A/~0ITPUB个人空间^:A!ZC A$h$N
The number of target processes will limit the number of workers
9_ dcMN
O{-z0available to the transaction manager, workers can be run in parallel, therefore toITPUB个人空间)zG(RC}f2v2J
significantly reduce the time taken to process your inventoryITPUB个人空间8A)a6W{C"iv
transactions,then increase the number of target processes to the maximum allowable
!]W/N6A^_+vX0within your system limits. For this request the assistance of your dba, system
9_X X5H7D
zgQ0memory and central processor performance will be the limiting factors for thisITPUB个人空间m{4`hW}n_:y
target parameter.ITPUB个人空间5J"{Hxt;H Yt|ZK

2h"I.\ i:ZC0Q0While running, the program: INCTCM, constantly checks for rows in theITPUB个人空间kZ4M:W"FL3T"yu"d k!M C
interface and interface temporary tables. First checking the interfacesITPUB个人空间o8_v@+}*rb3Cl
temporary tables and acting upon these records and then processing the
7Y8K2C*q ^D0records in the interface tables, marking these records with header identifiersITPUB个人空间Q8y1z| _
OR8p@,v
and subsequently moving them to the corresponding temporary tables, thisITPUB个人空间(I,Y+T}t er"G,}
process is repeated each time the workers are started.
M zY#f7TL}k0
jk!@)p#Gw4qg0For example:ITPUB个人空间!aJO+tl
INCTCM polls and transacts upon records held in mtl_transactions_interface,ITPUB个人空间`ZN[U7qF
mtl_transaction_lots_interface,and mtl_serial_numbers_interface moving
i"z4pc&Z%Qk0these to their respective temp tables, eg: mtl_material_transactions_temp, theseITPUB个人空间k9td+|9f
are then processed by the transaction processor, such rows have their
#k}&VN2}w0lock_flag set to the value Y.
u)]2G)fmV0
({!S X'FKjY3u
?)nJ0Different workers are submitted by the transaction processor to process
C K/?d+`Y`;us0Order Entry, Work in Progress and Inventory transactions,these are processedITPUB个人空间"^D6UKd+Lzq
in groups, depending on the value of the flag validation_required,
n@*Ejmz~
|0values 1 or null = detailed validation 2=not detailed processed rows are
7q/F-B9n Yvc wb_ Z,Q z0assigned a transaction_header_id using the sequence mtl_material_transactions_s.
h^*O:D]]Nn0ITPUB个人空间abV@/kQ k|
o Records that are ready for selection will have:ITPUB个人空间Iq7r%?!K/k%Q
ITPUB个人空间)|\i&[L!O*U%Q
transaction_mode=3, process_flag=1 or Y for mtl_material_transactions_temp table
}wo
T$l0lock_flag=2 or null(or N in mtl_material_transactions_temp)ITPUB个人空间1CXUIH9|$M

4D7Q7t&f'd0process_flag has a range of values: 1=ready,2=not ready,3=failedITPUB个人空间Ka7[ ]!dc0xhJ
lock_flag has a range of values: 1=locked 2=not locked,NULL=not locked
eOb9Ym#Tr#r0transaction_mode has a range of values: 2=immediate mode 3=backgound mode
`1S;j,U8c5PVG0ITPUB个人空间7C%[+[%V8{z
ITPUB个人空间IUW-o Y`.P |/u
The rows in mtl_transactions_interface are processed in 5 phases.
k"d]LK7Vh0
R*k'[`~+w`Kg$x'D01. Derives dependant columns, eg:acct_period_id, primary_quantity etc..ITPUB个人空间f#i,K5n+mA,D.P'H*k
2. Detailed validation performed on the recordsITPUB个人空间nHx:AOGq"Az!U
3. On hand qty check for negative qty's etc..
-y"d*f._O+k/u1K04. Reservations Relieved if demand was created in order entry
3Q5|7ub,oje Z'o?:X+p05. Rows are moved to mtl_material_transactions_temp where the
7?
yiU!B$s;OhrX0transaction processor is called to process these rows and update the inventoryITPUB个人空间o-h b1o$lIu:l
levels etc..ITPUB个人空间;j
N&~-g[N1tJ
ITPUB个人空间B Nt^ v0{`

5Iq~&~H%hK0For more details see vol 3 INV technical reference manual.ITPUB个人空间6yydI\ Dn
ITPUB个人空间V d@Rh*se_;z@

1d#E0Y8x_$H0o Resolving Errors:ITPUB个人空间7}u%j8v/?|

3q0_`'A3d[9Y0If an error occurs with the transaction processor, the entire group of
4lc/o4v$|iw6sq0records will be marked with the error code, the actual failing row will contain
9K7?,Va RE;}k0the error explanation.
'TAo RaT9D5F0
Z(Iv!h._+q'o;q0You can access failing rows using Inventory's View Pending InterfaceITPUB个人空间nWZL#JLT,~0V
Activity form, additionally you can use this form. to resubmit the records by
dlz_2cE0setting the 'resubmit' flag to yes, this is only appropriate if the error that
!sq:s9o/wm0caused the failure is unrelated to the interfaces transaction data, eg: databaseITPUB个人空间5y5I#q9F6b/_2\S$g
space problem.
9^1\C|H0
B2eyH})g,f0Errors can be determined by viewing columns: error_code and error_explanationITPUB个人空间v@g^2~RZYt
on table mtl_transactions_interface, once the cause has been corrected,ITPUB个人空间 R+vLhl3yj.yG
use sqlplus to update the process_fag = 1 and the lock_flag = 2 or null
qJTk*o3{:q/g0ITPUB个人空间p}#UG-?8L
During phases 1-3 above, rows are marked with an error code and explanation,ITPUB个人空间%Fd$|%xIL
for phase 4 all records with this header_id will be marked as erroredITPUB个人空间p1qhGt.DGa5]:f#s
regardless. For phase 5 all rows will be marked with the same errorITPUB个人空间9t'JrN if(nor
except for the single bad row that caused the failure.
-f f}+j7SO{f0
+a,GJj_nxa[%M0
|e0L8CE&qA6A`s%X0Demand Reservation Manager
TH Z|Qg/jf0--------------------------
]5w6bA$Bz1J"rb0ITPUB个人空间#@"k"hpLbq
o INCDCM module: Process demand interfaceITPUB个人空间"eKd#Ct
ITPUB个人空间jr,b9ldZ[)o7eDIO
The Demand Reservation Manager periodically updates Inventory with the
dsD,o5z$z \7U-D H*X(\f0demands from sales orders shipments.ITPUB个人空间,S*C)U)`Y

q^gg u'yi-S5]Ew0INCDCM is linked into INVLIBR, the program processes records fromITPUB个人空间2KY:G+vG`]/M,wo;v
mtl_demand_interface to mtl_demand table. Records held in mtl_demand_interfaceITPUB个人空间;_Lu2T6q I Wu^
need to have process_flag=1 (ready), transaction_mode=3 and error_code =ITPUB个人空间%qM&aIRKI^7x
null.ITPUB个人空间 J4}9?5f%P-b

~[CO0q%fVF8Pj0For more details on this program see page 3-812 vol 3 INV technical
G1CQs$fiwP*j0reference manual.
]1JKA-Z*A0l#La'V0ITPUB个人空间l0auA$U2F
o Resolving Errors:
0SeX#P,sO W0
-U3k`aK.k3c0Regardless of pass or failure, all records failing validation in the
ee VF r?M'?0interface table will be marked with an error code. Columns error_code andITPUB个人空间 ^] D(A.xtM
err_explanation can be selected for explanation of the cause. A
"eVqA2E~d
? f0succesful demand operation is denoted by error_code=0.ITPUB个人空间m,aQ0g9d'A
ITPUB个人空间5}tC[l1GlGu
Full errors listings can be determined by selecting, lookup_code and
}*@2|1{nS2a0meaning from the table mfg_lookups
'pT.~~I[K0where lookup_type='MTL_DEMAND_INTERFACE_ERRORS'ITPUB个人空间 HGxBt8AE'e
ITPUB个人空间7S/\4lb"o8pd
For more details on the table mtl_demand_interface vol 1 OracleITPUB个人空间.g'^Q.}!v9sY R
Inventory Technical Reference manual.ITPUB个人空间GcFD0|l5q

7HTL2k3|:Bd0ITPUB个人空间+Tq&Wlq@ A3c
Material & Resource Cost transaction processor (Cost Manager)
w2N"vZun0-------------------------------------------------------------ITPUB个人空间.}3F7pje L+Y
The Cost Manager controls both the Material & Resource Cost TransactionITPUB个人空间%S$Gg"?#?&r{I
Processors. This manager starts the processors at the specified process
zbRh [iw0interval in the launch manager form, The Cost manager itself does not kick off aITPUB个人空间X|6NBq3F5Z$m
concurrent request for each of the intervals, the manager only runs (goes fromITPUB个人空间5vBWyD
pending to running then back to pending) once every 24 hours.ITPUB个人空间N?L0b,o~s
ITPUB个人空间8}d7^zK C v\Va
Material Cost Processor
}Np'aI1uKz4}/|0-----------------------ITPUB个人空间xh$kjZ|
ITPUB个人空间q`4N?Z2CV6L,S
o CMCMCW module: Material Cost Transaction ProcessorITPUB个人空间b!mm FkH)^e&D

|`C&kp4e5q:T0This program is used to process material transactions for costing in
&kh&c+@'X w6AGb0inventory and WIP products. This module scans table mtl_material_transactions
_!V&J:d.HRT(V(X0for uncosted transactions, ie:ITPUB个人空间["N l+eH c8_!I7J
where costed_flag='N'& transaction_group_id=NULL. For each transactionITPUB个人空间u)Yhvn8\d2O
found program; INLTCP is called to process the records.ITPUB个人空间W Qb]+Ltt
l+kJ
ITPUB个人空间4~;TM
Note:ITPUB个人空间9iY.y3d-f5K*M1|Y
If this program is not running then there will be no availableITPUB个人空间6i,ox%|-B{*F
Transaction Distribution details in the Material Distributions inquiry form.

c7X^!S7jk0ITPUB个人空间"x%Ka6w d
fkz
Records are inserted into mtl_transaction_accounts, for the account and
e
s8\&J%?V(}{Y;s&Wk0the value of the transactions.
$`.v`@(dP9xtSo0
jv;R-|h-u-WC0For more details on this program see vol 3 Oracle Inventory TechnicalITPUB个人空间[Lb+H'ON5}
Reference manual.
t.oT%o(s9c1a0ITPUB个人空间6a lR"tJ
Resource Cost Processor
r6@3oN1D#B,dDt0---------------------ITPUB个人空间@!D#u GqY|

M4y
i:g6k8Y0o CMCCTM module: Resource cost transaction managerITPUB个人空间9?b.DO~%J|!|k
ITPUB个人空间0zRM/ja'B+qN
The Resource cost transaction manager processes transactions fromITPUB个人空间4Ql m_{`1Bd
Oracle's WIP in addition to those resource transactions imported from other sorcesITPUB个人空间t)L3hC[f#ex s
such as barcode readers.
%x_ Z's UdM0ITPUB个人空间)`Z%akFK(Ueg
The program polls pending transactions in wip_cost_txn_interface andITPUB个人空间R'uq5GF;M8g7m
periodically updates/inserts into the following WIP tables:
[[b v*Ma0ar;w0wip_transactions, wip_transaction_accounts and wip_period_balancesITPUB个人空间i S9u*O}
ITPUB个人空间}eugVv }T
The program can be run from the command line: CMCCTM bom/bom passwd 0 YITPUB个人空间anw9]9~

5sn&K_ |b0For more details on this program see Oracle WIP Technical Referance
8ng;xdt7w(q0manual.ITPUB个人空间k(c3M4L*M,G~/OX7|C

7i
`gLimYV0
vSVV,G/_ urV0WIP Move Transaction ManagerITPUB个人空间9\3JU%xLy"H2Z`7mI
----------------------------ITPUB个人空间 yoD/BF ^

.mQ[sK'g2c0o WICTMS module:
z&F G2N5m O6xFV#XW0ITPUB个人空间.w\/PLFx/p)[(r2m
The WIP Move Transaction Manager processes move transactions in OracleITPUB个人空间m5F9U \m M_i
WIP and move transactions from devices such as bar code readers.

nK"qWw0ITPUB个人空间1wazV:V`6d&{
The table wip_move_txn_interface is polled by the program WICTMS to
w'J"oC9Ay3S)T0determine if any transactions are pending validation and or processing.