How to get the XML output for the check payment (Format Payment Instruction) program in R12? I have asked this many times to myself.
Usually we look at the log file and use the XML tags from the log file. When the volume of payments made are high, the XML tags are truncated in the log file. So you wont be able to get the entire XML tags. So how do we get it??
IBY_TRXN_DOCUMENTS Table stores the XML generated during the Format Payment Instruction program. The following SQL Statement can be used to get the XML output.
WHERE payment_instruction_id = :l_payment_inst_id;
You can open the output in TOAD / SQL Developer.
For Web ADI documents to open you can follow the below steps:
1. Open Excel and go to File > Options
You will see a new window as shown below. Select “Trust Center” on the left navigation pane and then click on “Trust Center Settings”:
Select “MAcro Settings” on the left navigation pane. Under Macro Settings, select “Enable all macros” . Under “Developer Macro Settings”, select “Trust access to the VBA project object model”. See the image below for more details.
Next step is to navigate to the “Protected View” option on the left navigation pane. once you are there, uncheck all the protected view options as show below:
Click “Ok” and close Excel.
Open IE and navigage to IE > Internet Options and select “Security Tab”. Select zone as ”Internet” and click on “Custom Level”:
Scroll down and then “Enable” the “Allow status bar updates via script” option.
Close and Re-Open IE. Go ahead and try to open Web ADI Documents and it should be working fine.
Comments are welcome!! if there are other ways to accomplish this, please share your thoughts on that as well.
If you are using IE 10, then you might have issues when you login to EBS.
The list of responsibilities will be shown as “undefined”. This is because of the incompatibilities with IE 10 version.
You can get this resolved by clicking the “Compatibility View” option on IE. Please see the image below:
Once you click on that, you might have to login again to view the changes.
After upgrading to 12.1.3, I have been getting the below error while submitting the Auto Invoice Master Program from AR Responsibility.
APP-FND-1564: ORACLE error 24347 in FDFGVD
Cause: FDFGVD failed due to ORA-24347: Warning of a NULL column in an aggregate function.
SELECT BATCH_SOURCE_ID,NAME VALUE, DESCRIPTION DESCRIPTION, NVL(‘N’, ‘N’),
NVL(TO_NUMBER(NULL), -1), NULL, NVL(‘Y’, ‘Y’), NVL(TO_CHAR(TO_DATE(NULL),
‘J’), 0), NVL(TO_CHAR(TO_DATE(NULL), ‘J’), 0) FROM AR_AI_BATCH_SOURCE_V WHERE
( GET_ALL = DECODE(:b1, -99, ‘Y’,'N’) AND ORG_ID = DECODE(:b2, -99,
ORG_ID, :b3) ) AND BATCH_SOURCE_ID = :X and was executed from the file
Please see the below screenshots for reference:
Login to Receivables Manager Responsibility:
Click on AutoInvoice function under Interfaces Sub Menu.
Click “Ok”. The SRS window will be opening. Enter all the mandatory parameters. The organization parameter value defaults to “All”.
Once you have entered the mandatory parameters, click on “Submit”. You will receive the below error:
Work Around:- Select a different value for Organization parameter. You can select the operating unit value (US Operating Unit) and then submit the program.
See the screenshot below:
The following note from Oracle Support will be helpful.
AutoInvoice Error: Batch Source List of Values Raises Error: APP-FND-1564: ORACLE error 24347 in FDFGVD (Doc ID 1406558.1)
Recently I got a requirement to change the order in which the time cards are displayed in the Time Card list for the employees. The requirement was to show the latest time card on the top. We can achieve this using Self Service Personalization.
Before we start make sure that the following profile options are set. You can set this at Responsibility Level for development purpose.
Personalize Self-Service Defn
Set the value to Yes to allow ‘Personalize’ link to appear at the top of the page.
FND : Personalization Region Link Enabled
Set the value to Yes to display all the personalization links above each OAF page region.
Disable Self-Service Personal
Setting the value to Yes will disable all OAF personalization on all pages at all levels (Function, Site, Responsibility, User).
These profile options allow us to Personalize the web page.
Follow the below screen shots to see how we can achieve this change using Personalization.
Navigation:- OTL Responsibility > Time Entry
Click on “Personalize Recent Timecard List” link as shown in the below image:
Once you click the link, you will get the below page. Click on the region indicated. Here you select the region / item that we are going to personalize. In our scenario, we have to personalize the time card list.
Once you click the Personalize link for the item, it will show you various options that can be personalized. You should get the below page now.
Click on the Edit link against the Query option at Responsibility Level. See the above image to see where exactly you need to click. In the next page, you will be able to see the options for “Sorting”.
You have an option of sorting the time card list. For our requirement I have selected two options. You can select all the three options or only one of them based on your requirements.
Once you select the sort options, click “Apply”. Bingo. We are done.
Note:- There is NO NEED to bounce the server for this change.
Hope this helped some of you out there.
If you are starting with Oracle APEX development and would like to know the installation procedures, please refer to the following links.
The first link explains how to install the Oracle XE Database on Windows 8 OS and the second one talks about Oracle APEX. I found these two links helpful.
I will be posting more on APEX development in the future posts.
I was trying to update a previously submitted time card using the OTL API (hxc_timestore_deposit.execute_deposit_process). I was getting a very strange error as described below:
ORA-20020: Pa_Otc_Api ::: ->Validate_Otc_Data->Validate_Process->DetermineProcessingFlags :: Only Ovn has changed. Update the orig_transaction_reference of the ei. : ORA-01403: no data found
I searched a lot and did not find any help in Google or Metalink. Finally I decided to debug the API myself. After spending quite a few hours on the daunting task, I found out the issue.
The API hxc_timestore_deposit.execute_deposit_process, inturn calls another API and a function – Pa_Otc_Api.determineprocessflags(). In this function there is a select statement that retrieves the data from pa_expenditure_items table.
select project_id , task_id, expenditure_type
into l_Proj_Id , l_task_id , l_Exp_Type
where RowId = l_RowId;
The above select statement was not retrieving any records and that is the reason why the API was failing. And now the interesting facts:
1. The time card data was not transferred to Oracle Projects and there were no records in pa_expenditure_items table.
2. Since you are calling the API, please make sure that you set org context as API is using MO Tables
Hope this helps someone who is working on the API. I have used the below APIs in the order given below to update the time card hours: