Oracle creating new MO OPERATING UNIT

i am apps dba . I WANT TO KNOW HOW TO CREATE MO operating units. ...

Oracle FSCM 9.0: Value OPERATING_UNIT for chartfield is not valid for budgeting

Folks,Hello. I am working on FSCM 9.0 Commitment Control Budget Journals.I define Operating Unit "MyUnit" for budget using Navigator "Setup FSCM>Common Definition>Design CF > Define Values > CF Values " and select "Budgetary Only" check box.Then I enter Budget Journals using navigator "C ...

Oracle Windows Allocation Unit Size and db_block_size

We are using Oracle 9.2 on Windows 2000 Advanced Server. What is the largest db_block_size we can use? I am going to reformat the drive to the largest cluster size (or allocation unit) Oracle can use. ...

Oracle Constraint definition

Can someone please point me what is wrong with this constratint definition. (running against Oracle 10g)ALTER TABLE point.NOTEBLOB ADD CONSTRAINT FK_NOTEBLOB FOREIGN KEY (PRIMARYKEY) REFERENCES point.NOTES (PRIMARYKEY)ON DELETE CASCADEif i changed i to the follwoing, it works,ALTER TABLE "POINT"."NO ...

Oracle How to make a package or procedure to be a operating specific?

How to make a package.procedure to be operating unit specific. As in when we run the program from US operating unit it should give all US data and when ran from canada operating unit it should give canda data. How is this done? Any suggestions please. ...

Oracle How to reduce the virtual memory paging on the host operating system?

How to reduce the virtual memory paging on the host operating system?Oracle 10g Release 2 DataBase has been installed on the host OS.OS version: Microsoft Windows 2003 server r2 32-bit version ...

Oracle List of Manual Setup required for iSetup to work

This is Mugunthan from iSetup development. Based on my interaction with customers and Oracle functional experts, I had documented list of manual setups that are required for smooth loading of selection sets. I am sharing the same. Please let me know if I anyone had to enter some manual setup while u ...

Oracle Call to MO_GLOBAL.INIT procedure

We are facing strange issue, we need to create sales order using standard oracle procedure, this procedure is required to be called by Java using JDBC.If in Java code I don't make a call to MO_GLOBAL.INIT procedure it is error out in sale order creation procedure stating no data found. On analysis w ...

Oracle Positive Pay file Transfer Program Update

I have a Positive Pay File transfer program created and installed by consulting company which is not available right now. It was created as a executable and called by concurrent request set (Select, Encryption and Transfer). At the time it was set up we had only one operating unit, but now we split ...

Oracle Note: APP-ONT-25128: You cannot change order currency

When OM has to change the ship to on a sales order that was submitted from Oracle configurator in one of our international Operating units, the currency is automatically being updated from USD (was on the quote) to the local currency (GBP for the UK operating unit). The calculate price flag on the o ...

Oracle Discoverer Reports does not work in Multi-org Environment after R12 Upgrade

Discoverer Reports does not work in Multi-org Environment after R12 Upgrade. Created a simple report using the below query:SELECT po_header_id, segment1, type_lookup_codeFROM po_headersWHERE segment1 = '5000002'Query works perfectly fine; when i set the ORG_CONTEXT in the database using the command: ...

Oracle Fixed Asset Depreciation Not Matching

We have moved Fixed Assets from one Operating unit to another and have run the depreciation for both the units to ensure that the assets are moved correctly. We find that there are certain assets where the depreciation value varies between old and new operating unit. The New unit depreciation is cal ...

Oracle Data Provider

When I use the new Oracle Data Provider for .Net ver 9.2.0.4 I get the following web error:"The located assembly's manifest definition with name 'Oracle.DataAccess' does not match the assembly reference."The Oracle.DataAccess reference is displayed in the solution explorer of .Net and the path prope ...

Oracle Can I buy software support without hardware support?

If I own both Oracle hardware and software, can I just buy support for my software?It seems Oracle offers a software (OS) package and a bundled (both hardware and software) package.Oracle Premier Support for Operating SystemsOracle Premier Support for Systems ...

Oracle Listener and Intelligent Agent not working together

I currently have oracle 8i installed on a Windows NT Server with SP5 running on it. I have been able to access the listener and when reloaded, it works fine and TNSPING80.exe can ping the service name fine, but Oracle81Agent will not set up properly, b/c it doesnt find the Listner. The error Im ge ...

Oracle checking version string

everyone. I'm write a tool to locate and inventory Oracle databases on a network. I am using the message I get back from the listener service to determine the operating system oracle is running on. In order to do this properly I need the exact string that appears in the version and there's no way I ...

Index Definition Script Needed

Does anyone has the script to get all the index definition from the Oracle Data Dictionary and to create a index creation script.I wanted to search entire thread but did not found search option. ...

Is Oracle Spatial compatible with MapXtremeJava 3.1

I can not read data with Mapxtreme's Java Map Definition Manager from Oracle Spatial 9.0.1. In the console I get the error message: com.mapinfo.spatialj.jdbc.SpatialSQLException: The Oracle Spatial Option is not installed.But I have installed Oracle Spatial. I can connect to the database with MapXtr ...

Oracle backup & recovery

Kindly if someone can put some light on the below query we are facing : I have a setup of Intel Server with Windows 2000 Server operating system. Oracle 8i is installed in the server. Because of hard disk crash i lost my all data, i am having backup's on tape.please tell me which is the fastest meth ...

Oracle Invalid name pattern - at enqueue call

The advanced queuing demo code throws this error when we try to use our own object...9i, JDev 9.03, classes12, runtime12, AQJMS. Our object was pulled using jpublisher. PL/SQL has no trouble queuing the object and it is valid.Error text, code snippet and high level object definition follow... jdbc:o ...

Oracle Intelligent Agent problem

I got a problem with the Intelligent Agent.I installed Oracle 8i EE 8.1.5 and OEM 2.1 on Windows 2000 server. When I try to discover the node with OEM, OEM could only find the node, it could not find any database. So I thought maybe the Agent got some problem. Iopened the log file Nmiconf.log, the f ...

Oracle DATAGUARD

I plan to change a production server. My new server is a linux machine with several databases 9.2.0.4.0 Oracle version. The server to be replaced is a windows NT machine with databases in 9.2.0.3.0 Oracle version. i plan to keep the server to be replaced for 30 days, just in case that we need to bac ...

Oracle plesae solve this problem

Please investigate why the WIP Reconciliation Report is not pulling the Costs for Expenditure Catagory - APS_Field_Servc Contract Labor that has Expenditure Type - FS_LABOR_CONTRACTOR_ST in some projects. Examples are Projects Project Task Organization Total Cost Total Liquidated Cost Total Cost In ...

Oracle Versions Communication

this is my first post, so apologies in advance if I've selected the wrong part of the forum. . .We are currently undergoing a project to move the database for one of our systems from 8i on unix over to 10g on windows 2k3 (we no longer have any unix support since ms is the company standard - a decisi ...

Oracle Private SQL Area ..... PGA...???

In Oracle Concepts book of Ora10db in the paragraph titled as:"PL/SQL Program Units and the Shared Pool" is written ,by word , the following:"Oracle processes PL/SQL program units (procedures, functions, packages, anonymousblocks, and database triggers) much the same way it processes individual SQLs ...

Oracle Calling 32-Bit External Procedure from PL/SQL (Windows 2003 Server)

Can I run a extproc of 32 bits in a 64-bit architecture (server and operating system)?Oracle 10GWindows Server 2003 ...

Oracle Session

I want to know what is an Oracle Session?What is the Exact Definition of an Oracle Session?What is meant by an Session?The Next Question is Why Do we need to Commit Form Applications' Data to see the changes(inserts,updates,deletes) in other applications like TOAD?But without Commiting Form Applicat ...

Oracle FDPSTP failed due to ORA-01722

HiThere is a prcodeure which has suddenly failed in the front end with the following error:Cause: FDPSTP failed due to ORA-01722: invalid numberORA-06512: at "APPS.AXX_PROGRAM_PACK1", line 51ORA-06512: at line 1The program has been running fine from the front end from when it was implemented and it ...

Oracle I need the API name to copy the contracts line and subline

I have a requirement of copying the a contract in one operating unit to a contarct residing in another operating unit.Please suggest which API to use. ...

Oracle Backup management

I have to schedule a backup of a Database in a server three times a day. Server has Windows Operating System, Oracle 10g Release 2 is running on this. I am planning to take full hot backup of database daily night time. Two more backups which are incremental backups are also planned, one at 1 PM and ...

about oracle name parameter

could any one tell me some detailed definition about following oracle name parametersdb_namedb_unique_nameservice_nameinstance_nameHow are they used?what makes the /flash_recovery_are/? name what makes the OEM login to ?name ...

about oracle name parameter

could any one tell me some detailed definition about following oracle name parametersdb_namedb_unique_nameservice_nameinstance_nameHow are they used?what makes the /flash_recovery_are/? name what makes the OEM login to ?name ...

Oracle Worklfow issue

We have a workflow OTL Workflow for Employees.This is a seeded workflow for Timecard approval.In the Process Find and Notify approver there is a Notification node.This notifictaion node is referred to the notification which a supervisor gets when a timecard is submitted.The requirement is the timeou ...

Oracle PLS-00103: Encountered the symbol "EXCEPTION"

I have a plsql code which gives me an error as shown below:DECLARE*ERROR at line 1:ORA-06550: line 98, column 1:PLS-00103: Encountered the symbol "EXCEPTION" when expecting one of the following:begin case declare else elsif end exit for goto if loop modnull pragma raise return select update while wi ...

Impact of oracle DCE (Distributed Computing Environment (DCE)) component

Os is SunOS 5.10 Generic_120011-14 sun4u sparc SUNW,Sun-Fire-880 which is 64 bit operating systemOracle database version 10.2.0.1We encountered error during installation of oracle 10g on sun Os ********************************************************************************************************** ...

Oracle LogMiner

I'd like to know if it's possible to use LogMiner utility in a Enterprise Management Console (like in Windows) with Oracle 10g in Linux?My environment:Operating System: Oracle Enterprise Linux 5Database: Oracle 10g R2If it is, could anyone send me the steps to install, configure and use LogMiner? ...

Oracle How can i get the Organization_id (Inventory Organization) ?

I'm making a report in Inventory and we have a Multi organization setup in R12,In my Report i need to get the Organization_id (Inventory Organization) automatically so i can pass it and use it in the query.How can i get the Organization_id ? (using a query or a function)P.S i want Organization_id wh ...

Oracle Unable to query even after intialising Session using fnd_global.apps_initia

i am initialising using this scriptbeginfnd_global.apps_initialize (user_id => 1112,resp_id => 50707,resp_appl_id =>222);end;, but i am not able to query in view select * from ar_cash_receipts;please suggest if we need to do something more to initialise session.i checked MO:Operating Unit a ...

Oracle my streams not working,who knows why?

I am new in the streaming part of oracle, I have two database in vmware , I want to do online replication of the database. one is the main database and the other acts as backupI am using oracle tried for schema level streaming ,I have used orcl1=> orcl2, All of the databases were on Oracle 10.2.0 ...

Oracle Parallel Process

Is it possible to control the parallel execution for certain processor aloneConsider i am having server with 16 processsor , installed with windows 2003 server operating system,oracle 10g server X64. here i suppose to execute parallel statements in 8 processors and is it possible to select what 8 pr ...

Oracle What OS's are supported.

I am looking at 10G and its says release 2 supports the following operating systems Oracle Enterprise Linux 5 (OEL5) Oracle Enterprise Linux 4 (OEL4) Red Hat Enterprise Linux  5 (RHEL5) Red Hat Enterprise Linux  4 (RHEL4) Red Hat Enterprise Linux 3 (RHEL3) Novell SUSE Linux Enterprise Server 10 (S ...

Oracle Need Help for using dequeue_options.deq_condition while dequeuing message

Our requirement is to pass org_id as dequeue_options.deq_condition while dequeuing messages. So that we can filter messages of a particular operating unit only. Pls find the code snippet below:l_dequeue_options.consumer_name := p_app_short_name;l_dequeue_options.dequeue_mode := p_dequeue_mode;l_dequ ...

Oracle Client x86 on Windows 7 x64

Buenas,No tuve problemas al instalar el Oracle Client de 64bits en mi windows 7, pero cuando configuraba el PL SQL Development me surgieron un error, como el PLSQL es de 32bit y el Oracle Client de 64 no me detectaba el Oracle_home x ende tampoco oci.dll.La solucion seria instalar un Oracle Client d ...

Configuring Hetrogeneous connectivity from Oracle to SQL server

I am working on 02 servers, Information on the servers are:Server 1- Operating system => Oracle Linux- Database => Oracle 10g R2- Database name => ORCL- Server IP => 192.168.100.223 Server 2- Operating System => Windows 2003- Database => SQLserver 2008- Database name => Northwin ...

Oracle events

- what is the definition of an Oracle event?- what events are in Oracle?I saw some notes speacking about events like 10053 and 10046; ...

Ubuntu Oracle says may launch own Linux

"U.S. software maker Oracle Corp. is considering launching a version of the Linux operating system...""...Oracle had considered buying Novell Inc...."http://news.yahoo.com/s/nm/20060417/tc_nm/oracle_dcThat would be cool! ...

Oracle what does "dba_mviews.staleness" mean ??

what does "DBA_MVIEWS.staleness" mean?The following definition is from oracle manual. STALE - Materialized view is out of date because one or more of its masters has changed. If the materialized view was FRESH before it became STALE, then it is a read-consistent view of a former state of its masters ...

Oracle R12 Payment Instruction - Missing Data using Remit to Supplier field

HiWhen I'm performing Quick Payment using remit to Supplier field in Quick Payment's Forms Payment Instruction format finishes Normal but no Payee or External Bank Acount Information is in XML .Is it a setup issue or bug?ThanksJD. BASee Output log ( XML inside ) <?xml version="1.0" encoding="UTF- ...

Oracle Ledger and Legal Entity relationship informatin?

I have a concept on R12 which is the Ledger can have multiple Legal Entity and each Legal Entity can have multiple Operating Unit and Inventory Organziation.Does anyone has a sql statment to draw all those relationship information? So that I can understand which Legal Entity belongs to corresponding ...

Oracle Creating Sales Order and Shipping Goods in EBS R12

Is it possible to create a sales order in OM under certain Operating Unit (OU) say OU1 and ship the goods from an Inventory Organization (IO) under another Operating Unit say OU2?If the answer is yes, please send me the steps how to do it.If the answer is no, please explain why. ...