Understanding the AR_PAYMENTS_INTERFACE Table

Column Name		Null?	Type
TRANSMISSION_RECORD_ID			NUMBER(15)
SOURCE:	AR_PAYMENTS_INTERFACE_S.NEXTVAL
DESTINATION:	None
CREATION_DATE			DATE
SOURCE:	CURRENT SYSTEM DATE
DESTINATION:	None
CREATED_BY			NUMBER(15)
SOURCE:	FND_USER.USER_ID
DESTINATION:	AR_BATCHES.CREATED_BY
	AR_INTERIM_CASH_RECEIPTS.CREATED_BY
	AR_INTERIM_CASH_RECEIPT_LINES.CREATED_BY
LAST_UPDATE_LOGIN			NUMBER(15)
SOURCE:	UNKNOWN
DESTINATION:	None
LAST_UPDATED_BY			NUMBER(15)
SOURCE:	FND_USER.USER_ID
DESTINATION:	None
LAST_UPDATE_DATE			DATE
SOURCE:	CURRENT SYSTEM DATE
DESTINATION:	None
RECORD_TYPE		NOT NULL	VARCHAR2(2)
SOURCE:	AR_TRANS_RECORD_FORMATS.RECORD_IDENTIFIER
DESTINATION:	None
STATUS			VARCHAR2(30)
SOURCE:	FND_MESSAGES.MESSAGE_NAME
DESTINATION:	None
TRANSMISSION_REQUEST_ID			NUMBER(15)
SOURCE:	FND_CONCURRENT_REQUESTS.REQUEST_ID
DESTINATION:	None
TRANSMISSION_ID			NUMBER(15)
SOURCE:	AR_TRANSMISSIONS.TRANSMISSION_ID
DESTINATION:	None
DESTINATION_ACCOUNT			VARCHAR2(25)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_TRANSMISSIONS.DESTINATION
ORIGINATION			VARCHAR2(25)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_TRANSMISSIONS.ORIGIN
DEPOSIT_DATE			DATE
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_BATCHES.DEPOSIT_DATE
GL_DATE			DATE
SOURCE:	DERIVED FROM DEPOSIT DATE, IMPORT DATE OR
	ENTERED DATE
DESTINATION:	AR_BATCHES.GL_DATE
	AR_INTERIM_CASH_RECEIPTS.GL_DATE
	AR_CASH_RECEIPT_HISTORY.GL_DATE
DEPOSIT_TIME			VARCHAR2(8)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	None
TRANSMISSION_RECORD_ COUNT			NUMBER(15)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_TRANSMISSIONS.COUNT
TRANSMISSION_AMOUNT			NUMBER
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_TRANSMISSIONS.AMOUNT
TRANSFERRED_RECEIPT_COUNT			NUMBER
SOURCE:	PROGRAM COUNTS NUMBER OF RECORDS TRANSFERRED
	SUCCESSFULLY
DESTINATION:	AR_TRANSMISSIONS.VALIDATED_COUNT
TRANSFERRED_RECEIPT_ AMOUNT			NUMBER
SOURCE:	PROGRAM COUNTS RECEIPT AMOUNTS OF RECORDS
	TRANSFERRED SUCCESSFULLY
DESTINATION:	AR_TRANSMISSIONS.VALIDATED_AMOUNT
LOCKBOX_NUMBER			VARCHAR2(30)
SOURCE:	PROVIDED BY BANK OR ENTERED BY USER AT RUNTIME
DESTINATION:	None
LOCKBOX_BATCH_COUNT			NUMBER
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	None
LOCKBOX_RECORD_COUNT			NUMBER
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	None
LOCKBOX_AMOUNT			NUMBER
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	None
BATCH_NAME			VARCHAR2(25)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_BATCHES.LOCKBOX_BATCH_NAME
BATCH_AMOUNT			NUMBER
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_BATCHES.CONTROL_AMOUNT
BATCH_RECORD_COUNT			NUMBER(15)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_BATCHES.CONTROL_COUNT
ITEM_NUMBER			NUMBER
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	None
CURRENCY_CODE			VARCHAR2(15)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_BATCHES.CURRENCY_CODE
	AR_INTERIM_CASH_RECEIPTS.CURRENCY_CODE
EXCHANGE_RATE			NUMBER
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_BATCHES.EXCHANGE_RATE
	AR_INTERIM_CASH_RECEIPTS.EXCHANGE_RATE
EXCHANGE_RATE_TYPE			VARCHAR2(30)
SOURCE:	DEFAULTS FROM LOCKBOX DEFINITIONS OR ENTERED BY
	USER VIA 'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION	AR_BATCHES.EXCHANGE_RATE_TYPE
	AR_INTERIM_CASH_RECEIPTS.EXCHANGE
	AR_RATE_TYPE
REMITTANCE_AMOUNT			NUMBER
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_INTERIM_CASH_RECEIPTS.AMOUNT
TRANSIT_ROUTING_NUMBER			VARCHAR2(25)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AP_BANK_BRANCHES.BANK_NAME
	AP_BANK_BRANCHES.BANK_BRANCH_NAME
	AP_BANK_BRANCHES.BANK_NUM
ACCOUNT			VARCHAR2(30)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AP_BANK_ACCOUNTS.BANK_ACCOUNT_NUM
CUSTOMER_BANK_ACCOUNT_ID			NUMBER(15)
SOURCE:	AP_BANK_ACCOUNT_USES.EXTERNAL_BANK_
	ACCOUNT_ID
DESTINATION:	AR_INTERIM_CASH_RECEIPTS.CUSTOMER_BANK_
	ACCOUNT_ID
	AR_CASH_RECEIPTS.CUSTOMER_BANK_ACCOUNT_ID
CHECK_NUMBER			VARCHAR2(30)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_INTERIM_CASH_RECEIPTS.RECEIPT_NUMBER
	AR_CASH_RECEIPTS.RECEIPT_NUMBER
SPECIAL_TYPE			VARCHAR2(20)
SOURCE:	PROGRAM DETERMINES THE TYPE
DESTINATION:	AR_INTERIM_CASH_RECEIPTS.SPECIAL_TYPE
CUSTOMER_NUMBER			VARCHAR2(30)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	NONE
CUSTOMER_ID			NUMBER(15)
SOURCE:	PROGRAM DETERMINES IT
DESTINATION:	AR_INTERIM_CASH_RECEIPTS.PAY_FROM_CUSTOMER
	AR_CASH_RECEIPTS.PAY_FROM_CUSTOMER
BILL_TO_LOCATION			VARCHAR2(40)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	NONE
CUSTOMER_SITE_USE_ID			NUMBER(15)
SOURCE:	PROGRAM DETERMINES IT
DESTINATION:	AR_INTERIM_CASH_RECEIPTS.SITE_USE_ID
	AR_CASH_RECEIPTS.CUSTOMER_SITE_USE_ID
RECEIPT_DATE			DATE
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_INTERIM_CASH_RECEIPTS.RECEIPT_DATE
	AR_INTERIM_CASH_RECEIPTS.EXCHANGE_DATE
	AR_CASH_RECEIPTS.RECEIPT_DATE
	AR_CASH_RECEIPTS.EXCHANGE_DATE
RECEIPT_METHOD			VARCHAR2(30)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	NONE
RECEIPT_METHOD_ID			NUMBER(15)
SOURCE:	PROGRAM DETERMINES IT
DESTINATION:	AR_INTERIM_CASH_RECEIPTS.RECEIPT_METHOD_ID
	AR_CASH_RECEIPTS.RECEIPT_METHOD_ID
OVERFLOW_INDICATOR			VARCHAR2(1)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	NONE
OVERFLOW_SEQUENCE			NUMBER
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	NONE
INVOICE1-8			VARCHAR2(50)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	NONE
MATCHING_DATE1-8			DATE
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	NONE
RESOLVED_MATCHING_ NUMBER1-8			NUMBER
SOURCE:	PROGRAM DETERMINES IT
DESTINATION:	NONE
RESOLVED_MATCHING_DATE1-8			DATE
SOURCE:	PROGRAM DETERMINES IT
DESTINATION:	NONE
RESOLVED_MATCHING_ INSTALLMENT1-8			NUMBER
SOURCE:	PROGRAM DETERMINES IT
DESTINATION:	NONE
AMOUNT_APPLIED1-8			NUMBER
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_INTERIM_CASH_RECEIPT_LINES.PAYMENT
	_AMOUNT
	AR_RECEIVABLE_APPLICATIONS.AMOUNT_APPLIED
INVOICE1_STATUS- INVOICE8_STATUS			VARCHAR2(30)
SOURCE:	PROGRAM DETERMINES IT
DESTINATION:	NONE
COMMENTS			VARCHAR2(240)
SOURCE:	ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_BATCHES.COMMENTS
	AR_INTERIM_CASH_RECEIPTS.COMMENTS
ATTRIBUTE_CATEGORY			VARCHAR2(30)
ATTRIBUTE1-15			CHAR(40)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_INTERIM_CASH_RECEIPTS.ATTRIBUTE1...15
	AR_CASH_RECEIPTS.ATTRIBUTE1...15
INVOICE1_INSTALLMENT-
INVOICE8_INSTALLMENT			NUMBER
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	NONE
CUSTOMER_NAME_ALT			VARCHAR2(320)
SOURCE:	LOCKBOX DATA FILE
DESTINATION:	NONE
CUSTOMER_BANK_NAME			VARCHAR2(320)
SOURCE:	LOCKBOX DATA FILE
DESTINATION:	NONE
CUSTOMER_ BANK_BRANCH_NAME			VARCHAR2(320)
SOURCE:	LOCKBOX DATA FILE
DESTINATION:	NONE
REMITTANCE_ BANK_NAME			VARCHAR2(320)
SOURCE:	PROGRAM DETERMINES IT
DESTINATION:	NONE
REMITTANCE_ BANK_BRANCH_NAME			VARCHAR2(320)
SOURCE:	PROGRAM DETERMINES IT
DESTINATION:	NONE
Table 1 - 23. AR_PAYMENTS_INTERFACE Table (Page 8 of 8)

Java Virtual Machine Launcher Could Not Find Main Class Program Will Exit in BI Publisher Desktop in MS Word

Go to BI Publisher menu in Word.
Tools > options > preview tab.
Java home should be selected there, if not select it.

Use of the API FND_PROFILE

It is used to perform various actions related to profile values through PL/SQL. Some of the important ones are listed below:

SELECT fnd_profile.value('PROFILEOPTION')
      ,fnd_profile.value('MFG_ORGANIZATION_ID')
      ,fnd_profile.value('ORG_ID')
      ,fnd_profile.value('LOGIN_ID')
      ,fnd_profile.value('USER_ID')
      ,fnd_profile.value('USERNAME')
      ,fnd_profile.value('CONCURRENT_REQUEST_ID')
      ,fnd_profile.value('GL_SET_OF_BKS_ID')
      ,fnd_profile.value('SO_ORGANIZATION_ID')
      ,fnd_profile.value('APPL_SHRT_NAME')
      ,fnd_profile.value('RESP_NAME')
      ,fnd_profile.value('RESP_ID')
  FROM DUAL;

Also you can use following query:


SELECT *
    FROM fnd_profile_options_vl po,
    fnd_profile_option_values pov,
    fnd_user usr,
    fnd_application app,
    fnd_responsibility rsp,
    fnd_nodes svr,
    hr_operating_units org
WHERE 1 = 1
    AND pov.application_id = po.application_id
    AND pov.profile_option_id = po.profile_option_id
    AND usr.user_id(+) = pov.level_value
    AND rsp.application_id(+) = pov.level_value_application_id
    AND rsp.responsibility_id(+) = pov.level_value
    AND app.application_id(+) = pov.level_value
    AND svr.node_id(+) = pov.level_value
    AND org.organization_id(+) = pov.level_value;

How to identify the Activity ID for a Oracle Workflow Activity

 SELECT WI.ITEM_TYPE
              ,WI.ITEM_KEY
              ,WI.BEGIN_DATE
              ,WPA.INSTANCE_ID ACTIVITY_ID
              ,WPA.ACTIVITY_NAME ACTIVITY_NAME
              ,WPA.PROCESS_NAME
          FROM APPS.WF_ITEMS WI
              ,APPS.WF_ITEM_ACTIVITY_STATUSES WIAS
              ,APPS.WF_PROCESS_ACTIVITIES WPA
         WHERE WI.ITEM_TYPE = WIAS.ITEM_TYPE
           AND WIAS.ITEM_TYPE = WPA.PROCESS_ITEM_TYPE
           AND WI.ITEM_KEY = WIAS.ITEM_KEY
           AND WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID
           AND WPA.ACTIVITY_NAME = UPPER('&Activity_Name')
           AND WI.ITEM_TYPE = UPPER('&Workflow_Item_Type')
           AND WIAS.ITEM_KEY = UPPER('&Workflow_Item_Key')

Query to find the Position Attached to Username in Oracle Apps

SELECT pos.name position_name, pa.position_id,fnd.user_name
FROM PER_ALL_ASSIGNMENTS_F pa, per_positions pos,per_jobs job, fnd_user fnd
WHERE pa.POSITION_ID = pos.POSITION_ID
and pa.job_ID = job.job_id
and sysdate between pa.EFFECTIVE_START_DATE
and pa.EFFECTIVE_END_DATE
and pa.primary_flag = 'Y'
and pa.assignment_type = 'E'
and pa.person_id = fnd.employee_id
and pa.PERSON_ID = (select employee_id
from fnd_user
where user_name = '&user_name')

Purchase Requisition Action History in Oracle Apps

select poah.sequence_num seq#, poah.action_date, poah.action_code,
poah.employee_id emp_id, fnd.user_name, substr (poah.object_type_code,1,3) type, poah.object_sub_type_code sub_type,
poah.object_revision_num rev, pohead.org_id, poah.note
from po_action_history poah, fnd_user fnd, po_requisition_headers_all pohead
where poah.object_id = pohead.requisition_header_id
and pohead.segment1 = '&REQ_NUMBER'
and substr(poah.object_type_code,1,3) = 'REQ'
and pohead.org_id = '&ORG_ID'
and poah.employee_id = fnd.employee_id
and fnd.session_number != 0
order by 9,2,1

Advance Table Column Format in OAF

Advance Table Column Format in OAF

Include this code in your controller:

Formatter formatter = new OADecimalValidater("#,##0.0000", "#,##0.0000");
OAAdvancedTableBean AdvTable1 =(OAAdvancedTableBean)webBean.findChildRecursive("AdvTable1");
OAColumnBean column3 = (OAColumnBean)AdvTable1.findIndexedChildRecursive("column3");
column3.setAttributeValue(ON_SUBMIT_VALIDATER_ATTR, formatter);

or you can also try with this code:

OAAdvancedTableBean tableBean = (OAAdvancedTableBean)webBean.findChildRecursive("AdvTable1");
if(tableBean != null){
OATableFooterBean footerBean = (OATableFooterBean) tableBean.getFooter();
System.out.println("footerBean : "+footerBean);
if (footerBean!= null){
OATotalRowBean totalRowBean = (OATotalRowBean)footerBean.findIndexedChild("totalRow1");
System.out.println("Formattotal : "+totalRowBean);
if (totalRowBean != null){
Formatter formatter = new OADecimalValidater("#,##0.00;(#,##0.00)","#,##0.00;(#,##0.00)");
totalRowBean.setAttributeValue(ON_SUBMIT_VALIDATER_ATTR, formatter);
}
}
}