How can we debug order report ?I ran the report, data is populating to RPT table, but not writing to XML.I want to check the step by step execution of RPI. Please suggest
I want to add below column “Contribution Margin Rate” to a quick report….where would I find them to pull them in. @ZTC ZTC JGOTA Thanks,Srini
Hi Team, I want to extract a particular word from a string, I am using “regexp_substr”, but its not giving result as expected. TAB_NAME : Test TABLE IC_X_CUST_HEADER_F_123_TAB A, CUSTOMER_ORDER B, LEFTJOIN (PURHCASE_ORDER_LINE) From above text, I want to extract the word ‘IC_X_CUST_HEADER_F_123_TAB” , so I wrote below logic. SELECT regexp_substr(t.tab_name,'ic_[A-z]+[0-9]+) AS output FROM IC_TAB_LIST t; But, its not giving result. can anyone suggest ? Thanks,Srini
Hi All, I want to give grant permission to tables which are more in number. I have executed below logic , it is throwing below error “Encountered the symbol “GRANT” when expecting below “ Code used : DECLAREBEGINFOR R IN (SELECT TABLE_NAME FROM IC_TAB_LIST)LOOP GRANT SELECT ON R.TABLE_NAME TO IFSAPPEND LOOP;END Here : IC_TAB_LIST = Table name, which has around 300 tables where i need to give permission. Please suggest asap.
Hi Team, We are creating order reports , but instead of PDF the data should go into excel and send over the mail… Can anyone help with the solution Thanks, Srini
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.