Thursday, July 31, 2014

XLS Mime type in Oracle

Ensure that the ‘XLS’ in the output type of the concurrent program is not already been created by navigating using the following:
 

  • System Administrator -> Concurrent -> Program -> Define
  • Click on the drop down list of concurrent program output and ‘XLS’ format should not appear.

If entry doesn't exist then run the following insert statements:

INSERT INTO fnd_lookup_values
(lookup_type, LANGUAGE, lookup_code, meaning, description,
enabled_flag, start_date_active, end_date_active, created_by,
creation_date, last_updated_by, last_update_login,
last_update_date, source_lang, security_group_id,
view_application_id, territory_code, attribute_category,
attribute1, attribute2, attribute3, attribute4, attribute5,
attribute6, attribute7, attribute8, attribute9, attribute10,
attribute11, attribute12, attribute13, attribute14, attribute15,
tag, leaf_node
)
VALUES ('CP_OUTPUT_FILE_TYPE', 'US', 'XLS', 'XLS', 'Excel Output',
'Y', NULL, NULL, 1,
TO_DATE ('31-MAY-02', 'DD-MON-RR'), 0, 0,
TO_DATE ('29-AUG-05', 'DD-MON-RR'), 'US', 0,
0, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL
);

INSERT INTO fnd_mime_types_tl
(file_format_code, mime_type, LANGUAGE, source_lang, created_by,
creation_date, last_updated_by,
last_update_date, last_update_login, description,
allow_client_encoding
)
VALUES ('XLS', 'application/vnd.ms-excel', 'US', 'US', 0,
TO_DATE ('22-DEC-13', 'DD-MON-RR'), 0,
TO_DATE ('22-DEC-13', 'DD-MON-RR'), 0, 'Microsoft Excel',
'Y'
);


COMMIT ;

No comments: