Oracle Applications E-Learning Lab

Today we will guide you how to get concurrent program log files and output files from database. As you aware whenever you submit concurrent program , after successful completion of it, Two files will be generated  which are nothing but LOG files and OUTPUT files. We can get those files by calling function  FND_WEBFILE.GET_URL  This function will return output value which is nothing but the  Link for the Log file or Output File , So only thing we need to do is to just paste the link in browser to view Log File or Output file. During this activity you don't need to be login on to the Oracle Application Window Below code will help you out in Generating Log file , Pass request id   as   input parameter /*-----------------------------------------------------------           Code  for  Log File Generation              http://oracleerplearning.blogspot.in/               Author : Pranay Tiwari  ----------------------------------------------------------*/ SET SERVERO

Log in to SYSADMIN User and go to the responsibility User Management Click on Users and query the user Name , Once user name queried then click on Update  After Update new screen will pop up in that Click on Assign Roles Search for ‘Approval%Man%’ and it will give list of roles available Select Roles: 1)    Approvals Management Administrator 2)       Approvals Management business Analyst Click on APPLY   and provide Justification   and click Apply to assign the Roles to the user. Switch Responsibility to    Functional Administrator Click on Create Grant Fill Name and Description with relevant details and Grantee should be User Name which needs grant access and in Object Type it should be AME Transaction Types Click On Next with Data Context Type All Rows Click on Next and select Set as AME Calling Ap

Oracle Pricing Covers the basic feature like defining price lists ,discounts,surcharges for the items. Price Lists : Price Lists allows you to define the prices for the goods. Qualifiers: Qualifiers controls who qualifies for what. You can define qualifier based on customer groups,order types,order amount etc. and attach this to price list . Whenever sales order is entered it verifies whether qualifier is applicable for this price list or not Pricing attributes : This gives you added functionality of defining price based on some attributes. Modifiers : Price list defines the base prices, Modifier controls the discounts for the price list Prerequisites setup required for Price Lists  There are two type of Price list 1.Order Management Price list 2. PO Price List To execute API we need to set the Profile option , based on which price list you want to run API. Below are the option to set the various price lists. FOR OM PRICELIST   a. QP: Pricing Transac

Receipt Write off Activity : This activity will come into role if any adjustments needs to be made against the receipt apply amount For example Receipt amount is $100 and for that already applied amount is $50 and now you want to adjust that $50 from applied amount for that receipt write off functionality Prequisite setup To enable Receipt Write off functionality Approval limits for the users needs to be define Set up for the Approval Limits Receivables Manager à Transactions à Approval Limits  Select the relevant user with which you want to perform write off operations. Where document type has many activities but our aim is to write off amounts so choose  "Receipt Write Off". select currency as USD and set the approval limit amounts  Below is the sample code to create write off amounts but before that  we need to set the context for user without it , API wont kick off  and another mandatory paramter is Receivables_trx_id which can be defined

This API    AR_RECEIPT_API_PUB.Apply_on_account   will comes into picture  when amount needs to be apply against the receipt but there is no valid transaction for the customer . For those records you apply them as ON ACCOUNT against the receipts and later you can associate customer as well from front end. Sample API code to apply ON Account amount against Receipt. DECLARE    p_api_version                    NUMBER;    p_init_msg_list                  VARCHAR2 (200);    p_commit                         VARCHAR2 (200);    p_validation_level               NUMBER;    x_return_status                  VARCHAR2 (200);    x_msg_count                      NUMBER;    x_msg_data                       VARCHAR2 (200);    p_cash_receipt_id                ar_cash_receipts.cash_receipt_id%TYPE;    p_receipt_number                 ar_cash_receipts.receipt_number%TYPE;    p_amount_applied                 ar_receivable_applications.amount_applied%TYPE;    p_apply_date                  

Once Receipt created , Amount needs to apply against receipt amount. Inorder to apply amount against receipt , sample API code has been written. Sample API code to apply amount against Receipt. DECLARE    l_return_status   varchar2 (1);    l_msg_count       number;    l_msg_data        varchar2 (240);    l_count           number;    l_msg_data_out    varchar2 (240);    l_mesg            varchar2 (240);    p_count           number;    l_Rec_num         varchar2 (100);    l_trx_num         varchar2 (100); BEGIN    mo_global.SET_POLICY_CONTEXT ('S', 414);                     -- your org id    mo_global.init ('AR');    ar_receipt_api_pub.Apply (       p_api_version        => 1.0,       p_init_msg_list      => FND_API.G_TRUE,       p_commit             => FND_API.G_TRUE,       p_validation_level   => FND_API.G_VALID_LEVEL_FULL,       p_cash_receipt_id    => 95951,--- <CASH RECEIPT ID >       p_customer_Trx_id    => 289864

AR_CASH_RECEIPT_API.PUB  is the API to create receipts in Oracle , And below is the sample API code. Mandatory Input Parameters for API Currency Amount Receipt Method Id  Customer Id  Customer Site Use id  Org Id  Query to derive Receipt Method id           SELECT   receipt_method_id            FROM   ar_receipt_methods           WHERE   name = <Receipt Method Name > Query to derive Cust Account and Site Use id  SELECT   hca.cust_Account_id, hcsu.site_use_id   FROM   HZ_PARTIES HP,          HZ_CUST_ACCOUNTS HCA,          HZ_CUST_ACCT_SITES_ALL HCAS,          HZ_CUST_SITE_USES_ALL HCSU  WHERE       HP.PARTY_ID = HCA.PARTY_ID          AND HCA.CUST_ACCOUNT_ID = HCAS.CUST_ACCOUNT_ID          AND HCAS.CUST_aCCT_SITE_ID = HCSU.CUST_aCCT_SITE_ID          and hp.party_name=<Customer Name>          AND hcsu.org_id = <ORG ID> <Code Begins > DECLARE    l_return_status     VARCHAR2 (1);    l_msg_count         NUMBER;    l_msg_data

In Order to create Receipts in Oracle , The following navigation needs to follow Navigations :  Receivables Manager à Receipts à Receipts Enter the Receipt Method name , which has been created in previous tutorial . Once Receipt Method selected , Remittance Bank details gets auto populated.  After entering the Receipt Method details , enter customer details for which receipt needs to be created  Once Customer information and Receipt amount information entered not click on APPLY button to apply amount towards receipts  Once you click on Apply button there are various receipt application method activity  in which you can apply receipt amounts 1.You can apply Receipt amount  against customer Trx_Number which gets populated in the Lov 2.Receipt Amount can be applied ON ACCOUNT if trx_number unknown 3.Receipt Write off is another receipt application activity which used adjust the receipt amount. 1.Receipt Amount applied against selected invo

Once transactions created for the customer and its next step will be creating receipts. Receipts will be created only after customer pays amount against the transactions. Its not mandatory to pay full amount of transaction to create receipts ,Even with partial payments receipts can be generated. In simple terms we can refer this terms in below methodology. Transactions: Invoice/Bill Receipts: Payment Receipts.  Now will see how to create receipts and how to apply transaction over to it? Before proceeding with the receipt creation there are certain Prerequisite setups which are mandatory in Receipt generation . Here is the set up to create Receipt Classes to create Receipts in Oracle Navigation :     Receivables Manager à Setup  à Receipt Classes Go to Receipt Class query it and add your Receipt Method Name  for example check below receipt name has been added as TEST RECEIPT CLASS .After adding the receipt method , Click on Bank Accounts 

Before Proceeding towards interface concepts , We have to go through the base table of Oracle transactions. Base Tables :  RA_CUSTOMER_TRX_ALL   holds the header level data RA_CUSTOMER_TRX_LINES_ALL  holds line level data RA_CUST_TRX_LINE_GL_DIST_ALL holds distribution level data RA_BATCHES_ALL    table contains batch level information RA_BATCH_SOURCES_ALL table contains batch name RA_CUST_TRX_TYPES_ALL table contain information regarding transaction type data Interface Tables :  RA_INTERFACE_LINES_ALL     Line Interface Level Data RA_INTERFACE_DISTRIBUTIONS_ALL Distribution interface level data RA_INTERFACE_ERRORS    contains the information of rejected records from auto invoice program Auto Accounting rules and Set ups in Oracle . Auto accounting rule is nothing but a feature in oracle which automatically creates general ledger accounting flexifields at Distribution Level. In-order to set up Auto Accounting rule Go to Setup -->  Transaction --> Transa