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)
icon4.gif  Why I can not see my data on jtf_notes_source_type_map_v [message #424312] Thu, 01 October 2009 09:17 Go to next message
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


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 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Try commenting out the following::
AND xxuos_security.access_to_intr (fnd.lookup_code) = 0

By
Vamsi
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 Go to previous message
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.
Previous Topic: Help in understanding how Oracle uses file version numbering in apps
Next Topic: split the line in sales order
Goto Forum:
  


Current Time: Mon Sep 26 02:35:10 CDT 2016

Total time taken to generate the page: 0.14215 seconds