How to resolve Costing Errors & Problems (Doc ID

865438.1)

Modified:22-Jan-2014 Type:DIAGNOSTIC TOOLS

In this Document

Main Content
Purpose
Troubleshooting Steps
Component: Data Fix
Component: Period Close
Component: WIP
Component: COST_ERROR
Component: Reports
Component: SLA
Component: Inventory
Component: Accrual
References

APPLIES TO:

Oracle Inventory Management - Version 11.5.10.2 and later

Oracle Cost Management - Version 11.5.9 and later
Oracle Work in Process - Version 11.5.10.0 and later
Oracle Subledger Accounting - Version 11.5.10 and later
Information in this document applies to any platform.

MAIN CONTENT

Purpose
Identify known and unknown issues in Costing, diagnose, and provide common data
fixes or root cause Patch.

Troubleshooting Steps
A. We expect Sup/Dev to use this note to find similar historical issues, collect diagnostic
data and suggest relevant root cause patches to the customer. However, since data fix
is very specific to individual customers, the listed scripts are only for reference purpose.
For a newly reported customer issue, a data fix SR/ Bug is still required to
get confirmation and approval of the final fix.

B. It is Highly recommended to apply the latest consolidate Patch for Costing:

R11i: please review Note 816651.1-- CONSOLIDATED COSTING PATCH FOR 11.5.10.2
CUSTOMERS FOR BUGFIXES TILL 30-MAR-2009

R12: please apply Patch 8442125 - COSTING R12 Consolidated patch applicable on top
of R12 RUP6. This patch includes many critical and recommended patches fixed as on
16- APR-2009.

C. If you encounter an Error/uncosted transactions, please provide the following

information in details:

1.Refer to Note 378348.1 (Data Collection Scripts for Cost Management ) and provide
spooled output of err_txn.sql,txn.sql, and cmlwmx.sql.

Upload the output of txn.sql for item in question

ORGANIZATION_ID = &org_id and INVENTORY_ITEM_ID = &item_id
Refer to Note 378348.1 (Data Collection Scripts for Cost Management )

2. Run and upload output of Costing_hook.sql from Note 378348.1

3. For the Organization and period in question, upload completed spooled file
CstDiag115.txt after running CstCheck.sql and output of BDEprdcls.sql Diagnostics
Scripts (see Note 246467.1)

Problem Error Data Collection Root Rel

Description Cause eas
e
Component: Data
Fix
In an actual costing none 1. Provide the output All the 11.5
organization showing any back dated causes of .10.
(Average, FIFO or transactions this 2
LIFO) one or more of from Note 291005.1 To problem
the followings can verify if there have been has not R12
occur: back dated transactions, being fully
 the script can be run to identified,
1. Negative Quantity check the type of please
on Item Cost History transaction the dates make sure
form, which is not and the periods affected. you log a
matching with bug with
Onhand quantity Cost
form. 2. Check if there is MMT- Manageme
MOQ mismatch nt to
2. Some items have (Inventory issue) analyze the
prior costed quantity from Note 291005.1. Log feasibility of
not matching a bug against Inventory finding the
with the quantity in team so that MMT-MOQ root cause
the previous qty mismatch can be of this
transaction in fixed. problem.
transaction history
form 3. Provide output of
costing diagnostic script
3. The All Inventories mmt_cql_info_11i10+.sq
Value Report is not l
matching with the
Transaction Value Verify if any mismatch in
Report MMT-CQL is detected by
the script and verify no
4. The total quantity MMT-MOQ mismatch is
in Layer Cost Update found, if it is go back to
form is not the bug logged in 2 with
matching with the Inventory Development
Onhand quantity form to verify if fix was
(Only in FIFO/LIFO) applied.

5.Any of these 4. Run the costing

symptoms could diagnostic script for all
signify MMT-CQL the cost groups in the
mismatches or MMT- organization that is
MOQ mismatches having problems to find
which will need to be if there are mismatches
confirmed by the between MMT and CQL.
diagnostic scripts. Every time the script is
run it will create a spool
file mmt_cql_info.lst

Customer needs to give

input as:
organization_id
 and Cost_group_id
Unbalance Journal EU02 Run and upload the Apply Patch 11.5
entry from Inventory following in Excel file 3557357 .9
with error code: format with headings:
EU02
Journal import is SELECT *
failing with EU02 with FROM GL_INTERFACE
an imbalanced entry where
caused by root cause USER_JE_SOURCE_NAM
Bug 3557357 E ='Inventory'
and STATUS Like
'%EU02%' ;
Subledger Period none Review Note 738529.1 Patch 12.0
Close Exception 7690716 .5
Report Event Type
exceptions
Inventory Journals are EU02 Run the following SQL to Patch 11.5
stuck in GL interface identify transactions that 7127206 .10.
EU02 are in batches causing 2
REFERENCE_ACCOUN the discrepancy in the
T = -1 accounting layer.

Select
mta.transaction_id,
SUM(mta.base_transacti
on_value)
from gl_interface gli,
mtl_transaction_account
s mta
where gli.reference1 =
&'GL batch name'
and gli.gl_sl_link_table =
'MTA'
and gli.gl_sl_link_id =
mta.gl_sl_link_id
group by
mta.transaction_id
having
SUM(mta.base_transacti
on_value) <> 0
Run Receiving ORA-01476: Run and upload the Apply Patch 11.5
Account Distribution DIVISOR IS EQUAL following in Excel file 6790176 .10.
report error ORA- TO ZERO format with headings: 2
01476: DIVISOR IS
EQUAL TO ZERO. select *
Error due to a unit of from
measure conversion rcv_accounting_events
that rounded the where
value to 0 in the table primary_quantity<=0;
RCV_ACCOUTING_EV
ENTS
Missing RRSL return none Provide output of the Apply Patch 11.5
to receiving records following script 3712932 .9
for PA related
Expense PO data colection script
transactions. bug7392052.txt
Some Return to
Receiving transactions
were accounted in a
Return to Vendor or
another Return to
Receiving transaction
Cost History shown none 1. Provide the output none 11.5
Negative Onhand showing any back dated .9
Quantity . transactions
from Note 291005.1 To
Negative quantity verify if there have been
appearing on the Item back dated transactions,
Cost History due to the script can be run to
MMT-MOQ mismatch check the type of
and MMT-CQL transaction the dates
mismatch and the periods affected.

2. Check if there is MMT-

MOQ mismatch
(Inventory issue)
from Note 291005.1. Log
a bug against Inventory
team so that MMT-MOQ
qty mismatch can be
fixed.

3. Run the following

data script
 mmt_cql_info_new_11i9.
sql
Period Closed- none none Apply Patch 11.5
Summarized Reversal. 7036602 .10.
Script needed to 2
undo/ Reopen Period
Close.
WIP VALUE REPORT, none Provide output of the Apply Patch 12.0
old Repetitive following script 3621298 .2
Schedule is showing
Ending Balance. Data collection
Even after the Bug7554940.txt
accounting period is
closed, there are
some repetitive
schedules records
which aren't balanced
in WPB, and that
makes them to have
an ending balance
causing that this value
is reflected as the
ending balance in the
WIP Value Report.

Component: Period
Close
EU02 Error while EU02 Run and upload the Apply Patch 11.5
running the JOURNAL following in Excel file 7127049 .10.
IMPORT from format with headings: 2
Inventory. The error
comes due to the fact select *
that user doesn't use from
the encumbrance mtl_transaction_account
functionality for s
requisitions but the where
MTA was being accounting_line_type =
created for 15
encumbrance reversal and
with encumbrance encumbrance_type_id is
type id as null due to null
and gl_batch_id =
which transfer to GL &affected_glbatchid
was treating it as and
Actual and thus the transaction_source_type
error was EU02. _id in (7,8)
and not exists ( select 'x'
from
FINANCIALS_SYSTEM_P
ARAMS_ALL
where set_of_books_id
= &sob_id and org_id =
&operating_unit_id
and
nvl(req_encumbrance_fl
ag,'N') = 'Y' )
NEED TO CLOSE none none Submit the 11.5
MONTH IN COST pending .10.
MANAGEMENT transaction 2
The reason was that s for
the costing
transaction_group_id through
was populated for the forms.
transactions. This can
happen if the cost Review
worker was cancelled. Note
Cost workers are 748704. 1
system generated
programs and should
never be cancelled.
There was another
problem that the misc
receipt transaction
had null
distribution_account_i
d which was there
because of an
unknown inventory
bug.
Inventory Accounting none Run and upload the Apply Patch 11.5
Period is combining following in Excel file 5257946 .10.
Data from Different format with headings: 2
CALENDERS
The Open Period a. SELECT
control program can organization_id,
cause a corruption in operating_unit,
org_acct_periods that legal_entity,
will pull data from set_of_books_id
different calendars in FROM
particular this cst_organization_definiti
customer was having ons;
transactions with
wrong calendar b. SELECT
set_of_books_id,
PERIOD_SET_NAME,
creation_date,
last_update_date
FROM gl_sets_of_books;

c. SELECT *
FROM org_acct_periods
WHERE organization_id
= &org_id;

d. SELECT *
FROM gl_periods

Check if the organization

has correct period
Pending/ Uncosted ERROR_CODE: 1. Run 1. 11.5
Transactions error CST_INVALID_WIP wip_cst_invalid_wip.sql. Following .10
due to non existence ERROR_EXPLANATI This will create an Root-cause
of ON: The wip entity output called patches R12
wip_period_balances. is either not defined wip_cst_invalid_wip.lst should be
or does not have a applied:
period balance entry a. If you see output for
SQL # 1, log bug against R:11.5.10
CST with the output. 4209052
b. If you see output for 4322200
SQL # 2 and 3, please 4771899
follow the instructions 5187652
mentioned in Bug
5860661. R12:
c. If you see output for Apply <<
SQL # 4 and 5, log bug Patch
against WIP 8344919>>
with the output To update
d. If you see output for file version
SQL # 6, log bug against INVTTGPM.
WIP with the output fmb
e. If the query did not 120.19.120
return any rows for the 00000.7 or
SQLs mentioned in higher
wip_cst_invalid_wip.sql,
please follow steps 2. If
mentioned in "Missing wip_period
records in wip period _balances
balances" section. does not
have data
f. If there are records in for the
WIP_FLOW_SCHEDULES combinatio
, whose WIP_ENTITY_ID n of
are missing in organizatio
WIP_ENTITIES, then log n_id,
bug against WIP with acct_period
the output. _id and
The root cause of this Transaction
issue is disabling the _source_id
standard WIP triggers on (wip_entity
table _id)
WIP_FLOW_SCHEDULES existing in
. Use the following query mtl_materia
to check the status of l_transactio
the triggers: ns
SELECT status FROM customer
all_triggers WHERE can get the
table_name LIKE records
'WIP_FLOW_SCHEDULE inserted
S'; into
If the triggers are wip_period
disabled, enable them to _balances
prevent further data using the
corruption. script
mentioned
2.Provide output from in the
Note 362826.1 Oracle following
Work in Process Note
CST_INVALID_WIP Error 1080033.6
Data Collection Test to create
the missing
c. Run the following to WPB
determine whether there records.
is a row in Run the
wip_period_balances for script
this job / accounting cm276916.
period combination: sql out of
Note
select * 1080033.6
from if this error
wip_period_balances is for
where wip_entity_id = discrete
&wip_id jobs.
and acct_period_id = Otherwise
&period_id run the
and organization_id= script
&org_id; cm325424.
sql if the
d.Also can run errors are
wip_missing_wpb.sql to for
see how many jobs have repetitive
missing schedules.
records in Then
wip_period_balances resubmit
table. the
transaction
e. Provide job.sql output s through
( Note 378348.1 ) for forms.
the following jobs:
wip_entity_id=& 3.After
( TRANSACTION_SOURC Patch
E_ID in MMT table) application
for the error transaction and data
fix, please
resubmit
through
application
itself.
Costs ->
View
Transaction
s ->
Material
Transaction
s.
From the
menu,
Tools Select
All: Tools
Submit All

Else, can
use the
following
script to
submit the
records in
MMT table:

update
mtl_materia
l_transactio
ns
set
costed_flag
= 'N',
error_code
= NULL,
error_expla
nation =
NULL,
transaction
_group_id
= NULL,
transaction
_set_id =
NULL
where
organizatio
n_id =
&org_id
and
TRANSACTI
ON_ID=
&err_txn_id
and
costed_flag
='E';

commit;
TRANSFER none Run and upload the Apply Patch 11.5
TRANSACTIONS TO following in Excel file 7026054 .10.
GL - COMPLETED with format with headings: to update 2
ERROR file to latest
The Gl batch_id in SELECT * version
org_gl_batches gets FROM org_gl_batches CSTVWORB
stamped with -1* ogb .pls
gl_batch_id if the where ogb.gl_batch_id 115.4.1151
transfer errs out. Now < 0 and exists 00.7 or
the problem here is ( select 'x' from higher
that when the funds mtl_transaction_account
checker errs out it s mta
commits the data into where mta.gl_batch_id
gl_interface and data = -1 * ogb.gl_batch_id
in MTA and WTA and mta.organization_id
( updation of = ogb.organization_id
gl_batch_id). So we union all select 'x' from
will have gl_batch_id wip_transaction_account
as "XX" in MTA and s wta where
WTA wta.gl_batch_id = -1 *
while "-XX" in ogb.gl_batch_id and
org_gl_batches. wta.organization_id =
ogb.organization_id )

Component: WIP
RESOURCE none Provide output of the none 12.0
TRANSACTIONS are following script .4
not always updating
Costs on the WORK Data collection
ORDER. Bug7447898.txt

Due to incorrect
maintenance cost
category setup cost
Labor transactions are
not being recorded on
EAM work orders
tables i,e
wip_eam_period_bala
nces and
cst_eam_asset_per_b
alances
User would see
difference in wip value
report and EAM value.
RESOURCE none Run and upload the Apply Patch 11.5
transactions Pending following in Excel file 3309813 .10.
in format with headings: 2
WIP_COST_TXN_INTE
RFACE table. SELECT Count(*)
FROM
Transactions in WCTI wip_cost_txn_interface
which is getting wcti
orphaned is due to WHERE wcti.entity_type
the launching of = 4 AND exists ( select
resource cost worker 'x' from
when there is a mtl_material_transaction
running cost s mmt2 where
update,due to this for mmt2.completion_transa
the stuck records in ction_id =
WCTI all the wcti.completion_transact
associated completed ion_id and
transactions are mmt2.transaction_sourc
costed. e_type_id =5 and
mmt2.transaction_action
_id in (31,32) and
mmt2.costed_flag IS null
)
WIP_PERIOD_BALAN none Run and upload the Apply Patch 11.5
CES Created for all following in Excel file 5600760 .10.
Open Period by format with headings: 2
WOLC.
select *
Wip_period_balances from
records existed for wip_period_balances b
flow schedules for all where b.organization_id
open future periods = &org_id and exists
even if they were (select 1 from
beyond the closing wip_entities
date of the flow e,org_acct_periods o
schedule. where e.wip_entity_id =
b.wip_entity_id and
o.organization_id =
e.organization_id and
o.acct_period_id =
 b.acct_period_id and
o.period_start_date >
SYSDATE and
e.entity_type = 4) order
by wip_entity_id,
acct_period_id desc
Unable to Save Move none Run and upload the none 11.5
Transactions following in Excel file .10.
Customer had a few format with headings: 2
items which didn't
have costs defined SELECT
even though they msi.inventory_item_id,m
were costing enabled p.organization_id,mp.org
items.This seems to anization_code
be a PLM bug. FROM
inv.mtl_system_items_b
msi,inv.mtl_parameters
mp
WHERE NOT EXISTS
( SELECT 'X' FROM
bom.cst_item_costs cic
WHERE
cic.inventory_item_id =
msi.inventory_item_id
AND cic.organization_id
=
mp.cost_organization_id
AND cic.cost_type_id =
mp.primary_cost_metho
d) AND
msi.costing_enabled_fla
g = 'Y' and
msi.organization_id =
mp.organization_id;

Component:
COST_ERROR
Margin Analysis Load ORA-20001: none Apply Patch 12.0
Run error with CSTPMRGL.load_om 7215820 .4
CSTPMRGL.LOAD_OM _margin_data(160):
_MARGIN_DATA(160) ORA-01403
ORA-12899
Cannot Calculate none none Patch 12.0
Average Resource & 6908025 .3
Overhead Costs
resulting in WIP
VARIANCE.

No errors job
completion cost
incorrect
CST_MATCH_DATE_P Error Cosde: Run and upload the 11.5
ERIOD error, pending CST_MATCH_DATE_ following in Excel file .10.
Cost Transactions PERIOD format with headings: Data Fix 2
Error explanation: ----------
The transaction date SELECT Run the
is not within the oap.acct_period_id following
accounting period oap_acct_period_id, update to
specified." mmt.acct_period_i d correct the
mmt_acct_period_id, acct_period
COGS recognition mmt.transaction_id _id:
Errors.Refer Note mmt_transaction_id,
733275.1 oap.period_start_date Update
period_start_date, mtl_materia
mmt.transaction_date l_transactio
mmt_transaction_date ns
FROM set
mtl_material_transaction acct_period
s mmt, _id =
org_acct_periods oap ,
WHERE mmt.costed_flag costed_flag
= 'E' = 'N'
AND ,
mmt.transaction_source transaction
_type_id = 2 _group_id
AND = NULL
mmt.transaction_action_ ,
id = 36 transaction
AND _set_id =
mmt.organization_id = NULL
oap.organization_id ,
AND oap.acct_period_id error_code
= mmt.acct_period_id = NULL
AND ,
( mmt.transaction_date error_expla
< oap.period_start_date nation =
OR NULL
mmt.transaction_date > where
oap.schedule_close_date costed_flag
+.99999); = 'E'
and
acct_period
_id =
and
error_code
=
'CST_MATC
H_DATE_PE
RIOD'
and
organizatio
n_id = ''

Root
Cause:
--------------
11i:
Patch
4447285 to
obtain
CSTPACQB.
pls
115.35.115
100.5
Periodic
Cost
Update

Patch.4870
805
CSTFEPCU.f
mb in
version
115.18.115
100.3
Periodic
Cost
Update
 Patch.5398
466 wms
patch/115/s
ql
WMSTKPTB
.pls
115.141.11
5100.25

Patch
4992305
CSTVCPVB.
pls version
115.0.1151
00.7

R12:
Apply Patch
6873037
FAILURE IN Failure in procedure none Apply Patch 12.0
PROCEDURE CST_RevenueCogsM 8685863 .6
CST_REVENUECOGSM atch_PVT.Insert_On or Higher
ATCH_PVT.INSERT_O eSoIssue() to update
NESOISSUE() Unexpected error in file
CST_RevenueCogsM CSTRCMVB.
atch_PVT . pls to
Insert_OneSoIssue ( version
40 ) 120.37.120
The transaction date 00000.25
is not within the
accounting period The
specified. following
pre-req
patch
needs to be
applied
first: Patch
8510248
DEADLOCK IN COST none none Apply Patch 12.0
WORKER (CMCMCW). 6709905 .4
The update to WPB
for repetitive schedule
does not lock the
rows first causing that
other workers may try
to pick the rows and
may go into deadlock.
Periodic Absorption No entries found for none Please log 11.5
Cost Processor 'RUN list values an SR with .10.
OPTIONS' error NO support to 2
LOV NO ENTRIES re-set the
FOUND process
status as
'unprocesse
d' for
problematic
period
ACTUAL COST ORA-01455: Run and upload the Make sure R12.
WORKER CMLACW converting column following in Excel file you have X
FAILED DUE TO ORA- overflows integer format with headings: the latest
01455: CONVERTING data type code for
COLUMN OVERFLOWS select * the
INTEGER DATATYPE from following
mtl_material_transaction files:
s
where costed_flag = 'E'; inltcp.lpc
cmlacw.lpc
cmlmcw.lpc
cmllcw.lpc

For R12.x
Apply Patch
10435651:
R12.BOM.A.
or higher

For R12.1.1
Apply Patch
Patch
10416679:
R12.BOM.C
or higher
CSTPACDP.INV_COST CSTPACIN.COST_IN none Apply Patch 12.1
_TXN (45): ORA- V_TXN:CSTPACDP.in 7384398 .1
01086: SAVEPOIN v_cost_txn (45):
ORA-01086:
This is because of the savepoint
spell mistake in the 'INSERT_ONESOISS
code. save point. UES_PVT' never
Changed 'ROLLBACK established
TO ORA-06512: at
Insert_OneSoIssues_P ""APPS.CST_REVEN
VT' to 'ROLLBACK TO UECOGSMATCH_PV
Insert_OneSoIssue_P T"", line 2338
VT' in ORA-06510:
Insert_OneSoIssue PL/SQL: unhandled
procedure user-defined
exception
CSTPLCIR.COMPONEN CSTPLCIR.compone Run and upload the Apply Patch 11.5
T_ISSUE():30:INVENT nt_issue():30:Invent following in Excel file 7282633 .10.
ORY TOTAL TXN QTY ory total txn qty was format with headings: 2
WAS 0; EXPECTED -1 0; expected
Distributiobs for SELECT *
cst_inv_layer_cost_de or error: FROM CST_INV_LAYERS
tails Is not created CIL
whenever layer CSTPLCIN.COST_IN WHERE NOT EXISTS
quantity is zero in V_TXN:CSTPLENG.cr (SELECT 1
cst_inv_layers eate_layers FROM
There were couple of (130)::ORA-01407 CST_INV_LAYER_COST_
records in cannot update DETAILS CILCD
CST_INV_LAYERS (""BOM"".""CST_INV WHERE
which didn't have _LAYERS"".""LAYER CILCD.INV_LAYER_ID
data in _COST"") to NULL =CIL.INV_LAYER_ID);
CST_INV_LAYER_COS
T_DETAILS
or getting error:

CSTPLCIN.COST_INV_
TXN:CSTPLENG.CREA
TE_LAYERS (130):
ORA-1407 CANNOT
UPDATE ("BOM
Lines from Inventory No Error drill down Run the following to Apply Patch 11.5
View from GL is incorrect identify the incorrect 7264369 .10.
XLA_INV_AEL_GL_V transaction: 2
XLAIQDRL select * from
from
mtl_transaction_account
s mta,gl_je_lines jel
where mta.gl_batch_id
= jel.reference_1
and
mta.reference_account
=
jel.code_combination_id
and mta.transaction_id
= NVL(jel.reference_3,
mta.transaction_id)
and
NVL(mta.gl_sl_link_id,-
1)
= NVL(jel.gl_sl_link_id,
NVL(mta.gl_sl_link_id,-
1))
having
SUM(base_transaction_v
alue) = 0"
After RMA Receipt Failure in procedure Run and upload the Apply Patch 12.0
transaction showing CST_RevenueCogsM following in Excel file <="" .4 to
Costing Error in MMT atch_PVT.Process_R format with headings: a=""> 12.x
table maReceipt()
SELECT * FROM to update
or error cst_cogs_events file
CSTPACIN.COST_IN WHERE cogs_om_line_id RCVCOTRX.
V_TXN:UNEXPECTE = &om_line_id; pld
D ERROR IN 120.53.120
CST_REVENUECOGS SELECT * FROM 10000.9 or
MATCH_PVT.INSERT mtl_material_transaction higher
_ONES s
WHERE and Patch
(trx_source_line_id = 7015709 or
&source_line_idOR higher to
transaction_id = update file
&txn_id); CSTRCMVB.
pls
SELECT * FROM 120.37.120
oe_order_lines_all 00000.11
WHERE line_id =
&line_id;
 SELECT * FROM
cst_revenue_cogs_matc
h_lines
WHERE cogs_om_line_id
= &om_line_id;
Cost Manager is CST_MATCH_DATE_ Run and upload the Apply Patch 12.1
Unable to Cost PERIOD following in Excel file 6873037
Transactions, ends in format with headings: or higher to
error update file
SELECT CSTRCMVB.
CST_MATCH_DATE_P oap.acct_period_id pls
ERIOD oap_acct_period_id,
mmt.acct_period_i d
mmt_acct_period_id,
mmt.transaction_id
mmt_transaction_id,
oap.period_start_date
period_start_date,
mmt.transaction_date
mmt_transaction_date
FROM
mtl_material_transaction
s mmt,
org_acct_periods oap
WHERE mmt.costed_flag
= 'E'
AND
mmt.transaction_source
_type_id = 2
AND
mmt.transaction_action_
id = 36
AND
mmt.organization_id =
oap.organization_id
AND oap.acct_period_id
= mmt.acct_period_id
AND
( mmt.transaction_date
< oap.period_start_date
OR
mmt.transaction_date >
 oap.schedule_close_date
+.99999);
INV_EVENT_3S INV_EVENT_3S none Please log 11.5
Generates Unbalanced an SR with .10.
Entries support 2

MCACD not created,

missing cost details in
CICD
MMT error with CST_INVALID_WIP Run the following script none 11.5
CST_INVALID_WIP and identify the .10.
with missing records reason.Based on this 2
in should transfer the bug
WIP_FLOW_SCHEDUL to respective team if
E. data fix for the issue is
not provided in this link
This error can occur in
following cases: wip_cst_invalid_wip.sql

1.MISSING records in
WIP_FLOW_SCHEDUL
E.
2.Missing records in
WIP_PERIOD_BALAN
CES
(These two errors
should be handled by
wip team)
AN INVALID An invalid account is 1.Make sure to set the none 12.0
ACCOUNT IS associated with the following profile options .4
ASSOCIATED WITH item being MRP:debug Mode option
THE ITEM BEING transacted. set to yes
TRANSACTED MRP: Trace Mode set to
yes
CST:Cost update debug
level = Full

2.Resubmit the error

transactions for costing.
Uncosted/failed
transactions can be
resubmitted through
 application itself.
Costs -> View
Transactions -> Material
Transactions.
From the menu, Tools
Select All: Tools Submit
All

Else, can use the

following script to
submit the records in
MMT table:

update
mtl_material_transaction
s
set costed_flag = 'N',
error_code = NULL,
error_explanation =
NULL,
transaction_group_id =
NULL,
transaction_set_id =
NULL
where organization_id =
&organization_id
and costed_flag in
('N','E');

commit;

3.Obtain the log file of

the Cost Worker.
CSTPACIN.COST_INV cstpacin.cost_inv_tx 1.Set MRP DEBUG Data 12.0
_TXN: an Invalid n:an invalid account 2.Resubmit the error issue(Root .4
Account is Associated is associated with transactions for costing. cause
with the Item. the item 3.Obtain the log file of should be
PAC distribution identified
A miscellaneous processor. by
transaction was Inventory
erroring out with error Team)
due to missing
distribution_account_i
d information
Error in Obtaining the Error in Obtaining 11i: Apply 11i
Transfer Price the Transfer Price Patch.9302 &
Internal Requisition 594 R12
Intransit Receipt inltcp.lpc
transaction 115.120.11
5100.52 or
higher

R12: apply
Patch<>
inltcp.lpc
120.35.120
10000.13
or higher
Material or CMCACW - Error Code = No This query will list all the 11i: Please 11i
Actual Cost Worker Error in transaction Ids for the review &
completes with CSTPSISC.ins_std_c transactions from Note: R12
Error ost MMT(MTL_MATERIAL_T 284700.1 ,
Error explanation = RANSACTION) Note
CSTPSISC.INS_STD table which are also 290868.1
_COST (40): ORA- having entries in the
00001: unique accounting tables. R12 Patch
constraint 10634679:
(INV.MTL_CST_ACT Select R12.BOM.A
UAL_COST_DETAILS MMT1.transaction_id,MM
_U1) violated T1.costed_flag, R12.1
MMT1.error_code,MMT1. Patch
error_explanation 10416679:
from R12.BOM.C
MTL_MATERIAL_TRANS
ACTIONS MMT1 where
MMT1.transaction_id in (
SELECT
MMT.TRANSACTION_ID
FROM
MTL_MATERIAL_TRANS
ACTIONS MMT WHERE
MMT.costed_flag in
('N' ,'E')
AND (EXISTS(SELECT 1
FROM
MTL_TRANSACTION_AC
 COUNTS MTA
WHERE
MMT.transaction_id=MT
A.transaction_id) OR
EXISTS (SELECT 1 FROM
MTL_CST_ACTUAL_COS
T_DETAILs MCACD
WHERE
MCACD.transaction_id=
MMT.transaction_id)))
Component:
Reports
Journal Entries Report P_SECURITY_ID_IN none Please log 12.0
- Cost Management T_1 an SR with .5
error support
P_SECURITY_ID_INT_
1
the function "Change
inventory
Organization" was not
assigned to the
responsibility.
POXRRCVV Receiving ORA-01476: divisor Run and upload the Apply Patch 11.5
Value Report is equal to zero following in Excel file 6790176 .10.
completes with error format with headings: to update 2
ORA-01476: divisor is file
equal to zero SELECT RCVVRUTB.
RAE2.rcv_transaction_id pls or
FROM higher
rcv_accounting_events
RAE2
WHERE
RAE2.transaction_quanti
ty=0
OR
RAE2.primary_quantity=
0
OR
RAE2.source_doc_quanti
ty=0);
ORGANIZATIONS MSG-00999: Run and upload the none 11.5
CLOSED BUT NOT CSTRPCRE >X Mon following in Excel file .10.
SUMMARIZED - Sep 1 14:56:29 format with headings: 2
PERIOD CLOSE 2008
RECONCILIATION REP-0771: After SELECT
Due to incorrect Form trigger failed. MAX(acct_period_id)
sequence of INTO l_prior_period_id
acct_period_id,Period FROM org_acct_periods
close Reconciliation WHERE organization_id
Process Failed. = p_org_id
AND acct_period_id <
p_period_id;
then log a data fix bug
with development
All Inventories Value none Run the following: none 11.5
Report - Average .9
Costing QTY mmt_cql_info_new_11i9.
mismatch with sql
Transaction Value
report
MMT-CQL mismatch
Uninvoiced Receipts An invalid character none none 12.0
Report - CSTACREP was found in text .2
err no output content
AP AND PO ACCRUAL none Run and upload the Patch 12.0
RECONCILIATION following in Excel file 7528609 .5
REPORT DOESN'T format with headings:
SHOW NET
DISTRIBUTIONS select * from
xla_distribution_links xdl

where
xdl.source_distribution_t
ype
='RCV_RECEIVING_SUB
_LEDGER'
AND xdl.application_id
=707
AND
xdl.source_distribution_i
d_num_1 IS NULL;
Component: SLA
NO ACCTG EVENTS none none Patch 12.0
CREATED FOR INT 6792259 .4
REQ DIRECT ORG
XFER AT RECEIV

In Oracle Cost
Management,Accounti
ng events in SLA may
not be created for
internal requisition
direct interorg
transfer at the
receiving organization
if both the sending
and receiving
organization are
standard costing
organization.
Some SLA data for none Run and upload the Patch 12.0
MTL_TRANSACTION_ following in Excel file 6922624 .4
ACCOUNT are created format with headings:
by 12.0.4 upgrade
Patch Select
a.TRANSACTION_SOURC
During upgrade of the E_TYPE_ID,
MTA the transaction count(a.TRANSACTION_
user defined ID)
transaction types for from
action 1 and 27 are mtl_transaction_account
not considered for sa
upgrade. where not exists (
The internal req select 'X'
receipt in case of from
Actual costing xla.XLA_TRANSACTION_
organization is also ENTITIES b
not being considered. where
The internal req a.TRANSACTION_ID =
receipt in case of b.source_id_int_1)
Standard costing group by
organization is a.TRANSACTION_SOURC
also not being E_TYPE_ID ;
considered.
PLEASE EXTRACT THE none none Patch 12.0
SLA OBJECTS 7033488 .4
Receipt Accruals -
Period-End process
errored out with "SLA
errors" when
processing both 11i
Upgraded and R12
POs at the same time.

COSTING EVENT
CLASS SEED
CHANGES FOR
PERIOD END
ACCRUAL
PERIOD CLOSE: none To find the list of Patch 12.0
ENCOUNTERED accounting event 6916164 .4
UNPROCESSED WIP corresponding to MMT
VARIANCE/JOB CLOSE and WT transactions
VAR EVENTS with distributions, run
Some WIP and INV and upload the following
accounting events are in Excel file format with
not accountable headings:
because the
distributions are not SELECT a.event_id
created. ,b.event_type_code
There are SLA events FROM xla_events a,
created even if those xla_event_types_b b,
transactions are not xla_transaction_entities_
suppose to be upg c
accounted since they WHERE a.event_date
don't have <=
distributions TO_DATE('&problem_pe
riod','DD-MM-YYYY')
AND a.application_id =
707 AND
a.event_status_code =
'U'
AND
a.process_status_code =
'U' AND b.application_id
= 707
AND b.entity_code IN
('MTL_ACCOUNTING_EV
 ENTS','WIP_ACCOUNTIN
G_EVENTS')
AND b.event_type_code
= a.event_type_code
AND c.application_id =
707
AND c.entity_id =
a.entity_id
AND ( ( b.entity_code =
'MTL_ACCOUNTING_EVE
NTS'
AND NOT EXISTS
(SELECT NULL
FROM
mtl_transaction_account
s
WHERE transaction_id =
c.source_id_int_1))
OR ( b.entity_code =
'WIP_ACCOUNTING_EVE
NTS'
AND NOT EXISTS
(SELECT NULL
FROM
wip_transaction_account
s
WHERE transaction_id =
c.source_id_int_1)));
R12 SLA Subledger none Run and upload the Patch 12.0
Period Close following in Excel file 7505874 .4
Exception format with headings:
Report is showing
transactions as Select
Unprocessed. sum(mmt.quantity_adjus
Standard cost update ted*mmt.transaction_co
is not accounting for st),
intransit items but the mmt.intransit_account,
accounting events are mp.organization_code,
created. ccu.inv_adjustment_acc
ount
from
mtl_material_transaction
s mmt, mtl_parameters
mp,
 cst_cost_updates ccu
where
mmt.organization_id =
mp.organization_id
and
mmt.transaction_action_
id = 24 and
mmt.intransit_account is
not null
and mmt.costed_flag is
null and
mmt.quantity_adjusted
>0
and
mmt.transaction_cost
<> 0
and
mmt.transaction_date
between &&from_date
and &&to_date
and
(nvl(mmt.new_cost,0) -
nvl(mmt.prior_cost,0))
<> 0
and
ccu.cost_update_id(+) =
mmt.cost_update_id
and not exists (select
null from
mtl_transaction_account
s mta where
mta.transaction_id =
mmt.transaction_id)
group by
mmt.intransit_account,
mp.organization_code,
ccu.inv_adjustment_acc
ount order by
organization_code
CREATE Error number= Run and upload the none 12.0
ACCOUNTING ERR 95318 following in Excel file .4
95318 CODE The account code format with headings:
COMBINATION ID combination id 102
Select distinct
SPECIFIED FOR LINE specified for line 1 transaction_id
DOESN'T EXIST does not exist. from
mtl_transaction_account
s
where
reference_account=&pri
or_wrong_account_id;
COGS RECOGNITION none Run and upload the Apply Patch 12.0
EVENT is unprocessed following in Excel file 7690716 .4
for some SALES format with headings:
ORDER ISSUE lines
1.SELECT * FROM
XLA_EVENTS
WHERE
EVENT_STATUS_CODE=
'P'
and application_id =
707;

2.select * from
CST_REVENUE_RECOGN
ITION_LINES where
revenue_om_line_id
=&line_id

3. select * from
cst_cogs_events where
cogs_om_line_id
=&line_id;

4. select * from
cst_revenue_cogs_matc
h_lines where
cogs_om_line_id
=&line_id;

Component:
Inventory
JOURNAL IMPORT EU02 The following script is Apply Patch 11.5
ERROR EU02 SOURCE executed for a particular 4998992 .10.
INVENTORY batch_id will spool 2
 the data of
Data was missing in Inventory/WIP
GL Interface table. subledgers GL Interface
GL journals required
Inserted data in for reconciliation of data
gl_interface table between Sub-ledgers
and GL

Input required :
GL_BATCH_ID

GL_Batch_info.sql
ERROR IN THE none The following script none 11.5
PERIOD CLOSING, spools the PAC setup .9
DUE TO information to
INACTIVATED a file pac_setup.lst.
ORGANIZATIONS. Script should be run
from sql prompt.
User created
unwanted pac_setup.sql
organization,
unwanted cost group
and keep running PAC
processes for many
PAC periods
COGS CANNOT BE none none Bug 12.0
RECOGNIZED IF SO 7211401 .4
(NON AR) IS CLOSED
ON LAST DAY OF THE
MONTH

Revenue recognition
lines were not created
when a sales order
was closed on the last
day of a month. This
was because the
costing api was
comparing the event
date with time stamp
to the truncated gl
end date.
COGS not recognized
for ship only OM sales
orders on the last day
of the accounting
period when the OM
lines are closed
XLAIQDRL DRILL none none Bug 11.5
DOWN FORM GL TO 4751586 .10.
INVENTORY RETURNS 2
MORE THAN ONE
LINE

The
GL_IMPORT_REFERE
NCES had duplicate
lines, which made the
drill down data also
duplicated
RVTPTCONTROL RVTPTCONTROL Run and upload the none 12.0
FAILED RVTII-060: FAILED RVTII-060: following in Excel file .4
SUBROUTINE SUBROUTINE format with headings:
INV_TXN_MANAGER_ INV_TXN_MANAGER
PUB.PROCESS_TRANS _PUB.PROCESS_TRA Select
ACTIO NSACTIO MS.inventory_item_id,
MS.organization_id
Receiving processor is from
erroring out because mtl_system_items_b MS
its trying to retrieve where
records from MS.inventory_asset_flag
CST_ITEM_COSTS for ='Y'
the cost type id 2 and
(Average) and it MS.costing_enabled_flag
doesn't exist for this = 'Y'
items and NOT exists (
select
cic.inventory_item_id
from cst_item_costs cic,
mtl_parameters mp
where
cic.inventory_item_id =
ms.inventory_item_id
and ms.organization_id
= mp.organization_id
and cic.organization_id
 =
mp.cost_organization_id
and cic.cost_type_id=
mp.primary_cost_metho
d);
UNCOSTED error_code = Run and upload the none 11.5
TRANSACTIONS IN CST_NO_TXN_INVA following in Excel file .10.
MMT 2 OF THEM IN LID_ACCOUNT format with headings: 2
ERROR
The following SQL
error_code = identified the invalid /
CST_NO_TXN_INVALI incorrect data:
D_ACCOUNT select *
error_explanation = from
'CSTPACIN.COST_INV MTL_MATERILA_TRANS
_TXN:An invalid ACTIONS
account is associated where Costed_Flag =
with the item being "E";
transacted

Error due to expense

account not being
defined for the
subinv/item/org.
Define the accounts
and resubmit the
transactions.

Component:
Accrual
Some of the none Run and upload the Root Cause 12.0
RECEIPTS system is following in Excel file Bug with .3
creating double format with PSA: Bug
ACCOUNTING in headings.Run the 7714739
DELIVERY status following script to
In the case of PO identify the problem:
delivery to expense
with budgetary SELECT SUM (NVL
control enabled, (accounted_dr, 0) - NVL
Encumbrance reversal (accounted_cr, 0)),
happens against accounting_class_code,
actual instead of code_combination_id
encumbrance causing FROM xla_ae_lines
Double entry against WHERE application_id =
Actual. 707
AND ae_header_id IN (
SELECT ae_header_id
FROM xla_ae_headers
WHERE application_id =
707
AND event_id IN (
SELECT event_id
FROM xla_events
WHERE application_id =
707
AND
budgetary_control_flag
= 'Y'
AND
process_status_code =
'P')
AND
gl_transfer_status_code
= 'Y'
AND balance_type_code
= 'A')
GROUP BY
accounting_class_code,
code_combination_id
CREATE Error Number = Using this SQL, user will None. 3 12.0
ACCOUNTING errored 95311 be able to identify the bugs .4
out for PERIOD END RRSL created for the logged for
ACCRUAL EVENT The COMPANY 'PERIOD_END_ACCRUAL' the same
segment value for for the issue
Create Accounting the account code PO_DISTRIBUTION_ID
Receiving program combination is not with the wrong CCID
fails for transaction assigned to the The issue can be
when incorrect ledger. identified using the
account combination following query :
used for the charge
account for Expense Select rrsl.*
POs. Error : The from
Company segment rcv_receiving_sub_ledge
value for the account r rrsl,
code combination. rcv_accounting_events
This is due to rae
Incorrect Account Id where
used in RRSL and rrsl.rcv_transaction_id =
hence erroring out 0
when transferred to and
GL. rrsl.accounting_event_id
=
An invalid charge rae.accounting_event_id
account and variance and rae.event_source =
account was stamped 'PERIOD_END_ACCRUAL'
on PO distributions and rae.event_type_id =
that caused the period 14
end accrual events to and
fail in SLA create rae.po_distribution_id =
accounting program. &PO_DIST_ID
and
rrsl.accounting_line_type
= 'Charge';
No RECEIVING none Run and upload the None. 11.5
ACCOUNTING records following in Excel file Similar .10.
on RETURN TO format with headings: Datafix in 2
SUPPLIER transaction Bug
SELECT 6742514
Receiving Txn T1.TRANSACTION_ID,T1
Processor ended with .PO_HEADER_ID
error due to FROM
compilation issue of RCV_TRANSACTIONS T1
Pkg
RCV_AccEvents_PVT WHERE
which was Invalid (TRANSACTION_TYPE
after applying Patch IN ('RECEIVE', 'RETURN
4443747 . However, TO VENDOR')
data on the Receiving OR
side (RT) got (TRANSACTION_TYPE=
committed. 'DELIVER' AND
DESTINATION_TYPE_CO
DE='EXPENSE'))
AND EXISTS
(SELECT 'Accrue_Rcpt
and Non-Consigned'
FROM
PO_LINE_LOCATIONS_A
LL poll, po_headers_all
 poh
WHERE
poll.po_header_id =
poh.po_header_id
AND
poll.ACCRUE_ON_RECEI
PT_FLAG='Y'
AND
POLL.LINE_LOCATION_I
D
=T1.PO_LINE_LOCATIO
N_ID and
NVL(poh.consigned_cons
umption_flag, 'N') = 'N')
AND NVL(COMMENTS,'!')
NOT IN ('OPM
RECEIPT','OPM Receipt
Correction')
AND NOT EXISTS
(SELECT 1
FROM
RCV_RECEIVING_SUB_L
EDGER T2
WHERE
T2.RCV_TRANSACTION_
ID=T1.TRANSACTION_I
D);
Accounts Payable and none Please 12.0
PO Reconciliation apply Patch .5
Summary report 8367493:R
mismatch 12.BOM.A
Also
Incomplete Receiving
Data Migration to SLA

Receiving data (Pre-

Upgrade) did not get
migrated to XLA and
hence is missing in
XLA. Because of this,
unable to reconcile
accruals as the AP
and PO Reconciliation
Summary Report
shows large number
of invoices matched
to PO's as open AP
Balances. In other
words, all records in
the accrual
reconciliation table
(cst_reconciliation_su
mmary) have a zero
value for the
po_balance column.