Amicuk Programming Answers

Index > onvalid column name skey_val >

onvalid column name skey_val


Invalid column name 'SKEY_VAL' Error when Populating a planning dimension

Category:DefaultRelease time:2015-10-11Views:130

I'm trying to populate a planning dimension from a view in MSSQL. I thought that I had mapped the all of the required columns in my interface in ODI, but I am getting the following error: 207 : S0001 :[More]

Error when populating dimension

Category:DefaultRelease time:-0001-11-30Views:130

I encountered the following error when trying to populate a dimension in Analytic Workspace Manager: action BUILDDATABASE failed on object <analytic_workspace> Does anyone know what that means?1) No SKEY_VAL is not a variable. 2) This is my first at[More]

Re: Column is not getting displayed in the BI report

Category:DefaultRelease time:2015-10-11Views:130

Hello Gurus, I have developed a BI report with more number of parameters. Case 1: When i run my report , I am able to see data for particular condition but one column doesn't show any thing. All the rows in the column are blank. Case 2 I tried to put[More]

Query help: query to return column that represents multiple rows

Category:DefaultRelease time:2015-10-11Views:130

I have a table with a name and location column. The same name can occur multiple times with any arbitrary location, i.e. duplicates are allowed. I need a query to find all names that occur in both of two separate locations. For example, bob usa bob m[More]

Unable to capture the adf table column sort icons using open script tool

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I am new to OATS and I am trying to create script for testing ADF application using open script tool. I face issues in recording two events. 1. I am unable to record the event of clicking adf table column sort icons that exist on the column h[More]

Implementing BADI MD_ADD_COL_EZPS for MD04 custom column

Category:DefaultRelease time:2015-10-11Views:130

Hi there, I'm using BADI MD_ADD_COL_EZPS to display 3 new buttons and three new columns in MD04. For each line item that is displayed, the custom column is filled, after the button is hit -This works fine. My Question is: Is there any way to limit th[More]

APEX-The manullay created column is not getting updated in the database

Category:DefaultRelease time:2015-10-11Views:130

Dear all I have a form on page, which is created along with a report using Form on a Table with Report option. From the form I have deleted one field and recreated manullay as set the property as database column. When I am calling from the report pag[More]

Not null and enable or disable  column in tabular form

Category:DefaultRelease time:2015-10-11Views:130

Hi, Using apex version 4.1 and working on tabular form. ACT_COA_SEGMENT_MAS is Master table and ACT_SEGMENT_VALUES_MAS is detail table I have entered 8 rows in master table and PARENT_SEGMENT_ID is column in master table which is null able. If i spec[More]

Converting null and blank to NA in a column of a database table

Category:DefaultRelease time:2015-10-11Views:130

Hi This is a simple thing but is giving me a hard time. I need to change the values coming as null or blank to NA . The values comes in a flat file as a source and I need to laod it convertign to NA in database. I wrote the expression as ISNULL([NPS[More]

Get column values from list of values programmatically

Category:DefaultRelease time:2015-10-11Views:130

hi all how i get column values from list of values programmatically in the returnPopupDataListener methodIf this answers your question , please close this thread by marking it as answered. ThanksRead other 4 answers[More]

How to delete file from column after upload with messageFileUpload?

Category:DefaultRelease time:2015-10-11Views:130

Which is the way to delete a file from column i have uploaded with messageFileUpload. After uploading the system generates a link to download the file. But how i can delete the file?Thank you! Syncing has always scared me...basically I am just afraid[More]

In ALV report is possible to display the subtotals in separate column

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have made one ALV report, i need to show the subtotals of ekpo-brtwr (Gross Value)  grouped by or sorted by ekko-ebeln (Purshasing Doc) but in separate column  not at the end of the line items of each purshasing doc any idea how can i do this?[More]

How to rename C00n generic column names in a Dynamic SQL report

Category:DefaultRelease time:2015-10-11Views:130

I have a an interface whereby the user can select 1 to 60 (upper limit) columns out of 90 possible columns (using a shuttle) from one table before running a report. To construct the SQL that will eventually execute, I'm using a "PLSQL function body r[More]

Add Image column in classic sql report to open a pop page

Category:DefaultRelease time:2015-10-11Views:130

I have sql report I want to add a new column which will have image to click, Once user clicks the image a popup page should open.Hi Vikram, Sorry to bother you, I am very new to apex. Here is my sql query for sql report. Can you please help me. <xmp>[More]

Discoverer  report does not sum up the column

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I am running the discoverer report from discoverer desktop and was trying to use the sum function to sum the total amount of the report. The sum function does not work and it only display Cell Sum: (blank) with no actual data. When i checked[More]

Interactive report column filters to display differently than column values

Category:DefaultRelease time:2015-10-11Views:130

Greetings... We use images a lot in our interactive reports to provide a visual representation to a status, or something locked for update, or what-have-you. By default, when a user clicks the column heading of a column which contains images, the dro[More]

How to open a popup win within a PDF file (c:\test.pdf) as Column Link

Category:DefaultRelease time:2015-10-11Views:130

I have a interactive report based on a Table (EMP). I need to create a column link that opens a pdf file within the employee curricula All the curriculum are stored in a windows folder, and in the EMP table there is a field named PATH containing the[More]

How to make column headers in table in PDF report appear bold while datas in table appear regular from c# windows forms with sql server2008 using iTextSharp

Category:DefaultRelease time:2015-10-11Views:130

Hi my name is vishal For past 10 days i have been breaking my head on how to make column headers in table appear bold while datas in table appear regular from c# windows forms with sql server2008 using iTextSharp. Given below is my code in c# on how[More]

XML Publisher Report:how to disappear the column if no data found

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have a XMl publisher report requirement , the format is tabular lets say with the structure of 4 columns and 10 rows.requirement is to if suppose there is no data for row number 6 the row itself should not appear over the report and the immedia[More]

How to get multiple records in one row and different column

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I am using oracle database 11g and i have a two tables table_1, table_2 table_1 having columns emp_no first_name middle_name last_name email and table_2 having columns emp_no phone_type phone_number and having entires emp_no phone_type phone_[More]

Very frustrating! I am using OS 10.4.5, iPhoto 5.0.4 and Mail 2.0.7. When I select a picture on a slideshow in Mail to send to iPhoto, it looks like it's being sucked up and iPhoto opens but the picture does not appear in the Library of the iPhoto ap [More]
Hi, I want to create a method and pass a select-option to it. How to declare the parameter for this method. regards, Navneeth K.Hello Navneeth Sorry for the delay (I could not reply in the morning). However, here is a sample report showing how class [More]
Hi, My scenario is Fiel->XI->File with enhaced receiver determination that is i should get the receivers dynamically at runtime. I gave Operation mapping in Receiver determination and created all other objects. Even if i check message mapping i am g [More]
I've been building pages for a website on my old Mac with Photoshop CS1 then slicing and optimising them in ImageReady before uploading to the site I'm building in Dreamweaver where I put in the body text. Recently I upgraded to a newer Mac running S [More]
It happens just after the installation (BTW the .bat don't like path with space like "Program Files" :-( When I try to run the studio tool it fail to open. The error message is "Cannot find main class. Program will exit!" Thank you, He [More]
I am attempting to burn a DVD that has 4.6G of data in the meter. It's chaptered out and ready to go. When I hit the burn button it goes through all the compiling stuff, then at the end gave me an error message I have taken a snapshot of below. Any i [More]
UEsDBBQACAgIANlBmEUAAAAAAAAAAAAAAAAIAAAAMjAxNDEyMjQBIATf+2aGlSzSKX+B6hGlGQmw 746ZnYB8N63vNf0W2y5r0Ck9kp3iG42pnbaw4adXk9t5ViJwzajJY/QjnuTNtqS+TTPY437/1Ffy A1PhQkOhEcD22c2F+wCcgzDLYbylZHZ/bLATrwm5YAy5Nu3WqbYg1Z+kgwsGC17dF5yXN+W011Dw ltMAHDFTwpidp/iHwZ1 [More]
I received a .swf file with connection via .ASP pages to a SQL-Server Database and want to change the environment to an Oracle 9iAS Database. Since .ASP pages do not work in Oracle 9iAS : How can I manage to access the Oracle Database on the [More]
I need best practices for loading a number of messages/transactions from SAP into a single flat file (i.e. similar to an ETL tool)?  Can this be done "out of the box" or do I need to build custom ABAP or JAVA code to build this file with a numbe [More]
And how do I use them? Do I need to register for a special account somewhere?Hi Slurpie: Bonjour is a local IM client that let you connect to other computers on your local network. I.E. At work or your home network only-Whatever network you may be lo [More]