Trans 3 Us

8/8/2019 Trans 3 Us

1/12

TRANSACTIONS ANDDISTRIBUTIONS FLOW CHART

How transactions are handle byO.A.

INV & CST (and WIP, PO, OE)

R11 & R10.7 & R10.7.16.1

A document from Oracle Support Services France

Author: Edouard MARTEAU dAUTRY

Creation Date: August 24, 1999

Last Updated: April 17, 2000

Reference: E:\Seminaire Transactions\Transactions And Distributions Flow

Chart.Doc

Version: 3.0

8/8/2019 Trans 3 Us

2/12

Error! Unknown switch argument

Error! Unknown switch argument./Error! Unknown switch argument

Document Control

Change Record

Date Author Version

Change Reference

24 Aug 99 Edouard MARTEAU

d'AUTRY

1.0 No previous document

18 Nov 99 Edouard MARTEAU

dAUTRY

2.0 Add new flow graph

Add transaction type list

17 Apr 00 Edouard MARTEAU

dAUTRY

3.0 Add debug profile option and patchs

Convert all document to english

Contributors

Name Position

Distribution

Copy

No.

Contact Name Location

1

8/8/2019 Trans 3 Us

3/12



How the document is organized

Audience

Any Oracle Application users that deals with transactions.

This document is design to help Oracle Application user to analyze any problem they may

encounter

Related Documents

Oracle Cost Management Release 11 Users Guide (Part #A57766-01)

Oracle Cost Management Documentation Updates Release 11.0.1

Oracle Inventory Release 11, Volume 1 & 2, Technical Reference Manuel(Part #A58299-01 &

#A58296-01)

Oracle Bills of Material Release 11, Volume 1 & 2, Technical Reference Manuel(Part

#A58184-01)

Note:1016787.102

Note:1019601.102

Your Comments are

welcome

Oracle values and appreciates your comments as a user and reader of this manual. As we

write, revise and evaluate our documentation, your comments are the most valuable input

we receive. If you would like to contact us regarding comments and suggestions on future

releases of this document, please use the following address.

[email protected]

8/8/2019 Trans 3 Us

4/12



Contents

Document Control .......................................................................................................................................................................................

How the document is organized.............................................................................................................................................................

Audience.........................................................................................................................................................................................

Related Documents......................................................................................................................................................................

Your Comments are welcome...................................................................................................................................................

Contents..........................................................................................................................................................................................................

Caption ...........................................................................................................................................................................................................

Form .................................................................................................................................................................................................

Table.................................................................................................................................................................................................

Manager..........................................................................................................................................................................................

Worker.............................................................................................................................................................................................

CST :Average costing option ....................................................................................................................................................................

Debug profile options and patchs ..........................................................................................................................................................

CST:Cost update debug level....................................................................................................................................................

MRP:Debug Mode........................................................................................................................................................................

Patch 904573 .................................................................................................................................................................................

Transactions and distribution flow chart ............................................................................................................................................

Transaction type list ................................................................................................................................................................................ 1

8/8/2019 Trans 3 Us

5/12



Caption

Below are tips to help you understand the flow chart

Form

Represent a standard form . Allow to visualize

data through standard O.A.

Technical form name is written in bold

Table

Represent a table. Initial are the one used in the

code. Important columns are listed below the table

initial.

Manager

Represent a manager. Manager is a request

that detect rows to treat in a table and update

them with the same transaction_group_id. It

passes that transaction_group_id to the

worker.

Worker

Workers actually perform the job that need to be

done. To select lines that need to be process, it

uses the transaction_group_id that the manager

pass it to.

WIPTISFM

WIP Pending

Move

transactions

MMT

Costed_

flag=N

MaterialManagers

MvtdeStocks

INCTCM

INVusersguide

page6-7

MaterialWorker

MvtdeStocks

INCTCW

INVusersguide

page6-7

8/8/2019 Trans 3 Us

6/12



CST :Average costing option

Determine which cost processor is being used.

Attention : DO NOT switch the value of that profile option under any circumstances. This will result

in a data corruption.

INV only : Old cost processor INV & WIP : New cost processor

That profile option is set as non visible and not updatable in AOL.

Suggestion: : For more detail about that subject, check the following from Metalink

R11 CST Users guide under technical libraries/manufacturing

R11 CST Users guide update under technical libraries/manufacturing

Note:1016787.102

8/8/2019 Trans 3 Us

7/12



Debug profile options, patchs and tips

Profile option and patchs listed below are available to increase the details of information

provided in log files.

CST:Cost update debug

level

Set value to complete to get maximum information in cost worker log (CMCTCM, CMCOCW, CMCCTW, CMCACW,

CMCMCW)

MRP:Debug Mode

Set value to yes to get maximum information.

This profile option covers much more than inventory workers.

You need to make sure your log file directory is big enough to handle the size of log generated.

Patch 904573

Use this patch to add some profile option that will help analysing log files

Please see Note:1019601.102 and patch readme file available from MetalinkSet trace on for worker and

manager (R11 only)

You can set trace on for any worker listed in the chart.

Go to System administrator/Concurent/program/define

Query on short name

Set the Enable trace flag in the request section

8/8/2019 Trans 3 Us

8/12

ransactions and distribution flow chart

8/8/2019 Trans 3 Us

9/12

Transactions and distributions flow chart

Problem analysis method

R10.7.0.16.1 & R11

Transactions and distributions flow chart

Problem analysis method

R10.7.0.16.1 & R11

CST: Average costing option ?Inv only INV & WIP

Migrate

fromR

10.7.0.1

6.1toR

11R11freshInstall&

WACupgradescript

Organization parameters (costing method) INV users guide page 2-6Standard or Average?

Standard Average

Standard or Average?

Standard Average

1 2 3 4

TP: INV Transaction processing mode

On-line Concurrent immediateAt Form levelBackground

For each form, check TP:INV...

Updatable at all level

INV users guide

pages 1-26 & 6-4

Concurrent immediateBackgroundOn-line

L B

MMTT: MTL_MATERIAL_TRANSACTIONS_TEMP

MTLT : MTL_TRANSACTION_LOTS_TEMP

MTI : MTL_TRANSACTION_INTERFACE

MTLI : MTL_TRANSACTION_LOTS_INTERFACE

MMT : MTL_MATERIAL_TRANSACTIONS

MTLN : MTL_TRANSACTION_LOT_NUMBERS

MTA : MTL_TRANSACTION_ACCOUNTS

WMTI : WIP_MOVE_TXN_INTERFACE

WMT : WIP_MOVE_TRANSACTIONS

WCTI : WIP_COST_TXN_INTERFACE

WTA : WIP_TRANSACTION_ACCOUNT

WT : WIP_TRANSACTIONS

10.7

Hydeoption

withpatch666632

Mouse back to user

once transactions done

Transactions posted totemporary table.

One worker launch for

THAT transaction

8/8/2019 Trans 3 Us

10/12

Error! Unknown switch argument.

Error! Unknown switch argument./Error! Unknown switch argument.

8/8/2019 Trans 3 Us

11/12

MTLN

INV : Miscellaneous transactionsINV : Inter-org transfertINV : Subinventory transfertWIP: WIP material transactionsWIP : Completions

IfB

WIP : Move transactions

MTI

IfB

MMT

Costed_f

lag=N

MMT

Costed_

flag=Null

transaction_

group_id=xxx

IfL

IfL

Inventorytransaction

worker

INCTCW

INVuser'sguide

page6-7

Processtransaction

interface

INCTCM

INVuser'sguide

page6-7

Material Cost

Transactions Worker

CMCMCW

Costmanager

Gestionnairedescots

CMCTCM

INVuser'sguide

page6-10

MTA

INVTVTMP

INV Pending

transaction

INVTVPTX

INVTransaction

openinterface

INVTVTXN

INV Material

transaction

CSTFQITD

INV Material

distribution

1

Actual Cost Worker

CMCACW

2

3

4

WMTI

WIPTISFM

WIP Pending

Move

transactions

WICTMS

Wip Move

Transactions

Manager

WCTI

WIP : Ressourcestransactions

Resource Cost Worker

CMCCTW

WICTWS

Wip MoveTransactions

Worker

1

2

3 WT&

WTA

WIPTIRSC

WIP Pending

Resources

Transactions

OE

WIP : Workorder les

completions

WIPTQRSC

WIP View

ResourcesTransactions

WMT

WIPTQSFM

WIP Move

transactions

MMTT

MTLTMTLI

Overhead Cost Worker

CMCOCW1

2

3

INVTVTXN

INV Materialtransaction

8/8/2019 Trans 3 Us

12/12

Transaction type list

Transaction action Transaction source type Transaction type

1 Issue from stores 1 Account issue 3 Account

31 Account alias issue 6 Account alias

32 Miscellaneous issue 13 Inventory

33 Sales order issue 2 Sales order

36 Return to vendor from stores 1 Purchase order121 Charitable Contribution 13 Inventory

142 Field Service 13 Inventory

122 Issue to 13 Inventory

120 Obsolete Inventory 13 Inventory

37 Rejection of customer returns 12 RMA

34 Internal order issue 8 Internal order

35 WIP component issue 5 Job or Schedule

2 Subinventory transfer 2 Inventory sub transfer 13 Inventory

51 Replenish supply subinventory 13 Inventory

50 Internal order sub transfer 8 Internal order

3 Direct organization transfer 3 Inventory direct org transfer 13 Inventory54 Int order direct org transfer 8 Internal order

4 Cycle count adjustment 4 Cycle count adjustments 9 Cycle Count

8 Physical inventory adjustment 8 Physical Inventory adjustments 10 Physical Inventory

12 Intransit receipt 12 Inventory intransit receipt 13 Inventory

61 Internal Req intransit receipt 7 Internal requisition

21 Intransit shipment 21 Inventory intransit shipment 13 Inventory

100 Deposito presso terzi 13 Inventory

101 Trasferimento interno 13 Inventory

62 Int order intransit shipment 8 Internal order

24 Cost update 80 Average cost update 13 Inventory

88 Intercompany Cost Adjustment 2 Sales order24 Standard cost update 11 Standard cost update

25 WIP cost update 5 Job or Schedule

27 Receipt into stores 40 Account receipt 3 Account

123 Receipt From 13 Inventory

42 Miscellaneous receipt 13 Inventory

15 Receipt of customer return 12 RMA

43 WIP component return 5 Job or Schedule

18 Purchase order receipt 1 Purchase order

41 Account alias receipt 6 Account alias

28 Staging transfer 52 Sales order staging transfer 2 Sales order

53 Int order staging transfer 8 Internal order29 Delivery adjustments 70 Inventory delivery adj 13 Inventory

71 Purchase order delivery adj 1 Purchase order

72 Internal req delivery adj 7 Internal requisition

30 WIP scrap transaction 90 WIP scrap transactions 5 Job or Schedule

31 Assembly completion 44 WIP assembly completion 5 Job or Schedule

32 Assembly return 17 WIP assembly return 5 Job or Schedule

33 Negative component issue 38 WIP negative component issue 5 Job or Schedule

34 Negative component return 48 WIP negative component return 5 Job or Schedule

Trans 3 Us

Documents

Transcript of Trans 3 Us