Inventory (stores) costed error

Stop the COST manager or CONCURRENT manager

1)select * from mtl_material_transactions where costed_flag='E'

Confirm the error and find the organization_id and transaction_id

2)SELECT organization_id,

default_cost_group_id

FROM mtl_parameters

WHERE organization_id = '155'

(place organization id from the step 1)

2) UPDATE mtl_material_transactions

SET transfer_cost_group_id = &dcgi

WHERE tranasction_id = &txn_id;

(&dcgi = default_cost_group_id and &txn_id = from step1)

3) UPDATE mtl_material_transactions
     SET costed_flag = 'N',
     transaction_group_id = null,
     error_code = null,
     error_explanation = null
    WHERE transaction_id = &txn_id;

(&txn_id= from step1)

update mtl_material_transactions

set request_id = null,

costed_flag = 'N',

transaction_group_id = null,

transaction_set_id = null,

cost_group_id = transfer_cost_group_id

where costed_flag = 'E'

and transaction_id = '3392889'

Start the COST manager or CONCURRENT manager

Comments

Tablespace Management using Toad

You can view all of your tablespace information using toad tablespace screen from Database –> Administer –> Tablespaces Here each table describes different detailed information across all the tablespaces in database. If you open this screen from the toad DBA module then you are also able to see the “space history” and “IO history” tab along with Files, Free space, object, Fragmentation. With these tab you are able to able perform space monitoring and planning steps. These tab permits you check graphically space and IO usage over time. Through this way DBA are also able to estimate ‘Object size’ based on this estimation. From the below “alter tablespace” tab you can § Modify the tablespace and datafile size. § Add new datafile to the tablespace.

Import Excel Data into Oracle using Oracle form Button

Import Excel Data into Oracle using Oracle form Button 1. Create a button on the form with the name "IMPORT_EXCEL" and write a pl/sql on "WHEN BUTTON PRESSED" trigger. BEGIN IF :System.Cursor_Block<>'GL_DAILY_COMPOUND_HEADER' THEN Go_Item('GL_DAILY_COMPOUND_HEADER.V_DATE'); END IF; IF :System.Mode = 'NORMAL' AND :System.Record_Status IN ('NEW','INSERT') THEN IMPORT_EXCEL_PROC; ---Form procedure ELSE MESSAGE('Import allowed only for new entry!!!'); MESSAGE('Import allowed only for new entry!!!'); END IF; END; 2. Now write the procedure "IMPORT_EXCEL_PROC" into the program unit. Don't forget to create required table and folder for procedure IMPORT_EXCEL_PROC PROCEDURE IMPORT_EXCEL_PROC IS application OLE2.Obj_Type; workbooks OLE2.Obj_Type; workbook OLE2.Obj_Type; worksheets OLE2.Obj_Type; worksheet OLE2.Obj_Type; cell

Changing National Character Set AL16UTF16 to UTF8

Changing National Character Set AL16UTF16 to UTF8 The national character set is used for data that is stored in table columns of the types NCHAR, NVARCHAR2, and NCLOB. In contrast, the database character set is used for data stored in table columns of the types CHAR, VARCHAR2 and CLOB. Like the database character set, the national character set is defined when the database is initially created and can usually no longer be changed, at least not easily or without involving quite a lot of work (export, recreate database, import). Except when creating the database, where the national character set is defined explicitly, it can change implicitly even when upgrading the database from Oracle8i to Oracle9i (or Oracle10g). You require SYSDBA authorization to change the national character set. Changing the national character set means changing an Oracle Dictionary entry, but no data is changed. $sqlplus /nolog SQL> CONNECT / AS SYSDBA SQL> Select property_value fro

Oracle Database

Search This Blog