Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

2737

IMP-00070: Lob definitions in dump file are inconsistent with database.

1741

ORA-26082: load of overlapping segments on table string.string is not allowed

1766

What is the major use of Servelet

2502

//jobname positional parms,keyword parms,.... Restart=step3 //.. //.. //.. //step3 exec=xxxx //... //step4 exec=yyyy,cond=(0,Le,step3) //.. //step5 exec=zzzz Restart =step 3 executes step3.Step 3 gives some return code.In step 4,the test is passed as 0 is less than step 3.So step 4 is bypassed and is not executed. and the program is responsible for issuing the return code that was not even loaded in the main storage. The result: no return code can exist In the steps that follow any test of COND parameter tat attempts to interrogate this non-existent return code will be ignored . Step 5 will be e executed. IN THIS EXAMPLE WHAT DOES XXXX YYYY ZZZZ MEAN?? PLEASE CAN ANYONE SAY...

2843

Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??

1674

If Fi account is assigned to cost element categorie poatings are not possible it is giving error that cost element has to be assigned to a co object whts the solution for this error?

2786

IMP-00000: Import terminated unsuccessfully Hi all . when i go to restore oracle dmp file in my database ans typing this command , C:UsersW>imp HR2011/HR2011@XE TABLES=* dmpfile=F:Share223.27.244.72EXP 2017-0113030008FU160710ZIP/FU160710.DMP this message was showed to me and restore mission filed . LRM-00101: unknown parameter name 'dmpfile' IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help IMP-00000: Import terminated unsuccessfully how i can fix this problem plzzz

2939

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2719

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2225

how to run the application using winrunner for data driven test?

2386

NZE-28890: Entrust Login Failed

1872

When I look for mannual enry of any of the command in Unix, such as #man ls, I get a message "Reformatting entry. Wait..." and control comes to a next command prompt. what is the problem?

2449

how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board

2210

Account GOLD-100200 not allowed to be defined as reconciliation account Message no. AC309 Diagnosis Account 100200 is defined as a reconciliation account for fixed assets for chart of accounts GOLD and account determination 11000. This is not correct in the circumstances (Accumulated depreciation account for ordinary depr). Keep in mind that the Customizing definition of the given depreciation area also influences the consistency check of the G/L accounts. This is particularly true for the posting settings in the depreciation area, if the accounts are value adjustment (depreciation) accounts. Procedure Change the account definition, or assign a different account. ERROR MESSAGE “Account INT-160600 not allowed to be defined as reconciliation account” . Message No.: AC309 ANALYSIS The above error message occured when saving the configuration changes in “Acquisition from affiliated company” through config transaction AO90. Here’s the configuration path that prompted the error: Path: IMG → Financial Accounting → Asset Accounting → Integration with the General Ledger → Assign G/L Accounts. Transaction Code: AO90 G/L account 160600 is entered in the highlighted “Acquisition from affiliated company” field. Upon saving the configuration change, the above error messageprompted. Do note that g/l account 160600 has been defined as reconciliation account type for asset. Here’s how it is set- up. SYSTEM DIAGNOSIS Account 160600 is defined as a reconciliation account for fixed assets for chart of accounts BPPH and account determination 1000. This is not correct in the circumstances (Clearing acct: Acquisition from affiliated company). Keep in mind that the Customizing defination of the given depreciation area also influences the consistency check of the G/L accounts. This is particularly true for the posting settings in the depreciation area, if the accounts are value adjustment (depreciation) accounts. SOLUTION & PROCEDURE If the g/l account entered is correct change the settings of g/l account 160600. Do not set it as reconciliation account, just leave the reconciliation account type blank. Otherwise, create a new g/l account that will be used as intercompany transfer clearing account. The new g/l account should not be set as reconciliation account. You must be logged in to post a comment. • F Asset accounting account determination natandycanada asked Sep 3, 2009 | Replies (5) Hello I am building the asset accounting account determination. When i enter the GL account for Account determination i get the message: reconciliation account is not allowed!!! (. SAP message AC309 )has anyone come across this message? I checked the depreciation area definition and all should be good. I am on ECC6. Thank you Join this group Popular White Paper On This Topic • 2011 ERP (Enterprise Resources Planning) Comparison Guide 5 Replies 1 Anuj Purwar replied Sep 4, 2009 Hi, Assign a P&L account for depreciation posting. Thanks. _____ 1 natandycanada replied Sep 4, 2009 I do have a P&L account Andy Maoulaoui 0 Ron Roberts replied Sep 4, 2009 Help us ouot with a little more detail. What G/L account are you trying top assign? Depreciation expense? Asset account? Accumulated depreciation account? Gain/loss on disposal P&L account? Other? 1 natandycanada replied Sep 5, 2009 I am assigning an accumulated depreciation account. this account is naturally a reconciliation account. all other accounts can be entered without any error. When i enter the accum depreciation account in depr area 01 (post to legder 0L) the system give the message that reconciliation account is not allowed. when i enter the accum dep account in dep area 02 ( posting to non leading ledger) i dont get the error. Andy Maoulaoui White Papers and Webcasts Popular • The Evolution of ERP and What it Means for Business Related • Gain IT asset visibility, control and automation • SMB Accounting SaaS Comparison Guide • Shifting the B2B Marketing Paradigm from Contacts to People: ... More White Papers 0 Gearoid Pierse replied Dec 4, 2009 Hi everyone - I am getting the same problem when putting in an accumumated depreciation account in the customizing for depreciation area 01, I get *** (message AC309 "Account 1100250 is defined as a reconciliation account for fixed assets for chart of accounts OPER and account determination AD400. This is not correct in the circumstances (Accumulated depreciation account for ordinary depr).Keep in mind that the Customizing definition of the given depreciation area also influences the consistency check of the G/L accounts. This is particularly true for the posting settings in the depreciation area, if the accounts are value adjustment (depreciation) accounts. *** However, I can assign my accumulated depreciation account 1100250 (which has the recon account "A" (assets) setting no problem for depreciation area 20. If I take away the recon account setting in the G/L account I get a different error message

11078