How to create DBC file yourself

Open the link :-
http://hostname:port /OA_HTML/ jsp/fnd/aoljtest.jsp

For ex :- 

http://frmapp01-v.fin.corp.com:8000/OA_HTML/jsp/fnd/aoljtest.jsp


Screenshot :-

Inventory Profile Options

Implementing Profile Options Summary

The table below indicates whether you (the User) can view or update the profile option and at which System Administrator levels the profile options can be updated: at the user, responsibility, application, or site levels. The second column, User, references the user, while the next four columns, User, Resp, App, and Site, reference the System Administrator. The last two columns, Required and Default Value, reference requirements.
A Required profile option requires you to provide a value. An Optional profile option already provides a default value, so you only need to change it if you don't want to accept the default.

Profile Option Settings

Profile Option	User	User	Resp	App	Site	Required?	Default Value
Bom or Engineering	+	+	+	+	+	Yes	BOM
INV: Accounting Category Set	-	-	-	-	+	Yes	No default
INV: Advanced Pricing for Intercompany Invoice	-	-	-	-	+	Yes	No
INV: Advanced Pricing for Inter-Org Transfers	-	-	-	-	+	No	No Default
INV: Allow Expense to Asset Transfer	-	-	+	-	+	No	No Default
INV: Batch Size	-	-	-	-	Yes	No	Null
INV: Capable to Promise	_	_	_	_	+	Yes	No default
INV: CCEOI Commit Point	+	+	+	+	+	Yes	No Default
INV: CCEOI Workers	-	-	-	-	+	Yes	No Default
INV: Component Pick Batch Size	+	+	0	0	+	No	None
INV: Consigned Inventory Aging Enabled	-	-	-	-	+	No	Yes
INV: Cross Reference Type	0	0	0	0	+	No	Null
INV: Debug File (Including the complete path)	+	+	+	+	+	Yes	No Default
INV: Debug level	+	+	+	+	+	Yes	No Default
INV: Debug Trace	+	+	+	+	+	Yes	No Default
INV: Default Item Status	+	+	+	+	+	Yes	Active
INV: Default Primary Unit of Measure	+	+	+	+	+	Yes	Each
INV: Detect Truncation on UOM Conversion	-	-	-	-	+	Yes	No Default
INV: Dynamic Precision Option for Quantity on Reports	+	+	+	+	+	Yes	-9,999,999.00
INV: External ATP	_	_	_	_	+	Yes	No Default
INV: FIFO for Original Receipt Date	+	+	+	+	+	Yes	No
INV: Fill & Kill Move Order	0	0	0	0	+	No	No
INV: Fill Kanban on Partial Move Order Receipt	-	-	-	-	+	No	No
INV: Genealogy Delimiter	+	+	+	+	+	Yes	-
INV: Genealogy Prefix or Suffix	+	+	+	+	+	No	Prefix
INV: GTIN Cross Reference Type	-	0	0	0	+	No	Null
INV: Inter-Organization Currency Conversion	+	+	+	+	+	Yes	Corporate
INV: Intercompany Currency Conversion	+	_	+	+	+	Yes	Corporate
INV: Intercompany Invoice for Internal Orders	-	-	-	-	+	Yes	No
INV: Item Default Tab	+	+	+	+	+	No	Null
INV: Item Form Folder Category Set	+	+	+	+	+	Yes	Null
INV: Item Form Uses Master Set of Folders in the Org Items Form	+	+	0	0	0	No	Null
INV: Item Master Default Template	+	+	+	+	+	No	Null
INV: Item Master Flexfield	+	+	+	+	+	Yes	No Default
INV: Material Status Support	-	-	-	-	+	No	No Default
INV: Max # of Txn Purge Processes	+	+	-	-	+	No	Null
INV: Maximum Number of Quantity Trees	-	-	-	-	+	Yes	500
INV: MGD Maximum Number of Workers Permitted	+	+	+	+	+	Yes	No Default
INV: Minmax Reorder Approval	+	+	+	+	+	Yes	Approved
INV: Move Order Transact Form	+	+	+	+	+	Yes	Online Processing
INV: Multiple Serials Per Delivery Detail	0	0	0	0	0	Yes	None
INV: Override Neg for Backflush	+	+	+	+	+	Yes	Yes
INV: Override Reservation for Transactions	+	+	+	+	+	No	No Default
INV: Pick Slip Batch Size	+	+	0	0	+	No	None
INV: Product Family Item Template	-	+	+	+	+	Yes	Product Family
INV: Project Miscellaneous Transaction Expenditure Type	+	+	+	+	+	Yes	User Entered
INV: Purchasing by Revision	-	-	-	-	+	No	-
INV: Quantity Tree Timeout for Lock	-	-	-	-	+	Yes	No Default
INV: Replenishment Move Order Grouping	0	0	0	0	+	No	Null
INV: RC Line Failure	+	+	+	+	+	Yes	Continue Processing
INV: RC Requisition Approval	+	+	+	+	+	Yes	Approved
INV: Restrict Receipt of Serials	+	+	+	+	+	No	No
INV: RPC Timeout	+	+	+	+	+	Yes	300
INV: Round Reorder Qty	+	+	+	+	+	Yes	Yes
INV: Save Search Items	+	+	+	+	+	Yes	No
INV: Supplier Consigned Enabled	-	-	-	-	+	No	Yes
INV: Target Preferred Grade	+	+	+	+	+	No	No Default
INV: Transaction Date Validation	+	_	+	+	+	Yes	Allow Date In Any Open Period
INV: Transaction Reasons Security	0	0	0	0	+	No	No
INV: Updateable Customer Item	+	+	+	+	+	Yes	No
INV: Updateable Item Name	+	+	+	+	+	Yes	No
INV: Use Backorder Caching	+	+	+	+	+	No	No Default
INV: Use Model & Options for Configuration Pricing	-	-	-	-	+	No	Yes
INV: Use catalog name in the item description	+	-	-	-	+	Yes	No
INV: Validate Returned Lot	-	-	-	-	+	No	No Default
INV: Validate Returned Serial	-	-	-	-	+	No	No Default
INV: View Item Category People	+	+	+	+	+	No	Null
INV: VMI Enabled	-	-	-	-	+	Yes	No
TP: INV Cycle Count Approvals form	+	+	+	+	+	Yes	Online Processing
TP: INV Cycle Count Entries form	+	+	+	+	+	Yes	Online Processing
TP: INV Enter Replenishment Count form	+	+	+	+	+	Yes	Concurrent Processing
TP: INV Inter-Organization Transfer form	+	+	+	+	+	Yes	Online Processing
TP: INV Miscellaneous Issue and Receipt form	+	+	+	+	+	Yes	Online Processing
TP: INV Transaction Processing Mode	+	+	+	+	+	Yes	Immediate Concurrent Processing
TP: INV Transfer Between Subinventories form	+	+	+	+	+	Yes	Online Processing
TP: INV Update Average Cost form	+	+	+	+	+	Yes	Online Processing
TP: Server Side Online Processing	+	+	+	+	+	Yes	Yes

+	You can update the profile option.
-	You can view the profile option value, but you cannot change it.
0	You cannot view or change the profile option value.

SQL Query to find concurrent program details along with parameters and valus set attached to those parameters

  SELECT fcpl.user_concurrent_program_name
      , fcp.concurrent_program_name
      , par.column_seq_num      
      , par.end_user_column_name
      , par.form_left_prompt prompt
      , par.enabled_flag
      , par.required_flag
      , par.display_flag
      , par.flex_value_set_id
      , ffvs.flex_value_set_name
      , flv.meaning default_type
      , par.DEFAULT_VALUE
 FROM   fnd_concurrent_programs fcp
      , fnd_concurrent_programs_tl fcpl
      , fnd_descr_flex_col_usage_vl par
      , fnd_flex_value_sets ffvs
      , fnd_lookup_values flv
 WHERE  fcp.concurrent_program_id = fcpl.concurrent_program_id
 AND    fcpl.user_concurrent_program_name = '%Auto%Accounting%'
 AND    fcpl.LANGUAGE = 'US'
 AND    par.descriptive_flexfield_name = '$SRS$.' || fcp.concurrent_program_name
 AND    ffvs.flex_value_set_id = par.flex_value_set_id
 AND    flv.lookup_type(+) = 'FLEX_DEFAULT_TYPE'
 AND    flv.lookup_code(+) = par.default_type
 AND    flv.LANGUAGE(+) = USERENV ('LANG')
 ORDER BY par.column_seq_num

Generate FNDLOAD Command

Dynamically create FNDLOAD command

Select the options from dropdown list.

  ApplLoadOption InstanceFile Name
CP FND INV PO WMS DOWNLOAD UPLOAD Concurrent Program Forms Personalization Lookup Value Set Value Set with values Request Group Request Set Key Flexfield Descriptive Flexfield Responsibility Menu Forms Function Message User Profile Printer Style ERPDBG ERPDEV .ldt

Additional Parameters :

Conc Program Name

Forms Personalization Name

Lookup Name

Value Set Name

Value Set Name

Request Group Name

Request Set Name

Key Flexfield Code Key Structure Code

Desc Flexfield Name Context Code

Responsibility Key

Menu Name

Form Name

Function Name

Message Name

User Name

Profile Name

Printer Style Name

Result: FNDLOAD command will be populated here...

FNDLOAD command generator by Sachin Dixit