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]

Hi friends, Can anybody tell me how to define and where to define my web-application path in tomcat 6 server? I absolutely don't want to change any files inside tomcat6\conf\ folder (like its server.xml or context.xml) My problem comes in the followi [More]
Hello guys, I am creating a PO in reference to another PO and payment terms are copied from the old PO but not updating from Vendor Master. Our payment terms are changed very frequent and our users don't want to create a new PO with too many line ite [More]
HI, I have a requireent where i have to check the the user does not enter both Subitems and Over a Limit for a Service Purchase Requisition. Is there a User Exit or Badi that i can use where this information is availaible. also i have to check that r [More]
When I connect my SanDisk Firewire memory card reader to my Mac Pro, Lightroom doesn't open and the import dialog doesn't appear. This worked fine on my previous G5. iPhoto isn't opening either... nothing happens at all when I plug in the reader.Chri [More]
I am designing the layout for a 8.5" x 8.5" children's book to be uploaded to an online publisher, and they require a .25" bleed around all the outside edges, except for a no ink area of .125" on the bind side. The document must be set [More]
Hi, Does anyone know how to look up the values in a waveform graph with a mouse click but... without the cursor legend on, if i press in the waveform graph nothing happens, i must search my cursors and only then i can see the values of my signal data [More]
Hello     We have a requirement to connect PI7.0 to PI7.1 with SOAP over HTTPS. Would you please let us know what all configuration need        1.  Setting required to be done on PI7.0 ( Communication Channels, Receiver and Sender agreements)        [More]
For the past couple of days, I have been running into the "IOException in sending Request :: Connection refused: connect" error. I am running 10.2.01 on Windows 2003R2. Along with this error, the DB Control shows agent unreachable. Is there anyt [More]
I extand some materials for another plant. i also maintain Valuation class, valuation category and valuation type in material master. When i create sales order and deliver it system is not picking valuation type automatically in delivery document due [More]
Hi I am very new in Visual Composer. I develop a simple model in it and successfully able to compile it using flash compiler. But when I am deploying it, I am getting error "protal request failed (no specific exception )". I also checked the log [More]