Reporting - EBS (MOSC)

MOSC Banner

How to delete table row using Web ADI

edited Mar 9, 2020 5:10AM in Reporting - EBS (MOSC) 3 commentsAnswered

Hi All,

My instance details as below :

Oracle Applications    : 12.2.4

Oracle RDBMS           : 12.1.0.2.0

Excel Template         : Microsoft Office 365

My table is as below:

CREATE TABLE XXCL_WEB_ADI_TBL

   (

    EMP_ID NUMBER,

    EMP_NAME VARCHAR2(200 BYTE) UNIQUE,

    HIRE_DATE DATE,

    SALARY NUMBER,

    CONSTRAINT pk_emp_id PRIMARY KEY (EMP_ID)

   );

I have defined Integrator with Interface type as API - Procedure which is below.

Data in Web ADI excel template  as below:

EMP_ID  EMP_NAME   HIRE_DATE    SALARY

101         LAKSHMI         1/1/2020         2000

102         PAVAN             1/2/2020         1000

I am able to delete EMP_ID = 101 row in excel template by selecting entire row as shown in attached picture.

Requesting to tell how to write code to delete same row from XXCL_WEB_ADI_TBL table in attached procedure.

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