Monday, November 26, 2012

Query To Fetch Customer email address

SELECT hp.person_first_name



' '



hp.person_last_name

, hoc.contact_number

, hp1.email_address

FROM hz_cust_account_roles hcar

, hz_parties hp

, hz_relationships hr

, hz_org_contacts hoc

, hz_parties hp1

, hz_cust_accounts hca

WHERE hcar.party_id = hr.party_id

AND hcar.role_type = 'CONTACT'

AND hoc.party_relationship_id = hr.relationship_id

AND hr.subject_id = hp.party_id

AND hr.party_id = hp1.party_id

AND hr.subject_table_name = 'HZ_PARTIES'

AND hr.object_table_name = 'HZ_PARTIES'

AND hcar.cust_account_id = hca.cust_account_id

AND hca.party_id = hr.object_id

-- AND hcar.cust_account_role_id = v_ship_contact_id;

and hca.account_number=<>;

Thursday, November 1, 2012

Script to list All OAF personalizations in the system

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;

Wednesday, October 31, 2012

API for adding responsibility to user

DECLARE
CURSOR c1
IS
select responsibility_id, application_id
from fnd_responsibility_vl a where
a.responsibility_name in
(and not exists (
select 1
from FND_USER_RESP_GROUPS_DIRECT
where user_id=
and responsibility_id=a.responsibility_id);
l_number NUMBER := 0;
BEGIN
FOR c1_rec IN c1
LOOP
BEGIN

SELECT 1

INTO l_number

FROM FND_USER_RESP_GROUPS_DIRECT a

WHERE a.responsibility_id = c1_rec.responsibility_id

AND a.user_id = 7081;

EXCEPTION

WHEN NO_DATA_FOUND

THEN

l_number := 2;

WHEN OTHERS

THEN

l_number := 0;

END;



IF l_number = 2

THEN

DBMS_OUTPUT.

put_line (

'resp id --'



c1_rec.responsibility_id



'---Application id--> '



c1_rec.application_id);

fnd_user_resp_groups_api.

Insert_Assignment (

user_id => 7081,

responsibility_id => c1_rec.responsibility_id,

responsibility_application_id => c1_rec.application_id,

start_date => SYSDATE,

end_date => NULL,

description => NULL);

END IF;

END LOOP;



COMMIT;

END;

Wednesday, October 24, 2012

Supplier Conversion

http://prasanthapps.blogspot.co.uk/2011/04/supplier-conversion-in-r12.html

Tuesday, October 23, 2012

java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: Variable

There should not be any Bind variables defined in View Object if it is not used in SQL Query.

To remove the Bind Variables from the View Object.

1.Go to Edit view Object.-->Bind Variables
2.Select any variable defined and select remove button.

class apps.oracle.ak.prativa.testing.TlkApInvoicesHeaderTmpImpl should be declared abstract; it does not define method setLastUpdateLogin(oracle.jbo.domain.Number) in class oracle.apps.fnd.framework.server.OAEntityImpl

To overcome this issue, simply copy past the below lines into your EOImpl


public void setLastUpdateLogin( oracle.jbo.domain.Number n ) {}

public void setLastUpdatedBy( oracle.jbo.domain.Number n ) {}

public void setLastUpdateDate( oracle.jbo.domain.Date n ) {}

public void setCreationDate( oracle.jbo.domain.Date n ) {}

public void setCreatedBy( oracle.jbo.domain.Number n ) {}



Friday, October 19, 2012

Errors and resolution in OAF

Error


======

You have insufficient privileges for the current operation. Please contact your System Administrator.



You cannot run a page which is not SelfSecured when the MAC fails.



Solution:

=========

Set the profiles of the below three to 'None'



FND Validation Level

FND Function Validation Level

Framework Validation Level





Error:

======

when I am running, the fwktutorial.jsp, i am getting the links for hello world, etc. However when i click on the links, i am getting the follwoing error;

error:

Unexpected URL parameters have been detected and will be ignored.





Solution:

=========

Go to Tools-->Embedded OC4J Preferences-->Global-->Startup-->Select Default Local IP Address.

How to find the DBC File


It has different paths in 11i and R12.



Path in 11i:

$FND_TOP/secure





Path in R12:

$INST_TOP/appl/fnd/12.0.0/secure

Wednesday, October 10, 2012

Existing State Of Package Body "Apps.CS_WF_ACTIVITIES_PKG" Has Been Invalidated

Existing State Of Package Body "Apps.CS_WF_ACTIVITIES_PKG" Has Been Invalidated [ID 422925.1]

Tuesday, October 9, 2012

SQL to see profile option value

elect lpad(fpo.profile_option_name,55) pon

, lpad(fpot.user_profile_option_name,55) upon

, fpot.description d

, lpad(fpo.start_date_active,15) sda

, lpad(fpo.end_date_active,15) eda

, lpad(fpo.creation_date,15) cd

, lpad(fu.user_name,20) cb

, 'Site' lo

, 'SITE' lov

, fpov.profile_option_value pov

from FND_PROFILE_OPTIONS_TL fpot

, FND_PROFILE_OPTIONS fpo

, FND_PROFILE_OPTION_VALUES fpov

, FND_USER fu

where fpot.user_profile_option_name like '&&profile_like'

and fpot.profile_option_name = fpo.profile_option_name

and fpo.application_id = fpov.application_id

and fpo.profile_option_id = fpov.profile_option_id

and fpo.created_by = fu.user_id

and fpot.language = Userenv('Lang')

and fpov.level_id = 10001 /* Site Level */

union all

select lpad(fpo.profile_option_name,55) pon

, lpad(fpot.user_profile_option_name,55) upon

, fpot.description d

, lpad(fpo.start_date_active,15) sda

, lpad(fpo.end_date_active,15) eda

, lpad(fpo.creation_date,15) cd

, lpad(fu.user_name,20) cb

, 'Apps' lo

, fa.application_name lov

, fpov.profile_option_value pov

from FND_PROFILE_OPTIONS_TL fpot

, FND_PROFILE_OPTIONS fpo

, FND_PROFILE_OPTION_VALUES fpov

, FND_USER fu

, FND_APPLICATION_TL fa

where fpot.user_profile_option_name like '&&profile_like'

and fpot.profile_option_name = fpo.profile_option_name

and fpo.profile_option_id = fpov.profile_option_id

and fpo.created_by = fu.user_id

and fpot.language = Userenv('Lang')

and fpov.level_id = 10002 /* Application Level */

and fpov.level_value = fa.application_id

union all

select lpad(fpo.profile_option_name,55) pon

, lpad(fpot.user_profile_option_name,55) upon

, fpot.description d

, lpad(fpo.start_date_active,15) sda

, lpad(fpo.end_date_active,15) eda

, lpad(fpo.creation_date,15) cd

, lpad(fu.user_name,20) cb

, 'Resp' lo

, frt.responsibility_name lov

, fpov.profile_option_value pov

from FND_PROFILE_OPTIONS_TL fpot

, FND_PROFILE_OPTIONS fpo

, FND_PROFILE_OPTION_VALUES fpov

, FND_USER fu

, FND_RESPONSIBILITY_TL frt

where fpot.user_profile_option_name like '&&profile_like'

and fpot.profile_option_name = fpo.profile_option_name

and fpo.profile_option_id = fpov.profile_option_id

and fpo.created_by = fu.user_id

and frt.language = Userenv('Lang')

and fpot.language = Userenv('Lang')

and fpov.level_id = 10003 /* Responsibility Level */

and fpov.level_value = frt.responsibility_id

and fpov.level_value_application_id = frt.application_id

union all

select lpad(fpo.profile_option_name,55) pon

, lpad(fpot.user_profile_option_name,55) upon

, fpot.description d

, lpad(fpo.start_date_active,15) sda

, lpad(fpo.end_date_active,15) eda

, lpad(fpo.creation_date,15) cd

, lpad(fu.user_name,20) cb

, 'User' lo

, fu2.user_name lov

, fpov.profile_option_value pov

from FND_PROFILE_OPTIONS_TL fpot

, FND_PROFILE_OPTIONS fpo

, FND_PROFILE_OPTION_VALUES fpov

, FND_USER fu

, FND_USER fu2

where fpot.user_profile_option_name like '&&profile_like'

and fpot.profile_option_name = fpo.profile_option_name

and fpo.profile_option_id = fpov.profile_option_id

and fpo.created_by = fu.user_id

and fpov.level_id = 10004 /* User Level */

and fpov.level_value = fu2.user_id

and fpot.language = Userenv('Lang')

order by upon, lo, lov

Tuesday, October 2, 2012

Convert Oracle Report 6i to BIP

http://bipublisher.blogspot.com/2009/05/bi-publisher-reports6i-to-bip.html




Tuesday, September 18, 2012

Link between Internal requisition and Internal sales order


1. OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID =



po_requisition_lines_all.REQUISITION_LINE_ID

2. OE_ORDER_LINES_ALL.ORIG_SYS_DOCUMENT_REF=

po_requisition_HEADERs_all.SEGMENT1(Requisition Number)

3. OE_ORDER_HEADERS_ALL.ORIG_SYS_DOCUMENT_REF=

po_requisition_HEADERs_all.SEGMENT1(Requisition number)

Tuesday, September 11, 2012

Displaying ROWID in TOAD

That’s EXACTLY what it is.



In your data grid, mouse-right-click – SELECT COLUMNS



Enable ‘ROWID’



You also have –



Toad – View – Options – Data Grids – Data – Display – ‘Show ROWID in editable grids’

Wednesday, August 15, 2012

Query to find the time difference of a concurrent request

SELECT request_id


, x.status_code sts_cod

, (SELECT user_concurrent_program_name

FROM fnd_concurrent_requests a, fnd_concurrent_programs_vl b

WHERE a.request_id = x.request_id

AND a.concurrent_program_id = b.concurrent_program_id)

concurrent_program

, (SELECT meaning

FROM fnd_lookups

WHERE lookup_code = x.status_code

AND lookup_type = 'CP_STATUS_CODE')

status

, fu.user_name

, fu.description

, argument_text parameters

, actual_start_date actual_start_with_time

, TRUNC(actual_start_date) actual_start

, actual_completion_date actual_completion

, DECODE (

actual_completion_date

, NULL, TO_CHAR (

TO_DATE ('00:00:00', 'HH24:MI:SS')

+ (SYSDATE - actual_start_date)

, 'HH24:MI:SS'

)

, TO_CHAR (

TO_DATE ('00:00:00', 'HH24:MI:SS')

+ (actual_completion_date - actual_start_date)

, 'HH24:MI:SS'

)

)

hr_min_sec

, TO_CHAR (SYSDATE, 'ddmm:hh:mi:ss') systime

, completion_text

--,(ROUND(to_number(actual_completion_date -actual_start_date) *60 *60 *24)) dt_dif_in_sec

FROM fnd_concurrent_requests x, fnd_user fu, fnd_responsibility_vl frv

WHERE frv.responsibility_key LIKE '%\_UK\_%' ESCAPE '\'--all UK responsibilities

AND frv.responsibility_id = x.responsibility_id

AND x.requested_by = fu.user_id

AND x.concurrent_program_id IN

( --(170990),

(SELECT concurrent_program_id

FROM fnd_concurrent_programs_vl

WHERE UPPER (user_concurrent_program_name) LIKE 'XX%'))

--and request_id = 27061498

and actual_start_date <= sysdate

Tuesday, August 14, 2012

Upgrading Form Personalizations and OA Framework Personalizations from Oracle E-Business Suite Release 11i to 12.1 [ID 1292611.1]

Tuesday, July 17, 2012

Attach responsibility to user from backend

BEGIN

fnd_user_pkg.addresp(username =&gt
,resp_app =&gt 'SYSADMIN'

,resp_key =&gt  'SYSTEM_ADMINISTRATOR'

,security_group =&gt  'STANDARD'

,description =&gt 'Custom System administrator responsibility'

,start_date =&gt  Sysdate

,end_date = &gt Sysdate +100);

COMMIT;

END;

Monday, July 16, 2012

Passing Multiple Paramaters to the form from form personalisation

Type:Built In
Built In Type:Launch a Function
Function Code:
Function Name:
Parameters:
='XXINV_ORDER_NUMBER='


${item.order.order_number.value}

'

XXINV_ITEM_CODE='

${item.line.ordered_item_dsp.value}

' XXINV_ORDER_LINE_ID='

${item.line.ato_line_id.value}

' XXINV_ORIG_LINE_ID='

${item.line.line_id.value}

'

XXINV_CUST_ID='

${item.order.sold_to_org_id.value}

' XXINV_CUST_PART_NO='

'"'

${var.L_CHR_CUST_PART_NO.value}

'"'

Wednesday, July 11, 2012

Calling Form Function With Predefined Paramaters

Type:Built In
Built In Type:Launch a Function
Function Code:
Function Name:


Parameters='G_HEADER_ID = "'||:ORDER.HEADER_ID||'"'

Tuesday, July 3, 2012

Printing Problem in PDF format

https://kr.forums.oracle.com/forums/thread.jspa?messageID=9202118

cd $FND_TOP/resource




Vi pasta_pdf.cfg



Existing one - old vallue (Comment out this)

Preprocess= dftops {infile} {outfile}



Modified one - New value for pdf printing

preprocess=pdf2ps {infile} {outfile}

; semicolon is missing in preprocess.
 

Friday, June 22, 2012

FNDLOAD to add a program to existing request group

FNDLOAD apps/london01 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_WIP_UK_01.ldt REQUEST_GROUP REQUEST_GROUP_NAME="XX_WIP_UK" UNIT_APP="XXWIP" UNIT_NAME="XXWIP4962_01"




FNDLOAD apps/$pwd 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_WIP_UK.ldt

Wednesday, June 6, 2012

Definition Of Bill Of Lading

Definition of 'Bill Of Lading'


A legal document between the shipper of a particular good and the carrier detailing the type, quantity and destination of the good being carried. The bill of lading also serves as a receipt of shipment when the good is delivered to the predetermined destination. This document must accompany the shipped goods, no matter the form of transportation, and must be signed by an authorized representative from the carrier, shipper and receiver.

For example, suppose that a logistics company must transport gasoline from a plant in Texas to a gas station in Arizona via heavy truck. A plant representative and the driver would sign the bill of lading after the gas is loaded onto the truck. Once the gasoline is delivered to the gas station in Arizona, the truck driver must have the clerk at the station sign the document as well.

SQL Query for WIP JOBS associated to a sales order

Query1:
--------
SELECT


ooh.order_number

,msib.segment1

,mr.reservation_quantity

, we.wip_entity_name wip_job_name

, wdj.scheduled_start_date wip_start_date

, wdj.scheduled_completion_date wip_completion_date

, wdj.attribute10 job_type

FROM oe_order_headers_all ooh

, oe_order_lines_all ool

, mtl_reservations mr

, wip_discrete_jobs wdj

, wip_entities we

,mtl_system_items_b msib

WHERE ooh.header_id = ool.header_id

AND ooh.org_id = 160

-- AND ool.item_type_code IN ('CONFIG', 'STANDARD')

AND mr.demand_source_line_id = ool.line_id

AND mr.supply_source_type_id = 5

AND mr.supply_source_header_id = we.wip_entity_id

AND we.wip_entity_id = wdj.wip_entity_id

AND ool.ship_from_org_id = we.organization_id

AND ool.ship_from_org_id=msib.organization_id

AND mr.inventory_item_id=msib.inventory_item_id

AND we.organization_id = wdj.organization_id

Price adjustment query

Query1:
------

select ooh.order_number,


(SELECT SUM(NVL(ordered_quantity,0)*NVL(unit_selling_price,0))

FROM oe_order_lines_all

where header_id=ool.header_id

AND line_id=ool.line_id

and org_id=ool.org_id

)line_total,

SUM(NVL (ool.tax_value, 0)) tax_amount

,(SELECT NVL(SUM(NVL(opa.operand,0)),0)

FROM oe_price_adjustments opa

WHERE

opa.header_id = ooh.header_id

AND opa.line_id=ool.line_id

AND opa.applied_flag = 'Y'

AND opa.list_line_type_code = 'FREIGHT_CHARGE') Freight_charges,

(SELECT NVL(SUM(NVL (ool.pricing_quantity, 0) * NVL (opa.adjusted_amount, 0)),0)

FROM oe_price_adjustments opa

WHERE

opa.header_id = ool.header_id

AND opa.line_id=ool.line_id

AND opa.applied_flag = 'Y'

AND opa.list_line_type_code = 'DIS') Discount_amount

from oe_order_headers_all ooh,

oe_order_lines_all ool,

hz_cust_site_uses_all hcsua,

hz_cust_acct_sites_all hcasa,

hz_cust_accounts hca,

hz_parties hp,

ra_terms rt

,oe_transaction_types_tl ott

,ra_salesreps_all rs

-- ,oe_price_adjustments_v opa

where ooh.header_id=ool.header_id

AND ooh.org_id=ool.org_id

AND ooh.ship_to_org_id = hcsua.site_use_id

AND hcsua.cust_acct_site_id=hcasa.cust_acct_site_id

and hcasa.cust_account_id=hca.cust_account_id

and hca.party_id=hp.party_id

and hcsua.org_id=ooh.org_id

and ooh.payment_term_id=rt.term_id(+)

AND ooh.order_type_id = ott.transaction_type_id

AND ooh.salesrep_id=rs.salesrep_id(+)

AND ooh.org_id=rs.org_id

--AND opa.header_id(+) = ooh.header_id

--AND opa.applied_flag(+) = 'Y'

--AND opa.list_line_type_code(+) = 'FREIGHT_CHARGE'

AND ott.language='US'

AND ool.item_type_code <> 'CONFIG'

AND ool.top_model_line_id is null

--and ooh.order_number='3303592'

AND ooh.org_id=160

--and ooh.creation_date>sysdate-5

AND EXISTS(SELECT 1

FROM MTL_DESCR_ELEMENT_VALUES_V

WHERE inventory_item_id=ool.inventory_item_id

AND element_name='BM.Product'

AND element_value is not null)

group by

hcsua.attribute15,

ooh.transactional_Curr_code,

ooh.cust_po_number,

ooh.fob_point_code,

ool.tax_code,

rt.name,

ool.line_id,

hp.party_name,

hca.account_number,

ooh.order_number

,ott.name

,ooh.flow_status_code

,ool.flow_status_code

,rs.name

,ooh.orig_sys_document_ref

,ool.ordered_quantity

,unit_selling_price

,ool.header_id

,ool.org_id

,ool.pricing_quantity

, ooh.header_id

,ool.ordered_item

,ooh.request_date

,ool.request_date

,ool.schedule_ship_date

,ool.promise_date


Query2:
--------
select ooh.order_number "Order Number"


,hcsua.attribute15 "Ship To Reference Number",

ooh.transactional_Curr_code,

ooh.cust_po_number,

ooh.fob_point_code,

ooh.request_date,

ool.request_date,

ool.schedule_ship_date,

ool.promise_date,

ool.tax_code,

ool.ordered_item,

rt.name,

hp.party_name "Customer Name",

hca.account_number "Customer Number"

,ott.name "Transaction Type Name"

,ooh.flow_status_code "Order Status"

,ool.flow_status_code "Line Status"

,rs.name "Sales Person Name"

,ooh.orig_sys_document_ref

,ool.ordered_quantity

,(select SUM(NVL(ordered_quantity,0)*NVL(unit_selling_price,0)) from oe_order_lines_all where top_model_line_id=ool.top_model_line_id) Line_total

,(select SUM(NVL (tax_value, 0)) from oe_order_lines_all where top_model_line_id=ool.top_model_line_id) Line_tax_amount

,(select NVL(sum(operand),0) from oe_price_adjustments a,oe_order_lines_all b where a.line_id=b.line_id

and a.list_line_type_code='FREIGHT_CHARGE' and a.applied_flag(+) = 'Y'

and b.top_model_line_id=ool.top_model_line_id) freight_charges

,(select NVL(SUM(NVL (b.pricing_quantity, 0) * NVL (a.adjusted_amount, 0)),0) from oe_price_adjustments a,oe_order_lines_all b where a.line_id=b.line_id

and a.list_line_type_code='DIS' and a.applied_flag(+) = 'Y'

and b.top_model_line_id=ool.top_model_line_id) Discount_amount

,ool.line_id

from oe_order_headers_all ooh,

oe_order_lines_all ool,

hz_cust_site_uses_all hcsua,

hz_cust_acct_sites_all hcasa,

hz_cust_accounts hca,

hz_parties hp,

ra_terms rt

,oe_transaction_types_tl ott

,ra_salesreps_all rs

-- ,oe_price_adjustments_v opa

where ooh.header_id=ool.header_id

AND ooh.org_id=ool.org_id

AND ooh.ship_to_org_id = hcsua.site_use_id

AND hcsua.cust_acct_site_id=hcasa.cust_acct_site_id

and hcasa.cust_account_id=hca.cust_account_id

and hca.party_id=hp.party_id

and hcsua.org_id=ooh.org_id

and ooh.payment_term_id=rt.term_id(+)

AND ooh.order_type_id = ott.transaction_type_id

AND ooh.salesrep_id=rs.salesrep_id(+)

AND ooh.org_id=rs.org_id

AND ott.language='US'

AND ool.item_type_code = 'CONFIG'

--and ooh.order_number='3303308'

AND ooh.org_id=160

group by

hcsua.attribute15,

ooh.transactional_Curr_code,

ooh.cust_po_number,

ooh.fob_point_code,

ool.tax_code,

rt.name,

ool.line_id,

hp.party_name,

hca.account_number,

ooh.order_number

,ott.name

,ooh.flow_status_code

,ool.flow_status_code

,rs.name

,ooh.orig_sys_document_ref

,ool.ordered_quantity

,unit_selling_price

,ool.header_id

,ool.org_id

,ool.pricing_quantity

, ooh.header_id

,ool.ordered_item

,ool.top_model_line_id

,ool.link_to_line_id

,ooh.request_date

,ool.request_date

,ool.schedule_ship_date

,ool.promise_date
 

Friday, June 1, 2012

R12: How to set default template for an XML Publisher request? [ID 1264858.1]

R12: How to set default template for an XML Publisher request? [ID 1264858.1]

PDF output from XML Publisher Reports

How To Print XML Publisher PDF Reports Via The Concurrent Manager [ID 338990.1]
NOTE:333504.1 - How To Print Concurrent Requests in PDF Format



Tuesday, May 29, 2012

sql for customer bill to address

SELECT c.site_use_id,

a.cust_account_id,

e.address1,

e.address2,

e.address3,

e.address4,

e.postal_code,

e.province,

e.state,

country

FROM hz_cust_accounts a,

hz_cust_acct_sites_all b,

hz_cust_site_uses_all c,

hz_party_sites d,

hz_locations e

WHERE a.cust_account_id = b.cust_account_id

AND b.cust_acct_site_id = c.cust_acct_site_id

AND b.party_site_id = d.party_site_id

AND d.location_id = e.location_id

AND c.site_use_code = 'BILL_TO'

AND c.status = 'A'

AND b.org_id = c.org_id

AND b.org_id = 160

AND a.cust_account_id IN (595595, 555158)

Tuesday, May 22, 2012

Wednesday, May 16, 2012

SQL Queries for checking Profile Option Values


SELECT

substr(pro1.user_profile_option_name,1,35) Profile,

decode(pov.level_id,

10001,'Site',

10002,'Application',

10003,'Resp',

10004,'User') Option_Level,

decode(pov.level_id,

10001,'Site',

10002,appl.application_short_name,

10003,resp.responsibility_name,

10004,u.user_name) Level_Value,

nvl(pov.profile_option_value,'Is Null') Profile_option_Value

FROM

fnd_profile_option_values pov,

fnd_responsibility_tl resp,

fnd_application appl,

fnd_user u,

fnd_profile_options pro,

fnd_profile_options_tl pro1

WHERE

pro1.user_profile_option_name like ('%Ledger%')

and pro.profile_option_name = pro1.profile_option_name

and pro.profile_option_id = pov.profile_option_id

and resp.responsibility_name like '%General%Ledger%' /* comment this line if you need to check profiles for all responsibilities */

and pov.level_value = resp.responsibility_id (+)

and pov.level_value = appl.application_id (+)

and pov.level_value = u.user_id (+)

order by 1,2;



Monday, May 14, 2012

Function is not available for this responsibility.Contact your system Administrator or change the responsibility

Function is not available for this responsibility.Contact your system Administrator or change the responsibility


Solution:
======


Put entry of the custom top in the default.env file under $INST_TOP/ora/10.1.2/forms/server.

eg:XXXX_TOP=$APPL_TOP/xxxx/12.0.0 (better write full path of $APPL_TOP insted of writing $APPL_TOP)



Wednesday, April 18, 2012

Program - Publish FSG Report custom template will not show after R12 upgrade from 11i

Solution:The data definition in 11i is FSG Program and where as in R12.1.3 it is FSGXML Program.Please change all your custom template definition to New R12 data definition FSGXML Programs.

Friday, April 13, 2012

Record has been updated. Requery block to see change

"Record has been updated. Requery block to see change" error while trying to process MTI records from front end.

Reason:There could be possiblity of trailing and leading spaces in the field values...
Eg.Transaction_SOurce_name field has value of ' TEST' after removing the Trailing spaces in the field 'TEST'.The records are processing without any issues.

Thursday, April 12, 2012

SQL to find special character records in a table

select city from hz_locations where regexp_like(city,chr(15712189));

R12 changes in JA Tables

--Obsolete in R12
ja.ja_in_so_lines JSL
ja.ja_in_tax_categories JTC

--Replaced the above tables with the below tables
ja.JAI_OM_OE_SO_LINES JSL
ja.JAI_CMN_TAX_CTGS_ALL JTC

Friday, March 9, 2012

Oracle APPS Useful Technical Websites

--Good document for oracle forms.
http://www.scribd.com/doc/51362321/99/Data-Block-Level-Transaction-Triggers

http://bbs.erp100.com/document/yanerwei/OAF_TRAINING/training_movie/Lesson5/Lesson5.html
http://amitsrivastavaoaf.blogspot.com
http://www.tier1inc.com/blog.php
http://sheikyerbouti.developpez.com/tutoforms10g/tutoforms10g.htm
http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28419/d_stats.htm

10g and 11g new features
http://www.asktheoracle.net/oracle-10g-plsql-new-features.html

Excel:
http://www.homeandlearn.co.uk/ME/MicrosoftExcel.html

MOAC:
http://support.rysigo.com/entries/20514742-r12-oracle-applications-multiple-organizations-access-control-for-custom-code-oracle-note-id-420787-#overview

Good Website for Oracle Apps Technical
http://startapps.blogspot.com/2011/03/how-to-find-backend-sql-query-from-self.html