Troubleshooting Notes

This chapter covers the following topics:

• Notes Error Messages
• Answers to Frequently Asked Questions (FAQs)

Notes Error Messages

ORA-20000

InterMedia Text error: ORA-01722: invalid number ORA-06512: at "CTXSYS.DRUE", line 126 ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 226 ORA-06512: at line 1.

Cause: Script Failure Error

Action: To resolve this issue, configure your environment to include Intermedia text. For more information, refer to the Oracle 8i Intermedia Text Installation Manuals FAQ or contact Oracle Support.

Script Failed Error

The following error message can occur:

• ORA-29856: error occurred in the execution of ODCIINDEXDROP routine.

• ORA-20000: interMedia Text error: ORA-01722: invalid number ORA-06512: at "CTXSYS.DRUE", line 126 ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 226 ORA-06512: at line 1.

Configure your environment to include Intermedia text. For more information, refer to the Oracle 8i Intermedia Text Installation Manuals FAQ or contact Oracle Support.

See Also

• Setting Up Note Types

• Mapping Note Types to a Source

• Setting Up the Source Object Code and Context

• Setting Profile Options

Answers to Frequently Asked Questions (FAQs)

The following are frequently asked questions. Answers to these questions may help you in troubleshooting problems with the Notes module.

Can You Delete or End Date Seeded Note Types?

Seeded data cannot be end dated or deleted. However, users can define new note types.

What do the note statuses Private, Public, and Publish mean?

Note status has three values:

• Private: Note is visible to only the creator of the note.

• Public: Note is visible to all application users (except customers).

• Publish: Note is visible internally and to customers via customer facing applications like Oracle iSupport.

I changed the value of a profile option, but it is not reflected in HTML Notes. Why is that?

After changing a profile option value in Forms, you must bounce the Apache server for it to take effect in HTML.

The profile option "Notes: Default Note Type" is set, but it is not reflected in either HTML or Forms notes. Why?

This profile option applies only to Oracle Applications Framework Notes.

Note type setups were done in the Source and Note Type Mapping form. Why are the note types displayed on the Notes Detail page not restricted based on these setups?

The Note Type drop down list shows the following:

• All the note types that are mapped to the source

• All note types that are common across all sources. They are not mapped to any other source.