ADM Import Price List Item.Part # Fetching All Records Causing "SBL-DAT-00500: There were more rows than could be returned" (Doc ID 2725379.1)

Last updated on JULY 29, 2024

Applies to:

Symptoms

When trying to import an ADM Price List Items it error out with "SBL-SVC-50333: Import Failed" on Siebel Open UI. After further investigation as shown in the log details, it is trying to fetch all the Price List Items records causing the following error message captured in the log below.

Steps to reproduce the issue:

1. Create a Price List 'ABC Price List' and add 12 Product to the Price List Item with Part # 'ABC001'.

2. Created a new ADM Project 'ABC Project Test" with the following Deployment Filter below with PriceList Object.

[Name]='ABC Price List' AND [Price List Item.Part #] like 'ABC001'

3.Create an ADM Session with the ADM Project 'ABC Project Test" above and press Deploy and this will create an export file "X-XXXX_PriceList.xml".

4. Renamed the Price List to "OLD - ABC Price List". NOTE: Since we are using the same environment for this test, the Price List was renamed to simulate it as a Target environment..

5. Logoff and login back and import by using Deploy From Local File using your export file "X-XXXX_PriceList.xml".

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.