Procurement - EBS (MOSC)

MOSC Banner

No data found when create a planned purchase order

edited Jan 29, 2019 4:09AM in Procurement - EBS (MOSC) 4 commentsAnswered

Dear everybody,

When I use API to create a planned purchase order, the system returned an error.

Return Status: U

Return Message: ORA-01403: no data found at location 100 in Package PO_INTERFACE_S Procedure create_documents

Msg count:

Code:

declare

    p_api_version                               NUMBER := 1.0;

    x_return_status                VARCHAR2(10);

    x_msg_count                  NUMBER;

    x_msg_data                   VARCHAR2(4000);

    p_batch_id                   NUMBER := 14; --///

    p_req_operating_unit_id      NUMBER;

    p_purch_operating_unit_id    NUMBER := 83; --///

    x_document_id                NUMBER;

    x_number_lines                NUMBER;

    x_document_number            VARCHAR2(100);

   p_sourcing_k_doc_type        VARCHAR2(100); --<CONTERMS FPJ>

   p_conterms_exist_flag        VARCHAR2(100); --<CONTERMS FPJ>

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