Wednesday, December 12, 2012
Friday, December 7, 2012
Use Secondary Index in program to fetch data
Issue :
To make the program to pick the data from the database using the secondary index
Sol : %_HINTS ORACLE 'INDEX("table" "table name~index name")'.
Sol : %_HINTS ORACLE 'INDEX("table" "table name~index name")'.
Thursday, November 15, 2012
Thursday, October 25, 2012
DART View not visible when transported to other system
Issue : Dart view when transported from Dev to Qa or PRD will not be visible to extract the data.
Dart view when transported will be inactive state, we need to go to FTWY and activate it.
Tools->Administration -> Data Retention Tool ->Configuration ->Define data extract Views
SMART FORM while printing, only 1 page is getting printed pages are getting overlapped
Issue : When the sale order was seen in the print preview then it was displaying in 2 pages, when the same was printed then two pages were printed in same page causing the issue as below
This issue got solved by changing the page format in the spool
SP01->->Spool Request (Menu) ->Print->Print with change parameters
When changed the FORMAT to another the spool was printed in 2 pages, by this I confirmed the issue is with page format.
Page Format declaration: SMARTFORMS-> (Form name)->Form attributes->Output Options
How to check the missing?
SPAD->Full Administration->Device types->SWINCF (LOCL in ECC) ->Format (Menu) ->Double Click to check
This issue got solved by changing the page format in the spool
SP01->
When changed the FORMAT to another the spool was printed in 2 pages, by this I confirmed the issue is with page format.
Page Format declaration: SMARTFORMS-> (Form name)->Form attributes->Output Options
How to check the missing?
SPAD->Full Administration->Device types->SWINCF (LOCL in ECC) ->Format (Menu) ->Double Click to check
Tuesday, July 10, 2012
ALV Errors
ALV errors can be majorly corrected by the changing the field catalog.
Errors observed
Errors observed
·
When alv output is transferred to EXCEL it was going to dump
Sol: Do consistency check by clicking the (Shift+2 right clicks), it will display fields which are not assigned properly define them or remove unwanted fields.
Sol: Do consistency check by clicking the (Shift+2 right clicks), it will display fields which are not assigned properly define them or remove unwanted fields.
·
When summing a column in ALV the output is going to dump MESSAGE_TYPE_X
Sol: This might be due to wrong assignment of fieldcatlog; check the field name and field catalog are same and do changes accordingly
Sol: This might be due to wrong assignment of fieldcatlog; check the field name and field catalog are same and do changes accordingly
Subscribe to:
Posts (Atom)

