Remit to Address in Inovice

Let em give you query to find this from backend -

select Address1, address2, address3 telephone, address4 email
from ra_customer_trx_all rct,
     HZ_CUST_ACCT_SITES_ALL hcta,
     HZ_PARTY_SITES hps,
     HZ_LOCATIONS hl
where rct.customer_trx_id = P_customer_trx_is
and hcta.cust_acct_site_id = rct.remit_to_address_id
and hcta.party_site_id = hps.party_site_id
and hps.location_id = hl.location_id;

Now about the setup -
1. Receivables > Setup > System > System Options

2. Ensure that “Print Remit to Address” check box checked

3. Navigate to System profile option window
(N): System Administrator > Profile > System

4. Navigate to the Remit-To Address Form
(N): Receivables > Setup > Print > Remit To Address > Create Remit-To Address

FND Load scripts

1. LookupsFNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XXCUST" LOOKUP_TYPE="XX_LOOKUP_TYPE"

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

2. Concurrent Program
$FND_TOP/bin/FNDLOAD apps/apppdw O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXKCI_file.ldt PROGRAM APPLICATION_SHORT_NAME=”XXCUSTOM” CONCURRENT_PROGRAM_NAME=”XXCUSTPRG_SHORT_NAME”

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

3. ProfileFNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct XX_CUSTOM_PRF.ldt PROFILE PROFILE_NAME="XX_PROFILE_NAME" APPLICATION_SHORT_NAME="XXCUST"

$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct XX_CUSTOM_PRF.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

4. Request Set and LinkFNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct XX_CUSTOM_RS.ldt REQ_SET REQUEST_SET_NAME='REQUEST_SET_NAME'

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

5. FND MessageFNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_CUSTOM_MESG.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME="XXCUST" MESSAGE_NAME="MESSAGE_NAME%"

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

6. D2K FORMS$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XX_CUSTOM_FRM.ldt FORM FORM_NAME="FORM_NAME"
  
$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XX_CUSTOM_FRM.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

7. Form FunctionFNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XX_CUSTOM_FUNC.ldt FUNCTION FUNCTION_NAME="FORM_FUNCTION_NAME"

$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XX_CUSTOM_FUNC.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

8. AlertsFNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct XX_CUSTOM_ALR.ldt ALR_ALERTS APPLICATION_SHORT_NAME=XXCUST ALERT_NAME="XX - Alert Name"

FNDLOAD apps/apps 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct XX_CUSTOM_ALR.ldt CUSTOM_MODE=FORCE

9. Value Set$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_CUSTOM_VS.ldt VALUE_SET FLEX_VALUE_SET_NAME="XX Value Set Name"


$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XX_CUSTOM_VS.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

10. Responsibility
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct XX_RESP_KEY.ldt FND_RESPONSIBILITY RESP_KEY=’XX_RESP_KEY’

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct XX_RESP_KEY.ldt

11. Request Group
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_REPORT_GROUP_NAME.ldt REQUEST_GROUP REQUEST_GROUP_NAME=’XX_REPORT_GROUP_NAME’ APPLICATION_SHORT_NAME=’PO’



FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_REPORT_GROUP_NAME.ldt

12. request Set
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct XX_REQ_SET_NAME.ldt REQ_SET REQUEST_SET_NAME=’XX_REQ_SET_NAME’
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct XX_REQ_SET_NAME_LINK.ldt REQ_SET_LINKS REQUEST_SET_NAME=’XX_REQ_SET_NAME’
—–UPLOAD——-
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct XX_REQ_SET_NAME.ldt

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct XX_REQ_SET_NAME_LINK.ldt

Concurrent program details from back end

Concurrent Program Execution Methods

Below Query will give you the Concurrent Program/Execution Method

 
select b.concurrent_program_name||' - '||a.user_concurrent_program_name, a.description,
decode(b.execution_method_code,
'P', 'Oracle Reports',
'E' ,'Perl Concurrent Program',
'Q' ,'SQL*Plus',
'L' ,'SQL*Loader',
'A' ,'Spawned',
'B' ,'Request Set Stage Function',
'I' ,'PL/SQL Stored Procedure',
'K' ,'Java Concurrent Program',
'J' ,'Java Stored Procedure',
'S' ,'Immediate',
'H' ,'Host'
) Execution_Method
 from fnd_concurrent_programs_tl a, fnd_concurrent_programs b where
a.concurrent_program_id = b.concurrent_program_id
and b.enabled_flag = 'Y';

select * from  FND_CONCURRENT_PROGRAMS_VL
where user_CONCURRENT_PROGRAM_NAME like '%%'; -- program name

select * from FND_EXECUTABLES_FORM_V 
where executable_id = 123123; -- executable number

check status -

SELECT request_id,

DECODE(status_code,

'A','Waiting', 'B','Resuming', 'C','Normal', 'D','Cancelled', 'E','Error', 'F','Scheduled', 'G','Warning', 'H','On Hold',

'I','Normal', 'M','No Manager', 'Q','Standby', 'R','Normal', 'S','Suspended', 'T','Terminating', 'U','Disabled', 'W','Paused',

'X','Terminated', 'Z','Waiting') Status,

DECODE(PHASE_CODE, 'C','Completed', 'I','Inactive', 'P','Pending', 'R','Running', 'Others' ) PHASE,

TO_CHAR(REQUEST_DATE,'DD-MON-YYYY HH24:MI:SS') REQUEST_DATE,

REQUESTOR,

TO_CHAR(ACTUAL_START_DATE,'DD-MON-YYYY HH24:MI:SS') ACTUAL_START_DATE,

TO_CHAR(ACTUAL_COMPLETION_DATE,'DD-MON-YYYY HH24:MI:SS') ACTUAL_COMPLETION_DATE,

to_char(round((ACTUAL_COMPLETION_DATE-ACTUAL_START_DATE)*1440,0))||' Mins '||to_char(round(mod((ACTUAL_COMPLETION_DATE-ACTUAL_START_DATE)*86400,60),2))||' Secs' duration,

ARGUMENT_TEXT,RTL.RESPONSIBILITY_NAME,program,PROGRAM_SHORT_NAME,RTL.RESPONSIBILITY_ID,CONCURRENT_PROGRAM_ID,

priority_request_id,priority,printer,print_style,user_print_style,requested_start_date

from apps.FND_CONC_REQ_SUMMARY_V CONC , apps.FND_RESPONSIBILITY_TL RTL

where CONC.RESPONSIBILITY_ID=RTL.RESPONSIBILITY_ID

--and status_code = 'E'

and language='US'

and program like '%XYZUU%'--

--and request_id=12345679989

--and REQUESTOR = 'ABCDEFG'

--and ARGUMENT_TEXT ='1235, , 0, , , 4'

--and REQUEST_DATE > sysdate -10

order by REQUEST_DATE desc;