1858952 - Error: "..Cannot resolve column <LINE> whose full path is <QRY_CALL_BAPI.RETURN> in nested schema <RETURN>" in Data Services

A job using a BAPI with RETURN table fails in SAP Data Services as follows:

23596    2128406304         VAL-030365        5/9/2013 1:55:39 PM       |SESSION JOB_CO0012_PIR|WORKFLOW WF_CO0012_PIR_Load|DATAFLOW Copy_1_DF_CO0012_PIR_LOAD|STATEMENT <GUID::'467d2de3-a061-4ee7-908e-59836277e8d6' QUERY QRY_UNNEST>

23596    2128406304         VAL-030365        5/9/2013 1:55:39 PM       Cannot resolve column <LINE> whose full path is <QRY_CALL_BAPI.RETURN> in nested schema <RETURN>. Ensure that in the FROM

23596    2128406304         VAL-030365        5/9/2013 1:55:39 PM       clause for nested schema <RETURN>, path <QRY_CALL_BAPI.RETURN> is defined; or that it is defined in the FROM clause for any of

23596    2128406304         VAL-030365        5/9/2013 1:55:39 PM       the parent schemas.

23596    2128406304         VAL-030365        5/9/2013 1:55:39 PM       |SESSION JOB_CO0012_PIR|WORKFLOW WF_CO0012_PIR_Load|DATAFLOW Copy_1_DF_CO0012_PIR_LOAD|STATEMENT <GUID::'467d2de3-a061-4ee7-908e-59836277e8d6' QUERY QRY_UNNEST>

23596    2128406304         VAL-030365        5/9/2013 1:55:39 PM       Cannot resolve column <LINE> whose full path is <QRY_CALL_BAPI.RETURN> in nested schema <RETURN>. Ensure that in the FROM

23596    2128406304         VAL-030365        5/9/2013 1:55:39 PM       clause for nested schema <RETURN>, path <QRY_CALL_BAPI.RETURN> is defined; or that it is defined in the FROM clause for any of

23596    2128406304         VAL-030365        5/9/2013 1:55:39 PM       the parent schemas.

• SAP Data Services 4.1 SP1
• SUSE Linux 6.3
• Oracle 11g

BODI, DI, XI, BODS, DS, ADAPT, SAP Application , KBA , EIM-DS , Data Services , Problem