I have written this code below in Disco Admin 10g but get Ora-00918 column ambiguously defined error even though I have used alias in the table name.
Select
porh.segment1
,Porh.creation_date
,Porh.last_update_date
,porh.closed_code
,porh.authorization_status
,porh.description
,porh.note_to_authorizer
,porh.cancel_flag
,porh.enabled_flag
,porl.line_num
[code]....
I am getting ORA-00918: column ambiguously defined error when running the below SQL query. I am gettig this error at the last line of code where v1.objectid=v2.parent_object_id
I have not written this query so i find difficult to debug it. Also i am not that well verse with SQL
select distinct v1.UNIQUE_DOC_NAME,v1.UNIQUE_DOC_NAME_1,v1.vendor_object_name,v1.display_name,v1.document_description,
[Code].....
I have no knowledge about Barcode. The problem is an issue of Loyalty Cards of a Hotel and Restaurant to various customers and then these cards will be presented by the customers time to time in the Hotel as well as Restaurant. The Owner of the Hotel and Restaurant wants to generate separate barcode for each card and when this card will be presented then the bar code reader will readout the code and the system will calculate the amount of discount/rebate. Because if the data entry operator enter the code of the card through key board the it will be a chance of leakage or misuse of that card.
View 8 Replies View RelatedI Created a Bind parmeter in report .....but when i run report it show only loc bind parameter not fyyear bind parameter...
Code is :
SELECT distinct BPT_LOC Location, BPT_DOC_DT BNP_REF_DT, BPT_DOC_NO BNP_REF_NO,
BPT_VEN_NM Vendor_Name,
BPT_BIL_NO Bill_No, BPT_BIL_DT Bill_Date ,
E.BMDT_CNTRCT_CD CONTRACT_NO,
BPT_NET_VOU Total_Amount, BPT_SAL_RT VAT_AMOUNT,
[Code]...
I dont know where was the mistake, getting column ambiguously defined error
CREATE OR REPLACE PROCEDURE FLXUSER.testgg
AS
BEGIN
/*----------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------*/
BEGIN
[code]....
i have a Field item on my report which i would like to show "Price INCL of VAT". Any PL/SQL code or trigger to do this? VAT is 16%
I'm a Forms programmer, not so familiar with Reports.I suspect, it should be something like this:
F_1 := F_1 * 1.16
We are converting Oracle 6i reports to 10g. I have a report with a button on it that when clicked, it runs PL/SQL code in a program unit defined within the report. The only documentation I have run across says to replace buttons with a hyperlink but this seems to refer to when a report calls another report. This is not the case for this situation.
The button on the report came into 10g as a Text Item. I tried applying the following documentation to the hyperlink property:
"Example 5: Static hyperlink The following example shows a value for the Hyperlink property that specifies a link to a destination identified as LINK1: #LINK1"
The program unit is named: U_UPDATEBUTTONBUTTONACTION and I referenced it as #U_UPDATEBUTTONBUTTONACTION in the hyperlink property.
The open browser window is not what I need.
Printing a bar code (such as a pick slip number e.g. 223456) in Oracle Applications 10.7 char, reports 2.5 on a genicom (dot matrix)..I was unable to find any fonts for this when I searched.
View 3 Replies View RelatedI'm using Report Builder 9.0.4.0.33.
I am creating a report which generates the data to a PDF/CSV based on users Input.When I create the report using Report Builder and execute the report,Delimited data appears in a PDF layout.
But if I add the below code in After Parameter Form trigger,the column headers keeps repeating with the data.
function AfterPForm return boolean is
begin
IF :P_DESTYPE = 'CSV' THEN
:MODE :='DEFAULT';
:DESFORMAT:='DELIMITED';
Elsif :P_DESTYPE = 'PDF' THEN
:DESTYPE := 'CACHE';
:DESFORMAT:='PDF';
END IF;
return (TRUE);
end;
[code]....
But the PDF output seems fine where the header is shown only once.I could see many posts regarding this in Oracle reports 6i wherein delimited_hdr=no is used in Command Line but I would like to know the work around in Oracle reports 10g.
I want to show closing balance as opening balance by using place holder column
example
Date opbal sale closing bal
01-jun-2013 0 10000 10000
02-jun-2013 10000 5000 15000
how to do this
I receive the error,
REP-1241 Circular column dependency originating with column 'cenvat_opening'
I have the following return statement for a column total_credit;
function total_creditFormula return Number is
begin
Return (return nvl(:cf_cenvat_closing ,0) - nvl(:cf_duty_on_goods_ed,0);
end;
Now i am using this total_creditFormula for the error formula column 'cenvat_opening'
function cenvat_openingFormula return Number is
f_num_opn number(14,2);
begin
SELECT NVL(Amount,0) INTO F_NUM_OPN
[code]...
here the formula column 'total_credit' has the following return statements;
RETURN Nvl(:cenvat_opening,0) + Nvl(:cenvat_credit_manu,0)
so how can i use this formula column? is there any other option to return the value in the same column.
i have two questions.
(1) how can i fill some value in a table column based on some existing column value automatically without user intervention. my actual problem is i have 'expiry date' column and 'status'. the 'status' column should get filled automatically based on the current system date. ex: if expiry date is '25-Apr-2011' and current date is '14-May-2011', then status should be filled as 'EXPIRED'
(2)hOw can i build 'select' query in a report (report 6i) so that it will show me list of items 'EXPIRED' or 'NOT EXPIRED' or both expired and not expired separately in a single report based on user choice. 'EXPIRED' & 'NOT EXPIRED' can be taken from the above question no. 1.
This is what i want to do:
I have a basic report looking like this:
<Column name>
value 1
value 2
value 3
.
.
.
value n
Since the column is small it can fit in a page more then one time. I know how to make it print more then once: i switch the repeating frame to print down and across and i modify the frame that contains it so the horizontal elasticity is variable.
After these changes my report looks like this:
<Column name>
value 1-----------------------value n+1-----------------------value m+1
value 2-----------------------value n+2-----------------------value m+2
value 3-----------------------value n+3-----------------------...
.------------------------------- .
.------------------------------- .
.------------------------------- .
value n-----------------------value m
What i want is my report to look like this:
<Column name>-------<Column name>------------<Column name>
value 1-----------------------value n+1-----------------------value m+1
value 2-----------------------value n+2-----------------------value m+2
value 3-----------------------value n+3-----------------------...
.------------------------------- .
.------------------------------- .
.------------------------------- .
value n-----------------------value m
While executing the query i got an error saying "ORA-0092 - invalid sql query"
SELECT
S.user_je_source_nameSource,
B.nameBatch_Name,
B.default_effective_dateBatch_Eff_date,
B.posted_dateBatch_Posted_Date,
B.default_period_nameBatch_Period,
[code].......
How can I apply a user metric for DB (single database) using a script or cli?
clear my question:
Can I create a User Defined Metric using SQL code, and not via the graphical interface?
I am using windows 7 and running report from report builder 6i. I got this message error report builder has stopped working. And when i press on show problem details i got this info
Problem signature:
Problem Event Name:APPCRASH
Application Name:RWBLD60.EXE
Application Version:3.0.0.0
Application Timestamp:39c93f24
Fault Module Name:UIW60.DLL
[code].......
Read our privacy statement online:
[URL]........
If the online privacy statement is not available, please read our privacy statement offline:
C:Windowssystem32en-USerofflps.txt
We are using APPS 11i, Yesterday some Report are end with Error. Error Details Given Below.
X Error of failed request: BadWindow (invalid Window parameter)
Major opcode of failed request: 15 (X_QueryTree)
Resource id in failed request: 0x2600001
Serial number of failed request: 614
Current serial number in output stream: 614
I am doing report migration from 10g report to 11g version 11gR2(11.1.2.0.0). It is not converting into REP when I check the logs . I got compilation error, then I convert 10g RDF to 11g RDF and try to compile it in 11g report builder developer tool, It is giving me compilation error.
It is not allowing me any sql in that proc but if i comment it it get successfully compiled and if the same report i open with oracle report 10g it get successfully compile.
Command using for Conversion:
rwconverter userid=<schema_name>/<schema_name>@tns batch=yes source=<source RDF path> stype=rdffile DTYPE=REPFILE dest =<Dest RDF/REP Path> OVERWRITE=yes
I want to create matrix report with 2 column
we can assign one column in matrix report my req is to assign 2 column .
example
Row Is FND
columns are Cdate & Ldate
Cells are Crate & Lrate
CDATE CDATE CDATE CDATE LDATE LDATE LDATE
FND 01-MAR 02-MAR 03-MAR 04 MAR 28-FEB 31-JAN 31-DEC
-------------------------------------
ABC CRATE CRATE CRATE CRATE LRATE LRATE LRATE
ABC CRATE CRATE CRATE CRATE LRATE LRATE LRATE
ABC CRATE CRATE CRATE CRATE LRATE LRATE LRATE
XYZ CRATE CRATE CRATE CRATE LRATE LRATE LRATE
XYZ CRATE CRATE CRATE CRATE LRATE LRATE LRATE
XYZ CRATE CRATE CRATE CRATE LRATE LRATE LRATE
display values in descending order( as got from fomula column). i put that field in above group and got properly. now i want to sum these values at the end of report. its going to some distinct values, while i want all values to be sum.
View 1 Replies View RelatedI would like to know how can i add a column in existing report. I try to change SQL by doing this it does add that new column into group but when i try to run report i can not see that changes . then i try to do some changes in paper layout but i am not able to bring the changes in out put. i am new to this FORMS Reports . do i have to create a group again i am how can i change the layout in that report.
View 4 Replies View RelatedHow can i stretch field dynamically as per the requirement.
i use horizontal elasticity and also format trigger on the field but cant find the expected output.... How can i achieve the same...
1 problem regarding to oracle report 6i.
I have to hide a repeating frame based on different condition
like DEPTCODE = 1 THEN
return('true');
else
return('true');
end if;
there is 4 record when we select DEPTCODE = 1 and there is 25 records when we select DEPTCODE = 2
now my problem is when I choose DEPTCODE=1 the summary of that report like sum of sal, avg of comm is calculated based in all 29 records.
it happen because of all the summary column is placehoder column not CS.
the calculation of all placehoder column is complex I cant convert it in simple CS.
so how can it possible when i choose DEPTCODE=1 and it shows me summary of only 4 records.???
While calling a report I am getting the following error.
REP-546: Warning: The value of restricted LOV parameter TOPROFIT is not among the selectable values.
When I call the same report through another PC it displays parameter form.
I am using Report Builder 10g.
following is my code written in formula column
function CF_1FORMULA0006 return Char is
v_user_id number;
u_name varchar2(100);
begin
fnd_profile.get('user_id',v_user_id);
select user_name into u_name from fnd_user
where user_id =v_user_id;
return u_name;
end;
getting no data found error.
I was having report server running well on my oracle database db1.
Now, I created new database :When trying to run the old report server it gives me error.
How could I uninstall the report server and install it again??
every time user run the report they have got an error like unable to run report.
select b.branchdesc ,
c.description ,
d.groupgldesc ,
a.loanno,f.agreementno,
e.customername ,
(sum(a.dramt) - sum(a.cramt) ) diffamt ,
a.groupglid
[code]....
I want to design a report in different numeral(English,Arabic). I am using application server as a middle tier.
Like
empno name salary english salary arabic
34232 John 5000 in arabic digits
45454 Clark 6500 in arabic digits
I have already change environment as a parameter Eng to Arb or vice versa. but i need both language digits at a time.
I have wrote this code behind a formula column which take the image from a server. The name of the image and location is carried out from database. When ever there is new record new name of the image is posted in this formula column. But when the file is not present in the location it gives error. When the error occur i cant able to view the report. The error says 'You cant run the report without layout'. When all images are present in the directory then report runs fine.
function CF_QID_IMAGE return Char is
l_file_exists BOOLEAN;
l_file_len NUMBER;
l_blocksize BINARY_INTEGER;
image_link varchar2(50);
[code]...
I am facing a problem in leave_form report! want to show employee's previous leaves detail (leavedate,leavetype), i don't want to show leavetype 'PPP' repeating frame type is Across/Down, there are 22 records of leavetype 'PPP' and one record of leavetype 'CL'
problem is report is showing 22 records of leavetype 'CL' of same leavedate!
i want that report should show the actual leavedate and leavetype records.using 9i database 6i developer server2003
For leavetype
FUNCTION Cf_1formula
RETURN CHAR
IS
v_leavetype CHAR(40);
BEGIN
SELECT LT.description
INTO v_leavetype
FROM hrm_attendance L,
hrm_leavetype LT,
hrm_employees E
[code]....
