Analyis Update - Issue of DEBRIEF Page Greying out When Debrief Status -Pending -Task Completed but

Sumathi S

Jon.W-Oracle

Sriram,

It looks like you were almost there with finding the solution to your issue.

I searched the Knowledge Base for the error "An instance could not be found for the item and location information provided. "  , and got several hits, which give varying levels of detail.

The error you are seeing would appear to be an Install Base related error.

Can you review the following Notes:

An Instance Could Not Be Found For The Item And Location Information Provided . Item ID Org (Doc ID 1577951.1)

Serialized Item Debrief has IB Error: An instance could not be found for the item and location information provided (Doc ID 1544227.1)

The Note states there are duplicate debrief lines for the same serial number.

Because there are duplicate debrief lines try to ship out same serial number, so the 'no instance is found' error occurred when second debrief line is submitted

Delete the duplicated debrief line from the Field Service Debrief form, and then resubmit the remaining one.

Sadly it does not provide an explanation of how to delete the duplicates.

Debrief Transactions Fail With Errors 'An instance could not be found' and 'Invalid quantity specified' (Doc ID 455658.1)

Provides access to the diagnostics script to show the cause of the error.

Once you have reviewed these Notes, if yuo are no wiser, then update this thread, and we will see what further advice we can offer.

Rgds

Jon

Sumathi S

Sriram,

It looks like you were almost there with finding the solution to your issue.

I searched the Knowledge Base for the error "An instance could not be found for the item and location information provided. "  , and got several hits, which give varying levels of detail.

The error you are seeing would appear to be an Install Base related error.

Can you review the following Notes:

An Instance Could Not Be Found For The Item And Location Information Provided . Item ID Org (Doc ID 1577951.1)

Serialized Item Debrief has IB Error: An instance could not be found for the item and location information provided (Doc ID 1544227.1)

The Note states there are duplicate debrief lines for the same serial number.

Because there are duplicate debrief lines try to ship out same serial number, so the 'no instance is found' error occurred when second debrief line is submitted

Delete the duplicated debrief line from the Field Service Debrief form, and then resubmit the remaining one.

Sadly it does not provide an explanation of how to delete the duplicates.

Debrief Transactions Fail With Errors 'An instance could not be found' and 'Invalid quantity specified' (Doc ID 455658.1)

Provides access to the diagnostics script to show the cause of the error.

Once you have reviewed these Notes, if yuo are no wiser, then update this thread, and we will see what further advice we can offer.

Rgds

Jon

Hi Jon,

Thanks a ton for your time and tries to help on this!

I did verify first two oracle notes as they seemed close but doesn't seem like either of them.

For 2nd one, as well there is only one debrief line for the specific serial and no duplicate found for it.

Please check the uploaded snap.

Further, if you observe my 1 st upload (.doc) , the exact issue is the page getting greyed- out because of which service engineers could not make changes to material lines. Hence i thought clearing this "No instance found...." issue may flip the debrief status so that users can go back, make changes and resubmit it.

Thanks a ton!

Kind Regards,

Sriram

Jon.W-Oracle

Hi Jon,

Thanks a ton for your time and tries to help on this!

I did verify first two oracle notes as they seemed close but doesn't seem like either of them.

For 2nd one, as well there is only one debrief line for the specific serial and no duplicate found for it.

Please check the uploaded snap.

Further, if you observe my 1 st upload (.doc) , the exact issue is the page getting greyed- out because of which service engineers could not make changes to material lines. Hence i thought clearing this "No instance found...." issue may flip the debrief status so that users can go back, make changes and resubmit it.

Thanks a ton!

Kind Regards,

Sriram

Sriram,

Sorry that the Notes were of no use.

I searched again, and found an unpublished FS specific Note which references the error.  I'm not sure this is the case for you/that the Note is relevant, but it does suggest running the following unix command to verify the version of the library file:

strings -a $CSF_TOP/patch/115/sql/csfuppdb.pls |grep '$Header'

Meanwhile, looking at the statement in the log file:

Start of log messages from FND_FILE

+---------------------------------------------------------------------------+

An instance could not be found for the item and location information provided. Item ID: 1338. Organization ID: 186. (SUBINV=CWalton_N) (LOCATOR=)

DeBrief Line Id : 945618

Segment1 : 100:Segment4 : :Segment5 :

Segment1 : 100:Segment2 : 000:Segment3 : 191600:Segment4 : 000:Segment5 : 000:Segment6 : 00000

I am interested by the apparent lack of information in the line:

Segment1 : 100:Segment4 : :Segment5 :

I don't know if this is significant. 
Can you confirm (via sql) whether these segments are actually being populated?

I don't know that this would stop the screen from being enabled, but it still might be worth checking.

I'll take a closer look at csfuppdb.pls to see if it is obvious where the error is triggered.

Rgds

Jon

Jon.W-Oracle

Sriram,
I ran the following:

select message_name, message_text

    from fnd_new_messages

   where message_text like '%An instance could not be found%';

And got the result:  

   CSI_TXN_INST_NOT_FOUND    An instance could not be found for the item and location information provided. Item ID: &INV_ITEM_ID. Organization ID: &INV_ORG_ID.

So I should have been looking for CSI_TXN_INST_NOT_FOUND

This only appears in 3 files that I can see, and two of those are .ldt (error message) files.
The other one is csivptxb.pls

Can you tell me the version of this file which you are using, by running the following Unix command:

strings -a $CSI_TOP/patch/115/sql/csivptxb.pl* | grep '$Header'

We can then be sure that we are talking about the same code.

Thanks

Jon

Sumathi S

Sriram,

Sorry that the Notes were of no use.

I searched again, and found an unpublished FS specific Note which references the error.  I'm not sure this is the case for you/that the Note is relevant, but it does suggest running the following unix command to verify the version of the library file:

strings -a $CSF_TOP/patch/115/sql/csfuppdb.pls |grep '$Header'

Meanwhile, looking at the statement in the log file:

Start of log messages from FND_FILE

+---------------------------------------------------------------------------+

An instance could not be found for the item and location information provided. Item ID: 1338. Organization ID: 186. (SUBINV=CWalton_N) (LOCATOR=)

DeBrief Line Id : 945618

Segment1 : 100:Segment4 : :Segment5 :

Segment1 : 100:Segment2 : 000:Segment3 : 191600:Segment4 : 000:Segment5 : 000:Segment6 : 00000

I am interested by the apparent lack of information in the line:

Segment1 : 100:Segment4 : :Segment5 :

I don't know if this is significant. 
Can you confirm (via sql) whether these segments are actually being populated?

I don't know that this would stop the screen from being enabled, but it still might be worth checking.

I'll take a closer look at csfuppdb.pls to see if it is obvious where the error is triggered.

Rgds

Jon

Hi Jon,

Here is the version info:-

Thanks,

Sriram

-

$ strings -a $CSI_TOP/patch/115/sql/csivptxb.pl* | grep '$Header'

/* $Header: csivptxb.pls 120.27.12010000.22 2012/01/06 17:52:09 dsingire ship $ */

$

Jon.W-Oracle

Sriram,

Thanks for the update. 
csivptxb.pls 120.27.12010000.22
Surprisingly, we actually have the latest version installed on our instance - 120.27.12010000.35.

From what I can see the patches which deliver the latest version contain many files, which may have an impact on your regression testing, so I wouldn't want to suggest you upgrade without first confirming that this is truly the cause/solution to the problem.

It might be worth considering raising a SR for this issue, and then the Support engineer will probably be able to perform a more thorough investigation, and confirm if csivptxb.pls really is the cause of the problem, or whether this is just where the problem appears.  I would recommend referencing this discussion, and then the engineer can see all of the effort you have put in so far.

As an aside, I noticed that you created this posting in the 'Documents' section of the Community. (All Places > My Oracle Support Community > Oracle E-Business Suite (MOSC) > Field Service - EBS (MOSC) >  Documents )
  If you can, it would be better to raise issues in the  discussion section, since I am not certain that everyone will review or be notified when an issue is raised in the Document section.

good luck.

Rgds

J

Sumathi S

Sriram,

Thanks for the update. 
csivptxb.pls 120.27.12010000.22
Surprisingly, we actually have the latest version installed on our instance - 120.27.12010000.35.

From what I can see the patches which deliver the latest version contain many files, which may have an impact on your regression testing, so I wouldn't want to suggest you upgrade without first confirming that this is truly the cause/solution to the problem.

It might be worth considering raising a SR for this issue, and then the Support engineer will probably be able to perform a more thorough investigation, and confirm if csivptxb.pls really is the cause of the problem, or whether this is just where the problem appears.  I would recommend referencing this discussion, and then the engineer can see all of the effort you have put in so far.

As an aside, I noticed that you created this posting in the 'Documents' section of the Community. (All Places > My Oracle Support Community > Oracle E-Business Suite (MOSC) > Field Service - EBS (MOSC) >  Documents )
  If you can, it would be better to raise issues in the  discussion section, since I am not certain that everyone will review or be notified when an issue is raised in the Document section.

good luck.

Rgds

J

Thanks a ton Jon for your time and all efforts to help on this!

I have already raised an SR with raising here. Further, next time, i would raise it under Discussion Section for better viewership and more pairs of eyes on it.

Best Regards,

Sriram