Oracle: Uploading Read-Only columns in ADI

Standard functionality in Oracle Web Applications Desktop Integrator does not allow uploading columns marked as read-only; this is highlighted in Bug 6607618.

The following customisation can be used as a workaround, however as it requires direct modification of underlying tables it is not supported nor recommended by Oracle (and don't blame me if it goes wrong!).


In the application do NOT set the columns as read-only, instead, after defining the Integrator and Content identify the CONTENT_CODE using the following:

SELECT bint.user_name
     , bint.integrator_code
     , bcon.content_code
FROM   bne_integrators_tl bint
     , bne_contents_b bcon
WHERE  bint.integrator_code = bcon.integrator_code
AND    bint.user_name = &IntegratorName;

Then, update the READ_ONLY_FLAG to ‘Y’ on the table BNE_CONTENT_COLS_B for the columns you want to be read-only (based on the CONTENT_CODE identified in the above script).

Finally, clear the BNE cache (refer to Metalink Note 1075840.1).

Oracle: Submitting BI Publisher Reports using PL/SQL

This simple example shows how to submit concurrent programs that use BI Publisher to render the output.Before calling the fnd_request.submit_request procedure to create the concurrent request the BI Publisher template must be assigned, to do this use the seeded fnd_request.add_layout procedure:

declare
  xml_layout BOOLEAN;
  jreq_id NUMBER;

begin

xml_layout := fnd_request.add_layout ('XXAPPS'
                      , 'XXAPPS_TEMPLATE_CODE'
                      , 'en'
                      , '00'
                      , 'PDF');

jreq_id := fnd_request.submit_request ('XXAPPS'
                      , 'XXAPPS_PROGRAM_CODE'
                      , ''
                      , ''
                      , FALSE
                      , 'PARAM1'
                      , 'PARAM2');

end;


**XXAPPS : Application Short Code
**XXAPPS_TEMPLATE_CODE : Template Code (as defined in XML Publisher Administrator)
**en : Template Language
**00 : Template Territory
**PDF : Output Format


**XXAPPS_PROGRAM_CODE : Concurrent Program Short Code
**PARAM1/2 : Concurrent Program Parameters