How to parse field / column value from oracle form to concurrent program parameter input and enable tools menu to call program

By -

 Step1: Enable tools Menu when new form instance


Action Tab:
Type: Menu
Menu Entry: Special 4
Menu Name: Enter user friendly name


seq1: to initialize the global variable to be passed to Concurrent program

seq2: to capture the form value to global variable to be passed to Concurrent program

Next seq condition to call concurrent program from special menu

Action tab:
seq1:Assign the form value to the global variable
seq2:Call the concurrent program from the tools special menu

Navigate to concurrent program definition: 
assign default value type as SQL Statement and default value for the parameter required: 
  • select :GLOBAL.XX_G_JOB from dual
Output:

Opens up the report with the default value of job from the oracle form to concurrent program parameter.











Comments

Post a Comment

Popular posts from this blog

PO & Receipt Query

By -
Query to get PO & Receipt Data: select aps.segment1  "Supplier Number", poh.segment1  "Purchase Order Number", poh.AUTHORIZATION_STATUS  "Purchase Order Status", Null  "Purchase Order Release Number", poh.START_DATE  "Purchase Order Date", papf.full_name  "Buyer", msi.segment1   "Purchase Order Item Number", pll.closed_code  "Purchase Order Item Status", pol.PURCHASE_BASIS  "Purchase Order Item Type", msi.segment1  "Location Part Number", msi.description  "Location Part Description", pol.VENDOR_PRODUCT_NUM  "Supplier Part Number", POL.QUANTITY  "Item Order Quantity", pol.unit_price  "Location Item Price", poh.CURRENCY_CODE  "Location Currency Code", pol.unit_price  "Supplier Item Price", aps.PAYMENT_CURRENCY_CODE  "Supplier Currency Code", msi.PRIMARY_UNIT_OF_MEASURE  "Inventory Unit of Me...
Read more

Supplier SQL query

By -
Query to get Supplier data from Oracle R12 SELECT   aps.segment1 "SupplierNum",          assa.vendor_site_code "Address Book Identifier ",          aps.vendor_name "Supplier Company Name ",          --Hou.name "Operating Unit Name",          Assa.address_line1 "Supplier Address Line1",          Assa.address_line2 "Supplier Address Line2",          assa.address_line3 "Supplier Address Line3",          assa.address_line4 "Supplier Address Line4",          assa.city "Supplier city",          assa.state || assa.PROVINCE "Supplier State/Province",          assa.country "Supp_country_Code",          assa.zip "Supp_postal_Code",          apsite_rmt.ADDRESS_LINE1 "Supp_Remit_...
Read more

BOM Open Interface

By -
A Guide to Using the Bill of Material (BOM) Open Interface This paper serves as a reference when using the BOM Open Interface. It defines the tables used in importing bills and explains the mandatory, derived and optional columns. Interface Tables:  You need to populate following interface tables with data from your legacy system: BOM & ROUTING INTERFACE tables BOM INTERFACE tables BOM_BILL_OF_MTLS_INTERFACE BOM_INVENTORY_COMPS_INTERFACE BOM_REF_DESGS_INTERFACE BOM_SUB_COMPS_INTERFACE MTL_ITEM_REVISIONS_INTERFACE MTL_INTERFACE_ERRORS BOM tables BOM_BILL_OF_MATERIALS BOM_INVENTORY_COMPONENTS BOM_REFERENCE_DESIGNATORS BOM_SUBSTITUTE_COMPONENTS MTL_ITEM_REVISIONS ROUTING INTERFACE tables BOM_OP_ROUTINGS_INTERFACE BOM_OP_SEQUENCES_INTERFACE BOM_OP_RESOURCES_INTERFACE MTL_RTG_ITEM_REVS_INTERFACE ROUTING tables BOM_OPERATIONAL_ROUTINGS BOM_OPERATION_SEQUENCES BOM_OPERATION_RESOURCES Import Program : Once you load the data into the interface tables, you can launc...
Read more