Install Base and Asset Tracking - EBS (MOSC)

MOSC Banner

ORA-01008: not all variables bound in Package CSI_ITEM_INSTANCE_PUB

edited Jul 24, 2018 6:37AM in Install Base and Asset Tracking - EBS (MOSC) 1 commentAnswered

Hello Team,

I am using Oracle API CSI_ITEM_INSTANCE_PUB in one my procedure (NDCT_IB_UPDATE_WARRANTY_DATEexportPackageCSI_ITEM_INSTANCE_PUBProcedureGET_ITEM_INSTANCE_DETAILS.sql).

We do have issues with nearly +3500;

+2500 were successfully update using the Procedure.

Nearly 1000 records are getting following error

Msg1: ORA-01008: not all variables bound in Package CSI_ITEM_INSTANCE_PUB Procedure GET_ITEM_INSTANCE_DETAILS

Msg2: Passed Serial Number (4611) violates uniqueness across organizations.

ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes

I am not at all able to progress with these errors.

Please suggest some solution.

All logs and files are attached to the communication.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center