Stack Overflow
Stack Overflow

Questions tagged [oracle-ebs]

Oracle's E-Business Suite (also known as Applications/Apps or EB-Suite/EBS) consists of a collection of enterprise resource planning (ERP), customer relationship management (CRM), and supply-chain management (SCM) computer applications either developed or acquired by Oracle. The software utilizes Oracle's core Oracle relational database management system technology.

172 questions
47
votes
2 answers

Suppress output of variables substitution in sqlplus

I'd like to suppress the output of such lines as the following ones old 9: AND FROMDAT <= TO_DATE('&duedate', 'YYYYMMDD') new 9: AND FROMDAT <= TO_DATE('20091031', 'YYYYMMDD') old 10: AND TODAT > TO_DATE('&duedate', 'YYYYMMDD') new 10: AND…
user321068
8
votes
1 answer

In the URL orgId, UserId, and User are not appearing in R12

In the R12.2.6 Oracle iProcurement screen I added one link like Catalog -- it's defined on the $OA_HTML/US/POPNEWS.htm page like catalog When I click the link in the URL it is…
F0cus
  • 585
  • 3
  • 18
  • 52
5
votes
2 answers

get_release Oracle API returning "Unknown" result instead of correct release

While executing below get_release function from apps user it’s returning the correct release: 12.1.3 , but when execute it from another user it’s returning Unknown result: declare l_release_name varchar2(30); l_other_release_info …
Wael Dalloul
  • 22,172
  • 11
  • 48
  • 57
5
votes
1 answer

Working with jDeveloper OAF and EBS

I have a new project and need modify a web page in ebusiness suite created with oaf, but dont know where to start. Just now. I have the jDeveloper with the corresponding patch to oaf framework, I set the .DBC file in my secure folder to connect to…
csrivera
  • 53
  • 5
3
votes
1 answer

HTML tags are getting converted

I have the following code snippet to have output from XML data which is stored in the database table ServletOutputStream os = response.getOutputStream(); String contentDisposition =…
Jacob
  • 14,463
  • 65
  • 207
  • 320
3
votes
1 answer

Advisable to put a Commit in an Oracle EBS Concurrent Program?

i just want to ask if its Advisable to put a Commit inside PL/SQL Procedure being called by an Oracle EBS Concurrent Program? I've always believed its bad practice to put commits inside the program for the following reasons: If the Program…
Migs Isip
  • 1,450
  • 3
  • 23
  • 50
2
votes
0 answers

How to make CORPORATE RATE TYPE the only option to choose in Oracle form?

So, there are four options in Rate Type field (spot, corporate, user and fixed) on the Invoice Workbench in OEBS. How do I make corporate rate type the main and default option and hide the remaining three. Thanks in advance! The Rate Type field …
Karina
  • 95
  • 2
  • 8
2
votes
0 answers

Recorder for Oracle form(Applets) Actions or Oracle JVM Hook

I making recorder which record actions on Oracle EBS forms, for this i hook JVM which is open by oracle applet(form) using Java instrumentation. I list the virtual machines and hook that machine which name contains…
Nitin Parashar
  • 227
  • 3
  • 13
1
vote
2 answers

Is there a table in Oracle Ebs that keeps the change log of the iban information?

I need to see when an iban changed in oracle ebs system. Is there a specific log table for that? SELECT * FROM iby_ext_bank_accounts I checked this table but ı couldnt find
Musa Keskin
  • 15
  • 4
1
vote
0 answers

How to add Java Library inside Oracle EBS r11 in order to use Java script in SQL

I have a java script and want to use it in SQL oracle but don't know how and where to add the 3rd java library in the server. I found one folder name lib Is it the right folder or there is another folder I can Idd? which I have the .jar file need to…
MK Said
  • 165
  • 8
1
vote
2 answers

Oracle Forms doesn't completely respect my setting for the background color of an item

I'm forced to use Oracle Form Builder 10.1.2.3.0. An ideal control I can use in the form for a particular item is a List Item using a List Style called Combo Box. Using this control, I can use set_item_property in a PRE-FORM trigger to set the…
Jeff Holt
  • 2,940
  • 3
  • 22
  • 29
1
vote
0 answers

OIM EBS Connector Upgrade

I am upgrading Oracle EBS (e-Business Suite) connector for OIM (Oracle Identity Manager) I am going through this case that when I upgrade the EBS connector, I am loosing the previous customizations. For example: Custom process forms are not getting…
identitymgr
  • 11
  • 1
1
vote
2 answers

How to set max_string_size='EXTENDED' in Oracle database?

What is the appropriate syntax to set max_string_size = 'EXTENDED' in v$parameter? I tried: ALTER SYSTEM set value='EXTENDED',display_value='EXTENDED' WHERE NAME='max_string_size'; But I get: ORA-02065: illegal option for ALTER…
alexherm
  • 1,362
  • 2
  • 18
  • 31
1
vote
0 answers

From where can we retrieve next_available_date for Available-to-Promise in Oracle-EBS?

I'm supposed to get next_available_date for an item from the backend. I'm able to see it in the frontend(application). The record history for that particular column is disabled. So I'm unable to figure from where they are getting it. I've checked…
Meghana Palaparthi
  • 11
  • 2
1
vote
1 answer

How can use an ORACLS EBS xmlreport parameters from a package-body?

I have recently created a report using Oracle E-business suite, a XML publisher report. In that report I have added 4 parameters and I need to use those parameters from a package body which is a custom request these are the parameters in my xml…
ssik
  • 31
  • 2
1
2 3
…
11 12