Home » Applications » Oracle Fusion Apps & E-Business Suite » ERROR CODE:1072896760
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
)
|
|
|
|
|
Goto Forum:
Current Time: Thu Apr 17 04:07:58 CDT 2025
|