Query to check the complete R12 Payment profiles Setup


SELECT PPP.SYSTEM_PROFILE_CODE,
  PPP.SYSTEM_PROFILE_NAME,
  PPP.SYSTEM_PROFILE_DESCRIPTION,
  PPP.PAYMENT_FORMAT_CODE,
  PPP.PROCESSING_TYPE,
  PPP.SEEDED_FLAG,
  format.format_name,
  bank_acct.APPLICABLE_VALUE_TO Bank_id,
  bank.bank_account_name,
  bank.bank_account_num,
  bank.currency_code
  FROM IBY_SYS_PMT_PROFILES_VL PPP,
  iby_bepinfo bep,
  iby_formats_vl format,
  iby_formats_vl acpltr_format,
  iby_formats_vl pospay_format,
  iby_formats_vl regrpt_format,
  iby_formats_vl pireg_format,
  iby_applicable_pmt_profs bank_acct,
  ce_bank_accounts bank,
  iby_bank_instructions_vl bank_instr1,
  iby_bank_instructions_vl bank_instr2,
  ce_payment_documents pdoc,
  fnd_lookups f1,
  fnd_lookups f2,
  fnd_lookups f3
WHERE PPP.bepid                        = bep.bepid(+)
AND PPP.BANK_INSTRUCTION1_CODE         = bank_instr1.BANK_INSTRUCTION_CODE(+)
AND PPP.BANK_INSTRUCTION2_CODE         = bank_instr2.BANK_INSTRUCTION_CODE(+)
AND PPP.SYSTEM_PROFILE_CODE            = bank_acct.SYSTEM_PROFILE_CODE
and bank.bank_account_id               = bank_acct.applicable_value_to
AND PPP.payment_format_code            = format.format_code
AND PPP.POSITIVE_PAY_FORMAT_CODE       = pospay_format.format_code(+)
AND PPP.DECLARATION_REPORT_FORMAT_CODE = regrpt_format.format_code(+)
AND PPP.PAY_FILE_LETTER_FORMAT_CODE    = acpltr_format.format_code(+)
AND pdoc.payment_document_id(+)        = PPP.DEFAULT_PAYMENT_DOCUMENT_ID
AND PPP.pi_register_format             = pireg_format.format_code(+)
AND PROCESSING_TYPE                                        = f1.lookup_code
AND f1.lookup_type                                         = 'IBY_PROCESSING_TYPES'
AND MARK_COMPLETE_EVENT                                    = f2.lookup_code(+)
AND f2.lookup_type(+)                                      = 'IBY_MARK_COMPLETE_EVENTS'
AND MANUAL_MARK_COMPLETE_FLAG                              = f3.lookup_code
AND f3.lookup_type                                         = 'IBY_YES_NO'
and bank_acct.APPLICABLE_TYPE_CODE = 'INTERNAL_BANK_ACCOUNT'
AND PPP.INACTIVE_DATE is null
order by system_profile_description;

Comments

Post a Comment

Popular posts from this blog

R12: PPR Detailed Troubleshooting Guide

R12: Detailed Troubleshooting Guide for AUTOSELECT Issues: When PPR Does Not Select Expected Invoices How Invoices are Selected in a PPR: There are two ways a user can submit the Payment Process Request (PPR) Program. 1. Through the Submit Payment Process Request (PsrPG) OA Framework page This does not require a Payment Process Request Template. Navigation: AP Responsibility > Payments : Entry > Payments Manager Payment Process Requests tab Submit Single Request button From the parameters entered on this page, the OA Framework will insert the data into the following selection criteria tables (AP_INV_SELECTION_CRITERIA_ALL, AP_LE_GROUP, AP_OU_GROUP, AP_CURRENCY_GROUP, AP_PAY_GROUP) Once the Data is inserted into the above selection criteria tables, it submits the Payment Process Request Program concurrent program - This causes the AP_AUTOSELECT_PKG.SELECT_INVOICES procedure to be called. 2. As a Concurrent Request This requires a Payment Process Request Templa...
Read more

Oracle Applications - How to Bounce Services(Forms, Concurrent Mgr, Application Tier etc)

This post gives you a handy information on bouncing the services in eBusiness Suite Applications 11i/R12 Steps to Bounce ----------------- 1. Login to your unix box 2. Set the environment by running the env file present in $APPL_TOP        #cd $APPL_TOP        #ls *.env        #. <env_name>_<host_name>.env 3. Go to $ADMIN_SCRIPTS_HOME  (In 11i, Use $COMMON_TOP/admin/scripts)        #cd $ADMIN_SCRIPTS_HOME        4. Here you will see a list of files and based on the need you will have to run various scripts as given below      4.1. Bounce All Services ( Note the 'dot' after the # sign in the commands below and above)                           ...
Read more

Query to check concurrent program type and Executable name

 select fcptl.concurrent_program_id,fcptl.user_concurrent_program_name,fcptl.description,fcp.Concurrent_program_name,flv.meaning execution_method,fe.execution_file_name  from  apps.fnd_concurrent_programs_tl fcptl,  apps.fnd_concurrent_programs fcp,  apps.fnd_executables fe,  apps.fnd_lookup_values flv  where fcptl.concurrent_program_id = fcp.concurrent_program_id  and fcp.executable_id = fe.executable_id  and fe.execution_method_code = flv.lookup_code  and fcptl.language = 'US'  and flv.language = 'US'  and flv.lookup_type='CP_EXECUTION_METHOD_CODE'  and fcptl.user_concurrent_program_name = '< Cong Program Name>';
Read more