Oracle EBS

Oracle Financials RXi Reports RXi is the Reports Exchange and is a tool that works in the same way for many Applications. is one of the way to generate the flexible reports. It's Users are given with an option to setup the report layout based on their own business requirement. Here layout means user can choose the required columns, Summation of particular columns at page level or report level, Count of rows etc., Navigation For RXi Reports Setup: Select Responsibility Report eXchange Designer Select SetupRXi               Select RXi Report to setup We can have multiple Attribute Sets for each kind of report layout Select column Details to For ordering Column values and having Sum and count of Columns Click on Summary Details Purging RXi Report Data:    ...

Issue Description Oracle Metal ink Note id’s Verifying the Connection of SMTP Server in Notification Mailer  note.753845.1 Notifications With Embedded Framework Regions Are Not Mailed or Sent ID 309856.1 Workflow Mailer Fails To Send Email Notifications With Framework Region ID 747490.1 Not Receiving Workflow Email Notifications Possible Connection Refused Error   ID 464016.1 Connection Refused Errors in Mailer Log After Applying ATG RUP4 ID 403431.1 Troubleshooting Inbound & Outbound Email Notifications ID 1184846.1 Oracle Workflow Best Practices Release 12 and Release 11i 453137.1 Oracle Workflow Cartridge Workflow Java Mailer Setup Test 274764.1 Tracking Workflow Notification Event Messages 433359.1 Queries Related to Alert and Mailer Integration Post RUP4 456921.1 How to Stop mails from Workfl...

J-Initiator Installation on Window 7: Double-click on jinit13130.exe Install the J-Initiator and “Next” a couple of times program will be activated. Copy file to your computer at following folder "C:\Program Files\Oracle\JInitiator\1.3.1.30\bin\hotspot" Replace the old files  jvm.dll   and  msvr71.dll    If you are using the Windows 7 you have to do the following power settings ·          Click Start ·          In the search box, type Power Options and hit enter ·          Chances are, the radio dot is on the balanced (recommended) setting. ·          Click on the   Change     plan settings link to the right for whatever plan is selected. ·          Click the Change advanced power settings ...

AR Receipts API Single Insert Creation Script 1.Creating a RECEIPT : DECLARE l_return_status VARCHAR2 (1); l_msg_count NUMBER; l_msg_data VARCHAR2 (240); l_cr_id NUMBER; BEGIN ar_receipt_api_pub.create_cash (p_api_version => 1.0, p_init_msg_list => fnd_api.g_false, p_commit => fnd_api.g_false, p_validation_level => fnd_api.g_valid_level_full, x_return_status => l_return_status, x_msg_count => l_msg_count, x_msg_data => l_msg_data, p_currency_code => 'USD', p_amount => 200, p_receipt_number => 'XX_TEST1', p_receipt_date => SYSDATE, p_gl_date => SYSDATE, p_customer_id => Customer id , p_customer_bank_account_id => , p_customer_site_use_id => , p_receipt_method_id => , p_cr_id => l_cr_id ); DBMS_OUTPUT.put_line ('Message count ' l_msg_count); DBMS_OUTPUT.put_line ('Status ' l_return_status); IF l_msg_count = 1 THEN DBMS_OUTPUT.put_li...

What is the 'Single Euro Payments Area' (SEPA)? The euro has meant that you can pay by cash anywhere in the euro area just as easily as at home. But at present it's not so easy if you want to pay for goods or services electronically in another euro area country, for example with your bank debit card, which is how many people want to make payments today. And when you want to transfer money from your home bank account to an account in another euro area country, the payment can take much longer, and sometimes the receiver does not get the full amount. The Single Euro Payments Area (or 'SEPA' for short) will change all this. It will make all electronic payments in the euro area as easy as cash payments are now. It will mean that you can make fast and secure transfers between bank accounts anywhere in the euro area. . I have a personal bank account in the euro area. What will SEPA mean for me? First of all, let's be clear that SEPA won't be like the in...

AR_PAYMENT_SCHEDULES AR_PAYMENT_SCHEDULES Imp Columns: payment_schedule_id amount_due_original amount_due_remaining customer_trx_id cash_receipt_id     trx_number status           --Possible Values are CL- Closed , OP-Opened amount_applied    class AR_PAYMENT_SCHEDULES stores customer balance information at the transaction level. Each transaction's balance is stored as a unique record, based on the primary key, payment_schedule_id. The class column identifies the transaction type and determines which columns Receivables updates when a transaction is stored. For billing transactions, the AR_PAYMENT_SCHEDULES table joins the RA_CUSTOMER_TRX table via the customer_trx_id column and stores NULL in the cash_receipt_id column. For payment transactions, the AR_PAYMENT_SCHEDULES table joins the AR_CASH_RECEIPTS table via the cash_receipt_id column and stores ...

Use the Below queries for finding the Oracle Apps patch Levels for a particular Application SELECT patch_level FROM fnd_product_installations WHERE application_id = 200; SELECT a.application_name,   DECODE (b.status, 'I', 'Installed', 'S', 'Shared', 'N/A') status,   patch_level ,   a.application_id FROM apps.fnd_application_vl a,   apps.fnd_product_installations b WHERE a.application_id = b.application_id; SELECT patch_name,   patch_type,   maint_pack_level,   creation_date FROM applsys.ad_applied_patches ORDER BY creation_date DESC; SELECT fa.APPLICATION_SHORT_NAME,   fpi.PATCH_LEVEL,   DECODE(fpi.STATUS, 'I','Installed', 'S','Shared', 'N', 'Inactive', fpi.STATUS) Status ,   fpi.DB_STATUS FROM fnd_product_installations fpi,   FND_APPLICATION fa WHERE fpi.APPLICATION_ID IN   (SELECT APPLICATION_ID   FROM FND_APPLICATION   WHERE APPLICATION_SHORT_NAME IN ('CSK'...