Wednesday 27 November 2013

No List of Values for Payment Terms in Customer Account Profile Window in Oracle R12

Check the payment term Billing Cycle Control or not.

Receivables Manager>Set Up > Transactions> Payment Terms ( Check Billing Cycle column)

select cycle_name,billing_cycle_id,name from ra_terms_vl

Even if yes or no then please try as below.

Receivables Manager> Customers > Customers
Query the customer concerned

Tab: Account Profile

Uncheck the 'Enable' check box under 'Balance Forward Billing' under Account Profile Tab and then check the payment terms should be now visible.

Remove special characters from string in SQL

Using  regexp_replace function we can remove all special characters in sql.

Ex : This is/Anil@Maguluri

In the above string we have two extra characters /@

select regexp_replace('This is/Anil@Maguluri', '( *[[:punct:]])', ' ') test_string from dual;

result : This is Anil Maguluri

Friday 15 November 2013

Account Payable Trial Balance Report Shows Fully Paid invoices

Paid Invoice is Still Showing in Payable Trial Balance Report As Outstanding.
Please try this metalink-note    1474628.1

Single Euro Payments (SEPA)

Cross Border payments,
Single Euro Payments Area (SEPA)
Faster Payments
BACS


I have worked on all European Countries Payments in R12 for all International banks.Please contract me if you need any help.So i will guide you with proper information. 

Wednesday 6 November 2013

How to disable the Prepayment Matching Program (ARPREMAT) from the AutoInvoice.

Disable the  Business Event  oracle.apps.ar.batch.AutoInvoice.run 

 System Administrator > Workflow > 
                       Administrator Workflow > Business Events 

 Search for the event: oracle.apps.ar.batch.AutoInvoice.run
 Click on Subscription icon.
 Locate the Function: AR_PREPAYMENTS.rule_select_prepayments
 Click on the pencil icon to update the subscription and change status to Disabled. 

                              Save your changes.