Posts

Finding concurrent program assigned to which responsibilities

Finding concurrent program assigned to which responsibilities   SELECT cp . user_concurrent_program_name , rg . request_group_name ,        rv . responsibility_name   FROM fnd_concurrent_programs_vl cp ,        fnd_request_group_units rgu ,        fnd_request_groups rg ,        fnd_responsibility_vl rv   WHERE rgu . request_unit_id = cp . concurrent_program_id    AND rg . request_group_id = rgu . request_group_id    AND rg . request_group_id = rv . request_group_id    --AND CP.CONCURRENT_PROGRAM_id=42419    AND cp . user_concurrent_program_name LIKE 'XXCUST%NA%COGS%'
Post a Comment
Read more

XML Publisher Bursting

Image
About Bursting Bursting is a process of splitting data into blocks, generating documents for each block, and delivering the documents to one or more destinations. The data for the report is generated by executing a query once and then splitting the data based on a "Key" value. For each block of the data, a separate document is generated and delivered.   Dynamic location value : location="xdo://XXCUST.XXCUST_RTF.en.00/?getSource=true"> location="xdo://<Application short name>.<DataTemplate Shortname>.<Language>.<Territory>/?getSource=true"> Using the below code for running the Bursting file:(After Report Trigger) G_REQUEST_ID is the request_id of the main program submitted. G_BURST_REQUEST_ID := APPS.FND_REQUEST.SUBMIT_REQUEST ( 'XDO',           'XDOBURSTREP', '', '', false, G_REQUEST_ID, 'Y', '', CHR(0), '', '',  ...
1 comment
Read more