Oracle R12 Profile Option for Responsibility Level Query

 Select * 

from

(SELECT 

decode(a.level_id, 10001, 'Site',

10002, 'Application',

10003, 'Responsibility',

10004, 'User') "Level",

decode(a.level_id, 10001, 'Site',

10002, b.application_short_name,

10003, c.responsibility_key,

10004, d.user_name) Level_Value,

t.user_profile_option_name Profile_Option,

a.profile_option_value Profile_Value

FROM fnd_profile_option_values a,

fnd_application b,

fnd_responsibility c,

fnd_user d,

fnd_profile_options e,

fnd_profile_options_tl t

WHERE a.profile_option_id = e.profile_option_id

AND a.level_id = 10003 ---Respo

--AND t.user_profile_option_name like '%SG%'

AND a.level_value = b.application_id(+)

AND a.level_value = c.responsibility_id(+)

AND a.level_value = d.user_id(+)

AND t.profile_option_name = e.profile_option_name

AND t.LANGUAGE = 'US'

ORDER BY e.profile_option_name, a.level_id DESC) aa

Where aa.Level_Value like '%JG%';

Oracle R12 EBS Profile option extract query

 select p.profile_option_name SHORT_NAME,

  n.user_profile_option_name NAME,

  decode(v.level_id,

  10001, 'Site',

  10002, 'Application',

  10003, 'Responsibility',

  10004, 'User',

  10005, 'Server',

  10006, 'Org',

  10007, decode(to_char(v.level_value2), '-1', 'Responsibility',

  decode(to_char(v.level_value), '-1', 'Server',

  'Server+Resp')),

  'UnDef') LEVEL_SET,

  decode(to_char(v.level_id),

  '10001', '',

  '10002', app.application_short_name,

  '10003', rsp.responsibility_key,

  '10004', usr.user_name,

  '10005', svr.node_name,

  '10006', org.name,

  '10007', decode(to_char(v.level_value2), '-1', rsp.responsibility_key,

  decode(to_char(v.level_value), '-1',

  (select node_name from fnd_nodes

  where node_id = v.level_value2),

  (select node_name from fnd_nodes

  where node_id = v.level_value2)||'-'||rsp.responsibility_key)),

  'UnDef') "CONTEXT",

  v.profile_option_value VALUE,

  n.language

from fnd_profile_options p,

  fnd_profile_option_values v,

  fnd_profile_options_tl n,

  fnd_user usr,

  fnd_application app,

  fnd_responsibility rsp,

  fnd_nodes svr,

  hr_operating_units org

where p.profile_option_id = v.profile_option_id (+)

and p.profile_option_name = n.profile_option_name

and upper(p.profile_option_name) in (

  select profile_option_name from fnd_profile_options_tl

  where 1=1 

--upper(profile_option_name) = upper('fnd_init_sql')

  and upper(profile_option_name) in (select profile_option_name

  from fnd_profile_options_tl

  ))

and usr.user_id (+) = v.level_value

and rsp.application_id (+) = v.level_value_application_id

and rsp.responsibility_id (+) = v.level_value

and app.application_id (+) = v.level_value

and svr.node_id (+) = v.level_value

and org.organization_id (+) = v.level_value

and n.language = 'US'

order by short_name, user_profile_option_name, level_id, level_set;

How To Enable The DFF For LOOKUP Oracle R12

Create a DFF on Lookup 

STEPS:

Login to System Administrator Application -> Flexfield -> Descriptive -> Segments 

Search for Application = Application Object Library 

Title = Common Lookups 

 You can see referenced field as "LOOKUP_TYPE" Now if you want to enable your lookup, you need to uncheck "Freeze Flexfield Definitions" checkbox on the top left the DFF Segments screen. this enables you to enter new DFF entries. Now, enter create a line under Context Field Values Under "Code" enter your lookup ex: SOCPL_ACCT_OU_INV_MAP_LK

Click on Segments Enter the number, name, prompt, column and value set(if you have one) save and compile the DFF. Now, switch the responsibility to Application Developer to see the DFFs enabled in lookup Open the common lookups screen and query for the lookup name you have given under "Code" of DFF setup. and thus your DFF is enabled.
 

How to Create Display field in DFF (using Special Value Set)

Create a DFF with Read only or Non Editable field:

Click on Segments:

Crate a Value Set: 

Validation Type : Special

Click On Edit Information

Event : Edit
Function : FND SQL "BEGIN NULL; END;"

Event : Validate
Function : FND SQL "BEGIN NULL; END;"

Find the custom top path in Oracle EBS

Find the custom top name and path in Oracle EBS

  SELECT variable_name top_name, value top_path

    FROM fnd_env_context

   WHERE variable_name LIKE '%XX%TOP%'       -- some time custom, 

GROUP BY variable_name, value

ORDER BY variable_name;

Oracle EBS Application name and Short name

Oracle EBS Module List

Application	Oracle Username
Application Object Library	APPLSYS
System Administration	APPLSYS
General Ledger	GL
Assets	FA
Alert	ALR
Application Report Generator	RG
XML Gateway	ECX
e-Commerce Gateway	EC
Oracle iProcurement	ICX
Application Implementation	AZ
Payables	AP
Purchasing	PO
Supplier Scheduling	PO
iAssets	IA
Receivables	AR
Web Applications Desktop Integrator	BNE
E-Business Tax	ZX
Quality	QA
Cash Management	CE
Report Manager	FRM
Projects	PA
Oracle E-Business Suite Diagnostics	IZU
Sales Foundation	OSM
Warehouse Management	WMS
Sourcing	PON
Inventory	INV
Mobile Applications	MWA
Enterprise Asset Management	EAM
Process Manufacturing Systems	GMA
Process Manufacturing Inventory	GMI
Process Manufacturing Product Development	GMD
Process Manufacturing Process Execution	GME
Process Manufacturing Process Planning	GMP
Process Manufacturing Financials	GMF
Process Manufacturing Logistics	GML
Process Manufacturing Regulatory Management	GR
Manufacturing Execution System for Process Manufacturing	GMO
Global Accounting Engine	AX
Common Modules-AK	AK
XML Publisher	XDO
Order Management	ONT
Advanced Pricing	QP
Shipping Execution	WSH
Payments	IBY
CRM Foundation	JTF
Bills of Material	BOM
Master Scheduling/MRP	MRP
Work in Process	WIP
E-Records	EDR
Project Manufacturing	PJM
Constraint Based Optimization	MSO
Advanced Supply Chain Planning	MSC
Human Resources	HR
Payroll	HR
SSP	SSP
Mobile Application Foundation	JTM
XXJG CUSTOM Application	XXJG
US Federal Human Resources	HR
Public Sector HR	HR
Public Sector Payroll	HR
Public Sector Financials International	IGI
Labor Distribution	PSP
Public Sector Financials	PSA
Federal Financials	FV
Oracle Landed Cost Management	INL
Application Utilities	APPLSYS
Applications DBA	APPLSYS
Applications Shared Technology	APPLSYS
Service	CS
Manufacturing Scheduling	WPS
Marketing Encyclopedia System	AMV
Subledger Accounting	XLA
Order Capture	ASO
Manufacturing	MFG
Engineering	ENG
Capacity	CRP
Configurator	CZ
Flow Manufacturing	FLM
FastFormula	HR
DateTrack	HR
Advanced Benefits	BEN
Grants Accounting	GMS
Capital Resource Logistics - Assets	CUA
Telephony Manager	CCT
iSupplier Portal	POS
Treasury	XTR
Risk Management	QRM
Applications BIS	BIS
Approvals Management	HR
Legal Entity Configurator	XLE
Loans	LNS
Oracle Imaging Process Management	IPM
Internet Procurement Enterprise Connector	ITG
Property Manager	PN
Sales	ASN
Incentive Compensation	CN
Exchange	POM
Order Entry	OE
Shop Floor Management	WSM
Development	DNA
Product Hub	EGO
Document Managment and Collaboration	DOM
Financials Common Modules	FUN
Project Portfolio Analysis	FPA
Operations Intelligence (Obsolete)	OPI
Human Resources Intelligence (Obsolete)	HRI
Product Intelligence(Obsolete)	ENI
Contracts Core	OKC
Customer Care	CSC
Depot Repair	CSD
Field Service	CSF
Service Contracts	OKS
Marketing Intelligence(Obsolete)	BIM
Customer Intelligence(Obsolete)	BIC
Scripting	IES
TeleSales	AST
Sales Online	ASF
Spares Management	CSP
Contracts Integration	OKX
Marketing	AMS
Number Portability	XNP
Provisioning	XDP
Interaction Center Technology	IEO
Lease and Finance Management	OKL
Installed Base	CSI
Sales Offline	ASL
Advanced Outbound Telephony	IEC
Content Manager	IBC
Process Manufacturing Intelligence (Obsolete)	PMI
Release Management	RLM
Automotive	VEA
Oracle Web Analytics	IBW
Oracle Deal Management	QPR
iStore	IBE
iSupport	IBU
Email Center	IEM
Trade Management	OZF
CRM Gateway for Mobile Devices	ASG
Partner Management	PV
Proposals	PRP
Collections	IEX
Universal Work Queue	IEU
Scheduler	CSR
Interaction Blending	IEB
Supply Chain Trading Connector for RosettaNet	CLN
Transportation Execution	FTE
Site Management	RRS
Demand Planning	MSD
Inventory Optimization	MSR
Project Contracts	OKE
Outsourced Manufacturing for Discrete Industries	JMF
Time and Labor	HXT
Time and Labor Engine	HXC
Learning Management	OTA
iRecruitment	HR
Citizen Interaction Center	CUG
Complex Maintenance Repair and Overhaul	AHL
Field Service/Laptop	CSL
Oracle Sales for Handhelds	ASP
Asset Tracking	CSE
Customers Online	IMC
Quoting	QOT
Oracle Telecommunications Billing Integrator	XNB
Field Service/Palm	CSM
Project Intelligence(Obsolete)	PJI
Asia/Pacific Localizations	JA
European Localizations	JE
Regional Localizations	JG
Latin America Localizations	JL
Contract Commitment	IGC
Capital Resource Logistics - Projects	IPA
Oracle Price Protection	DPP
Oracle Manufacturing Operations Center	MTH
Demand Signal Repository	DDR
Oracle Environmental Accounting and Reporting	GHG
Oracle Yard Management	YMS
Oracle In-Memory Cost Management	CMI

Oracle Forms Personlization list with Condition

SELECT DISTINCT a.form_name, a.enabled, c.user_form_name, d.application_name,
                a.trigger_event, a.trigger_object, a.condition
           FROM fnd_form_custom_rules a,
                fnd_form b,
                fnd_form_tl c,
                fnd_application_tl d
          WHERE enabled = 'Y'
            AND a.form_name = b.form_name
            AND b.form_id = c.form_id
            AND b.application_id = d.application_id

Oracle Apps CUSTOM.PLL

CUSTOM.PLL IN ORACLE APPLICATION
Custom Library (custom.pll) allows to extend/customize Oracle Applications form(Oracle Form) without changing or modifying Oracle Applications code. Examples may include enforcing a new business rule, opening a form using zoom etc. Most of the things that we can do using custom.pll, we can achieve that using Forms Personalization. Since Custom.pll takes the full advantage of PL/SQL so it is having an edge over Forms Personalization for complex customizations.
CUSTOM.pll is used to add extensions to Oracle’s form Functionality. Some of the common scenarios where CUSTOM.pll can be used are:-

1. Enabling/Disabling the fields
2. Changing the List of Values in a LOV field at runtime
3. Defaulting values
4. Additional record level validations
5. Navigation to other screens
6. Enabling Special Menu
Where is this located?
Custom.pll is located in $AU_TOP/resource Directory.
How to add code to this?
Open this pll using the Form builder and make changes to the program units.

How to compile this PLL?
 Once you make changes you need to compile the pll. Use the F60gen to compile it
f60gen module=custom.pll userid=APPS/ output_file=$AU_TOP/resource/custom.plx module_type=library batch=no compile_all=special
While writing code inside custom.pll we should consider following things:
1. We should not run any SQL statement inside this, we can use record group.
2. We should not perform any DML operations, instead we should call database procedure and functions for the same.
For following Events call will go to CUSTOM Library:

WHEN–FORM–NAVIGATE
WHEN–NEW–FORM–INSTANCE
WHEN–NEW–BLOCK–INSTANCE
WHEN–NEW–RECORD–INSTANCE
WHEN–NEW–ITEM–INSTANCE
WHEN–VALIDATE–RECORD
SPECIALn (where n is a number between 1 and 45)
ZOOM
EXPORT
KEY–Fn (where n is a number between 1-8)
Custom Library contains Custom Package which is having two Functions and one procedure.
1] ZOOM_AVAILABLE:
This function allows you to specify if zooms exist for the current context. If zooms are available for this block, then return TRUE else return FALSE. This routine is called on a per-block basis within every Applications form from the WHEN-NEW-BLOCK-INSTANCE trigger. Therefore, any code that will enable Zoom must test the current form and block from which the call is being made. By default this routine must return FALSE.
Sample code1:

function zoom_available return Boolean is
form_name  varchar2(30) := name_in(‘system.current_form’);
block_name varchar2(30) := name_in(‘system.cursor_block’);
begin
if (form_name = ‘DEMXXEOR’ and block_name = ‘ORDERS’) then
return TRUE;
else
return FALSE;
end if;
end zoom_available;
Sample code2:
function zoom_available return Boolean is
form_name  varchar2(30) := name_in(‘system.current_form’);
block_name varchar2(30) := name_in(‘system.cursor_block’);
begin
if (form_name = ‘APXINWKB’ and block_name = ‘INV_SUM_FOLDER’)
then
return TRUE;
elsif (form_name = ‘APXINWKB’ and block_name = ‘LINE_SUM_FOLDER’)
then
return TRUE;
else
return FALSE;
end if;
end zoom_available;

2] STYLE:
This function returns a integer value. This function allows to override the execution style of Product specific events, but it doesn’t effect generic events like when-new-form-instance. Possible return values are:
1. custom.before
2. custom.after
3. custom.override
4. custom.standard
By default it returns custom.standard.
Sample code:

function custom.style(event_name varchar2) return integer is
begin
if event_name = ’MY_CUSTOM_EVENT’ then
return custom.override;
else
return custom.standard;
end if;
end style;

3] EVENT:
This procedure allows you to execute your code at specific events including:
  –    ZOOM
  –    WHEN-NEW-FORM-INSTANCE
  –    WHEN-NEW-BLOCK-INSTANCE
  –    WHEN-NEW-RECORD-INSTANCE
  –    WHEN-NEW-ITEM-INSTANCE
  –    WHEN-VALIDATE-RECORD
By default this routine must perform ‘null;’
Sample code:
procedure event(event_name varchar2) is
form_name varchar2(30) := name_in(’system.current_form’);
block_name varchar2(30) := name_in(’system.cursor_block’);
begin
if (form_name = ‘XXBI’ and block_name = ‘xxcc’) Then
if(event_name = ‘WHEN-NEW-FORM-INSTNACE’)
–Write your code here
elsif(event_name = ‘WHEN-VALIDATE-RECORD’)THEN
–Write your code here
else
null
end if;
end if;
end;

How to make the changes get affected?
Once you make all the necessary changes, compile the pll and generate the PLX file. Since the CUSTOM library is loaded once for a given session, a user must log out of the application and sign-on again before any changes will become apparent.
Forms Personalization: an alternative of custom.pll
In older versions, prior to 11i, Custom.PLL was most prominently used for adding additional features in the seeded form but the latest version of Oracle EBS comes with the feature called as Forms Personalization which allows even an end user to alter the seeded forms functionality using an user interface called the Personalization form.
Advantages of Forms Personalization over Custom.PLL:
•    Forms personalization can be used by an user with limited PL/SQL knowledge.
•    Changes take place immediately on reopening the form.
•    Anything which can be done using Custom.PLL can be done using Forms Personalization also.
•    Personalizations are stored in base tables related to Form Personalization.
•    CUSTOM.pll is a single file/entity, hence only one developer can make changes to CUSTOM.pll at any given point in time. This is not a restriction in Forms personalization.
•    Easy to disable/enable with click of a button.
•    Can be moved easily through FNDLOAD from one instance to other.
•    Can be restricted at site/responsibility/user level.
•    Personalization stores who columns with which we have the ability to track who created/modified it where as in CUSTOM.PLL we don’t have that ability

How to find personalizations in which form

--Query 1. Simple list of form personalizations, ordered by form
SELECT form_name Form, function_name Function, description Description,
   sequence Seq, trigger_event TriggerEvent, trigger_object TriggerObject,
   condition Condition, enabled
FROM fnd_form_custom_rules
ORDER BY form_name, function_name, sequence

--- Query 2. List of ALL OA Framework-based pages with Personalizations
SELECT PATH.PATH_DOCID PERZ_DOC_ID, jdr_mds_internal.getdocumentname(PATH.PATH_DOCID) PERZ_DOC_PATH
FROM JDR_PATHS PATH
WHERE PATH.PATH_DOCID IN
   (SELECT DISTINCT COMP_DOCID FROM JDR_COMPONENTS
   WHERE COMP_SEQ = 0 AND COMP_ELEMENT = 'customization'
   AND COMP_ID IS NULL)
ORDER BY PERZ_DOC_PATH

---Query 3. List of personalizations created at the customer site
SELECT PATH.PATH_DOCID PERZ_DOC_ID,
   jdr_mds_internal.getdocumentname(PATH.PATH_DOCID) PERZ_DOC_PATH
FROM JDR_PATHS PATH
WHERE PATH.PATH_DOCID IN
   (SELECT DISTINCT COMP_DOCID FROM JDR_COMPONENTS
   WHERE COMP_SEQ = 0 AND COMP_ELEMENT = 'customization'
   AND COMP_ID IS NULL)
MINUS
SELECT PATH.PATH_DOCID PERZ_DOC_ID,
   jdr_mds_internal.getdocumentname(PATH.PATH_DOCID) PERZ_DOC_PATH
FROM JDR_PATHS PATH
WHERE PATH.PATH_DOCID IN
   (SELECT DISTINCT COMP_DOCID FROM JDR_COMPONENTS, JDR_ATTRIBUTES
   WHERE COMP_SEQ = 0 AND COMP_ELEMENT = 'customization'
   AND COMP_ID IS NULL
   AND ATT_COMP_DOCID = COMP_DOCID
   AND ATT_COMP_SEQ = 0
   AND ATT_NAME = 'developerMode'
   AND ATT_VALUE = 'true')

Find the Concurrent Program Execution Method

		Spawned : Your concurrent program is a stand-alone program in C or Pro*C. Host : Your concurrent program is written in a script for your operating system. Immediate : Your concurrent program is a subroutine written in C or Pro*C. Immediate programs are linked in with your concurrent manage and must be included in the manager's program library. Oracle Reports : Your concurrent program is an Oracle Reports script. PL/SQL Stored Procedure : Your concurrent program is a stored procedure written in PL/SQL. Java Stored Procedure : Your concurrent program is a Java stored procedure. Java Concurrent Program : Your concurrent program is a program written in Java. Multi Language Function : A multi-language support function (MLS function) is a function that supports running concurrent programs in multiple languages (as well as territories and numeric character settings). You should not choose a multi-language function in the Executable: Name field. If you have an MLS function for your program (in addition to an appropriate concurrent program executable), you specify it in the MLS Function field. SQL*Loader : Your concurrent program is a SQL*Loader program. SQL*Plus : Your concurrent program is a SQL*Plus or PL/SQL script.

FNDLOAD Script for AOL and WebADI objects.

Before run FNDLOAD check the Set environment variables (.env)

. $APPL_TOP/custom< CONTEXT_NAME >.env (e.g. APPSICEBSDEV.env)

Following are the usage list of FNDLOAD to download and upload various AOL objects.

Concurrent Program

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXCUST_CP.ldt PROGRAM APPLICATION_SHORT_NAME="XXCUST" CONCURRENT_PROGRAM_NAME="XXCUST_CP"

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXCUST_CP.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

Data Definition and Data Template

FNDLOAD apps/apps 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXCUST_DD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=XXCUST DATA_SOURCE_CODE=XXCUST_DS

FNDLOAD apps/apps O Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXCUST_DD.ldt

Lookups

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XXCUST_LKP.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XX_CUST" LOOKUP_TYPE="XX_CUST_LKP"

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct  XX_CUST_LKP.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

Descriptive Flexfield

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XXPO_MY_DFF.ldt DESC_FLEX APPLICATION_SHORT_NAME="FND" DESCRIPTIVE_FLEXFIELD_NAME="FND_COMMON_LOOKUPS" DESCRIPTIVE_FLEX_CONTEXT_CODE="XXJG"

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct  XXJG.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

Message

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XXCUST_MESG.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME="XX_CUST" MESSAGE_NAME="XX_CUST_MESG%"

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct XXCUST_MESG.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

Request Set and Link

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct XXCUST_RS.ldt REQ_SET REQUEST_SET_NAME='XX_CUST_RS'

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct XXCUST_LNK.ldt REQ_SET_LINKS REQUEST_SET_NAME='XX_CUST_LNK'


FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct  XX_CUST_RS.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct  XX_CUST_LNK.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

Form Function

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXCUST_FUNC.ldt FUNCTION FUNC_APP_SHORT_NAME='XX_CUST' FUNCTION_NAME='XX_CUST_FUNC'

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XX_CUST_FUNC.ldt

Profile

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct XXCUST_PROF.ldt PROFILE PROFILE_NAME="XXCUST_PROFILE" APPLICATION_SHORT_NAME="XXCUST"

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct XXCUST_FUNC.ldt

Menu

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXCUST_MENU.ldt MENU MENU_NAME="XXCUST_MENU"

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XXCUST_MENU.ldt


-------------------------
Following are the usage list of FNDLOAD to download and upload various WebADI objects.
------------------------

• Integrators
• Contents
• Layouts
• Mappings
• Parameter List
• Components

Integrator
Command to Download Integrator

FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bneintegrator.lct XX_INTEGRATOR_LDT_FILE.ldt BNE_INTEGRATORS INTEGRATOR_ASN=”XX_CUST” INTEGRATOR_CODE=”XX_INTEGRATOR_CODE”

Command to Upload Integrator

FNDLOAD apps/apps 0 Y UPLOAD $BNE_TOP/patch/115/import/bneintegrator.lct XX_INTEGRATOR_LDT_FILE.ldt

Contents
Download
FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bnecont.lct XX_CONTENT_LDT_FILE.ldt BNE_CONTENTS CONTENT_ASN=”XX_CUST” CONTENT_CODE=”XX_CONTENT_CODE”

Upload
FNDLOAD apps/apps 0 Y UPLOAD $BNE_TOP/patch/115/import/bnecont.lct XX_CONTENT_LDT_FILE.ldt

Layout:
Download
FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bnelay.lct XX_LAYOUT_LDT_FILE.ldt BNE_LAYOUTS LAYOUT_ASN=”XX_CUST” LAYOUT_CODE=”XX_LAYOUT_CODE”

Upload
FNDLOAD apps/apps 0 Y UPLOAD $BNE_TOP/patch/115/import/bnelay.lct XX_LAYOUT_LDT_FILE.ldt

Mappings
Download
FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bnemap.lct XX_MAPPINGS_LDT_FILE.ldt BNE_MAPPINGS MAPPING_ASN=”XX_CUST” MAPPING_CODE=”XX_MAPPINGS_CODE”

Upload
FNDLOAD apps/apps 0 Y UPLOAD $BNE_TOP/patch/115/import/bnemap.lct XX_MAPPINGS_LDT_FILE.ldt

Parameter Lists
Download
FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bneparamlist.lct XX_PARAM_LIST_LDT_FILE.ldt BNE_PARAM_LISTS PARAM_LIST_ASN=”XX_CUST” PARAM_LIST_CODE=”XX_PARAM_LIST_CODE”

Upload
FNDLOAD apps/apps 0 Y UPLOAD $BNE_TOP/patch/115/import/bneparamlist.lct XX_PARAM_LIST_LDT_FILE.ldt

Components
Download
FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bnecomp.lct XX_COMPONENT_LDT_FILE.ldt BNE_COMPONENTS COMPONENT_ASN=”XXOM” COMPONENT_CODE=”XX_COMPONENT_CODE”

Upload
FNDLOAD apps/apps 0 Y UPLOAD $BNE_TOP/patch/115/import/bnecomp.lct XX_COMPONENT_LDT_FILE.ldt


Workflow
Download
WFLOAD apps/<<Apps Password>> 0 Y DOWNLOAD JGAPINVW.wft JGAPINVW

Upload
WFLOAD apps/<<Apps Password>> 0 Y UPLOAD JGAPINVW.wft JGAPINVW

Upgrade

WFLOAD apps/<<Apps Password>> 0 Y UPGRADE JGAPINVW.wft JGAPINVW

SoftLinkx

ln -s $FND_TOP/bin/fndcpesr $XXJG_TOP/bin/XXJG_TEST_P

How to find Scheduled concurrent program or request will be runing ?

SELECT r.request_id, u.user_name requestor, pt.user_concurrent_program_name,
       r.phase_code, r.status_code, r.priority_request_id, r.priority,
       r.request_date, r.requested_by, r.requested_start_date, r.hold_flag,
       r.has_sub_request, r.is_sub_request, r.update_protected,
       r.queue_method_code, r.responsibility_application_id,
       r.responsibility_id, r.save_output_flag, r.last_update_date,
       r.last_updated_by, r.last_update_login, r.printer, r.print_style,
       r.parent_request_id, r.controlling_manager, r.actual_start_date,
       r.actual_completion_date, r.completion_text, r.argument_text,
       r.implicit_code, r.request_type, r.program_application_id,
       r.concurrent_program_id, pb.concurrent_program_name program_short_name,
       pb.execution_method_code, pb.enabled_flag enabled,
       DECODE (r.description,
               NULL, pt.user_concurrent_program_name,
               r.description || ' (' || pt.user_concurrent_program_name || ')'
              ) program_name,
       pb.printer_name fcp_printer, pb.output_print_style fcp_print_style,
       pb.required_style fcp_required_style,
       s.user_printer_style_name user_print_style, r.description
  FROM applsys.fnd_concurrent_programs_tl pt,
       applsys.fnd_concurrent_programs pb,
       applsys.fnd_user u,
       applsys.fnd_printer_styles_tl s,
       applsys.fnd_concurrent_requests r
 WHERE pb.application_id = r.program_application_id
   AND pb.concurrent_program_id = r.concurrent_program_id
   AND pb.application_id = pt.application_id
   AND pb.concurrent_program_id = pt.concurrent_program_id
   AND pt.LANGUAGE = USERENV ('LANG')
   AND u.user_id = r.requested_by
   AND s.printer_style_name(+) = r.print_style
   AND s.LANGUAGE(+) = USERENV ('LANG')
   AND u.user_name = NVL(:p_requestor,u.user_name)
   AND phase_code = 'P' -- Pending
   AND status_code IN ('I', 'Q')
     AND ((   DECODE (implicit_code, 'N', status_code, 'E', 'E', 'W', 'G') =
                                                                   status_code
           OR DECODE (implicit_code, 'W', 'E') = status_code
          )
         )
     AND (NVL (request_type, 'X') != 'S')

How to add a Concurrent Program to Responsibility (Request Group) using API

Example 1. Custom Responsibility (Request Group)

BEGIN
apps.fnd_program.add_to_group(
        PROGRAM_SHORT_NAME  => 'XXCONA_JG',
        PROGRAM_APPLICATION => 'XXILL',
        REQUEST_GROUP       => 'XXILL Request Group',
        GROUP_APPLICATION   => 'XXILL'
      );
COMMIT;
END;

Example 2. India Localization Purchasing Request Group
BEGIN
apps.fnd_program.add_to_group(
        PROGRAM_SHORT_NAME  => 'XXCONA_JG',
        PROGRAM_APPLICATION => 'XXILL',
        REQUEST_GROUP       => 'JAI_Purchasing_RG',
        GROUP_APPLICATION   => 'JA'
      );
COMMIT;
END;


Example 3. India Localization Receivables Request Group
BEGIN
apps.fnd_program.add_to_group(
        PROGRAM_SHORT_NAME  => 'XXCONA_JG',
        PROGRAM_APPLICATION => 'XXILL',
        REQUEST_GROUP       => 'JAI_Receivables_RG',
        GROUP_APPLICATION   => 'JA'
      );
COMMIT;
END;

How to enable the Default Operating Unit in R12

1. Login into application with System Administration responsibility after then  Concurrent -> Programs

2. Query for short name of the concurrent program to find and then click update button.

3. Select on Request Tab.

4. Select Single from the drop down of Operating Unit Mode field.

5. Save changes by clicking on Apply button 

How to find the Lock table in oracle apps

SELECT   a.session_id,
         a.oracle_username,
         a.os_user_name,
         b.owner "OBJECT OWNER",
         b.object_name,
         b.object_type,
         a.locked_mode
  FROM   (SELECT   object_id,
                   SESSION_ID,
                   ORACLE_USERNAME,
                   OS_USER_NAME,
                   LOCKED_MODE
            FROM   v$locked_object) a, (SELECT   object_id,
                                                 owner,
                                                 object_name,
                                                 object_type
                                          FROM   dba_objects) b
 WHERE   a.object_id = b.object_id;

/

select sid,

decode(block ,0,'NO','YES') BLOCKER,

decode(request,0,'NO','YES') WAITER

from v$lock

where request > 0 or block > 0 order by block desc;

How to find the Concurrent Program for which Responsibility to assign

---Responsibility find on a Concurrent Program

SELECT   f.application_short_name app_short_name,
         responsibility_name,
         responsibility_key,
         request_group_name,
         user_concurrent_program_name program_name
  FROM   fnd_request_groups a,
         fnd_request_group_units b,
         fnd_concurrent_programs_vl c,
         fnd_responsibility d,
         fnd_responsibility_tl e,
         fnd_application f
 WHERE       a.request_group_id = b.request_group_id
         AND b.request_unit_id = c.concurrent_program_id
         AND a.request_group_id = d.request_group_id
         AND d.responsibility_id = e.responsibility_id
         AND d.application_id = f.application_id
         AND user_concurrent_program_name =
               NVL (:REPORT_NAME, user_concurrent_program_name)

How to call Concurrent Request from an Oracle Reports

1. Define "User Parameters" of type number by the name:

    P_CONC_REQUEST_ID

 2. Add below script on Before-Report trigger:

    SRW.USER_EXIT('FND SRWINIT');

3. Create a script to call Concurrent program on report-trigger (e.g. AfterReport )


 l_request_id     NUMBER;
 l_layout_id      BOOLEAN;


    l_layout_id :=   
                    fnd_request.add_layout (template_appl_name   => 'XXILL',
                                  template_code        => 'XXCONA_PURCHASE_COND',
                                  template_language    => 'en',
                                  template_territory   => 'IN',
                                  output_format        => 'PDF'
                                  );

    l_request_id :=
          fnd_request.submit_request
                                   (application      => 'XXILL',
                                    program          => 'XXCONA_PURCHASE_COND',
                                    description      => NULL,
                                    start_time        => SYSDATE,
                                    sub_request     => FALSE,
                                    argument1        => :P_ORG_ID,
                                    argument2        => :PO_ORDER
                                   );
          Commit;

4. Add below script on After-Report Trigger

    SRW.USER_EXIT('FND SRWEXIT');