[API]Unexpected error in EGO_ITEM_USER_ATTRS_CP_PUB.Process_

In this Document

? Symptoms ? Changes ? Cause ? Solution ? References

---

?

APPLIES TO:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.

SYMPTOMS

The API EGO_ITEM_PUB.process_item raises an error but still creates the item.

Error

Entity: ITEM_USER_ATTRS_ENTITY_CODE. Row Identifier: -1. Table Name:
EGO_ITM_USR_ATTR_INTRFC.
Unexpected error in EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data:
ORA-01403: no data found

The error is raised but the item is getting created or updated successfully.

Error in log of concurrent program:

[NO_DATA_FOUND exception overwrites other critical exceptions such as INV_IOI_MASTER_CHILD_4H and INV_IOI_ITEM_NUMBER_NO_EXIST. ]

Expected Behavior

Expect no error raised and no error in log file when the item is created or updated successfully.

Steps
1. Run the ego_item_pub.process_item?
2. Experience the error but item is created.

CHANGES

?

CAUSE

The public API listed non-critical exceptions in the log causing the program to show errors even though the item was created.?
The exceptions were reviewed in?Bug 18846783?and non-critical exception errors were removed.?
For example,there were user name validations that could raise no data found (NO_DATA_FOUND) but this was not a critical error so should be ignored.

?

?

SOLUTION

Summary: The API was corrected to avoid non-critical errors so the error is not raised when the item is successfully created or updated.

Action Details:

To implement the solution,please execute the following steps:

1. Download and review the readme and pre-requisites for the appropriate patch for your environment:?

12.1.x Patch 19459920:R12.EGO.C EGOCIUAB.pls 120.59.12010000.34 12.2.x Patch 18846783:R12.EGO.D EGOCIUAB.pls 120.80.12020000.9

2. Ensure that you have taken a backup of your system before applying the recommended patch.?
3. Apply the patch in a test environment.?
4. Confirm the upgraded file version. You can use Unix commands like?

strings -a $EGO_TOP/patch/115/sql/EGOCIUAB.pls | grep -i ‘$Header‘

Or SQL like:

select text from dba_source where name =
(‘EGO_ITEM_USER_ATTRS_CP_PUB‘) and owner = ‘APPS‘ and line = 2; -- API proccess_item|

Or you could run the Apps Check for Application Parameter: Advanced Product Catalog (in R12.2.4 and above,‘Product Hub‘) -- refer to?Note 276207.1.

5. Retest the issue.?
6. Migrate the solution as appropriate to other environments.

REFERENCES

BUG:18846783?- AFTER R12 UPGRADE: EGO_ITEM_USER_ATTRS_CP_PUB.PROCESS_ITEM_USER_ATTRS_DATA: ORA-

?

Didn‘t find what you are looking for?

Ask in Community...

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!

Patch/File Details

Release	Patch	File/Version