• Oracle forms 6i cannot connect to Oracle database

    Dear All,   ORA-28040 :NO matching authentication protocol We have tried with SQLNET.ALLOWED_LOGON_VERSION_SERVER=8 SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8 on both server side & client side sqlnet.ora ...
    last modified by muba_zak
  • Re-writing the below query for better performance and optimized cost.

    Oracle 10g.   ----------------------   Query   UPDATE FACETS_CUSTOM.MMR_DTL SET CAPITN_PRCS_IND = 2, FIL_RUN_DT = Current_fil_run_dt, ROW_UPDT_DT = dta_cltn_end_dttm WHERE CAPITN_PRCS_IND = 5 ...
    last modified by Dayanand
  • Consecutive counter

    I am currently trying to build a counter field that will increment for groups of consecutive rows. SELECT EMPLOYEE_ID,        DTE,        HOURS,  &nb...
  • How long system process scheduler logs kept?

    How would I find out how long does our system process scheduler logs are being kept?  I am referring the logs in the $ps_home\appserv\prcs\DOMAIN\LOGS, because we have a process that were run successfully on 4/21...
    last modified by 1828286

    Dear Gurus,   We are facing following error.   Please see attached file.   Thanks Adeel Imtiaz
    Malik Adeel Imtiaz
    last modified by Malik Adeel Imtiaz
  • Is Eloqua send times accommodating for daylights savings in Europe?

    Does anybody know if Eloqua is accommodating for DST in Europe? I know that they had the adjusted the NA send times for campaign activation, but I haven't seen any similar notes for the rest of the world time zones. ...
    Brian Boyd
    last modified by Brian Boyd
  • oracle identify and generate script to drop old partitions

    Hello DBAs and Gurus,   DB: 11gR2 OS: Linux   I am new to Oracle partition world with limited experience in partition management. I am trying to drop some old partitions from users schema and not sure fr...
    last modified by khallas301
  • get ora-28021 during impdp, but user has role in source db

    Hello, RHEL, 6 x86-64, Oracle   I did a full database export (expdp) from source db and upon running import (impdp), I get this:   ORA-39083: Object type ROLE_GRANT failed to create with error: O...
    last modified by 6String
  • API for Packing or assigning the LPN to a delivery in a WMS enabled Org

    Hi Folks,   Need urgent help regarding the following scenario,   An LPN was created for and Org which is WMS Enabled using the following API wms_container_pub.create_lpn, the LPN got created successfully ...
    last modified by Anujk12
  • "CEIL"-function for dates

    25 votes
    A minor nuisance is to determine the closing border of an arbitrary interval covering a date-time-value. It would be nice to have CEIL(SYSDATE, 'MM'), CEIL(SYSDATE, 'YYYY'), etc. analogous to TRUNC(SYSDATE, 'MM'), TR...
    Carsten Kaftan
    last modified by Carsten Kaftan
  • Mandatory multi-select pick lists for forms

    so... anyone know how to make a multi-select list mandatory? we have forms from E9 that have it, and we are struggling to make that happen in E10 !
    last modified by zurine.garciamartin
  • select distinct with subquery

    I have the following select distinct (texe_cnasupro)account_num, (texe_cnfuncid)v_service, (texe_cnsubser)v_subservice, (texe_cnnetnam)bank_num, 'N'previousday_cust, 'N'sameday_cust, 'N'achsameday_cust from kndtex...
    last modified by 2841366
  • Next_Value

    Hi,   I am trying to achieve following results. I have only LOAN_DATE available and trying to calculate PAY_DATE. PAY_DATE is the same date of next LOAN_DATE. If there is only one row for same B_ID or it is the ...
    last modified by skas
  • fsg reports shows some negative rows with () and some with -

    hi made a report in fsg, but when publish the same some negative rows are displayed in () and some with - its strange as its the same column
    last modified by user1343407
  • FDMEE Dataload with SAP ERP Integration

    Hi everyone I'm on FDMEE11. I've integrated SAP ERP with FDMEE but when doing the dataloads, I'm getting the below error related to OpenTools. Could someone please throw some light on this. I did import the...
    last modified by user12032009
  • Known issues: the issues we know

    The previous thread is Known issues, again. Some stuff was fixed last week....   The banners in the Topliners and OTN spaces are intrusive and large. [We are actively working on this right now.] FixeDefault the...
    last modified by moniquevdb-Oracle
  • Version of existing EDQ setup

    I am new to EDQ. I have a system with already setup with EDQ. How can I can find version of below: EDQ EDQ-CDS EDQAV Loqate EDQ Siebel Connector   and if possible if you can tell me any other component to c...
  • How to update calander in FDMEE source period mapping

    Hi,   We are trying to find to update the calender in FDMEE source period mapping.   i have attached the screenshot. Once i selected the calendar MD(jan - Dec),the GL year details upto 2014 is coimg up whe...
    last modified by 1529441
  • Error running Maxl and ESSMSH Commads

    Hello,     I had recently installed  EAS Client while my system was getting changed from a previous one . Firstly , I was unable to enter the Maxl with essmsh command , so i had started going to the di...
    last modified by 955124
  • OR condition displays incorrect results

    Hello,   I have a  very simple SQL   SELECT COMPANY, EMPLOYEE, DEPT, REASON_01, REASON_02 FROM TABLE WHERE (TRIM(REASON_01) <>'D90' OR  TRIM(REASON_02) <> 'D90')   If either ...
    last modified by user11070698