Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x

Oracle Database

78K

Solutions

25K

Contributors

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Share tech news, updates, or what's on your mind.

Sign up to Post

I am in process of adding new item status to existing one.Guess I need to look at below transactions to define how item will behave in each based on status:
All sales order, material stock request (MSR), and Express Issue.
Picking and shipping.
Warehouse movements.
Adjustments.
RMA and RTV.
Supply planning.
Replenishment.
Manufacturing.
Receiving.
Putaway.
Purchase order and requisitions.

However I need to check if I should also look at material transaction in Oracle(menu path -Inventory-transactions -Material transactions) and if yes how to proceed . There are more than hundred transactions defined in there , not sure if they are pre determined by oracle or was decided by my business maybe previously. Not all used currently. What actions should I take.

Thanks
0
Get free NFR key for Veeam Availability Suite 9.5
LVL 1
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

My select date is 04-Sep-2017 then 8 weeks future date should display

Style , Dept,Class,Subclass,04-Sep-17      11-Sep-17      18-Sep-17      25-Sep-17      02-Oct-17      09-Oct-17      16-Oct-17      23-Oct-17      
                                                                                          
                                                                                          
                                                                                          
Note:  Have to use only SQL query from Oracle database.
0
Hello,
I have multiple tables with insert, update. When one of table inert or update failed don't want to save the data in all table.
Means Transaction should be either completely  successful or it may failed. How to incorporate this in form.
I have to use rollback in form procedure or any other option.

thank you
0
Hi,

My compnay has agreed to sponsor Oracle training in supply chain management as we are using oracle e business suite  R12 version for our supply chain.

However it will not be a full subject training but have been asked to identify key topics to cover due to budget restrain.

Would be great if someonce can suggest what I should opt for to get maximum out of this training. (Mine is healthcare company ).

Some in mind are Material Master Data, BOM, Planning, work orders .

May thanks
Meenu
0
In oracle form 10g,I have implement one task,I have to read text file and extract the useful data like name DOB CRN no etc and display it on form,i have to create LOV of CRN no which is present only in text file,
,if we choose CRN no then form should display information related to that CRN

My thought on it
1)create procedure to read file and extract data put it on temp table
2)used that temp table in oracle from to create LOV and display information
Can you please suggest me on this? is there any other way to do that
Thank you
0
hi i have upgrade the liabrary from 6i to 11g the foolowing code work in 6i but when i compile in 11g is giving error check attachment
erro0987.jpg
tpapi1Bdy.txt
tpapi1Spec.txt
0
I am trying to add new link server to oracle db in SSMS. I've installed oracle client 12c 64 bit.
I can connect to the oracle db via SQL developer when I enter the tnsnames directory but not mgt studio, when adding a new linked server. This confirms all service names passwords and firewall rules, content of tnsname.ora are correct. I get "ORA-12154 tns could not resolve the connect identifier specified" immediately so its not finding the tnsnames.ora file.

So I have also checked the following:
I have amended the provider options to allow inprocess.

My tnanames.ora and sqlnet.ora files are in c:\oracle\product\12.2.0\client_1\network\admin\

I have names.directory_path= (Tnsnames) in my sqlnet.ora file.

If I do a tnsping tnsentry it uses the above sqlnet.ora as parameter file bit I get
tns-03505: failed to resolve name error

Ive check the path in environment variables. In regedit, the path of Inprocserver32 of the oracle clsid is c:\oracle\product\12.2.0\client_1\bin\oraOlEDB12.dll

Ive restarted SQL services.

How can I get SQL mgt studio to point.to my tnsnames file.?  Is there anywhere in regedit that tells SQL of the file location
0
Hi,
we have a planned maintenance for our production environment (WINDOWS SERVER 2008 R2) scheduled in a weeks time from the time of this post. Windows cluster is configured for two nodes on an ACTIVE/PASSIVE basis. Going by the company planned maintenance policies all nodes are expected to be shutdown . Oracle database 11gR2 is running on the primary node. Kindly advise on the best procedure to shutdown and startup the cluster after maintenance is completed.

Also do i shutdown the database manually through the 'SHUTDOWN IMMEDIATE' command?

Kind regards.
0
Good Afternoon

I am using an Oracle Form (10g) and I would like to return multiple records in a field rather than just returning one row.  I tried Bulk Collection but I received a client side error.
0
Ours is pharma products and expiration date is imp. but on one particular batch no expiration date was picked. What can be the reason?

Earliest response would be grateful.

I am using oracle e business suite R12 vversion.

Thanks
minzee
0
NFR key for Veeam Backup for Microsoft Office 365
LVL 1
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

i have data file like this

gender
-------
---------------------F--------------------------
--------------M--------------------------------
F----------------------------------------------
-----------------------------M--------------------
---------------------F--------------------------
--------------M--------------------------------
F----------------------------------------------
-----------------------------M--------------------

now, i want to load the data like

Gender
-----------
F
M
F
M
F
M
F
M

like this by using sql loder control file

any one help me plsee
0
Hi,

I am not clearly understanding the difference between Inter and Intra UoM converaions. I have read oracle doc and some brief examples but still nto very clear. Can someone please explain this in more details.

Thanks
Minzee
0
I'm running Oracle 9i and on Windows 2003 Server.  This is a legacy application that was setup by an old administrator and I need to access to recover the data to move.  I found the command for sqlplus and to use /nolog but SQLplus requires an admin and password.  If I have physical access to the server how to I reset the Oracle Admin login?  Or which login do i need to try to reset to be able to access features like the Database, exporting, backup and so on.  It seems they locked every place to access, Oracle enterprise console, SQLPlus, and the Database itself.  I assume once I get into enterprise console I can just reset the DB password myself if we even need to.  I'm just trying to get if off this server before it crashes.
0
Where to define product lifecycle phases in oracle e business suite R 12
0
I have a lengthy query that creates a table then fills it with about 20 INSERT statements from various other sources.

When I edit the query at times all the various pieces of the query open.  Is it possible to collapse the drill in with a single key stroke or mouse click?

mlmcc
0
Hi,
How do I create a unique constraint against 2 columns and nulls included
I found it before but can't remember the syntax..

      alter table "DB_BASIC_PARM_USE" add constraint
      "DB_BASIC_PARM_USE_CON" unique ("PROJECT_ID",nvl(MY_NUM,-1))
      /  
I want
insert into mytable project_id 1, my_num 2  --- inserted successfully
insert into mytable project_id 1, my_num 2 should cause constraint violation
insert into mytable project_id 1, my_num null  --- inserted successfully ALLOWS ONLY ONE NULL COMBINATION
insert into mytable project_id 1, my_num null should FAIL cause constraint violation
insert into mytable project_id 1, my_num 3  --- inserted successfully
insert into mytable project_id 1, my_num 4  --- inserted successfully
insert into mytable project_id 1, my_num null should FAIL cause constraint violation
insert into mytable project_id 2, my_num null  --- inserted successfully ALLOWS ONLY ONE NULL COMBINATION

thank you,
Bill
0
We are trying to connect to an older Oracle 8i database from SQL 2014 64 bit  running on Windows 2012 64 bit. We were able to connect from a 32 bit sql 2005 server. I do not have the 10g 64 bit client which i believe i need.   Questions are , what can i do to connect the database ? is there some other files i need? is there a 10g 64 bit client anywhere ? Oracle does not have them on there public site.
0
We had oracle licenses for our environment
And we run through upgrade project so we had change the component used within the environment
We need to decide what license should we have and which we should release
New env is oracle rac db two nodes
Weblogic and forms and reports +ohs installed on two nodes
Works async
0
hello,

first time here so hopefully someone can help.
I have two tables in one table it has a column with a number of digits ie 1 to 34...
in the other table is a column in numbers that differ in various lengths.

without doing case statements for all 34 number is there another way to say if the column in table 1 has 4 and table 2 has 3 digits can you format the number to look like 4 digits

another example
column in table 1 has 10 and table 2 has 8 digits format the number to look like 10 digits with leading zeros.

Many thanks

Mac
0
Efficient way to get backups off site to Azure
LVL 1
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

How do i disable all DB links in oracle database .
can you show with example . I am using SQl developer tool
0
I had this question after viewing ODBC in excel 2016 in Windows 10 via VBA.

Any of you find the solution, please hep what was it?

Many thanks
0
i have developed small application in oracle 10g forms 6i .it's working rightly but i want to acess that application from another client pc which reside on different network how it can be done .
plz help me.
0
i have 2 tables like

T1                       T2
-----                     ----

id  name              id  name                            
---  -------               ---- -------

10  xyz
20  abc

in this the first tabe (T1) id column data type is number

and second column(T2) id column data type is varchar2

Now,

I want to insert data from table T1 to T2

how can i insert
0
hello,
i am working on oracle 6i forms.i have a form named as ''add_inventory_item" now what i want is to store data through this form into database by using barcode scanner. how it can be possible?
please guide me,thanks in advance.
0
Hello Experts,

I have a view which is created based on a sql. Now I am trying to convert the same VIEW to materialized view.
Now using the same SQL I am getting the below error :

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 1

 Lines highlighted are :
     a.Fieldwork_Complete_Actual,
          CASE
            WHEN TRUNC (DAY_DATE) = TRUNC (LAST_DAY (SYSDATE))
             THEN
                'CURRENT'
             ELSE
                'HISTORY'
          END
             F_DATA_TYPE
     FROM (SELECT A.*,

Open in new window



And the SQL has 3 views where column "DAY_DATE" is used and the data type is date.
0

Oracle Database

78K

Solutions

25K

Contributors

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.