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

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

SQL:

SELECT COSTED_FLAG
VpVg1l'z[0FROM MTL_MATERIAL_TRANSACTIONSITPUB个人空间.Go|?N|
WHERE --ORGANIZATION_ID = &OrgID AND TRANSACTION_DATE <= '&EndPeriodDate' AND ITPUB个人空间2T |6v0sL${K
~
COSTED_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-2005
R!u:J)A
n G;d K0
9g'Zia!]|3T`7r.^0PURPOSEITPUB个人空间/p(z? QP yR4L
==============ITPUB个人空间u_:Y7ta
This article provides technical overviews and details of the four
C&A)SL0sn0interface managers that can be controlled from the Interface Managers form asITPUB个人空间 aT6~cdO.p
part of the setup procedures:
8B/i4o'm-tWA0ITPUB个人空间TP]B;`W
1. Material transaction managerITPUB个人空间 ?7N/[r7Q!S
2. Demand reservation manager
#lQ:t3K*v03. Cost Manager
tP;m[~ht04. Move transaction manager
BGcsL G,e&e0
Nsg)R*?
b}0@A0ITPUB个人空间Jk-G\,~ y
SCOPE & APPLICATIONITPUB个人空间[s0w @ CZ
C

S3Wn#N'F0This bulletin is intended for system administrators of OracleITPUB个人空间(]
hL,?_5c%y*G F
Applications and users that are involved with setting up Oracle Inventory 11.0.3 and higher.
D"?\:iU0ITPUB个人空间3FlK|q
ITPUB个人空间u!\
{,}q
RELATED DOCUMENTS
G`2Pw|0==================ITPUB个人空间hRM)U6}R
Oracle Inventory User Guide - Transaction Setup
(Z0Z%nhP0
W@`_.G?R0u0
A6R S)o)w}x Z0These four managers execute the following processes: materialITPUB个人空间D'C4e2v*g(T S
transaction, demand reservation, resource & material cost transactions and move
+KVX;cPvS0transactions. Generally these managers are running continuously at regular ITPUB个人空间*x"Kc7C!ixf
process intervals as determined on starting the managers. ITPUB个人空间wK"G[cI)Z

;o)etJ-A'wO0They control the number of transaction workers, processing intervals and number of transactions
3U#y_b9IB0processed by the worker. The mode of operation for these managers is governed by the setting ofITPUB个人空间eJ [3Pk"EQ
profile options prefixed by the letters TP (transaction processing).ITPUB个人空间 czt%k v
ITPUB个人空间!|U3\*y8x C[6h
o For example:

@/U,W4t3kc/P"SW]0
8D;G a0@0U%?,f"uW0Setting profile TP:INV Transaction Processing Mode to a value of
J sij#vnKC*uL0Background Processing, will mean that Inventory and WIP transactions are
3{3xb Yax!W@?q0periodically transacted upon by the Material transaction manager. The transaction
;I0nuD2y m7d2{0manager requests will appear on the concurrent managers queue at regular
FFW wWs0processing intervals.ITPUB个人空间oquGt%fE,K
ITPUB个人空间4n([3ydd"b/p

H6A^H'PT0Resolving Problems
oG$iwFi0------------------
wA\'r0eVN0As transactions are processed, the respective inventory and work inITPUB个人空间.Wn Tj5N-C/QK
progress tables are updated to reflect these changes. If for some reason theITPUB个人空间@ QM3EJ-K3B
results viewed in inquiry forms and reports do not reflect these updates, it
7~K @c Qn[:ad6uM0will then be necessary to review and correct the errors. This can be done in partITPUB个人空间;}?C2I8Np0E
using the Transaction Interface & Pending Transations forms, however there are
2c0b-fq6g)Iv/JFo0often cases when sqlplus will be required to effect a resolution, in these ITPUB个人空间;f%f})n t,A6d!p
cases it may be helpful to refer to the notes below.ITPUB个人空间*O/uYGv K1zz?

`0[%x{m0
(|%g'ft u2v\0Material Transaction InterfaceITPUB个人空间1Vwjv:WR_5J
------------------------------ITPUB个人空间#X3K^L&O}

D1Z8[TZ)m|0o INCTCM module: Process transactions interfaceITPUB个人空间%R(}Oq-N k{!doD
ITPUB个人空间-vB#V/Fbl:I
This program processes material transactions following changes in any of
;ZWlM1^0the transactions form. For optimal processing speed the system managerITPUB个人空间6sy&tF^;i5ml I0e
responsibility should be used to tune the Inventory Manager. The initialITPUB个人空间fanR5v
setup for this is defaulted with a single target process setup.ITPUB个人空间u'w-r9k/UU

xt"e yH0The number of target processes will limit the number of workers
s1`9ypk$o0available to the transaction manager, workers can be run in parallel, therefore to
'p:e+I&p4k)Rq,e x^W \G0significantly reduce the time taken to process your inventoryITPUB个人空间0V^vI6uSF |_
transactions,then increase the number of target processes to the maximum allowable
LQx-qC:BP/Nn3x&X-O0within your system limits. For this request the assistance of your dba, system
Wd![0g
S(T2S*F0memory and central processor performance will be the limiting factors for thisITPUB个人空间K G9M5?u
target parameter.
8_3W!ukTT:u0
g0b+nMOY6a;^0While running, the program: INCTCM, constantly checks for rows in the
9P#\a9p@E+~0interface and interface temporary tables. First checking the interfacesITPUB个人空间6p1EV0m9}Q
temporary tables and acting upon these records and then processing theITPUB个人空间7`m M VfA1T
records in the interface tables, marking these records with header identifiers
VT)P3RF3{.Z0and subsequently moving them to the corresponding temporary tables, thisITPUB个人空间e-M1N{a
process is repeated each time the workers are started.ITPUB个人空间AVgu9{i8Q}

1B;GH0Tg3Q{b(o-I-D0For example:ITPUB个人空间'O(U+Wp;Cn#xxD
INCTCM polls and transacts upon records held in mtl_transactions_interface,ITPUB个人空间(x-[.wS7rpH4^;Q
mtl_transaction_lots_interface,and mtl_serial_numbers_interface movingITPUB个人空间y-O bf2X.B
these to their respective temp tables, eg: mtl_material_transactions_temp, theseITPUB个人空间 y~j9QOa"L!P
are then processed by the transaction processor, such rows have theirITPUB个人空间:e'bCq,l.i
lock_flag set to the value Y.ITPUB个人空间ZOM'}7Q8g

bUgl F?c0Different workers are submitted by the transaction processor to processITPUB个人空间t~2Y8HjKR
Order Entry, Work in Progress and Inventory transactions,these are processed
7I0~)B#rx#i`ih?0in groups, depending on the value of the flag validation_required,ITPUB个人空间O vE QK.EX,Y
d
values 1 or null = detailed validation 2=not detailed processed rows are
L q
R
ieB-u0assigned a transaction_header_id using the sequence mtl_material_transactions_s.
j"?u@3K Mz0l0
z ]!^,h]\e!`0o Records that are ready for selection will have:
#C Nt3j0fV%s| Y0ITPUB个人空间 m.Q#w+[$|3RJMw
transaction_mode=3, process_flag=1 or Y for mtl_material_transactions_temp tableITPUB个人空间 f RS-[;a.BW-F
lock_flag=2 or null(or N in mtl_material_transactions_temp)ITPUB个人空间-~UMx4g%RGT+}v'qM

8VJ E{M,Fr'q0process_flag has a range of values: 1=ready,2=not ready,3=failedITPUB个人空间%Lr^4jIMGP#{:j*D
lock_flag has a range of values: 1=locked 2=not locked,NULL=not locked
J7igw+Y0transaction_mode has a range of values: 2=immediate mode 3=backgound mode
? }J)p1v@ n0ITPUB个人空间2D)]GB&mBGc
ITPUB个人空间#r3g:I8Ys/zS4G{
The rows in mtl_transactions_interface are processed in 5 phases.

yYx"CI&`%ry0
'T!B7`/C$n+]C*_*H.{#I01. Derives dependant columns, eg:acct_period_id, primary_quantity etc..
.JYOpsD_/JjM02. Detailed validation performed on the recordsITPUB个人空间v-Z1cm2M"i9f(h
3. On hand qty check for negative qty's etc..ITPUB个人空间:Wj8Hr6Lzm
4. Reservations Relieved if demand was created in order entry
4Ga;z?uU3xj-G05. Rows are moved to mtl_material_transactions_temp where the
G%m d3Y3`A]0transaction processor is called to process these rows and update the inventory
o!F2D9j0P7A/E_DA"N'\+s0levels etc..
0e7A:h8Oi K2J0
3cA$x/J-P]$}3P&C0ITPUB个人空间)Xk
a1b%RLp%v+M
For more details see vol 3 INV technical reference manual.ITPUB个人空间0U&N"QmQ!@#oQ
ITPUB个人空间
E`fO1r

h2O A N9Y8CU1n0o Resolving Errors:ITPUB个人空间;yj0] J(Rmn_
k

on%La
M;p0If an error occurs with the transaction processor, the entire group of
8Kx)pyNu0records will be marked with the error code, the actual failing row will containITPUB个人空间Ss]#iw8c0m/BI
the error explanation.
K D%f|"q!~xx
P"k0
;o2V-x(W`1d }0You can access failing rows using Inventory's View Pending Interface
^#Q*~I%QmE0Activity form, additionally you can use this form to resubmit the records byITPUB个人空间'C:\?T#cL'p
setting the 'resubmit' flag to yes, this is only appropriate if the error thatITPUB个人空间g-}T(p2vbGS
caused the failure is unrelated to the interfaces transaction data, eg: database

?Qd7m4qR0space problem.
"KZ;j|,w$`0
bij'ov6l`}7M0l0Errors can be determined by viewing columns: error_code and error_explanation
m7f
vv6`+`[.o0on table mtl_transactions_interface, once the cause has been corrected,
*Yc*ps*aI{%s0use sqlplus to update the process_fag = 1 and the lock_flag = 2 or null
'nx t'mos+}0ITPUB个人空间:z*IZo(iN${
During phases 1-3 above, rows are marked with an error code and explanation,ITPUB个人空间_QmT8Jg&d
for phase 4 all records with this header_id will be marked as erroredITPUB个人空间"h2J.?*z/z$F#m
h
regardless. For phase 5 all rows will be marked with the same error
u sbD6^7R0c~ABY'U![0except for the single bad row that caused the failure.
_hZ9p.?)V0
,V%n0Ueg2Wc}6B0
zb!YDF!Dw0Demand Reservation Manager
Y?\,unO0--------------------------
&u-z1aicZY:NL0ITPUB个人空间j
L2[)v/XU8m*F~
o INCDCM module: Process demand interface
,KH$d$W{{@"V_G0ITPUB个人空间 A%\j@0^#_ q }_
The Demand Reservation Manager periodically updates Inventory with the
~3PlIwqx&?9y(n0demands from sales orders shipments.ITPUB个人空间 Y;z"s~TB:j v0W@Wx

8KI,bf H0INCDCM is linked into INVLIBR, the program processes records from
%Qz%y6n:f0mtl_demand_interface to mtl_demand table. Records held in mtl_demand_interface
!tD:oR:_4]/\o B#P0need to have process_flag=1 (ready), transaction_mode=3 and error_code =
nk(xk"@$M0null.
;iWyDY0
3s
Q'm
Au-WS0For more details on this program see page 3-812 vol 3 INV technicalITPUB个人空间v:h} IuE2}
reference manual.ITPUB个人空间:dZU` Ch

#n Nx/tv3s+~ h0o Resolving Errors:
7N6^d
n1f)C0ITPUB个人空间(HDl%C~%m!m U+{|PF
Regardless of pass or failure, all records failing validation in theITPUB个人空间h8y-utt}M%Y|Edh
interface table will be marked with an error code. Columns error_code andITPUB个人空间@uR8C'l(]q%g
err_explanation can be selected for explanation of the cause. A
Xb,l:P@8mQ0succesful demand operation is denoted by error_code=0.
d[4`h!MFW,wiz0
-z!E&d%gPU [1E2fa-Y$g0Full errors listings can be determined by selecting, lookup_code and
-J(a\rv]E"a0meaning from the table mfg_lookups
Zr;ke7^-g1b0\0where lookup_type='MTL_DEMAND_INTERFACE_ERRORS'
ZIuog(@[.]k0
v6l&T
~|#cTy0For more details on the table mtl_demand_interface vol 1 Oracle
.Ml/xr C1z M uO)a H0Inventory Technical Reference manual.
*t)FSn? M0ITPUB个人空间_${6S'V#NV't*f

5B M2X w`0Material & Resource Cost transaction processor (Cost Manager)
Q,K c&o;igMV0-------------------------------------------------------------
!eOoMlAw1K0zE0The Cost Manager controls both the Material & Resource Cost Transaction
x2p"B+?-JD0Processors. This manager starts the processors at the specified processITPUB个人空间s2Y0r!F
AOa
interval in the launch manager form, The Cost manager itself does not kick off aITPUB个人空间#xb*S#O],g4B
concurrent request for each of the intervals, the manager only runs (goes from
P,n;uMVr KF,F0pending to running then back to pending) once every 24 hours.
!n;Yiwevr0
jX/N,\!]?9CI0Material Cost ProcessorITPUB个人空间eTz/[j]V?
-----------------------
7E!@is%md0ITPUB个人空间X5X"R*EN8Hn s
o CMCMCW module: Material Cost Transaction Processor
8O gDUB*SKB2Wv0
"M#saO1p0This program is used to process material transactions for costing in
SvS)Yo0@n9N}n
M,x0inventory and WIP products. This module scans table mtl_material_transactions
U1\-ZR9nt0for uncosted transactions, ie:
E-Eg#O^\0where costed_flag='N'& transaction_group_id=NULL. For each transactionITPUB个人空间*Q]+e/Bk[
found program; INLTCP is called to process the records.ITPUB个人空间$?R.sQ;dT.n]_ ]
ITPUB个人空间/k.Y(z x;m IQ-Lo3@
Note:ITPUB个人空间Q~2x%y.Y}W E
If this program is not running then there will be no availableITPUB个人空间;ul9J:hM8Ww W\~,u
Transaction Distribution details in the Material Distributions inquiry form.
Rr T{G mW0
7izDQE Gm0Records are inserted into mtl_transaction_accounts, for the account andITPUB个人空间 mn,JB`0B+g6[
l1V$z
the value of the transactions.
NZHYEf,Q0ITPUB个人空间Q Yd\;N;t
For more details on this program see vol 3 Oracle Inventory Technical
*F|3GC WU0Reference manual.ITPUB个人空间Hv5O$c3B
ITPUB个人空间8]R#K8q3sx8k
Resource Cost Processor
J"vx]f[:J+t2A0---------------------
:u~3D~ b6SSw0
+X/Yd|Pj^0o CMCCTM module: Resource cost transaction manager
a/Pj`(^XCF0ITPUB个人空间4J5Uh6Sd a%R
The Resource cost transaction manager processes transactions from
gU+T3N?L k,U%\,U3z0Oracle's WIP in addition to those resource transactions imported from other sorces
9C[r@5`yP r0such as barcode readers.ITPUB个人空间6F8nTXXM?%H#w:?
ITPUB个人空间+ZG P[j0s IY[
The program polls pending transactions in wip_cost_txn_interface and
([2Cw9G$`*ON0periodically updates/inserts into the following WIP tables:ITPUB个人空间p*B$HPbU%R
wip_transactions, wip_transaction_accounts and wip_period_balancesITPUB个人空间}/?t)h1@4qMQA

/t\2e&U4C!kt0The program can be run from the command line: CMCCTM bom/bom passwd 0 YITPUB个人空间)f/?5GN-~H

3{-QCt#GcXHE0For more details on this program see Oracle WIP Technical ReferanceITPUB个人空间,C4s];R2t2|{
manual.ITPUB个人空间%|8P.G8U3F0}0M^;X7_
ITPUB个人空间l \1RVad8|&sJ
ITPUB个人空间;T)i$B}8dT]s'O
WIP Move Transaction ManagerITPUB个人空间&h!jc.V/`(^2N0Q
----------------------------
rNE#|-dYw0ITPUB个人空间MQQ#O5F&YTh Wg!p
o WICTMS module:
o&NE*u"p)_.Z0
{j#x&~[0The WIP Move Transaction Manager processes move transactions in Oracle
`0P9R+rKm0WIP and move transactions from devices such as bar code readers.
$r[HP:?+u0ITPUB个人空间9bD`k
sF8d
The table wip_move_txn_interface is polled by the program WICTMS toITPUB个人空间KEvY0x|k0|
determine if any transactions are pending validation and or processing.