10 Replies Latest reply: Jul 24, 2009 7:53 AM by 649606 RSS

    Family Pack patch for after R12 RUP 6

    649606
      Hi Hussein,

      EBS R12 (12.0.6)
      RHEL 4.6

      We have an on going implem of EBS R12 RUP 6 (FINANCIALS) and still, every day our functional consultant is still
      encountering setup error and ask me to apply more patches. Does FINANCIALs have Family pack that followed
      RUP 6? It is really tiring going to the client everyday just to apply 1 patch. I want to apply all at one time. How
      do I find all the FINANCIAL pathces after 12.0.6? Is patchset.sh applicable to R12?


      Thanks a lot
        • 1. Re: Family Pack patch for after R12 RUP 6
          Hussein Sawwan-Oracle
          Hi,

          Please see these documents.

          Note: 744038.1 - Oracle Financials Readme, Release 12.0.6
          Note: 793520.1 - Oracle Financials Release 12.0.6 Software Updates

          You can use Patchsets.sh script with R12.

          Regards,
          Hussein
          • 2. Re: Family Pack patch for after R12 RUP 6
            649606
            Thanks a lot hussein :) , I have to read it now...brb
            • 3. Re: Family Pack patch for after R12 RUP 6
              Srini Chavali-Oracle
              All of the patches for Finance in R12 are documented in MOS Doc 557869.1 (EBS: R12 Oracle Financials Critical Patches) - this document also lists Critical Patch Collections (CPCs) for Finance - these CPCs are mandatory

              HTH
              Srini
              • 4. Re: Family Pack patch for after R12 RUP 6
                Hussein Sawwan-Oracle
                Hi,
                All of the patches for Finance in R12 are documented in MOS Doc 557869.1 (EBS: R12 Oracle Financials Critical Patches) - this document also lists Critical Patch Collections (CPCs) for Finance - these CPCs are mandatory
                This note is already mentioned in the second document referenced above.

                Regards,
                Hussein
                • 5. Re: Family Pack patch for after R12 RUP 6
                  649606
                  mangaway pa gyod na sya uy...;)
                  • 6. Re: Family Pack patch for after R12 RUP 6
                    649606
                    Hi Hussein,

                    Based on Note 793520.1 you gave me, the following ang the patches updates made after RUP 6.
                    These are quite plenty if I have to apply them 1 by 1. Are there family pack where all of these patches
                    are merged ? say RUP 7

                    Thanks
                    Financials R12.0.6 Software Updates
                    To assist you with your patch application testing, the following patch descriptions are listed below by business activity.
                    Create Accounting
                    
                    Product      Patch Number      Description
                    Payables        7156680        Payment Accounting is now generated correctly for foreign currency invoices where rounding amount is larger than the invoice line base amount.  
                    Payables        7295407        During Payment Accounting, deferred tax amount is now calculated correctly without deducting the withholding tax, thereby fully offsetting the interim tax account.  
                    Payables        7318763        Performance of Unaccounted Transaction Report has been improved in processing unaccounted invoices. Execution time has been reduced by adding a filter condition while updating the global temporary table.  
                    Payables        7351478        Create Accounting now updates the payment transaction processing status correctly if it errors out during processing and these transactions will be picked for processing during next accounting run.  
                    Payables        7394744        Bank charge amount is now properly accounted when the currency has zero precision and the bank charges are prorated to multiple invoices. Earlier the actual discount taken and the discount accounted amounts were different.  
                    Payables        7422774        Create Accounting now successfully accounts for payment clearing events in case of foreign currency payments. The loss is now calculated on the payment amount instead of the invoice amount.  
                    Payables        7508899        Encumbrances now successfully gets reversed for exchange rate variances. Earlier encumbrances were not relieved to the extent of exchange rate variance amount.  
                    Payables        7509835        Performance of Create Accounting program has been improved in processing accounting events associated with prepayment application, un-application, and adjustment.  
                    Payables        7516015        Performance of Unaccounted Transaction Report has been improved in processing unaccounted invoices. Execution time has been reduced by relocating null check processing.  
                    Payables        7560247        Create Accounting for payments transactions will now successfully account when the invoices paid by those payments have been partially paid, adjusted and then fully paid.  
                    Payables        7595304        Create Accounting now properly accounts cancellation of payment, which was created, accounted and cancelled before upgrade.  
                    Payables        7621517        Accounting in reporting ledger is now done correctly for invoices with the same currency as that of the primary ledger currency by using the exchange rate applicable on the general ledger date instead of invoice date.  
                    Payables        7623562        Performance of Create Accounting program has been improved in processing invoice and payment events. Execution time has been reduced by making queries related to primary pay events more selective.  
                    Payables        7688509        Create Accounting for prepayments now completes successfully for invoices having adjustment events in 11i and prepayment applied in R12.  
                    Receivables        6970663        Performance of the Create Accounting program has been improved for processing accounting events associated with receipt application. Execution time of the program has been reduced from hours to a few minutes for processing accounting events for receipt applications to invoices containing hundreds of lines.  
                    Receivables        7046688        Receivables now allows unapplied receipt account to be defined as a control account. The system no longer uses unapplied receipt account when creating accounting entries for unidentified receipts.  
                    Receivables        7326016        When an on-account credit memo in functional currency is applied to an invoice, receivables no longer creates a gain/loss accounting line with zero amount.  
                    Receivables        7447470        When using Subledger Accounting methods ' Multi-Fund Accrual - Account Method' or 'Multi-Fund Accrual - Balancing Method', Receivables now creates accounting entries successfully for credit memo which has freight line.  
                    Receivables        7484811        Generation of accounting for bills receivables transaction has been corrected as follows: 1. When a bills receivable transaction is deleted, the system now correctly handles associated accounting events by deleting them. 2. When a bills receivable transaction status is changed to incomplete, the system now correctly handles associated accounting events by updating their status to incomplete. This prevents such transactions from appearing on Subledger Period Close Exception report.  
                    Receivables        7497944        Receivables now creates correct accounting entry when a miscellaneous receipt is uncleared in Cash Management. Users will no longer encounter accounting error "The subledger journal entry does not balance in the entered currency" when the Create Accounting program process the miscellaneous receipt.  
                    Receivables        7507503        When using Subledger Accounting methods ' Multi-Fund Accrual - Account Method' or 'Multi-Fund Accrual - Balancing Method', system now creates accounting entries successfully for credit memo refund activity. Users will no longer receive error message stating accounting entry is not balanced in entered currency.  
                    Receivables        7528706        Receivables now creates a balanced accounting entry when a miscellaneous receipt is reversed.  
                    Receivables        7535858        Receivables now calculates correct gain or loss in reporting ledger when a foreign currency receipt is applied to an invoice.  
                    Receivables        7594971        Users can now perform receipt processing actions like unapplication, placing on-account, reverse, etc., on receipts upgraded from 11i. System no longer gives accounting errors when such actions are performed on upgraded receipts, which have gain/loss accounting lines created in 11i.  
                    Receivables        7625737        For prepayment receipts, system now creates accounting entries with correct amounts. System no longer creates unapplied accounting line when the prepayment receipt is accounted.  
                    Subledger Accounting        6997731        The Create Accounting program now completes successfully and no longer gives unique constraint violation error. Users encountered this error when same sequence number was generated for account event and accounting header.  
                    Subledger Accounting        7230462        Payables: When using Multi Period Accounting (MPA) feature, system now creates final period accounting lines with correct amounts for a deferred Payables invoice.  
                    Subledger Accounting        7253542        Receivables: Subledger Accounting now calculates correct gain or loss in reporting ledger when a foreign currency receipt is applied to an invoice.  
                    Subledger Accounting        7259699        Cost Management: Performance of Transfer to General Ledger program has been enhanced when processing large volumes of data. Execution time has been reduced by leveraging available indexes.  
                    Subledger Accounting        7351981        When the Create Accounting program is run in a translated language, the 'Report Date' field in the output of the program is now correctly translated into the template language.  
                    Subledger Accounting        7481354        Loans: Supercedes the patch 7390659 which resolved online accounting for Receivables adjustments in Loans module. This patch includes required dependant patches.  
                    Subledger Accounting        7483871        Import Application Accounting Definitions program now completes successfully without any errors when importing Oracle seeded Application Accounting Definitions which use supporting references.  
                    Subledger Accounting        7512923        The Transfer to General Ledger program has been improved as follows: 1. The Create Accounting program now sets the status of accounting entries to 'Not Transferred to GL' for both primary and reporting ledger if the Journal Import program in General Ledger fails for reporting ledger. 2. The Create Accounting program now sets the status of accounting entries to 'Not Transferred to GL' if the journal entries selected for transfer failed to be inserted in General Ledger Interface. 3. The 'SLA: Disable Journal Import' profile option is end dated to discourage usage of this profile. 4. Interface tables used by journal import processing are now not dropped to help troubleshooting. 5. Six additional columns namely ENTITY_ID, EVENT_ID, AE_HEADER_ID, LINE_NUM, ACCTD_DR, ACCTD_CR will be populated in General Ledger import references during the journal import for the effective reconciliation between General Ledger and Subledger Accounting. 6. The Create Accounting program now sets the status of accounting entries to "Not transferred to GL" in Subledger Accounting if the journal import completes in status other than "Normal" and "Warning".  
                    Subledger Accounting        7529475        The Create Accounting program now correctly generates rounding lines for encumbrance journal entries. Users will no longer encounter the General Ledger error "Encumbrance entry should have encumbrance type id populated" when encumbrance journal entries containing rounding lines are transferred to General Ledger.  
                    Subledger Accounting        7567172        Payables: The Create Accounting program no longer ends in error when submitted in French language. The program now correctly handles column titles containing quote character.  
                    Subledger Accounting        7608545        Payables: Subledger Accounting now correctly calculates opening balance for control accounts.  
                    Subledger Accounting        7651627        The Create Accounting program now correctly handles data corruption in data extract. The program provides in the log file the details of events which have corrupted data in the extract.  
                    Create Payments
                    
                    Product      Patch Number      Description
                    Payables        7371792        Credit Memos are now correctly applied to the extent of available credit balance thereby preventing creation of negative payments.  
                    Payables        7673570        Payments can now be successfully voided from Payment Workbench for payments created using Payment Process Request. Earlier it used to error with FRM-40654.  
                    Payables        7674115        Performance of Payments Dashboard has been improved when querying Payment Process Request status. Execution time has been reduced by caching the Payment Process Request statuses.  
                    Funds Capture
                    
                    Product      Patch Number      Description
                    Payments        7260720        Payment System dropdown in Funds Capture Process Profile setup page now successfully displays the user created Payment Systems having only credit card as supported capability. Earlier it used to display user created Payment System when either both credit card and bank account transfer or only bank account transfer has been selected as supported capability.  
                    Payments        7326965        Order Management: When creating new credit cards in sales order form, the card brand dropdown box now displays only those brands which have value 'Yes' for Accepted field in credit card brands setup in Payments.  
                    Payments        7436823        Order Management: Approval Code is now correctly shown for credit card sales order by populating the right value for the authorized flag.  
                    Payments        7437833        Credit Card refunds to customers no longer errors with java.sql.SQLException: Missing IN or OUT parameter at index: 22.  
                    Payments        7459855        Spanish CSB 19 Direct Debit Magnetic format now displays value for the field due date in the output which was missing earlier.  
                    Payments        7462188        Fetch Settlement Batch Clearing concurrent request is now importing the acknowledgment file from Paymentech payment system. The batch and the transaction status is also being updated to 0 (success) instead of 11 (pending) and 111 (pending) respectively. Prior to this fix the Fetch Settlement Batch Clearing program did not update the transactiona and batch status from the pending status.  
                    Payments        7485946        Receivables: Auto Remittance program no longer errors out for Duplicate Order ID as Payments now provides only one authorization for each transaction extension id.  
                    Payments        7488171        German Direct Debit format output file now displays correct data by modifying the following in the template: 1. Added fillers to form 128 byte records 2. Added rounding function to amount values 3. Removed line breaks 4. Replaced underscores with hyphen 5. Display condition for overflow record has been changed  
                    Payments        7495784        Fetch Settlement Batch Clearing program now successfully matches the submission id generated during the settlement batch creation with the one present in the acknowledgment file received from FDC North Payment System by modifying the logic for security code length.  
                    Payments        7510710        Fetch Settlement Batch Clearing program now successfully obtains full acknowledgment file from FDC North payment system.  
                    Payments        7516906        Fetch Settlement Batch Clearing program now completes with Warning status if acknowledgment file is not found.  
                    Payments        7527819        Create Settlement Batch program no longer generates empty output file for German Direct Debit format when XML extract contains amount in German notation and special characters. Template for German Direct Debit has been modified to provide conversion logic for amount in German notation and special characters.  
                    Payments        7530578        Payments now successfully fetches Payment Card Level II & III details from Receivables by using transaction extension id instead of tangibleid. Earlier it was not able to fetch due to using tangibleid entity which has become obsolete in upstream applications in R12.  
                    Payments        7536164        ECServlet security token check may now be disabled by setting newly added system profile option IBY: ECServlet Security Token Force to No.  
                    Payments        7601765        Create Settlement Batch program for German Direct Debit format now completes successfully even if the bank branch number is null. This has been achieved by adding the to_number function while summing up the branch and bank numbers in the rtf template.  
                    Payments        7611463        Credit Cards can now be created with credit card brand as Unknown. Earlier it was giving programing error while creating credit card with Unknown brand.  
                    Payments        7623051        Submit Offline Transactions program now supports integration with gateway model payment systems for transactions using Funds Capture Process Profile.  
                    Payments        7628586        Fetch Settlement Batch Clearing program now successfully updates the status of funds capture transactions with Paymentech payment system. This has been achieved by modifying the tangibleid generation logic which would restrict the tangibleid length to 19 characters which is below 22 i.e. maximum allowed by Paymentech.  
                    Payments        7642479        Order Management: When creating new credit cards in sales order form, the card brand dropdown box now displays only those brands which have value 'Yes' for Accepted field in credit card brands setup in Payments.  
                    Payments        7642886        Create Settlement Batch and Fetch Settlement Batch Clearing programs now ends in Warning status only when the acknowledgment file is missing.  
                    Payments        7712875        Create Settlement Batches program now successfully processes refund transactions when any or both settlement date and settlement due date parameters are selected.  
                    Funds Disbursement
                    
                    Product      Patch Number      Description
                    Payments        6822879        In Payment Method usage rules, the First Party Legal Entity LOV will show all the legal entities defined in the application. This was achieved by rectifying the query used to retrieve legal entities.  
                    Payments        7207573        Oracle Internet Expenses: When processing the employee expense reimbursements, Payments will now pick address from address type Mailing if the Provisional site is selected in the supplier setup.  
                    Payments        7242267        Unique priority number is now assigned to each payment instrument when setting up the payment instruments. Earlier the payment instruments were added with duplicate priority numbers.  
                    Payments        7252846        Logic for printing checks has been modified to print checks voided by overflow first followed by negotiable checks.  
                    Payments        7286412        In Supplier Banking Details page when creating bank branch, RFC Identifier field now successfully saves and the text field is changed to a dropdown.  
                    Payments        7329846        In the Positive Pay File with Additional Parameters program: 1. The LOV search for the bank account name parameter, no longer errors with message APP-FND-01444 and 2. Payment status dropdown now shows value Negotiable and Voided instead of Voided.  
                    Payments        7333272        Send Separate Remittance Advice report now displays the details of checks voided by overflow and the invoices paid by these checks.  
                    Payments        7348463        Payment Process Request details page now successfully displays information entered in the additional information tab.  
                    Payments        7351153        Payment Process Request Status report now successfully displays the Report Date in the header.  
                    Payments        7390295        Cash Management: For SEPA payments, group reconciliation can be performed successfully. This has been achieved by modifying payment grouping options in seeded Payment Process Profiles.  
                    Payments        7410850        Payment amounts in New Zealand domestic EFT payment instruction is now correctly formatted. Earlier a cent was reduced from payment amount and formatted in the payment instruction.  
                    Payments        7411229        Output file of Format Payment Instructions concurrent program now utilizes the outbound payment file prefix, file extension and file directory given in the Payment Process Profile.  
                    Payments        7432754        Funds Disbursement Process Home page now opens quickly when user selects the Funds Disbursement Process Manager responsibility. This has been achieved by modifying the page so that the performance-affecting query is executed only once.  
                    Payments        7433132        Payment Instruction program now displays payment amount text in words without any truncation. Earlier it used to truncate the text length when it is 116 characters.  
                    Payments        7435768        Banking Details updated at supplier site level no longer errors with null pointer exception.  
                    Payments        7448758        In Suppliers, when updating Separate Remittance Advice Delivery section with delivery method as fax or email, the information is saved only when the additional relevant information for each of the method is entered.  
                    Payments        7459662        Payment Process Request Status Report now display the details of checks voided by overflow.  
                    Payments        7477054        Payables: In Payments Dashboard, Today's Payment Process Requests section now correctly excludes transmitted Payment Process Request count in Processing column.  
                    Payments        7481665        Payables: Payments Manager home page now opens quickly after performance improvement achieved by fine tuning the queries used for fetching the number of Payment Process Requests with status Processing and Need Action.  
                    Payments        7484692        When processing customer refunds, payee name and bank account details are now printed on the check.  
                    Payments        7492186        Payment Process Request no longer creates duplicate payments when more than one Build Payments program is triggered for the same Payment Process Request.  
                    Payments        7501494        Multiple user defined validations attached to payment format are now getting saved. Earlier only the first user defined validation was getting saved.  
                    Payments        7506922        Cash Management: Reconciliation of non-SEPA payments no longer errors out with APP-SQLAP-10786. This is achieved by properly handling group id having no values for non-SEPA payments.  
                    Payments        7508983        Send Separate Remittance Advices report now displays postal code information for both payer and payee.  
                    Payments        7516296        In the Positive Pay File with Additional Parameters program: 1. The LOV search for the bank account name parameter, no longer errors with message APP-FND-01444 and 2. Payment status dropdown now shows value Negotiable and Voided instead of Voided.  
                    Payments        7517086        Send Separate Remittance Advices report now shows supplier bank account number in masked form.  
                    Payments        7528455        In Payment Method usage rules, the First Party Legal Entity LOV will show all the legal entities defined in the application. This was achieved by rectifying the query used to retrieve legal entities.  
                    Payments        7530130        Send Separate Remittance Advice report now displays the details of checks voided by overflow and the invoices paid by these checks.  
                    Payments        7532799        Upgrade script has been modified to include text 'Stub after Payment' in the seeded Payment Process Profiles name for check payment formats having text 'Stub after Payment' in the name. Earlier the upgrade script used to create Payment Process Profile with duplicate names for such payment formats.  
                    Payments        7533469        Payables: In Payments Dashboard, Today's Payment Process Requests section now correctly excludes transmitted Payment Process Request count in Processing column.  
                    Payments        7536110        Unique priority number is now assigned to each payment instrument when setting up the payment instruments. Earlier the payment instruments were added with duplicate priority numbers.  
                    Payments        7540297        Oracle EDI Gateway: EDI Remittance Method field in ECE PYO file now shows delivery channel code instead of the payment due date.  
                    Payments        7551983        Funds Disbursement Process Home page now opens quickly after performance improvement achieved by modifying the query used for fetching the pending user actions.  
                    Payments        7560766        Payables: In Payments Dashboard, Today's Payment Process Requests section now correctly considers incomplete Payment Process Request count in either Need Action or Processing columns. Earlier incomplete Payment Process Request count was considered in both the columns.  
                    Payments        7588481        In Suppliers, Bank Account and Assignment Details page now displays the banks accounts for whom primary account owners have been end dated.  
                    Payments        7595957        Italian EFT Format now shows the correct IBAN Check digit number and bank account number by changing the data type from numeric to alpha numeric in the template. Earlier the information for these fields was shown as zeroes for alpha characters.  
                    Payments        7620214        Payables: Payables Open Interface Import program now correctly validates Remit To Supplier information and FRM-40654 error will no longer appear.  
                    Payments        7630460        Oracle EDI Gateway: EDI Remittance Method field in ECE PYO file now shows delivery channel code instead of the payment due date.  
                    Payments        7652218        Payment Details tab in customer account setup page no longer displays duplicate bank account details.  
                    General
                    • 7. Re: Family Pack patch for after R12 RUP 6
                      Hussein Sawwan-Oracle
                      Hi,

                      Those patches are not included in any patchset. Please note that R12.1.1 already includes R12.0.6 and the March 2009 CPCs.

                      Regards,
                      Hussein
                      • 8. Re: Family Pack patch for after R12 RUP 6
                        649606
                        So I have to install all of them 1 by 1 to be a "proactive" support. :( or do I just wait till the functional hit an error and tell me to apply 1 patch?
                        • 9. Re: Family Pack patch for after R12 RUP 6
                          Hussein Sawwan-Oracle
                          Hi,

                          I would say go through the description of each patch and see which ones you need to apply.

                          Regards,
                          Hussein