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]

Hello- When I recently synced my iPhoto library to my 1st generation iPod Touch, it would not sync SOME recent portrait-orientation photos. The photos not synced appeared to be only very recent ones (within the last week or so). Older events and impo [More]
My iMac hard disc is getting full so I bought an external hard disk. I changed my iTunes folder over to the external hard disc without any trouble and removed the old iTunes music folder as per directions. After that iTunes played fine, the next day [More]
Hi All, I am working on a std. SAP program (RPRAPA00) that will create a vendor for an employee record ... this program when executed will create a vendor for a selected employee and will transfer the HR master data for that employee to the vendor ma [More]
Hello, I have dowloaded a SAP IDOC into XI and build a mapping based on this IDOC. Now the IDOC is enhanced with a new (Z)segment and I have dowloaded the new structure again. But the new segment is not visible in the mapping based on that IDOC. Do I [More]
While trying to read from a socket, the data gets corrupted: First, from telnet, I send the length of the data: 12<enter> Then I send the data: this is some data The server only displays part of the data: �� = some unprintable character (I can't eve [More]
Hello, In the Financial statement through Tcode F.01 for FY-2010 showing Account i.e. 3xxxxxx Stock Account, showing some Value. I want to see details of G/L account Value, from which transactions Values are are flowing in 3xxxxxx Stock Account. Spec [More]
Hey everyone, i'm having some serious difficulty deploying an ejb application on bea weblogic. I cannot find the java application deployment tool, or any concise documentation for that matter. I have experience writing jsps, javabeans, servlets etc. [More]
Hi there I've got an Oracle VM 2.2.1 installation on an X4150 which has a few guests: RHEL5.6, Windows and Solaris 10. Both RHEL and Windows are performing really smoothly and as expected, however the Solaris guest starts fast but becomes unresponsiv [More]
I'd like to have more control over the Properties panel and when it appears. Is there a keyboard shortcut to Collapse/Expand the Properties panel? (I know about Ctrl-Shift-D, but that toggles through the open panels.) Is there a way to prevent the Pr [More]
i have garrys mod on steam and i also have counter strike but when i play on servers people have the word error in them its a giant red word and i dont know why also now its purple and black squares please helpThe giant error signs means you dont hav [More]