OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Why I can not see my data on jtf_notes_source_type_map

Home » Applications » Oracle Fusion Apps & E-Business Suite » Why I can not see my data on jtf_notes_source_type_map_v (EBS 11i, db 9i or 10g whatever)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Why I can not see my data on jtf_notes_source_type_map_v [message #424312]

Thu, 01 October 2009 09:17

asmani
Messages: 47
Registered: February 2007

Member

Dear All

I have inserted some data in FND_LOOKUP_VALUES through "Application Object library lookups" where lookup = JTF_NOTE_TYPE using application developer responsibility.

PROBLEM:
I can see that data on jtf_notes_source_type_map_v view. May I ask you why Mad

?

Is there anywhere else I need to insert that data? for more details please find my following query

SELECT meaning, lookup_code
FROM fnd_lookups fnd
WHERE lookup_type = 'JTF_NOTE_TYPE'
AND (lookup_code IN (
SELECT note_type
FROM jtf_notes_source_type_map_v
WHERE source_object_code = 'PARTY'
AND TRUNC (SYSDATE) <= TRUNC (NVL (end_date, SYSDATE))
)
)
AND enabled_flag = 'Y'
AND TRUNC (SYSDATE) BETWEEN TRUNC (NVL (fnd.start_date_active, SYSDATE))
AND TRUNC (NVL (fnd.end_date_active, SYSDATE))
AND xxuos_security.access_to_intr (fnd.lookup_code) = 0
ORDER BY meaning

Thanks for your time and help...
Usman Ahmad

Report message to a moderator

Re: Why I can not see my data on jtf_notes_source_type_map_v [message #424605 is a reply to message #424312]

Sun, 04 October 2009 09:38

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Try commenting out the following::
AND xxuos_security.access_to_intr (fnd.lookup_code) = 0

By
Vamsi

Report message to a moderator

Re: Why I can not see my data on jtf_notes_source_type_map_v [message #424663 is a reply to message #424605]

Mon, 05 October 2009 04:02

asmani
Messages: 47
Registered: February 2007

Member

Thanks Vamsi for your reply but I managed to sort that out.
As I am new to CRM that's why I did not know that we have do some mapping for that.

I'm copying following code to map your type. I know you alright knew it but just adding it for people like me Smile

Mapping Note Types To a Source
When you may map a note type to a source object, you limit the visible note types
for that source to the defined subset of note types. Perform the following steps to
map note types to source code.
Prerequisite
You must log on under the CRM Administrator account to perform this task.
Steps
1. Select CRM Administrator from the list of logon responsibilities.
The CRM Administrator Navigator opens.
2. Expand the Notes Setup node.
3. Select Source and Note Type Mapping.
Setting Up the Source Object Code and Context
Implementing Notes 17
The Source to Type Mappings formwindowopens.
4. Select a source to map from the Source LOV.
5. Select a note type tomap to it fromthe Note Type LOV.
6. Save this record when you have finished.

Thank you everyone for your time...
Usman Ahmad.

Report message to a moderator

Previous Topic:	Help in understanding how Oracle uses file version numbering in apps
Next Topic:	split the line in sales order

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 23:14:24 CDT 2024