EBS Customizations (MOSC)

MOSC Banner

How to modify BPA price in API

edited Mar 30, 2023 5:14AM in EBS Customizations (MOSC) 2 commentsAnswered ✓

Error: specified is not a valid original catalog.

I find it, but still error

Error: ####### specified is not a valid original catalog. When Uploading Item Information to the Catalog (Doc ID 2273181.1)

query PO_INTERFACE_ERRORS.column_name = VENDOR_DOC_NUM

how to get VENDOR_DOC_NUM



DECLARE

 X_RETURN_STATUS VARCHAR(240);

 V_NUM_BCOUNT  VARCHAR(240);

 V_ERRBUF    VARCHAR(240);

 P_request_id  NUMBER;


 CURSOR BPA IS

  SELECT PHA.PO_HEADER_ID,

      PLA.PO_LINE_ID,

      PHA.AGENT_ID,

      PHA.SHIP_TO_LOCATION_ID,

      PHA.BILL_TO_LOCATION_ID,

      PHA.TYPE_LOOKUP_CODE,

      MSI.ORGANIZATION_ID,

      PHA.ORG_ID,

      PV.VENDOR_ID,

Tagged:

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