Mobulous Technologies Interview Questions and Answers

Procedures are faster as they are precompiled and stored in memory, while functions need to be compiled each time they are called.

• Procedures are precompiled and stored in memory, making them faster to execute.

• Functions need to be compiled each time they are called, which can slow down execution.

• Procedures are commonly used for performing tasks, while functions are used to return a value.

• Example: If you have a procedure to calculate employee salaries, it would be faster than a...read more

Lexical parameter is a placeholder in a SQL query that is replaced by a specific value at runtime. Bind parameter is a placeholder in a SQL query that is bound to a specific value before execution.

• Lexical parameter is denoted by a colon followed by a name, like :parameter_name.

• Bind parameter is denoted by a question mark, like ?.

• Lexical parameters are replaced with values at runtime, while bind parameters are bound to values before execution.

• Example: SELECT * FROM employees W...read more

O2C process stands for Order to Cash process, which involves all the steps from receiving an order to receiving payment.

• Includes order entry, order fulfillment, invoicing, and payment collection

• Involves multiple departments such as sales, operations, finance, and customer service

• Key steps include order creation, order processing, shipping, invoicing, and payment processing

• Ensures timely delivery of goods or services to customers and timely payment collection

Important points for package include customization, integration, user training, and support.

• Customization to meet specific business requirements

• Integration with other systems for seamless data flow

• User training to ensure effective utilization of the package

• Ongoing support for troubleshooting and updates

Tables from AR module in Oracle Financials

• RA_CUSTOMER_TRX_ALL

• RA_CUSTOMER_TRX_LINES_ALL

• AR_PAYMENT_SCHEDULES_ALL

• AR_RECEIVABLE_APPLICATIONS_ALL

• AR_PAYMENT_SCHEDULES_ALL