Payables and Cash Management - EBS (MOSC)

MOSC Banner

how to know the next value to be inserted STATEMENT_LINE_ID

edited Aug 20, 2021 7:45AM in Payables and Cash Management - EBS (MOSC) 10 commentsAnswered ✓

Dear All,

im trying to manually insert a new record into CE_STATEMENT_LINES

but i got this error :

ORA-01400: cannot insert NULL into

("CE"."CE_STATEMENT_LINES"."STATEMENT_LINE_ID")

Procedure that im using:

CREATE OR REPLACE PROCEDURE XX_CE_PROCEDURE_AUDI

--(errbuf OUT VARCHAR2, retcode OUT NUMBER )

AS

C_AUDI_REC XX_ST_AUDI_LOAD%ROWTYPE;

ST_HEADER CE_STATEMENT_HEADERS.STATEMENT_HEADER_ID%type;

f_pay  CE_STATEMENT_LINES.TRX_TYPE%type;

K Number :=0;

CURSOR C_AUDI is

SELECT * from XX_ST_AUDI_LOAD where rownum =1;

BEGIN

OPEN C_AUDI ;

LOOP

FETCH C_AUDI into C_AUDI_REC;

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