XML report publisher concurrent program from backend.

XML report publisher

At times you might need to take the xml output of an existing program and apply an XML Publisher / BI Publisher Template to it. The standard use case is if the output is generated by pro*c code/ a spawned or host concurrent program. The XML Report Publisher concurrent program can help achieve this. The Report takes the Concurrent request id, template application id, template name, template locale, template type and output type as parameters. A sample piece of code is shown below. DECLARE   l_req_id NUMBER; BEGIN   fnd_global.apps_initialize(6087,                              20420,                              1,                              0);   l_req_id := fnd_request.submit_request('XDO',                                          'XDOREPPB',                                          NULL,                                          NULL,                                          FALSE,                                            FND_GLOBAL.CONC_REQUEST_ID,                                          1919318,                                          20003, -- Receivables                                          'XXGILGMDWOPICKLIST', -- Statement Generate                                          'en-US', -- English                                          'N',                                          'RTF',                                          'PDF');   dbms_output.put_line(l_req_id);      commit; END;

--
Best Regards,
Boge Prasanth kumar Reddy.

Enabling Audit Trail in Oracle Apps Release 12

Enabling Audit Trail in Oracle Apps Release 12

1. Setting the AuditTrail Profile Value: 2. Creating the Audit group: 3.Creating the Audit Columns for the Audit Table: 4. Enabling audit for APPS User. Similarly query the AR user and enable Audit for the AR user. 5. Running the AuditTrail Update Tables Request: 5. Changing the status of the account number XXXXX to Invalid on Receivables Customer page: 6. Query the audit table hz_cust_accounts_a. One can see the record in the audit table and the status field shows it as Inactive.

Note:This materail is copied from applikast.net

--
Best Regards,
Boge Prasanth kumar Reddy.

Following SQL query can be used to find out the exact version of the oracle applications you are currently working on.

Following SQL query can be used to find out the exact version of the oracle applications you are currently working on.

SELECT substr(a.application_short_name, 1, 5) code,

       substr(t.application_name, 1, 50) application_name,

       p.product_version version

  FROM fnd_application a,

       fnd_application_tl t,

       fnd_product_installations p

 WHERE a.application_id = p.application_id

   AND a.application_id = t.application_id

   AND t.language = USERENV('LANG')

--

Following query gives Operating Unit Information and corresponding Inventory Orgs related information as well.

Following query gives Operating Unit Information and corresponding Inventory Orgs related information as well.

SELECT hou.NAME operating_unit_name,

hou.short_code,

hou.organization_id operating_unit_id, 

hou.set_of_books_id,

hou.business_group_id,

ood.organization_name inventory_organization_name,

ood.organization_code Inv_organization_code,

ood.organization_id Inv_organization_id, 

ood.chart_of_accounts_id

FROM hr_operating_units hou, 

org_organization_definitions ood

WHERE 1 = 1 

AND hou.organization_id = ood.operating_unit

ORDER BY hou.organization_id ASC

--