where we mention the Profile Attributes when we call these attributes throu - Siebel Technology(Archived)

I have query
I am working in Call Centre Application on 7.7 version. Some of my x employees have written some scripts on some Business Components. In that Scripts they have called some GetProfileAttribs with out using the SetProfileAttribs.
But i can not under stand where they have set this Profile attribs and from where they are calling these attribs?
If any body have an idea on this please let me know ?

Hi Venkat
It could be an OOTB (Out of the Box) profile attribute. Could you give an example?
It could also be that the attribute is set in some workflow or by a runtime event or ..

As well as "dynamic" Profile Attributes there are also static profile attributes that are stored within the system. You can see which attributes have been defined by looking at the fields defined on the "profile attribute" BCs.
In Siebel Tools go to the Business Component view and query for Profile Attribute.
There is more information about the use of these BCs in the Personalization Guide in Bookshelf.


OWNER_POSTN_ID of the Activity is not getting stamped in S_EVT_ACT

Hi Gurus,
I see the action BC class in out of box is based on CSSBCActivity. But Customer configured his ActionBC based on CSSBCFinsActivity. He has in addition changed/added lot of modifications to Action BC. While analyzing Action.sif, he has almost touched every properties of this BC and modified. Now he reports that OWNER_POSTN_ID of the Activity is not getting stamped in S_EVT_ACT.
Customer says he didnot use EIM for this. Any suggestions to analyze the cause of this?
The field is "*Position Id*" in Action BC for the Column "OWNER_POSITION_ID" and the Predefault value should be - System: PositionId.
Check whether the value exists and the Picklist for this field should be "PickList Sales Rep Position" and the Pick map should have defined for this filed with the bleow:
Field           Value
Position Name
Position Id Id
Joseph Arul Dass 
Hi Karpagam
I would like to point the fact that Action Business Component is based on class CSSBCFINSActivity in out of the box SIA Repository, so please make sure your are using the right version of sample to perform your comparison.
You most probably compared to the SEA version also known as Horizontal.
As mentioned by Joseph, the value is predefault to System: PositionId so please verify the settings on this property as well as user properties on BC level.
Then you can spool detailed logging to veirfy if this is a current issue or a past issue.
You can mass correct using EIM as the OWNER_POSTN_ID is mapped in EIM_ACTIVITY.
Best Regards

How to Create a Custom Integrator in R12 based on a Query set

Hi Everyone,
I am very much new to web adi. I got an unique requirement which I am finding it difficult. I did searched through the entire documentation/blogs/forums and I didnt find any suitable answer. Please let me know if anybody can throw some pointers here.
My Requirement is as follows
1) Using WEB ADI I need to update the data to collections responsibility ( I need to update unpaid reason code column and notes column for transactions)
2) So to start up with I need to design my excel template first with a query region to download the data. This query region may have 5-6 parameters like transaction number, customer name, customer number. When I click the submit button in query region, The data should be retrieved from database and should display in the same excel sheet.
3) Now for the data fetched from database, I need to update some of the columns and then again upload it back to EBS. I need to enable some of the columns to be LOV's.
Now My Questions are
1) Is this building a parameter based query then downloading to excel and then after modifying uploading back to EBS. Is this possible with WEB ADI. If this is doable then please let me know.
2) Unfortunately there are no interface tables or public API's available for collections responsibility then how one can update the data
I was trying to create a custom integrator a basic one to insert the data to a custom table. I had used HR Integrator set up for creating custom integrator.Enabled all the profile options functions and menus. But now I am stuck at a point I am unable to create a layout whenever I choose my custom integrator and then tries to create a layout I get the following error:
No columns have been defined in the column list.
Once this can be resovled then I can fo for column mapping and then test a custom load. Can anybody please let me know what am I missing here after following each procedures.
Your inputs are appreciated. I am in great need of your suggestions pretty urgently
Thanks and Regards
The answer to your query is 'Yes'. You need to design a 'UPDATE' metadata type custom integrator. The custom integrator shall use a parameter based view to first download data and then use a PL/SQL wrapper/API to re-upload it back. The brief steps are listed below:
1. Create a 'UPDATE' metadata type custom integrator. Give a parameter list name, std/custom view for data download and a PL/SQL wrapper.
2. Create a form function and associate the form function with the custom integrator created.
3. Add the form function to the std WebADI menu for access.
4. Define a layout for the custom integrator defined.
4. To create a parameter use the standard integrator 'HR Standalone Query'. As a part of this integrator you can define the SQL WHERE clause (parameter based) that you will like to use with the custom/std view defined in the custom integrator definition.
Note: You can use a max of 5 parameters only. For each parameter, one needs to define the datatype and also the HR standalone query has a size limitation of 2000 chars in 11i10. You increase this length you may apply patch - 3494588 to get 4000 chars.
Hope this information helps.
Nitin jain 
There is a private API available to update the unpaid reason in delinquencies (IEX_TRX_GRID_PVT.set_unpaid_reason). For notes, you have to use jtf_notes_pub.create_note.

Accessing data from EAM

Dear Friends,
we are currently working on a small OAF extension. Here we want some data from the EBS EAM like the fleet ids. I guess we shall have to use some APIs to get the data from the EAM.
Can anyone guide me to use the APIs so that I can fetch the required data from the EBS.
I would also appreciate if anyone lets me know where I can find appropriate study material to use the APIs so that I can use it to access the required data or even update some processed data to the EBS.
Following are few ways to get data from self-service pages (I hope you have basic knowledege of OAF):
1) using pageContext
String temp = pageContext.getParameter("fleetId")
Here "fleetId" is the ID of a filed.
2) Using bean
If fleet id field is of type "MessageTextInput" then you can get value using
OAMessageTextInputBean tempBean = (OAMessageTextInputBean)webBean.findChildRecursive("fleetId");
String temp = tempBean.getValue(pageContext);
You can get "OAMessageTextInputBean" API information in OAF Developer's guide and Java Doc. You can get all other required API information in OAF Developer's guide and Java Doc.
3) Using view object
For furthur details refer Dev Guide
Hi Anand,
thanks for your reply. Yes I have experience in working with OAF.
Here fleet id is not a field from my schema. I am talking about some information entered in the Oracle Enterprise Asset Management which happens to be a standard module coming with the Oracle EBS.
I refered to jdevdoc but could not find about using APIs. The Java doc has the following sections.
OA Framework Release 12
Business Components for Java (BC4J) 10.1.3
UIX 2.3.6
Caching Framework
Oracle JDBC 10g
Can you let me know in which section I can find about using APIs.
Thanks & Regards
Regarding code snippet's I have posted:
As an example, I was considering "Fleet ID" as a field on a self-service page(not from database schema) under EAM module.
Regarding Java Doc:
Each section under Java Doc consists some set of API's. For example we want to search for API of "OAMessageTextInputBean"(This class we have used in code snippet). Go to Java Doc -> OA Framework Release 12.
At the left side bottom window you can see title called "All Classes". Search of "OAMessageTextInputBean" under this window and click on 'OAMessageTextInputBean' link, now you can see all the method's this class has and their importance.
Now a question arises, How to know which class I need to use for a specific requirement?
For this some experience is required in OAF and you can get help from Dev Guide by searching similar functionality.
If you are struck at any point OTN is always there.
Hi Anand,
thanks for your help. I could see the various classes under each Package and the various methods of these classes.
However I failed to find such classes with member functions which would help us to fetch certain data from the standard modules of the EBS.
Suppose I am developing a custom extension using OAF, and I want to display all the P.Os in my custom OAF page. The P.Os were created in the material management module of Oracle EBS. Can you please give me such an example.
If you want to display all the po's information on OAF page.In that case you need to identify what all information you need to display and what all are the base table for that.Prepare a VO based on that query and make the page accordingly..Please read Dev guide for more informaton.
Hi Ajay,
I thought we are supposed to access the tables of our own schemas only while making VOs for our custom component. The P.Os shall be created in EBS's own internal tables and we are not supposed to touch them but access them only through APIs. Thats why I asked this question.
What i am saying is you can write a query based on all those table and then make a VO based on that query not on an individual table.There wont be any issues with that.This is the option to display data only.
1) Java API's under Java Doc are used across all modules. There are no specific set of API's for a specific module.
2) To display data in any module generaly API's are not used. SQL queries are used instead.
3) If you want to display data you need to build a SQL query and create a view object(VO) based on it. Use this VO in your custom page/extention to display data.
4) If you want to display data which is already there in some seeded module/page, you can find out VO used over there and you can use the same VO in your custom page/extention
Hi Anand,
thanks for your reply.
In fact I had already accessed some of the system tables from my VO to display or to validate data in another table. But in such cases I shall need to know the proper table in EBS from which I need the data. I have heard that there are more than 30k tables in the EBS. So how can we know which particular table I need to use in my VO to access certain data?
You can Check Oracle eTRM site for information about all the tables, Views, Concurrent Programs etc. Module wise.Please go through below link
Hope it helps!!!
Hi AJ,
the Oracle eTRM site for which you sent me the link seems to be very informative and shall really help me.
In that site, on the righthand top of the page there are three tabs - Search, FND and DBA. Can you please let me know what really FND and DBA means.
In many EBS system tables the names starts with fnd_ , so does it mean FND are all standard tables of EBS.
Can you please clearify this to me please.
FND Tab:
This tab consists information of all seeded TABLES, VIEWS and LOOKUPS etc used in all modules
for a specific oracle release(e.g. R 12.0.0).
When you click on FND tab by default it opens any one release data. You can see
a heading as "<relesae number> FND DEsign Data"
DBA Tab:
This tab consists of information about seeded PACKAGES, PROCEDURES and FUNCTIONS etc
used in all modules for a specific oracle release(e.g. R 12.0.0).
When you click on DBA tab by default it opens any one release data. You can see
a heading as "<relesae number> DBA Data"
Search Tab:
This tab consists of information of all releases.
At the left side menu (named "Select Database") we can see all releases(11.5.7, 11.5.8 etc).
When we place cursor on any link/release we can see four sub links(named "FND Data", DBA DAta, PDF Files, HTML Files).
e.g. When we click on 11.5.10 - FND Data, we will navigate to FND tab where it displays "11.5.10 FND Design Data".
1. If you want to search a seeded TABLE of Account Payables module of 11.5.10 release:
In search tab click on 11.5.10 - FND Data. Then select a module(select "AP Payables" in Product field) then select object type as TABLE then click on Submit button.
2. If you want to search a seeded PROCEDURE of Account Payables module of 11.5.10 release:
In search tab click on 11.5.10 - DBA Data. Then select Object Type as "PROCEDURE" and click on Submit button.
Dear Anand,
thanks for the nice explaination. It was helpful.

How to find the rule name of one property

Hi All,
I am new to Oracle Configurator. I working with some published oracle configurator models. In configuarator model we are having one option class for Customer Name and one property like Customer ID. It is allowing user to select the Customer Name, depending upon the Customer Name selection, it is setting the value for *"Customer ID"* property. I am not able to find which rule is doing it.
Anybody can help me to find out the rule name based on property name?
Thanks in Advance....
Purushothaman M 
Hi All,
Any suggestion Plz.... 
Check for any extension written on the "postvalue change" event of the customer option class 
open configurator developer and look at all the rules associated with it.
The rule you are looking for will be listed there.
Sandeep Gandhi 
If you can access the CZ schema you can find it.
then write SOL and get the folder name, the ID and others.
The questioin is what is the purpose of knowing the name?
Thanks.. i found it . It is attched as property for the class.

Restricting subinventories to a user

Is there any way to restricting subinventories to a particular user.
For example, user ABC should be able to see only one or two subinventories from the LOV when doing any invnetory transaction.
i think there is no feature yet available for that. 
You can use the Custom library to add some custom control on the standard forms. 
can u pls provide some details of custom library n control? 
Please refer to document through Metalink Note:279034.1. I am not sure you would be able to change the LOV, but, at least, you will be able to add a control on the Subinventory validation field.
If you are not in 11.5.10 , you can even so use Custom library. In this case, please refer to Oracle Application Developer Guide.