Oracle EBS

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

DECLARE V_Start_Date_Time    VARCHAR2(100); V_Gateway            VARCHAR2(1000) :='http://reportstest/reports/rwservlet/'; V_Desname            VARCHAR2(4000); V_Des_Server   VARCHAR2(4000) :='\\testserver.net\01\Files\AR\XXREPORTS\02\'; --Location of the server to store the Report output we can also pass the email id like xx@maildomain.com V_Filename VARCHAR2(1000); V_Userid             VARCHAR2(100):= apps/apps@scott ; --Database login credentials v_apsuid             VARCHAR2(100) :=; V_Paramlist          srw_paramlist; V_Job_Ident          srw.Job_Ident; V_Sta_Ident          srw.Status_Record; BEGIN For I_Index in (SELECT   * FROM     xxAP_INVOICES WHERE    1=1 AND      ORG_ID =83 --AND TRUNC(cre...

CREATE TABLE "XX_STAGE_SUPPLIERS" ( "SUPPLIER_NAME" VARCHAR2(200), "SUPPLIER_NO" VARCHAR2(50) ) ORGANIZATION external ( TYPE oracle_loader DEFAULT DIRECTORY XXBMASSINV ACCESS PARAMETERS ( RECORDS DELIMITED BY NEWLINE CHARACTERSET US7ASCII BADFILE ' XXBMASSINV':'VENDOR7.bad' LOGFILE 'VENDOR7.log_xt' READSIZE 1048576 FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' LDRTRIM REJECT ROWS WITH ALL NULL FIELDS ( "SUPPLIER_NAME" CHAR(200) TERMINATED BY "," OPTIONALLY ENCLOSED BY '"', "SUPPLIER_NO" CHAR(255) ) ) location ( 'table_export777.csv' ) ); /*--Sample Data "HOLCH POVLSEN SWITZERLAND AG","410025" "ABS TRIKO TEKSTIL","253410" "AKTIESELSKABET AF 21.11.2001","008067" "AKTIESELSKABET AF DEN 17.11.2011","99423204" "RIMAKS","253606...