ERPstuff - Oracle EBS Community

Hi All,
I have a table with an image column having data type long raw, i want to insert an image using INSERT statement,
INSERT INTO IMAGE_TABLE(ORG, IMG)
VALUES(82, ?? );
is it possible!

Try this,
Before submitting the report, go to option and change the template format from pdf to excel.

Regards
Ali Pirzada

Hi All, I am unable to calculate the total in a Cross-Tab report in bi publisher. I have to get the sum of the rows at the end of the report. It is matrix report built on report builder, i have split the column header and column data in the rtf template but am not able to get the total at the end fo...

Dear Admin, i did tried to create the link from the GL responsibilty, but it continously gave error ' Unable to create Database Link'. How can i find/define the connect string for the instance ? One thing more the DB_DOMAIN is not deifned(NULL) in our instance, what should i give in the field "...

Dear Bilal, Thanks for such a quick response, but i have defined the database link but just not able to use it in the application. Can u please give me info on how to define it in the application. I navigated to Create Database Link Form in the GL responsibilty. Following are the information of my s...

Hi All, I want to transfer FSG's from Test Instance to Production instance. I tried the 'Program - FSG Transfer' but was not able to create the link between the two databases in the application, however a link was successfully created in the database. Urgent reply is required. Thanks in advance. Reg...

Hi All,
I need to find the opening balance of an item according to the date parameter entered by the user.
Can any one provide me with the query or the table name from where i can get that.

Regards,
Ali Pirzada

Dear Admin,
Still waiting for that article you were gonna write on technical consultants roles.

Regards,
Ali Pirzada

Hi Ram,
what hav u defined in the Execution File Name? It should be like PackageName.[Procedure][Function]

Regards,
Ali Pirzada

Hi, I have a written a pocedure that generates a csv file by extracting data from the tables and is executed from a concurrent program in the application. The procedure generates the output file on the server, is there any other way that the file could be generated on the client side or at any other...

Hey,
Try this
WHERE NVL(ATTRIBUTE1,0) = nvl(nvl(:P_ATT1,ATTRIBUTE1),0)
Hope this solves your problem

Regards
Ali Pirzada

Dear Aimam,
You need to add the same value set 'TESTING' in report parameters where you define the report.
For quering all results if the parameter is left blank add this in your report's where clause
WHERE ATTRIBUTE1 = NVL(:P_ATT1, ATTRIBUTE1)

Hi All,
I want to know the core role and responsibilities of an Oracle EBS technical consultant, what are the his main tasks other than Reporting,Data Conversion and Migration, and what are the DOs and DONTs for this job.

Ali Pirzada

Hi All,
Is there a solution to automatically set the $PROFILES$.MFG_ORGANIZATION_ID Value when a user logs in, such that the user does'nt have to select the change organization option for setting up this value.
Regards
Ali Ahmed Pirzada

Hello All, I am new to oracle apps. I am creating a report having details of customer transaction. I want to pick the particular lot number of the item in transaction. I am not able to find the realtionship between the RA and MTL tables. I am picking the transaction details from RA_CUSTOMER_TRX_ALL ...