SQL* Plus is one of the executable methods available while defining a concurrent program in Oracle Apps. It allows running SQL* Plus script against the Oracle ERP database under Oracle Apps Environment following all security and access control. This method helps to create some ad-hoc script as a concurrent program. Ideally, convert this standalone script […]
SQL* Plus Concurrent Program in Oracle Apps Read More »
Business users sometimes need functionality to email the output of the concurrent program as soon as it completes. Let’s see how to email concurrent request output in Oracle Apps You can achieve this using another custom concurrent program based on Unix, PL/SQL so send an email of a concurrent program. Unix provides mailx and in
Email Concurrent Request Output in Oracle Apps Read More »
fnd_request.submit_request Oracle Apps PL/SQL API helps to submit the concurrent program from the backend. backend means from the Database. fnd_request.submit_request Below is the signature of fnd_request.submit_request API. This function submits a concurrent request for processing by concurrent Manager and returns, request id – if the request is submitted successfully 0 – if the request is not
How to Submit Concurrent Program from back-end using fnd_request in Oracle Apps Read More »
How to make Parent concurrent request to wait until all child concurrent programs complete in Oracle Apps? So what we are looking at here is a Parent program that submits multiple child requests at once and waits till all child programs complete either successfully. Oracle apps provide a built-in package FND_CONC_GLOBAL and FND_REQUEST to achieve
Parent Child concurrent request in Oracle Apps Read More »
Concurrent programs in Oracle Apps are batch jobs. You can define a concurrent program on PL/SQL stored procedure, Oracle Reports, Host – an Operating system based execution file, Perl, C or Pro* C based spawned program, Java file. Here, I will show you how to define concurrent programs in Oracle Applications (Apps). We will use
PL/SQL Stored Procedure Concurrent Program in Oracle Apps Read More »
ICX:Session Timeout is a profile provided in Oracle apps which controls the time for which a session is valid. Post that time out limit, the user gets below error. Log on session is no longer valid. Would you like to log back in so you can continue working? If you do not log in, any
Use ICX:Session Timeout to change the session Timeout in Oracle Apps Read More »
The accounting flex field uniquely identifies a chart of accounts. The organization may choose 3 segments, 5 segment or 7 segments flex field as per the business requirement e.g Org 1 – Company, Department, and Account – 010.202.300 Org 2 – Company, Account, Product, Product Line, and Subaccount – 020.456.8898.8890.8980 GL_CODE_COMBINATIONS table stores all this
How to get Concatenated Segments in Oracle Fusion and Apps Read More »
Who columns in a table allows users to track changes made to the data in Oracle Apps. It also helps to differentiate between changes made by forms and changes made by concurrent programs. Below is the list of standard who columns, CREATED_BY The created_by is a number(15) not null column in a table that keeps
Who Columns in Oracle Apps Read More »
FND-CP-ESP: Child: exec:: Permission denied error comes when you submit host-based concurrent program in Oracle apps and apps is not able to execute the shell script for the program. This is the way you design the host program in Oracle Apps. Create the shell script (test.prog), Make sure .prog is the extension of the script.
FND-CP-ESP: Child: exec:: Permission denied Read More »
Planning Data Pull request completes in error “User not defined or not assigned to the responsibility – ‘APS COLLECTIONS’”, when the user who submitted the request does not exists in source instance or does not have APS collection responsibility is assigned Check if the user exists in Oracle EBS Source side and has APS collection