1,145 questions
1
vote
1
answer
78
views
When running java against a jar java2d is not being found? [duplicate]
I am using client host commands from powershell to launch a Oracle forms FSAL via the following command:
java -jar "fsal jar location" -url "url"
This command works except there ...
- 200
0
votes
0
answers
51
views
oracle forms stacked canvas is visible but content canvas is not
When I change a display item to a text item (for a data block) I can no longer see my content canvas.
I have an Oracle form that works; Content canvas and stacked canvas.
The query mode is a table and ...
- 1,833
1
vote
0
answers
50
views
JSON_ARRAYAGG identifier must be declared in Oracle Forms 14c
I'm encountering an error in Oracle Forms 14c when trying to use the JSON_ARRAYAGG function:
identifier JSON_ARRAYAGG must be declared
Here's the context:
Oracle Forms version: 14c (14.1.2)
...
0
votes
0
answers
22
views
RAD (Remote Access Descriptors ) in OPSS schema
[ Remote Access Descriptor (RAD) entries in Oracle Platforms Security Services (OPSS). - when we create RAD in the EM console, where exactly it stored ? in which file and which location in weblogic ? ...
- 1
0
votes
1
answer
156
views
Oracle Forms Java Importer not detecting my JAR files
Currently, I am trying to implement a simple REST API trigger upon a button click on Oracle Forms.
import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.net.HttpURLConnection;
...
0
votes
0
answers
59
views
when validate item did not work in form 6i
See my simple code in form 6i for checking the barcode scanning.
I am trying to check when textbox length is ten then show a message but it did not work when the validate item triggers:
if Length (:...
0
votes
0
answers
102
views
CURENT_DATE does not return the date and time in the local time zone in Oracle Forms
We are moving our Oracle Forms application to OCI (Oracle Cloud Infrastructure) which always runs in UTC time. Previously all our servers were in our local time zone, so we didn't need to be concerned ...
0
votes
0
answers
24
views
Oracle Forms 6i, information deletes itself
I started working in a public water treatment company, where they use Oracle forms 6i to generate reports, they are in the process of making an upgrade to the system, but something strange happens ...
0
votes
0
answers
512
views
Using FND_FUNCTION.EXECUTE
I use FND_FUNCTION.EXECUTE and the function I want to call comes without any problems and I can perform my operations there. But when I close the function I called, it does not run the codes below ...
- 11
0
votes
1
answer
65
views
I'm making a school project in Oracle Forms 10g. I want to assign subjects to class using LOV and filter out that subject when the LOV is called again
I don't want to show the subjects in LOV after they are selected once
I tried the following SQL for record group; the subject_id goes to class_info block after selecting a subject from LOV.
select ...
- 3
0
votes
0
answers
90
views
problem with procedure choose_org, i can't see list of value always when i open the forms
I'm new in oracle forms. I have a form and when i open the form i see LOV (pre-filter)to choose organization, and after all informations of forms. But when i try to open this form again i don't see ...
- 1
0
votes
1
answer
623
views
how to save a report in the local system in Oracle 12c
how to save a report in the local system in Oracle Forms 12c. Like in Forms 6i, we are using the run_product() procedure to save a report in the local system
pl_id := create_parameter_list('us00300p');...
- 11
0
votes
0
answers
2k
views
frm-41213 cannot connect to Report server 12 c from oracle Form
--- Print Code in oracle form after Push button Pressed
PROCEDURE PRINT_1 IS
report_id REPORT_OBJECT;
ReportServerJob VARCHAR2(254);
BEGIN
report_id := find_report_object('REPORT191'); ---...
0
votes
1
answer
671
views
Oracle Form giving error when trying to insert data into table
I have created an Form with Oracle Form Builder, when trying to insert data through the form in my DB table. Although Data is getting inserted and the success message kept by me is also comming but ...
0
votes
1
answer
2k
views
ora-04067 not executed package does not exist
While loading oracle form application, users are getting the below error
ora-04067 not executed package "XYZ" does not exist
I have checked the package and package body (XYZ) and it is ...
- 345
0
votes
1
answer
419
views
How to draw charts(Graphs) in Oracle Form (11g & above)
i want to draw charts(pie and
bar charts ) in oracle form
builder using bean component in oracle form block.
SET_CUSTOM_PROPERTY()
using bean property as mentioned above. If anyone refers to or share ...
- 3
0
votes
1
answer
292
views
Issue displaying Oracle 10g Reports generated PDFs in Google View (gview)
I am experiencing difficulties when trying to display Oracle 10g Reports generated PDFs in Google View (gview). Crystal Reports generated PDFs open successfully using the following URL format:
https://...
-2
votes
1
answer
366
views
How to get data from a row of a table from a checkbox?
I have a table with many rows, and one of the columns has a checkbox for each row. How do I access the row data through these checkboxes when they are checked? Can anyone help me please??
- 17
0
votes
1
answer
885
views
Oracle Forms - Compile forms on Windows platform - Redirect errors
I'm using frmcmp.exe (12.2.1.4.0) to compile forms on Windows.
I enter the required information thru the displayed form.
Let say I enter a wrong user/password / missing TNS... An error window will be ...
- 13
0
votes
2
answers
1k
views
How to use trigger KEY-ENTER in Text Field Multiple Line Oracle Forms
1./ Could I ask about Oracle Forms,
I have a Text Field with Multiple lines in Oracle Forms,
when I input the value and click Enter then will move the new line inside the text box,
But I want to click ...
- 151
0
votes
1
answer
630
views
Oracle Developer 10g works on Oracle Dtabase 21c XE?
I want to connect my oracle database 21c xe with Oracle Developer 10g (forms/reports)?
0
votes
0
answers
81
views
Using subquery in insert statement(Oracle Forms Builder)
I'm new to database and form builder .
I'm getting:
Error 103 at line 10, column 2
Encountered the symbol "SELECT"...
Whats the correct syntax for that please?
INSERT INTO vehicle (
...
0
votes
1
answer
243
views
Populate data from DB and save as new record oracle forms
I Have populated master detail block from Data based want to change some values in data block and save it as a new record in Both master and child tables.
To Populate used execute query
Changed values ...
- 33
0
votes
1
answer
406
views
where to find where the value for the diplay block is coming from
How do I find where the value for a display item in coming from in Oracle forms? The property pallete shows the database item is null, as it's a display item. I need to know which column/table ...
0
votes
1
answer
270
views
how to pass selected drop-down list value to a variable or data block to execute a query
I have a form and I a dropdown pop-list with year values in it(year field is not a primary key).
I have to fill all other field values when i select a year from dropdown(need to execute query of ...
- 61