| ERROR CODE:1072896760 [message #467446] |
Sat, 24 July 2010 05:34  |
manisha_borade
Messages: 49
Registered: May 2010
|
Member |
|
|
hi
i create one report(.rdf) and registered on oracle application.
for that i create executable and concurrent program (output format is XML). i dont create data definition and template for this(i.e. i dont create .rtf ).
is it possible to open my output of rdf file in xml spreadsheet.
it show mw the error .....
ERROR CODE:1072896760
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: ERROR CODE:1072896760 [message #467883 is a reply to message #467882] |
Wed, 28 July 2010 00:34  |
manisha_borade
Messages: 49
Registered: May 2010
|
Member |
|
|
I am attaching code contained in rdf...
The output is come correctly when i given the input parameter...but if i did not give any Input parameter then accordingly code it need to show all data in XSL sheet but at this time it showing error
ERROR CODE:1072896760
As i shown in previous attached document.....
Please suggest me direction to resolve this error........
SELECT b.segment1 "ITEM CODE",
b.description "ITEM DESCRIPTION",
mcb.segment1
|| '.'
|| mcb.segment2
|| '.'
|| mcb.segment3"ITEM CATEGORY",
b.list_price_per_unit "UNIT PRICE",
b.PRIMARY_UNIT_OF_MEASURE "UOM",
gcc.segment1
|| '.'
|| gcc.segment2
|| '.'
|| gcc.segment3
|| '.'
|| gcc.segment4
|| '.'
|| gcc.segment5
|| '.'
|| gcc.segment6
|| '.'
|| gcc.segment7 "CHARGE ACCOUNT",
decode(b.SERIAL_NUMBER_CONTROL_CODE,1,'No','Yes') "Serial No. Enabled"
FROM mtl_system_items_b b,
mtl_category_sets_b mcsb,
mtl_category_sets_tl mcs,
mtl_categories_b mcb,
mtl_item_categories mic,
gl_code_combinations gcc,
hr_all_organization_units hou
WHERE mic.category_set_id = mcsb.category_set_id
AND mcsb.category_set_id = mcs.category_set_id
AND gcc.code_combination_id = b.expense_account
AND b.organization_id = mic.organization_id
AND b.inventory_item_id = mic.inventory_item_id
AND mcb.category_id = mic.category_id
AND b.organization_id = hou.organization_id
AND hou.NAME = 'TDN Item Master'
AND TRUNC (b.creation_date) = NVL (:creation_date, b.creation_date)
AND b.segment1 >= NVL (:from_item, b.segment1)
AND b.segment1 <= NVL (:to_item, b.segment1)
AND gcc.segment1
|| '.'
|| gcc.segment2
|| '.'
|| gcc.segment3
|| '.'
|| gcc.segment4
|| '.'
|| gcc.segment5
|| '.'
|| gcc.segment6
|| '.'
|| gcc.segment7 =
NVL (:charge_account,
gcc.segment1
|| '.'
|| gcc.segment2
|| '.'
|| gcc.segment3
|| '.'
|| gcc.segment4
|| '.'
|| gcc.segment5
|| '.'
|| gcc.segment6
|| '.'
|| gcc.segment7
) |
|
|
|
|
|
| Re: ERROR CODE:1072896760 [message #467911 is a reply to message #467885] |
Wed, 28 July 2010 04:27 |
 |
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
|
Senior Member |
|
|
Google says this is because of invalid character in the xml.
I suspect the value of description column.
XDO Invalid Char patches
--------------------------
5987839
6773291
7339075
Also check $APPLCSF/$APPLOUT/o<request_id>.out -- replace request_id with the concurrent program request_id.
Try to rename the extension to xml from out and try to open in any browser, which gives the error line number.
Open the file in text (notepad/wordpad/textpad/etc) and check the data in that line.
By
Vamsi
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
