Receivables - EBS (MOSC)

MOSC Banner

API AR Transaction can't create invoice

edited May 26, 2016 5:04AM in Receivables - EBS (MOSC) 3 commentsAnswered


Dear All,

I need your solution for my problem, i already create source code for create invoice AR Transaction but when i executed, i always getting error like this "UNIQUE ALWAYS USED"

this is my code :

CREATE OR REPLACE PROCEDURE APPS.TT_AR_TRANSACTIONS(

                            ar_order_number   IN NUMBER,

                            ar_trx_number     IN VARCHAR2

                            ) AUTHID CURRENT_USER IS

  

    ar_header_id            number;

    ar_bill_to_customer_id  number;

    ar_bill_to_site_use_id  number;

    ar_cust_trx_type_id     number;

    ar_id_header            number;

    ar_id_line              number;

    l_return_status         varchar2(1);

    l_msg_count             number;

    l_msg_data              varchar2(2000);

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