New Comment System@Siebel Unleashed.. Do Try and give me feedback | Next Tip »Home

Runtime Event-Attachment BC and a Strange Problem

OkAvarageGoodVery GoodExcellent (2 votes, average: 5.00 out of 5)
Loading ... Loading ...

Siebel is full of strange problem and for many of them there is no logical explanation of problem (may be there is but we just don’t know). In this post I will discuss a strange problem that I faced few days ago. I was able to solve the problem but unfortunately I was not able to completely figure out the reason why it happened in first place. So, putting it out here so if anybody out here has a reason or has faced similar problem then he can share it with us.

We did the following configuration in Opportunity Attachment BC for a requirement:

  • Created 2 new joins 1 with S_OPTY table and 2nd with S_ORG_EXT TableOpportunityAttachmentJoin
  • Created 3 new field using the above created joins with following naming convention
    Oppty XXXX XXXX

Till now everything was fine. Next Step was

  • Setup a Runtime event on Write Record of Opportunity Attachment BC.
  • Associate an Action Set with this Runtime Event.
    RuntimeEventOpptyAttachment
  • Used newly created fields to set some profile attributes in action set.
    NewProfileAttribute

Now, as soon as we used newly created fields in Action Set to set some profile attribute, Siebel started giving below mentioned error on Opportunity attachment write record.

—————————
Siebel
—————————
No field matches identifier ‘Oppty Customer Name’.
Please ask your systems administrator to check your application configuration.(SBL-DAT-00416)

Old fields were working fine this problem was only with new fields that we had created.

I tried everything I could do such as:

  • Compile the BC again.
  • Double check if I am compiling in same SRF
  • Wrote a business service that would get field value for these fields and it was working fine.

Error was coming only when I used that field in Runtime events. After some R&D I noticed a User Property “DefaultPrefix” on Attachment BC that has value “Oppty” and searching bookshelf give me cryptic line or two about this user property.

What I understood from it is that, there is relation between field names and this prefix and using this prefix for custom fields can have side effect.

So, I removed this prefix and tried but error was still coming but by now I was pretty sure that there is something wrong with the fields that we had created. In the end I had to delete new fields and recreate them again with a different name (without Oppty prefix) to make it work.

I will be doing some more R&D when I get some time to find out if DefaultPrefix was the only reason for this behavior or was there something more to it. In the mean time you can post your suggestion/solutions/reasons about this problem via comments.

  • Share/Bookmark

Related Posts


Article by neel

Authors bio is coming up shortly. neel tagged this post with: Read 387 articles by neel
  • Anupam
    Exposing the field on the applet will make it active only if it's NOT a join field. In your case all 3 fields are join.

    As Dos has rightly pointed out, making it force active will get the join in the query and the field value will be retrieved. However, the error you are getting doesn't seem to have anything to do with query.

    Can you check the query getting formed in your case (where it doesnt work) and the query which gets formed after making it force active (where it works)?
  • Dos
    For me , it was throwing the same error. I set Force Active = 'Y' it worked. I exposed the field on UI, it worked. Anyways I have used this in Siebel 8.0 SIA. Which version are u using?

    Thx
    Dos
  • I did everything else except expose the fields on UI.. but nothing worked.
  • Dos
    Did u expose that custom field in the applet? alternatively u can make the Force Active property = 'Y' for that field and let me know if that error is coming or not?

    Thx,
    Dos.
blog comments powered by Disqus

Polls

Do you like the new Comment System and new look to Site?

View Results

Loading ... Loading ...