Oracle Apps Learning with Satish Bhoi (EBS Professional)

Stopping Invoice sent for approval without Validation The Invoice is submitted for Workflow approval even though the invoice is not fully validated (or Accounted). This can be avoided if the AP Automatic program submit the invoice for approval only when it is fully validated. We can do the below changes to achieve the same In the payable options Approval tab, the check box “Require Validation before approval” and “Require Accounting before Approval” is checked, we can avoid the invoice to be  submitted for approval until the conditions are met. Since this option requires the invoice to be fully Validated and Accounted before it can be placed in the Workflow Approval Cycle.

 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>';

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 ...

Enabling SSL in Oracle E-Business Suite Release 12 Overview SSL stands for Secure Socket Layer which is protocol developed by Netscape. Data Transferred between Server & Client is secured (Encrypted). Usually data transmitted between client machine & server (Web Server on http protocol & Forms Server on Sockets ) is clear text packets. Any one can put Packet Sniffer between Client machine & Server & can open & read all data transaction between your machine & Server (If he/she has network access) Hacker can get your Username/Password or any sensitive data. This become critical when you have Internet access to Oracle Applications 11i (Usually Self Service Implementation) Communication between Client & Oracle Applications happens via three components. ·        Oracle Web Server (Initial Connection & all self service access is via Web Server/Apache). If your Form Server is in servlet Mode then Core ...

Paying invoices with a Credit Note via PPR in R12 Payables   1)       The Include Zero Amount Flag should be checked 2)    The Maximize credit Checkbox on the Processing tab should be checked.

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...