Stack Overflow
Stack Overflow

Questions tagged [oracle-apps]

Oracle Applications are applications that address specific category-based business requirements such as customer relationship management, financial management, governance, risk, and compliance, project management, and more.

Oracle Applications is a packaged Enterprise Resource Planning solution. It has things that organizations could need to run their business. All the business flows are categorized and coherent activities are organized into modules of Oracle Applications.

Overview: https://www.oracle.com/applications/

155 questions
8
votes
1 answer

Why doesn't Oracle have foreign keys in Oracle Apps/ E-Business Suite?

Why doesn't Oracle have foreign keys in Oracle Apps/ E-Business Suite? I observed that Oracle doesn't have/use referential constraints on the Oracle Apps 11i Schema. All the logic is contained in PL/SQL packages. This seems odd coming from a RDBMS…
Padmarag
  • 7,067
  • 1
  • 25
  • 29
6
votes
1 answer

How can I communicate with Oracle Financials api from .Net?

Oracle ERP exposes a set of API but does anyone know how to communicae with it? Is there any third party tools that could help? Please note I am not interested in Oracle database but Oracle ERP Financials. Thanks
ironpaw
  • 2,995
  • 3
  • 19
  • 10
4
votes
1 answer

Getting extra messages while executing a trigger

I'm facing a problem while creating a db trigger to raise an error message for oracle forms. Can you please help me out? My code is: CREATE OR REPLACE TRIGGER unsuccessful_attempts_lock BEFORE UPDATE of last_logon_date ON temp_user FOR EACH…
prashant1988
  • 262
  • 1
  • 8
  • 24
4
votes
4 answers

Issue while running UNIX shell script from Oracle concurrent Program

I am trying to run a HOST script which I have build in KSH shell using an Oracle Concurrent Program. My Test script is as follows: echo "System Parameters passed by Concurrent Manager" echo…
Arun Antony
  • 573
  • 4
  • 13
  • 26
3
votes
1 answer

How to restrict the access of concurrent program(Oracle report) to few users only?

I need to give Oracle XML report access to only some users and not responsibility specific.For eg only 3 users can run a particular concurrent program and no one else. Please suggest all the possible ways to achieve it.
Nikhil
  • 151
  • 1
  • 3
  • 20
2
votes
2 answers

How can a PL/SQL procedure tell if it is being run from a concurrent program?

I want to write a procedure that logs output to the Oracle concurrent manager log when run from a concurrent program, but writes to dbms_output when run "standalone". Is there a way from PL/SQL to check whether my code is being run from a concurrent…
Paul Moore
  • 6,569
  • 6
  • 40
  • 47
2
votes
1 answer

Oracle Applications - Next Step Attribute

When using the Oracle database frontend application, under the Shipping Transactions Screen, there is an attribute called "Next Step". This attribute sits next to the "Line Status" attribute. My question is, where does this attribute, "Next Step"…
421
  • 203
  • 1
  • 5
  • 13
2
votes
0 answers

Clear Query Table Result in OAF on page refresh

I have an requirement to clear the table search result on page referesh. I have added the below code in processRequest of my Controller but it is not working. My Page Structure looks like this: Note I have also tried to clear cache of tableBean…
pulse
  • 169
  • 1
  • 17
2
votes
3 answers

Writing to oracle logfile from unix shell script?

I am having a Oracle concurrent program which calls a UNIX shell script which will execute SQL loader program. This is used for inserting flat file from legacy to Oracle Base tables. My question here is, How do I capture my custom messages,…
Arun Antony
  • 573
  • 4
  • 13
  • 26
2
votes
2 answers

Oracle: error while trying to use formulas

I created an element with an input value of type "Day" , when i write a formula i get this error. Any idea what's wrong? APP-FF-33232: EATC_EXTRA_DAYS_ENTRY_EFFECTIVE_DATE_ENTRY_VALUE has null or not found allowed, but no default set…
Yazeed
  • 21
  • 2
2
votes
1 answer

Find programs whose schedule is lost/skipped/missed

I have around 350 concurrent programs which run with different schedules in Oracle varying from once in a week to once every minute. In the 350 programs, few programs have more than one schedule with different parameters. There is a weekly…
zephyrus
  • 261
  • 1
  • 6
  • 18
2
votes
1 answer

cannot find symbol symbol : method getDBTransaction()

I was trying to call a Concurrent Program from OA Framework. And here is the code. But I am getting following error: Error:: cannot find symbol symbol : method getDBTransaction() location: class _myclass OADBTransaction tx =…
Nidheesh
  • 4,390
  • 29
  • 87
  • 150
2
votes
1 answer

Oracle e business suite - UI label to database field mapping?

I am looking for some sort of a UI label:database field mapping that tells me which UI field corresponds to which database column in the backend. I am pretty sure that something like this must be existing in the Oracle e business suite... but my…
The Bad Wolf
  • 33
  • 4
2
votes
1 answer

Oracle GRCC Tcg data type issue

I am working with oracle GRCC Tcg Application version 8.6.4. I have created business object successfully on this Tcg application. After that I have created a model using that business object. While I'm trying to save the model, the following…
janani
  • 61
  • 1
  • 1
  • 6
1
vote
1 answer

opening oracle application in a browser

Is it possible to open oracle applications inside a browser itself instead of it opening a separate window? because if this is done than we can automate oracle applications using selenium. I'm using oracle applications 11.5 . Thank you
Tom
  • 411
  • 12
  • 28
1
2 3
…
10 11