Auto Accounting Rule Is Not Taking Effect In PROD
Aug 10, 2013
we are in the migration of oracle apps 11.5.9 [version] , while uploading AR open invoices we used auto accounting rule for revenue account , but we did this changes its not taking an effect , same revenue a/c we uploaded is uploaded , but the auto accounting is not taking an effect ,
for a work around we migrated the data ! but we would be the root cause and possibilities why it hasn't worked ?
But this auto accounting rule worked in CRP & UAT as well ...!!!
View 2 Replies
ADVERTISEMENT
Oct 23, 2012
An Oracle user account got locked, how do I check, which program or session was the cause for it? how to fetch this details along with details like timestamp, ip address, program name.
Wanted to know for Oracle 11 version running on Solaris machine.
View 2 Replies
View Related
Jan 1, 2013
I am using oel 5.8, oracle 11.2.0.3. The raw disk permissions are getting changed when the node gets rebooted.I am trying to use udev rule to change the permission permanently but its not working.
CODE[root@VM-PAGRAC3 rules.d]# more 99-asm.rules
KERNEL=="sd", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p",*
RESULT=="SATA_VBOX_HARDDISK_VB7a29b7ae-de673b56_",
NAME+="oracleasm/disks/DSK1#" OWNER="grid"
GROUP="asmadmin" MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p",
RESULT=="SATA_VBOX_HARDDISK_VB36f5d134-4e0e4c43_",
[code].....
View 8 Replies
View Related
Feb 20, 2012
Is there any rule in documentation, when create partition index? For tables, it is said to partition when table is greater than 2GB, but what about index? WHat size it should have to partition?
View 1 Replies
View Related
Aug 3, 2011
I have 2 questions :
1. How many oracle mechanism can link with oracle send mail mechanism ??
2. Any samples which the oracle send mail mechanism to run with some oracle alert mechanism.
View 3 Replies
View Related
Sep 3, 2012
I am working on Workflow and the issue is When a person leaves for vacation he can set his vacation rules so that someone has to attend / approve his workflow notifications. But when we set vocation rules all notification goes into errors state and this error can resolve by refreshing/Retry this notification. And the error detail is mentioned below An Error occurred in the following Workflow.
Item Type = CONCSPL
Item Key = 086937-15990
User Key =
Error Name = 100
Error Message = ORA-01403: no data found
ORA-01403: no data found
Error Stack =
Wf_Engine_Util.Function_Call(cust_f_test.f_find_approver, CONCSPL, 086937-15990, 180198, RUN)
[code]....
Bottom line is all notifition should be successfully process and send to dedicated person.
View 2 Replies
View Related
Oct 19, 2010
Not sure if its an issue or just an Oracle "feature" of some sort. So I create a table with a specified partition/ sub partition template as follows:
CODEcreate table sr_part_test
(
part_key NUMBER,
subpart_key VARCHAR(10)
)
tablespace NORKOM_DATA
partition by range ( part_key )
subpartition by list ( subpart_key )
[code].......
Then when I split the MAX VALUE partition, all is hunky dorey and as expected:
CODEalter table sr_part_test split partition sr_part_max at (4) into
(
partition sr_part_4,
partition sr_part_max
);
select * from user_tab_subpartitions where table_name = 'SR_PART_TEST' and partition_name = 'SR_PART_4';
[code]......
But - what if I want to have new generated names and possibly even new subpartition keys? Won't work:
CODEalter table sr_part_test
set subpartition template
(
subpartition sp_1_NEWNAME values ('foo'),
subpartition sp_2_NEWNAME values ('bar'),
subpartition sp_3_NEWNAME values ('baz')
);
[code]........
Notice that the sub partition names are still using the old names (which I do NOT want), and still using the old keys! C .
View 3 Replies
View Related
Jul 21, 2012
I know that truncate is a ddl operation that removes all the data from the table and set the HWM to very beginning. I am curious to know, is anyhow indexes will be affected on the issuance of truncate command or we need to rebuild the indexes after issuing truncate.
Also is there any way to know that how many rows/blocks a select statement is scanning because of the effect of HWM even the table has 0 rows.
View 1 Replies
View Related
Mar 15, 2011
Is it Possible to get Marquee Effect in Form Text ?
View 9 Replies
View Related
Dec 17, 2011
I have one indexed column in a table.for performance improval purpose i created index to that column .
my doubt is..it may decrease the performance while inserting data into that column?
View 5 Replies
View Related
Jul 4, 2012
We use Apex 4.0.1 and (to simplify) say we have 2 environments: DEV and PROD (both with same workspace ID.)Application 10 is in production, and currently being modified in DEV as part of an improvement project.However a bug is found in PROD and needs to be fixed as soon as possible. The steps we take are:
- Get the version currently in PROD from CVS
- Import it under a different application ID in the DEV environment, say application 11.
- Fix the bug
Now the problem starts. We always deploy whole applications to other environments (rather than individual components) and we want to keep the same application ID when we deploy this fix to PROD. But we only have the run-time environment in PROD, so it is not possible to override the application ID during deployment. So what we do is:
- Export DEV application 10 (the one being modified)
- Export DEV application 11 (the one with the bug fix)
- Import DEV application 11 over application 10
- Export DEV application 10 (the one with the bug fix)
- Import DEV applicaton 10 back (the one being modified)
- Deploy DEV application 10 to PROD (the one with the bug fix)
Is there a way to improve this (other than manually modifying the application ID in the export file)?
Another problem we have is that, once application 10 is imported into application 11, all the internal IDs change (hence the title of this post. :) ) This makes comparing versions in CVS a nightmare. Any way to prevent it? The only way seems to be import the application from PROD into the same application number in DEV, but this has an impact in the development process as no new development can be done until the bug is fixed.
View 7 Replies
View Related
Apr 19, 2012
What will be the effect of insert statement on expdp if I am doing full table export?
View 4 Replies
View Related
Jan 26, 2011
I am getting the below error when I import a table from Prod to Dev. I understand this error will be occured if length of the datatype is low. First I got the error when the datatype(length) which is 25 for the column PASSWORD column.Then I increased the length of this column to 45, then it was imported successfully.
why am facing the error when the datatye and length for this table is same in prod and dev? What are the possible ways to import the data without increasing the PASSWORD column length?
IMP-00019: row rejected due to ORACLE error 12899
IMP-00003: ORACLE error 12899 encountered
ORA-12899: value too large for column "ANEES"."SALSA_WEB_ACCESS"."PASSWORD" (actual: 28, maximum: 25)
[code]....
View 7 Replies
View Related
Apr 23, 2013
11.2.0.1
I am monitoring out PROD database using EMCA database control.
Under "Performance" tab I check the AVERAGE ACTIVE SESSION and I see spikes of "CPU concurrency". (figure emca1)
figure: emca1>
[URL].......
I want to investigate what causes this "spike" in cpu so I drill it down further:
figure: emca2>
[URL]........
Then figure drill down further:
figure: emca3>
[URL].......
But I can not understand what causes the spike thing.
View 2 Replies
View Related
Nov 7, 2013
I support an APEX app that has one workspace for Development and one for the live Production application. When I originally created the Dev instance I was able to copy tables and data by granting select privileges between the two workspaces (I did this one table at a time).
The development workspace data needs to be refreshed from production since it's been a long time since the initial refresh and is very out of date. I would like to do a couple things:
1) execute SQL to compare the tables in the two workspaces to ensure they're structurally identical
2) execute SQL to truncate Dev tables and refresh from Prod Is there a way to do this?
View 3 Replies
View Related
Jan 31, 2012
I have a question about spfile.
SQL> SELECT COUNT(*) FROM v$parameter WHERE value IS NOT NULL;
COUNT(*)
----------
246
SQL> SELECT COUNT(*) FROM v$spparameter WHERE value IS NOT NULL;
COUNT(*)
----------
20
v$parameter displays information about the initialization parameters that are currently in effect for the session,but v$spparameter displays information about the contents of the spfile.I want to know why the count of parameters whose values are not null in v$parameter is greater.where are they from? My initialization parameter file is spfile.
View 3 Replies
View Related
Nov 20, 2009
Are there redo generate during truncate operation even my primary database is in FORCE LOGGGING mode? How this will effect on physical standby database.
View 6 Replies
View Related
Apr 22, 2013
has copied one table data from Production to any other schema , know which user has done this ?
View 1 Replies
View Related
Jan 21, 2013
outlining 'key' differences between databases / configuration / hardware that can potentially make a difference to what results you get when running sql / pl/sql - I am trying to find a check list to use against PROD / DEV / TEST environments.
View 2 Replies
View Related
Jul 16, 2013
An SQL query is taking a lot of time than usual and not completing even left after hours! The query joins a table with a quite complex view.
The same query in a test database completes in less than 2 mins.
I would like to export the sql plan from test database to prod database.
how to export/import in 10.2.0.4 version for a particular sql statement's execution plan.
View 2 Replies
View Related
Jun 17, 2012
I need to refresh a PROD database into TEST database. The PROD and TEST runs on 10g. I need a full refresh. Is there any pre req's which i should keep in mind ?.
View 1 Replies
View Related
Dec 21, 2011
User wants to take a backup of the table .
There are 2 methods that i know to take a table backup. From those 2 methods
1.Using Export ?
exp user/pass file=table.dmp tables=owner.table compress=n consistent=y grants=y
feedback=1000 log=table.log
2.Copy method ?
create table table_backup as select * from <table_name>.
View 1 Replies
View Related
Feb 25, 2010
I have a table called transaction_dw and I need to select all records that have an account balance that has been below 0 in the past 6 months. initial query I tried was:
select account_balance, timestamp
from transaction_dw
where account_balance < 0
and timestamp between sysdate and sysdate - 6;
but this is only taking 6 days off the sysdate rather than months, how I can get it to take off 6 months?
View 3 Replies
View Related
Feb 6, 2013
What is the best possible method to take backup of 50 tables with data ? My DB version is 11gR2
View 14 Replies
View Related
Nov 18, 2010
Is there any strcuture or fucntion that can make the table have something like rotation.
I mean the record can be first in first delete.
So,for example , even the table have limit row for example , 100 row .
so, the new data can be replace the oldest row in the table auto and insert into the table .
so the new row will replace the oldest 99 th row auto .the table still keep 100 row but the data can be update .
Is it "partition" or other ??
how can I create it .
View 4 Replies
View Related
Feb 27, 2013
Need to generate auto number as below
A00001 to A99999. After A99999 it should begin with B00001 and ends with B99999. till Z99999 we need to generate.
View 1 Replies
View Related
Feb 19, 2011
I have set up a schema using a DDL script in Oracle 10g. I am linking this through to a Visual Basic 2008 fron end. The connection is fine. My database of is for a car hire company project.
I need to know how to create an auto increment for a primary key field, like Access does.
For example here is my table structure for my Rental_Payment table.
-- TABLE RENTAL_PAYMENT
CREATE TABLE RENTAL_PAYMENT (
PAYMENTNO NUMBER NOT NULL,
CARDNO NUMBER NOT NULL,
[Code]....
So for example the first record would appear as:
PAYMENTNO CARDNO AMOUNT CARD_TYPE
======== ===== ====== =======
01
I would then enter values and the next payment number would be 02 etc.
PAYMENTNO CARDNO AMOUNT CARD_TYPE
======== ===== ====== =======
01 123412 £40.00 VISA
02
Visual Basic will usually have a star (*) beside a new entry field so 02 will be
* 02
etc........
I have about creating a sequence. So how can I tie this to my table?
View 12 Replies
View Related
Apr 2, 2012
I have 2 tables where the data is related.table ot_pack_list,ot_delv .ot_pack_list contains details of items information that are packed to be delivered sometimes what happens user may remove some items from this, and the summary column of dl_wt and dl_qty in ot_delv must get automatically changed whenever there is addition in ot_pack.
create table ot_pack_list (item varchar2(12),pack_qty number,pack_wt number,pack_no number)
insert into ot_pack_list values ('a',2,10,1);
insert into ot_pack_list values ('b',3,55,1);
create table ot_delv (d_no varchar2(12),d_qty number,d_Wt number,d_pack_no number)
[Code]...
--after updating the data in ot_delv should be like..
select * from ot_delv;
d_no d_qty d_wt d_pack_no
----- ----- ---- -------
1 5 75 1
View 15 Replies
View Related
Aug 11, 2010
I have a table abc with name and phone_number columns in it,and this table contains 100 records. Now I want to add a column say ID as primary key for this and it should be auto incremented and should have primary key for the first 100 records as well.
View 8 Replies
View Related
Sep 14, 2012
I have to make this script . It should be something like this :
starting of lsnrctl.......
startup mount;
alter database open read only;
recover managed .....................;
and a second script is to shut down everything correctly during Linux shutdown..I think it would be better to make a new Linux service . make a whole script? Oracle 11.2, Oracle Linux 5
View 2 Replies
View Related
