Saturday, October 21, 2017

Delete Concurrent Program using API

Concurrent program cannot be deleted from Oracle Applications front-end, it can only be disabled.

Try to delete a concurrent program from Oracle Applications..

 

Execute the following database script using fnd_program.delete_program to delete Concurrent program programmatically:-
  BEGIN
       fnd_program.delete_program (program_short_name => 'XX_CP',  -- Conc. Executable Short Name
                                          application => 'AR'      -- Program Application Short Name
                                   );
       COMMIT;
END;



After the program deletion script is executed, try to query the Concurrent Program from Oracle Applications

Press F11, Enter Program: XX Concurrent Program, Ctrl + F11

 
 

No comments:

Post a Comment

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)