AP Invoices Tables Information
The below diagram illustrates the AP Invoices table information. We can see the flow of how AP Invoices load into Oracle and all the way to GL batch post.
Java Concurrent Program with Parameters in Oracle Apps R12
We have seen how to create Java concurrent program in Oracle Apps R12. In this article, we will see how to Java concurrent program with Parameters and how to some of the global apps columns/fields like RequestId, UserId and etc. While submitting Java concurrent program we will pass some parameters and those parameters we will retrieve in the Java program. Create Java Concurrent Program with Parameters Let’s create a concurrent program with 3 different parameters. Note: we use the same…
Java Concurrent Program in Oracle Apps R12
We will explore Java Concurrent Program in Oracle Apps R12. We can do a lot of things with Java and lots of coding and sample scenarios are available on Google. If we want to use those kinds of java programming, we can use OAF or we can use the Java Concurrent Program in Oracle Apps. Let’s assume if you want to read the excel file(with multiple sheets) and store the data into Oracle custom tables. In Java, we can achieve…
Custom Check Printing in Oracle Apps R12
We will discuss about Custom check printing in Oracle Apps. Sometimes AP team in the organization has to send the checks to the Suppliers/Employees(Internal Employee Expenses), so we need a one check format according to the Bank guidelines. Oracle provides couple of predefined check formats in the system but most of the times we have to add our custom formats. Here we will cover below Topics 1. Download Standard Check Format 2. Add your company logo and address 3. Add…
SUM Function in BI Publisher
Let’s talk about SUM function in BI Publisher. Sometime we might end up doing SUM of columns on the fly. So we can capitalize the SUM function which is available in BI/XML Publisher. We can write all the SUM functions within our Data set(SQL/Procedure,etc..) but sometimes we might get a request from users to add some other totals(SUM columns). Instances like above we can add/change the SUM totals in BI?XML publisher without touching the code. Simple SUM: We would like…
Delete Expense Report From Interface Tables
In this article, we will talk about how to delete the Oracle expenses. The workflow(Expenses – APEXP) will delete the Rejected Expenses from the system after certain days. Manually delete the expenses from Oracle using API. Auto Delete/System Delete: If the user submits expense and approver rejected that expense. User/submitter will get notified to once the expense got rejected and expense will sit in users queue for 31 days. If the user doesn’t respond to an expense within 31 days,…
Timecard Layout Modification – Adding Text Field
In this article, we will see how to add a Project Name column and comments in a column in the Project Timecard Layout. If we observe the Oracle standard layout for Projects we don’t see any project name column in the Layout. So as part of this exercise, we will try to add the Project Name column. As soon as we select the project number in the timecard page it should automatically pull the Project Name information based on the…
OTL Table Information
Submitting XML Concurrent Program from Backend(PLSQL)
Here we talk about how to submit the XML based concurrent program from backend using PLSQL. In order to submit the XML concurrent program in R12 and above, we have to follow the below steps. 1. Assign an operating unit value(optional) 2. Initialize the session variables 3. Add the XML template using Oracle standard API 4. Submit the concurrent program using Oracle standard API Assign an operating unit value: Sometimes in Oracle Apps R12 onwards, if we enable to multi-org…
Timecard Layout Modification – Remove Columns
Let’s talk about how to remove the columns from the timecard projects layout. In the previous posts, we have seen how to add a custom new columns in the timecard project layout. Now we remove those columns from the timecard layout. We can even take out the columns which are available in Oracle seeded template Projects Timecard Template but sometimes we may run into some problems. Here we take out the two custom columns that we create in earlier stages/posts….