BI Publisher (MOSC)

MOSC Banner

XML Parsing Error: junk after document element in EBS BI Publisher using PLSQL Code

edited Jul 4, 2019 5:00AM in BI Publisher (MOSC) 1 commentAnswered

Hi All,

Generating XMLP data tags using PLSQL code...

BEGIN

      fnd_file.put_line(fnd_file.output,'<?xml version="1.0" encoding="UTF-8"?>');

      FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'<XXC_ORDER_DET>');

      FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'<LIST_G_MAIN>');

    FOR c_rec IN c_1 LOOP

    FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'<G_MAIN>');

FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'<ORDER_NUM>'||dbms_xmlgen.CONVERT(c_rec.ORDER_NUM)||'</ORDER_NUM>');

        FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'</G_MAIN>');

    END LOOP;

      FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'</LIST_G_MAIN>');

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