Oracle EBS– Regularly Asked Interview Question – Good for Beginners


Winners : Ganesh Kamble , Raj kumar

This Quiz is closed now

Oracle Apps – Regularly Asked Interview Question – Good for Beginners

Some of the Sample Questions can be asked on any New or recently trained person. Most of them are descriptive and subjective.I am sure if a candidate can answer 12-15 Questions comfortably then candidate will be comfortable with Oracle Apps in general.

Like to know if you want to give a try and submit your answer, You can either put your answers in Comment section or send me at shivmohan.purohit@gmail.com

For who give most correct answer will get a PRIZE ! , A Office Document Folder

  1. What are the key benefits of forms personalization over custom.pll?
  2. How can you import invoices into Oracle Receivables?
  3. Which responsibility do you need to extract Self Service Personalization?
  4. Which Form in Oracle Applications has most number of Form Functions?
  5. How can an end-user be given control to run a script developed by a developer, given that an end user will never have access to apps password (and rightly so)?
  6. What are the basic steps when defining a concurrent program?
  7. What are the more common pseudo-columns.
  8. What’s the difference between DELETE TABLE and TRUNCATE TABLE commands?
  9. What are the various report triggers? What is their order of firing?
  10. Describe the main tables involved in AR?
  11. Describe the main tables involved in AP?
  12. Describe the main tables involved in GL?
  13. Describe the main tables involved in Inventory?
  14. Describe the main tables involved in Purchasing?
  15. Describe the main tables involved in Application Developer Module?
  16. How to register a Form to invoke it from Menu?
  17. How to create an BI Publisher Report?
  18. What are steps involve in Data conversion activity.
  19. What is the difference between upgrade and migration?
  20. Where we monitor concurrent manager and names of different type of Concurrent Managers?

— We got following Answer so far, waiting few more before closing this and publish the answers and winner .

following people has submitted Answers so far:

1. Lokesh Surana

2. Shrikanth VGR

3. Raj Kumar

4. Shrikant Nawale

5. Ganesh Kamble

15 thoughts on “Oracle EBS– Regularly Asked Interview Question – Good for Beginners

  1. 1.What are the key benefits of forms personalization over custom.pll?
    — Easy of use, Flexibility
    Scalable
    Minimal Coding
    Changes Effective Almost Immediately
    No Shared Library
    No Patches
    Recommended by Product Development

    2.How can you import invoices into Oracle Receivables?

    3.Which responsibility do you need to extract Self Service Personalization?
    — Functional Administrator

    4.Which Form in Oracle Applications has most number of Form Functions?
    — Run Reports

    5.How can an end-user be given control to run a script developed by a developer, given that an end user will never have access to apps password (and rightly so)?
    — register the script as in answer to step 6 and assign the responsibility (of the request group) to user.

    6.What are the basic steps when defining a concurrent program?
    — Define the executable with ececutable method type
    Define the concurrent program by attaching the executable
    If it is part of Request Set add to the request set then add the request set to the request group
    if not then add to the request group

    7.What are the more common pseudo-columns.
    — ROWNUM, ROWID, LEVEL ,CURRVAL , NEXTVAL

    8.What’s the difference between DELETE TABLE and TRUNCATE TABLE commands?
    — DELETE
    data is deleted but table definition is intact
    Can be rollbacked
    WHERE clause can be used
    TRUNCATE
    Data is deleted
    cannot be rollbacked
    WHERE clause cannot be used

    9.What are the various report triggers? What is their order of firing?
    –There are eight report triggers.
    (1) Before Parameter Form
    (2) After Parameter Form
    (3) Before Report
    (4) Between Pages
    (5) After Report
    (6) Validation Triggers
    (7) Format Triggers
    (8) Action Triggers
    1 to 5 is the sequence of report triggers.
    6,7,8 are event based triggers.

    10.Describe the main tables involved in AR?
    — RA_CUSTOMER_TRX_ALL , RA_CUSTOMER_TRX_LINES_ALL ,RA_BATCHES_ALL ,RA_INTERFACE_ERRORS ,RA_INTERFACE_LINES_ALL

    11.Describe the main tables involved in AP?
    — AP_INVOICES_ALL,AP_AE_HEADERS_ALL,AP_INVOICE_DISTRIBUTIONS_ALL , AP_AE_LINES_ALL , AP_PAYMENT_DISTRIBUTIONS_ALL

    12.Describe the main tables involved in GL?
    — GL_JE_HEADERS , GL_JE_LINES , GL_CODE_COMBINATIONS, GL_PERIODS , GL_LEDGERS,GL_SETS_OF_BOOKS,GL_BALANCES

    13.Describe the main tables involved in Inventory?
    — MTL_SYSTEM_ITEMS_B , MTL_ITEM_CATEGORIES, MTL_ITEM_SUB_INVENTORIES ,MTL_ITEM_CATEGORIES

    14.Describe the main tables involved in Purchasing?
    — PO_REQUISITION_HEADERS_ALL,PO_REQUISITION_LINES_ALL,PO_DISTRIBUTIONS_ALL, PO_HEADERS,PO_LINES,PO_VENDORS ,RCV_TRANSACTIONS

    15.Describe the main tables involved in Application Developer Module?
    — FND_USERS, FND_RESPONSIBILITES, FND_REQUEST_GROUPS, FND_CONCURRENT_REQUESTS , FND_CONCURRENT_PROGRAMS ,FND_EXECUTABLES, FND_PROFILE_VL

    16.How to register a Form to invoke it from Menu?
    — 1> Find the menu of the responsibility from the responsibility definition of the sysadmin responsibility( Security>Responsibility>Menu(field)
    2>first define the form in the FUNCTION
    3>Query the Menu in the MENU menu of the sysadmin (Application>Menu)
    4> assign the form name to the required SUBMENU

    From the Databse point..herewith are the helpful queries:
    After finding the menu attached to the Responsibility:
    SELECT *–MENU_ID, MENU_NAME
    FROM FND_MENUS_VL
    WHERE USER_MENU_NAME = ‘GL_OPERATIONS_USER’
    /
    SELECT * –sub_menu_id, entry_sequence,function_id ,prompt
    FROM FND_MENU_ENTRIES_VL
    WHERE MENU_ID=69509
    AND PROMPT=’External Interfaces’
    /
    SELECT *–menu_id, entry_sequence,function_id,prompt
    FROM FND_MENU_ENTRIES_VL
    WHERE MENU_ID=1003058
    AND PROMPT=’Open Link JE Interface’
    /
    SELECT * –function_id, function_name, form_id, parameters
    FROM FND_FORM_FUNCTIONS_VL
    WHERE FUNCTION_ID=27280
    /

    17.How to create an BI Publisher Report?
    http://technology.amis.nl/blog/1620/my-first-steps-with-oracle-bi-publisher-enterprise-edition-10132-create-a-report-based-on-the-orablogs-rss-feed

    18.What are steps involve in Data conversion activity.
    — Load data from csv into a stagin table
    Throguh CC program validate the data by pl/sql before pushing it into interface table or base table (through API if avialable)
    recheck the data in the application for verification

    19.What is the difference between upgrade and migration?p
    — Upgrade is from Oracle lower version to newer version and Migration is from one instance to another(it can be oracle to oracle or legacy to oracle).

    20.Where we monitor concurrent manager and names of different type of Concurrent Managers?
    — SYSADMIN [Resp] : Concurrent : Manager : Administer

    Like

  2. What are the key benefits of forms personalization over custom.pll?
    Ans :
    1.CUSTOM.pll is a single file/entity, hence only one developer can make changes to CUSTOM.pll at any given point in time.

    2. If for some reasons CUSTOM.pll causes issues in Production, you will have to re-release the code changes after another round of UAT.
    Form Personalizations makes this much simpler by allowing you to disable specific personalizations.
    3. You do not need to resort to programming for trivial tasks like changing prompt, and more so for changing prompts in Muli-Lang environment.

    Lets do a quick comparison between Forms Personalization and CUSTOM.pll
    Task/Business Requirement CUSTOM.pll Forms Personalization
    Change LOV Query Yes Yes
    a. Create a New Record Group
    b. Attach new RG to LOV
    Change field properties like Mandatory/Display etc Yes Yes
    Zoom to another screen Yes Yes
    a. Enable Menu
    b. Trap the Menu event
    Disable a Menu entry when certain conditions are met Yes No
    Display messages, warnings, hints etc Yes Yes
    Display message with Questions, and conditionally execute code based on users response to the question Yes No
    Execute PL/SQL Stored procedures Yes Yes
    Change Navigation and Navigational Properties Yes Yes
    Change block properties like “Query Where Clause” etc Yes Yes
    Change is applicable across multiple screens, like Changing window title for all screens within one Organization/Responsibility Yes Yes
    Show FND Messages with their tokens replaced Yes Yes

    How can you import invoices into Oracle Receivables?
    Ans : Use import invoice open interface or ar_invoice_api_pub.create_single_invoice API.
    Which responsibility do you need to extract Self Service Personalization?
    Ans : Functional Administrator
    Which Form in Oracle Applications has most number of Form Functions?
    Ans : Run Reports
    How can an end-user be given control to run a script developed by a developer, given that an end user will never have access to apps password (and rightly so)?
    Ans : Develop a concurrent request which user can run at any time.
    What are the basic steps when defining a concurrent program?
    Ans :
    1. Connect to the application and select system administrator create Executable
    2. Executable Name (Any User defined Name)
    3. Application Name(e.g. Where the .rdf file located)
    4. Execution Method (e.g. Oracle Reports for reports)
    5. Execution File (e..g .rdf file Name)
    6. Create Concurrent program and attach Executable
    7. Parameters
    8. Incompatible Programs
    9. create Request Group attach Concurrent Program
    10. Create responsibility attach
    11. Request Group
    12. Menu
    13. Data Group
    14. Create User Attach Responsibility to the User
    15. User will submit the request from SRS (Standard Request Submission) Window

    What are the more common pseudo-columns.
    Ans : Rowid, rownum,currval, nextval , level
    What’s the difference between DELETE TABLE and TRUNCATE TABLE commands?
    Ans : The TRUNCATE command provides a fast, efficient method for deleting all rows from a table or clustered table.
    A TRUNCATE statement does not generate any rollback information and it commits immediately; it is a DDL statement and cannot be rolled back.
    A TRUNCATE statement does not affect any structures associated with the table being truncated (constraints and triggers) or authorizations (grants).
    A TRUNCATE statement also specifies whether space currently allocated for the table is returned to the containing tablespace after truncation.
    As a Truncate statement deletes rows from a table (or cluster), triggers associated with the table are not fired.
    A TRUNCATE statement does not generate any audit information corresponding to DELETE statements if auditing is enabled. Instead, a single audit record is generated for the TRUNCATE statement being issued.
    What are the various report triggers? What is their order of firing?
    Ans :
    • Before Parameter
    • After Parameter
    • Before Report
    • Between Pages
    • After Report

    Apart from above 5 report triggers, there are 3 other triggers as well.
    • Validation Trigger
    • Format Trigger
    • Action Trigger

    Describe the main tables involved in AR?
    Ans :
    AR Base Tables
    RA_CUSTOMER_TRX_ALL
    RA_CUSTOMER_TRX_LINES_ALL
    RA_CUST_TRX_LINE_GL_DIST_ALL
    AR_PAYMENT_SCHEDULES_ALL
    AR_RECEIVABLES_TRX_ALL
    AR_RECEIVABLE_APPLICATIONS_ALL

    AR Interface Tables
    AR_PAYMENTS_INTERFACE_ALL
    AR_TAX_INTERFACE
    HZ_PARTY_INTERFACE
    HZ_PARTY_INTERFACE_ERRORS
    RA_CUSTOMERS_INTERFACE_ALL
    RA_INTERFACE_DISTRIBUTIONS_ALL
    RA_INTERFACE_ERRORS_ALL
    RA_INTERFACE_LINES_ALL
    RA_INTERFACE_SALESCREDITS_ALL

    Describe the main tables involved in AP?
    Ans :
    AP Base Tables
    AP_INVOICES_ALL
    AP_INVOICE_DISTRIBUTIONS_ALL
    AP_PAYMENT_SCHEDULES_ALL
    AP_HOLDS_ALL
    AP_AE_LINES_ALL
    AP_AE_HEADERS_ALL

    AP Interface Tables
    AP_INTERFACE_CONTROLS
    AP_INTERFACE_REJECTIONS
    AP_INVOICE_INTERFACE
    AP_INVOICE_LINES_INTERFACE

    Describe the main tables involved in GL?
    Ans :
    GL Base Tables
    gl_je_batches
    gl_je_headers
    gl_je_lines
    gl_je_sources
    gl_periods
    gl_code_combinations
    gl_set_of_books

    GL Interface Tables
    GL_INTERFACE
    GL_INTERFACE_HISTORY
    GL_INTERFACE_CONTROL
    GL_BUDGET_INTERFACE
    GL_DAILY_RATES_INTERFACE
    GL_IEA_INTERFACE

    Describe the main tables involved in Inventory?
    Ans :
    INV Base Tables
    mtl_system_items_b
    mtl_item_locations
    mtl_item_categories
    cst_item_costs
    hr_all_organization_units

    INV Interface Tables
    MTL_SYSTEM_ITEMS_INTERFACE
    MTL_ITEM_REVISIONS_INTERFACE
    (If importing revisions)
    MTL_ITEM_CATEGORIES_INTERFACE (If importing categories)
    MTL_INTERFACE_ERRORS (View errors after import)

    Describe the main tables involved in Purchasing?
    Ans :

    PO Base Tables
    PO_REQUISITION_HEADERS_ALL
    PO_REQUISITION_LINES_ALL
    PO_REQ_DISTRIBUTIONS_ALL
    PO_DISTRIBUTIONS_ALL
    PO_HEADERS_ALL
    PO_LINES_ALL
    PO_VENDORS
    PO_VENDOR_SITES_ALL

    PO Interface Tables
    PO_HEADER_INTERFACE
    PO_LINES_INTERFACE
    PO_DISTRIBUTIONS_INTERFACE
    PO_INTERFACE_ERROR

    Describe the main tables involved in Application Developer Module?
    FND_USER
    FND_CONCURRENT_PROGRAM
    FND_CURRENCY
    FND_LOOKUP
    FND_APPLICATION

    How to register a Form to invoke it from Menu?
    Ans :
    A)Open up TEMPLATE.fmb, and save this as XXHELLOAPPS.fmb
    B) Create a new window, by right clicking on Window/new
    Name this window as XXHELLOAPPS,and assign it SubClass Type “WINDOW” from picklist.
    C) Create a new canvas and name it XXHELLOAPPS , ensuring its Sublcass Type is “Content”
    D) Make the windows property reference canvas XXHELLOAPPS and vice versa make the canvas reference windows XXHELLOAPPS.
    E) Now create a block named XXHELLOAPPS . Lets keep this a control block for simplicity.
    F) go to form level property, and set first navigation block to XXHELLOAPPS.
    G) Add a label and a field named “Hello_World” to this block.
    H) Generate the form on PC using Control-T keystrokes. This will ensure that nothing critical has been missed out.
    I) FTP the form file to $XXPO_TOP/forms/US
    Surely, this XX will be replaced by the naming convention at your client/company.
    J) cd to $XXPO_TOP/forms/US
    And f60gen on XXHELLOAPPS.fmb
    This will create a file executable as XXHELLOAPPS.fmx

    [command : f60gen module=XXORIG.fmb userid=$USER_APPS/$PASS_APPS output_file=XXORIG.fmx compile_all=yes]

    K) Go to Application Developer responsibility
    Menu /applicaton/form
    Register the form

    L) Register the Forms Function
    Have you read he article form functions[http://getappstraining.blogspot.com/2006/10/oracle-forms-functions-menus-and-their.html] yet?
    This forms function must be registered against application “XX Purchasing”.
    M) Now add a menu item so that this forms function becomes available to specific responsibility.

    Thats it, you will be able to open up this form from the responsibility.
    How to create an BI Publisher Report?
    Ans : http://www.scribd.com/doc/30749065/How-to-Create-Reports-in-BI-Publisher-UI
    What are steps involve in Data conversion activity.
    Ans :
    1 ) Provide sample data in the prescribed format.
    2) Upload to staging
    3) Validate
    4) move to interface tables by custom or seeded interface concurrent program
    5) Finally move the data to base from interface tables.
    What is the difference between upgrade and migration?
    Ans : Upgrade is moving from one version to another. It may include database upgrade also.
    Migration is uploading data to the existing system, it could be from a traditional legacy system or from a third party system.
    Where we monitor concurrent manager and names of different type of Concurrent Managers?
    Ans :
    System Administrator > Concurrent: Managers > Administer
    Conflict Resolution Manager (CRM)
    Product Specific Concurrent Manager
    Internal Concurrent Manager (ICM)
    Scheduler Manager
    Standard Manager
    Transaction Managers

    Like

  3. 18. What are steps involve in Data conversion activity.
    A18 steps are:
    a) Identify the source data
    b) Load data into oracle staging tables.
    c) Do basic technical validation and business validation.
    d) Load data to interface table and Call concurrent program to load data from interface table to base table.
    OR
    e) Write program to do business and functional validation and call API to load data to base tables.
    f) Verify the data in target instance and error / load reporting.

    Like

  4. 5.How can an end-user be given control to run a script developed by a developer, given that an end user will never have access to apps password (and rightly so)?
    A5. Create the concurrent program based on the script as executable and assign it to the user so that user can run the program from the application.

    Like

  5. Q1.What are the key benefits of forms personalization over custom.pll?
    A1
    1) Easy portablility of changes done to forms
    2) No need of Extensive technical knowledge to do plsql coding in Custom.pll
    3) Upgrades of forms is more easy.

    Like

  6. Q6. What are the basic steps when defining a concurrent program?
    A6
    1. Develop the procedure as per client requirements.
    2. Create Executable with execution method as PL/SQL stored procedure/
    3. Create Concurrent Program attach Executables, Parameters, Incompatibilities.
    4. we will attach this concurrent program to request group.
    5. Attach request group to responsibilities
    6. Attach the responsibilities to user with submit from SRS window.

    Like

  7. Q16.How to register a Form to invoke it from Menu?
    A16. Forms Development and Registration Steps:
    1.Download Template .fmb from AU top//Resource folder.
    2.Delete existing Canvas, Window, Data Block having the name called ‘Block_name’ then create new Canvas, Window, Data Block.
    3.Assign the Standard oracle Applications Property classes to the new Objects.
    4.Customize the following triggers at form level.
    a. Pre_form -> Used for New Window
    b. When_new_form Instance -> Used for new form
    c APP_Custom Package -> Used for First Window
    5. Transfer the .fmb into Corresponding path according to module. Ex:- PO/11.5.0/Forms/US -> for PO module
    6.Compile the form we will get .FMB(ctrl+K) then execute the form we will get .FMX(Ctrl+T)
    7.Select application Developer Responsibility and create the form
    8.Create the Function attach the Form to Function.
    9.Create Menu attach the Function to menu.
    10.Create Responsibilty attach menu to Responsibilty and Responsibilty will be attach to user.

    Like

  8. What are the various report triggers? What is their order of firing?

    Ans : There are eight report triggers.
    Global triggers called the Report Triggers :
    (1) Before Parameter Form
    (2) After Parameter Form
    (3) Before Report
    (4) After Report
    (5) Between Pages

    Other Triggers :
    (1) Validation Triggers
    (2) Format Triggers
    (3) Action Triggers

    Report Triggers Firing Sequence:
    i) Before parameter form trigger
    ii)After Parameter form trigger
    iii)Before report trigger
    iv)Between pages trigger
    v)After report trigger

    Like

  9. What are the more common pseudo-columns?
    Ans:
    CURRVAL –> Returns the current value of a sequence.
    NEXTVAL –> Returns the next value of a sequence.
    NULL –> Return a null value.
    ROWID –> Returns the ROWID of a row.
    ROWNUM –> Returns the number indicating in which order Oracle selects rows.
    For First row rownum = 1 and for Second rownum 2 and so on.
    SYSDATE –> Returns current date and time.
    USER –> Returns the name of the current user.
    UID –> Returns the unique number assigned to the current user

    Like

  10. What are the basic steps when defining a concurrent program?

    The steps to register concurrent programs in apps are as follows :
    · Register the program as concurrent executable.
    · Define the concurrent program for the executable registered.
    · Add the concurrent program to the request group of the responsibility

    What are the more common pseudo-columns?

    SYSDATE, USER , UID, CURVAL, NEXTVAL, ROWID, ROWNUM

    Like

  11. Describe the main tables involved in Inventory

    MTL_CATEGORIES_B is the code combinations table for item categories.
    MTL_CATEGORY_SETS_B contains the entity definition for category sets.
    MTL_ITEM_CATEGORIES stores the item assignments to categories within a category set.
    MTL_ITEM_SUB_INVENTORIES maintains a listing of subinventories assigned to an inventory or engineering item.
    RCV_TRANSACTIONS – It stores historical information about receiving transactions that you have performed.
    RCV_SHIPMENT_HEADERS and RCV_SHIPMENT_LINES
    When a Ship Confirm is processed, one record is inserted in rcv_shipment_headers and one record is inserted in rcv_shipment_lines for each of the Sales Order Lines. The rcv_shipment_lines are linked to the one rcv_shipment_header record by shipment_header_id.

    Describe the main tables involved in Purchasing?

    po_requisition_headers_all
    po_requisition_lines_all
    po_req_distributions_all
    po_headers_all
    po_lines_all
    po_distributions_all
    rcv_transactions
    po_requisitions_interface_all
    po_reschedule_interface
    po_headers_interface
    po_lines_interface
    po_distributions_interface

    Like

  12. What’s the difference between DELETE TABLE and TRUNCATE TABLE commands?

    TRUNCATE is a DDL command whereas DELETE is a DML command.
    Hence DELETE operation can be rolled back, but TRUNCATE
    operation cannot be rolled back. WHERE clause can be used
    with DELETE and not with TRUNCATE.

    Describe the main tables involved in AR?

    RA_BATCHES_ALL
    – INFORMATION ABOUT TRANSACTION BATCHES
    RA_CUSTOMER_TRX_ALL
    – HEADER INFORMATION ABOUT TRANSACTION
    RA_CUSTOMER_TRX_LINES_ALL
    – LINES INFORMATION ABOUT TRANSACTION
    RA_CUST_TRX_LINE_GL_DIST_ALL
    – DISTRIBUTION INFORMATION ABOUT TRANSACTIONS
    RA_CUST_TRX_LINE_SALESREPS_ALL
    – SALES REPS OF TRANSACTIONS INFORMATION
    AR_PAYMENT_SCHDULES_ALL
    – INFORMATION ABOUT PAYMENT SCHDULES
    AR_APPLICATION_PAYABLES_ALL
    RA_INTERFACE_ERRORS
    – ERRORS IN AUTO INVOCIE INTERFACE DATA
    RA_INTERFACE_LINES_ALL
    – USE THIS TABLE TO ENTER HEADER AND LINES INFORMATION IN AUTO INVOICE INTERFACE PROGRAM
    RA_INTERFACE_DISTRIBUTIONS_ALL
    – DISTRIBUTION TABLE IN AUTO INVOICE INTERFACE PROGRAM
    RA_INTERFACE_SALESCREDITS_ALL
    – SALESCREDITS INFORMATION TABLE IN AUTO INVOICE INTERFACE PROGRAM

    Describe the main tables involved in AP?
    AP_INVOICES_ALL – AP_INVOICES_ALL contains records for invoices you enter
    AP_INVOICE_DISTRIBUTIONS_ALL – AP_INVOICE_DISTRIBUTIONS_ALL holds the distribution line
    information that you enter for invoices.
    AP_EXPENSE_REPORT_HEADERS_ALL
    AP_EXPENSE_REPORT_LINES_ALL -Expense Report information is stored
    AP_AE_HEADERS_ALL
    AP_AE_LINES_ALL
    AP_INVOICE_PAYMENTS_ALL
    AP_PAYMENT_DISTRIBUTIONS_ALL

    Describe the main tables involved in GL?
    GL_INTERFACE – (For Journal Import) is the table you use to import journal entry batches through Journal Import.
    GL_JE_CATEGORIES_TL stores journal entry categories.
    Gl_JE_BATCHES – Stores journal entry batches. Each row includes the batch name, description, status,running total debits and credits, and other information.
    GL_JE_HEADERS – hEADER LEVEL INFORMATION JE
    GL_JE_LINES – Stores the journal entry lines that you enter in the Enter Journals form.
    GL_CODE_COMBINATIONS –
    GL_BALANCES
    GL_DAILY_RATES
    GL_PERIODS :Stores information about the accounting periods you define using the Accounting Calendar form.
    GL_PERIOD_TYPES stores the period types you define using the Period Types form.
    GL_SETS_OF_BOOKS stores information about the sets of books you define in your Oracle General Ledger application.
    GL_DAILY_BALANCES
    GL_CONSOLIDATION

    Like

  13. What are the key benefits of forms personalization over custom.pll

    # Many users can develop form personalization at a given time.
    # By using form personalization it becomes fairly easy to enable and disable forms personalization.
    # Hide/disable fields or buttons functionality is removed.
    # Provides more visibility on customizations to the screen

    How can you import invoices into Oracle Receivables?

    This can be done in two ways defines below:
    We can either use AutoInvoice. Which can be possible by populating following table name RA_INTERFACE_LINES_ALL, RA_INTERFACE_DISTRIBUTIONS_ALL and RA_INTERFACE_SALESCREDITS_ALL.
    Alternately by using API ar_invoice_api_pub.create_single_invoice for Receivables Invoice Import.

    Which responsibility do you need to extract Self Service Personalizations?
    –Functional Administrator

    Like

Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s