BUG:573272<\/a> for more information on this topic):<\/p>\n* Item costs are not defined for Frozen cost type in CST_ITEM_COSTS.
\n* WIP_PERIOD_BALANCES is missing rows for the acct_period_id.
\n* If a repetitive schedule, MTL_MATERIAL_TXN_ALLOCATIONS is missing rows
\nfor the corresponding transaction_id from MTL_MATERIAL_TRANSACTIONS.<\/p>\n
1. If you are running inltcp.opp 50.90 or lower, please apply patch for
\nBUG 559432 for version 50.91 (or INV patchset C or higher).<\/p>\n
2. Fixing missing rows in WIP_PERIOD_BALANCES for transactions that are
\nthe result of a DISCRETE JOB requires you to use the below cm276916.sql
\nscript. The rows are missing in WIP_PERIOD_BALANCES because status
\ntypes 14 (Pending Close) and 15 (Failed Close) were not included while
\ninserting rows for discrete jobs in this table.<\/p>\n
To determine if you need to insert records into WIP_PERIOD_BALANCES,
\nchange the INSERT statement to a SELECT. If more than zero rows are
\nreturned, then re-run the script with INSERT and resubmit the
\nrecords in MTL_MATERIAL_TRANSACTIONS.<\/p>\n
NOTE: THIS DOES NOT APPLY TO CLOSED DISCRETE JOBS WDJ.STATUS_TYPE = 12)<\/p>\n
====================================================================
\n| Run the sql script cm276916.sql to create missing balances in |
\n| the wip_period_balances table. Run this script as APPS user: |
\n| For example, from UNIX shell, type: |
\n| sqlplus <APPS username\/APPS password> @$BOM_TOP\/sql\/cm276916.sql |
\n====================================================================<\/p>\n
[sql]
\nINSERT INTO WIP_PERIOD_BALANCES
\n(ACCT_PERIOD_ID, WIP_ENTITY_ID,
\nREPETITIVE_SCHEDULE_ID, LAST_UPDATE_DATE,
\nLAST_UPDATED_BY, CREATION_DATE,
\nCREATED_BY, LAST_UPDATE_LOGIN,
\nORGANIZATION_ID, CLASS_TYPE,
\nTL_RESOURCE_IN, TL_OVERHEAD_IN,
\nTL_OUTSIDE_PROCESSING_IN, PL_MATERIAL_IN,
\nPL_MATERIAL_OVERHEAD_IN, PL_RESOURCE_IN,
\nPL_OVERHEAD_IN, PL_OUTSIDE_PROCESSING_IN,
\nTL_MATERIAL_OUT, TL_MATERIAL_OVERHEAD_OUT, TL_RESOURCE_OUT,
\nTL_OVERHEAD_OUT, TL_OUTSIDE_PROCESSING_OUT,
\nPL_MATERIAL_OUT, PL_MATERIAL_OVERHEAD_OUT,
\nPL_RESOURCE_OUT, PL_OVERHEAD_OUT,
\nPL_OUTSIDE_PROCESSING_OUT,
\nPL_MATERIAL_VAR, PL_MATERIAL_OVERHEAD_VAR,
\nPL_RESOURCE_VAR, PL_OUTSIDE_PROCESSING_VAR,
\nPL_OVERHEAD_VAR, TL_MATERIAL_VAR, TL_MATERIAL_OVERHEAD_VAR,
\nTL_RESOURCE_VAR, TL_OUTSIDE_PROCESSING_VAR,
\nTL_OVERHEAD_VAR)
\nSELECT
\nOAP.acct_period_id, WDJ.WIP_ENTITY_ID,
\nNULL, SYSDATE,
\n0, SYSDATE,
\n0, 0,
\nWDJ.ORGANIZATION_ID, WAC.CLASS_TYPE,
\n0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
\nFROM WIP_ACCOUNTING_CLASSES WAC,
\nORG_ACCT_PERIODS OAP,
\nWIP_DISCRETE_JOBS WDJ
\nWHERE WDJ.STATUS_TYPE IN (3, 4, 5, 6, 7, 14, 15)
\nAND WAC.CLASS_CODE = WDJ.CLASS_CODE
\nAND WDJ.ORGANIZATION_ID = WAC.ORGANIZATION_ID
\nAND OAP.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
\nAND OAP.OPEN_FLAG = ‘Y’
\nAND OAP.PERIOD_CLOSE_DATE IS NULL
\nAND OAP.SCHEDULE_CLOSE_DATE >= NVL(WDJ.DATE_RELEASED,WDJ.CREATION_DATE)
\nAND WAC.CLASS_TYPE != 2
\nAND NOT EXISTS
\n(
\n SELECT ‘X’ FROM WIP_PERIOD_BALANCES WPB
\n WHERE WPB.REPETITIVE_SCHEDULE_ID IS NULL
\n AND WPB.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
\n AND WPB.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
\n AND WPB.ACCT_PERIOD_ID = OAP.ACCT_PERIOD_ID);
\n [\/sql]<\/p>\n
3. For repetitive schedules, you may need to fix missing records in
\nWIP_PERIOD_BALANCES as well as in MTL_MATERIAL_TXN_ALLOCATIONS.<\/p>\n
A. To fix missing rows in WIP_PERIOD_BALANCES as a result of a
\ntransaction that was due to a REPETITIVE SCHEDULE, you
\nwill need to run the cm325424.sql script. It has been modified
\nto include status_type=5 so that rows are inserted for closed
\nschedules too.<\/p>\n
——————————————————————
\n| FILENAME |
\n| cm325424.sql |
\n| |
\n| DESCRIPTION |
\n| Bug fix 325424 |
\n| 1. Insert missing rows in wip_period_balances |
\n| |
\n| NOTES |
\n| Invoking Syntax: |
\n| sqlplus <APPS username>\/<APPS password> @cm325424.sql |
\n| HISTORY |
\n| 28 NOV 95 Rina Banerjee Creation |
\n+================================================================+<\/p>\n
[sql]INSERT INTO WIP_PERIOD_BALANCES
\n(ACCT_PERIOD_ID, WIP_ENTITY_ID,
\nREPETITIVE_SCHEDULE_ID, LAST_UPDATE_DATE,
\nLAST_UPDATED_BY, CREATION_DATE,
\nCREATED_BY, LAST_UPDATE_LOGIN,
\nORGANIZATION_ID, CLASS_TYPE,
\nTL_RESOURCE_IN, TL_OVERHEAD_IN,
\nTL_OUTSIDE_PROCESSING_IN, PL_MATERIAL_IN,
\nPL_MATERIAL_OVERHEAD_IN, PL_RESOURCE_IN,
\nPL_OVERHEAD_IN, PL_OUTSIDE_PROCESSING_IN,
\nTL_MATERIAL_OUT, TL_MATERIAL_OVERHEAD_OUT, TL_RESOURCE_OUT,
\nTL_OVERHEAD_OUT, TL_OUTSIDE_PROCESSING_OUT,
\nPL_MATERIAL_OUT, PL_MATERIAL_OVERHEAD_OUT,
\nPL_RESOURCE_OUT, PL_OVERHEAD_OUT,
\nPL_OUTSIDE_PROCESSING_OUT,
\nPL_MATERIAL_VAR, PL_MATERIAL_OVERHEAD_VAR,
\nPL_RESOURCE_VAR, PL_OUTSIDE_PROCESSING_VAR,
\nPL_OVERHEAD_VAR, TL_MATERIAL_VAR, TL_MATERIAL_OVERHEAD_VAR,
\nTL_RESOURCE_VAR, TL_OUTSIDE_PROCESSING_VAR,
\nTL_OVERHEAD_VAR)
\nSELECT
\nOAP.acct_period_id, WRS.WIP_ENTITY_ID,
\nWRS.REPETITIVE_SCHEDULE_ID, SYSDATE,
\n0, SYSDATE,
\n0, 0,
\nWRS.ORGANIZATION_ID, 2,
\n0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
\nFROM WIP_REPETITIVE_SCHEDULES WRS,
\nORG_ACCT_PERIODS OAP
\nWHERE WRS.STATUS_TYPE IN (3, 4, 5, 6)
\nAND WRS.ORGANIZATION_ID = OAP.ORGANIZATION_ID
\nAND OAP.OPEN_FLAG = ‘Y’
\nAND OAP.PERIOD_CLOSE_DATE IS NULL
\nAND OAP.SCHEDULE_CLOSE_DATE >= NVL(WRS.DATE_RELEASED,
\nWRS.CREATION_DATE)
\nAND NOT EXISTS
\n(
\nSELECT ‘X’ FROM WIP_PERIOD_BALANCES WPB
\n WHERE WPB.REPETITIVE_SCHEDULE_ID IS NOT NULL
\n AND WPB.WIP_ENTITY_ID = WRS.WIP_ENTITY_ID
\n AND WPB.REPETITIVE_SCHEDULE_ID = WRS.REPETITIVE_SCHEDULE_ID
\nAND WPB.ORGANIZATION_ID = WRS.ORGANIZATION_ID
\n AND WPB.ACCT_PERIOD_ID = OAP.ACCT_PERIOD_ID);
\n————[\/sql]<\/p>\n
B. To fix missing rows in MTL_MATERIAL_TXN_ALLOCATIONS (MMTA):<\/span><\/p>\na. Run the following select statement to see if you have missing
\nrows:<\/p>\n
[sql]select mmt.transaction_id id,mmt.transaction_quantity qty,
\nmove_transaction_id moveid, transaction_source_id txnsource
\nfrom mtl_material_transactions mmt
\nwhere mmt.transaction_source_id=<wip_entity_id>
\nand mmt.organization_id=<your organization_id>
\nand not exists
\n(select ‘x’
\nfrom mtl_material_txn_allocations mmta
\nwhere mmta.transaction_id=mmt.transaction_id
\nand mmta.organization_id=mmt.organization_id)[\/sql]<\/p>\n
b. Run the following select statement to see what repetitive
\nschedules do not have records in MMTA. When inserted, the
\nmissing rows from above will be allocated to the schedule(s)
\nfrom below:<\/p>\n
[sql]select repetitive_schedule_id,
\n(daily_production_rate * processing_work_days) schedqty
\nquantity_completed, status_type status
\nfrom wip_repetitive_schedules wrs
\nwhere wip_entity_id=<wip_entity_id used above>
\nand not exists
\n(select ‘x’
\nfrom mtl_material_txn_allocations mmta
\nwhere mmta.repetitive_schedule_id=wrs.repetitive_schedule_id
\nand mmta.organization_id=wrs.organization_id)[\/sql]<\/p>\n
c. Set the schedule to Complete-Charges Allowed by running the
\nfollowing:<\/p>\n
[sql] update wip_repetitive_schedules
\nset date_closed=NULL, status_type=4
\nwhere repetitive_schedule_id=<repetitive_schedule_id above>
\nand organization_id = <your organization_id> [\/sql]<\/p>\n
\/<\/p>\n
d. Insert record into MMTA:<\/p>\n
[sql]INSERT INTO MTL_MATERIAL_TXN_ALLOCATIONS
\n(TRANSACTION_ID,REPETITIVE_SCHEDULE_ID, ORGANIZATION_ID,
\nLAST_UPDATE_DATE,LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,
\nLAST_UPDATE_LOGIN,REQUEST_ID,PROGRAM_APPLICATION_ID,
\nPROGRAM_ID, PROGRAM_UPDATE_DATE,PRIMARY_QUANTITY,
\nTRANSACTION_QUANTITY, TRANSACTION_DATE)
\n(select mmtt.material_allocation_temp_id,<repetitive_schedule_id above>,
\nmmtt.organization_id, mmtt.last_update_date,
\nmmtt.last_updated_by,
\nmmtt.creation_date, mmtt.created_by, mmtt.last_update_login,
\nmmtt.REQUEST_ID, mmtt.PROGRAM_APPLICATION_ID,mmtt.PROGRAM_ID,
\nmmtt.program_update_date,mmtt.primary_quantity,
\nmmtt.transaction_quantity,
\nmmtt.transaction_date
\nfrom mtl_material_transactions_temp mmtt
\nwhere mmtt.transaction_source_id=<wip_entity_id?from w_p_b?>
\nand mmtt.organization_id=<your organization_id>)[\/sql]<\/p>\n
e. Set the schedule status back to Complete-No Charges Allowed:<\/p>\n
[sql] update wip_repetitive_schedules
\nset date_closed=NULL,
\nstatus_type=5
\nwhere repetitive_schedule_id=<repetitive_schedule_id above>
\nand organization_id = <your organization_id>[\/sql]<\/p>\n
4. To fix the generic error message in the log file:<\/p>\n
– Apply patch for bug 624269 (cmlwmx.ppc 50.23). It changes the
\nerror message from: APP-00001 Cannot find message name INV_NO_UPDATE
\nto: No rows were updated in table WIP_PERIOD_BALANCES.<\/p>\n
5. To prevent entries for Repetitive Schedules in unopened periods:<\/p>\n
– Apply patch for bug 776068 for non-character Rel 10.7.16.1,
\nWIPREMDF.fmb 61.47 and Rel 11, WIPREMDF.fmb 110.27(or WIP Patchset D)
\n– Apply patch for bug 876983 for character (WIPREMDF.inp 51.2)<\/p>\n
6. One enhancement to keep an eye on…..bug 881684<\/p>\n
Release 11i will have an enhancement to the View Material Transactions
\nform. This enhancement will allow the user to view material
\ntransactions (MMT table) which are uncosted (mmt.costed_flag = N) or
\nerred out during cost processing (mmt.costed_flag = E). It will also
\nlet the user resubmit those pending and erred transactions from the
\nsame form.<\/p>\n
Additional Search Words
\n———————–
\nperiod close errored<\/p>\n","protected":false},"excerpt":{"rendered":"
Unable to close EAM Work Orders because Resource transactions are not being processed by the Cost Manager. Records are stuck in the wip_cost_txn_interface (WCTI) \u00a0table with process_status = 1 (pending). Actual Cost Worker, CMCACW,\u00a0ends with an error and the corresponding material transaction is erred in the mtl_material_transactions\u00a0 (MMT) table with costed_flag = E. The work […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[111,110],"class_list":["post-610","post","type-post","status-publish","format-standard","hentry","category-oracle-e-is-yonetim-sistemi","tag-record-not-found","tag-wip_period_balance"],"_links":{"self":[{"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/posts\/610","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=610"}],"version-history":[{"count":10,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/posts\/610\/revisions"}],"predecessor-version":[{"id":611,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/posts\/610\/revisions\/611"}],"wp:attachment":[{"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=610"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=610"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}