Receivables - EBS (MOSC)

MOSC Banner

DOC_SEQUENCE_VALUE is null when create the receipt using API (APPS.AR_RECEIPT_API_PUB.CREATE_CASH)

edited Dec 20, 2017 10:33PM in Receivables - EBS (MOSC) 11 commentsAnswered ✓

DOC_SEQUENCE_VALUE is null when create the receipt using API (APPS.AR_RECEIPT_API_PUB.CREATE_CASH). I am using the below code:

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

DECLARE

L_ERROR_DESCRIPTION         VARCHAR2 (2000) := NULL;

L_MSG_INDEX_NUM             NUMBER:= 1;

L_MSG_COUNT                 NUMBER;

L_DATA_TXT                  VARCHAR2(1000);

L_MSG_DATA                  VARCHAR2(1000);

L_RECEIPT_ID                NUMBER;

L_RETURN_STATUS             VARCHAR2(10);

L_ATTRIBUTE_REC             APPS.AR_RECEIPT_API_PUB.ATTRIBUTE_REC_TYPE ;-- DEFAULT ar_receipt_api_pub.attribute_rec_const   ;--ar_receipt_api_pub.attribute_rec_type;

L_RETURN_STATUS_2   VARCHAR2 (1);

L_MSG_COUNT_2       NUMBER;

L_MSG_DATA_2        VARCHAR2 (240);

L_MSG_INDEX_NUM2    NUMBER;

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