ERPstuff - Oracle EBS Community

Hi Team, I would like to know the flow of receipts when it is interface to oracel apps. rcv_transactions_interface rcv_headers_interface rcv_shipment_headers rcv_shipment_lines rcv_transactions Basically I would like to get the queries to check the records that get entered into interface and move on...

Hi Team,

There are few transactions stuck in rcv_transactions_interface.I have to clear that.
Before I clear that I want to check if they are already there in final tables.
If not I will have to process it, how do i do that.

Regards,
Abbas.

Hi All How can I trace invoice(AP/AR) that is transferred to Gl AP - GL AP_INVOICES_ALL AP_INVOICE_DSITRIBUTIONS_ALL AP_ACCOUNTING_EVENTS_ALL AP_AE_HEADERS_ALL AP_AE_LINES_ALL GL_IMPORT_REFERENCES GL_JE_LINES AR - GL ra_customer_trx_all ra_customers AR_PAYMENT_SCHEDULES_all ra_customer_trx_lines_all...

Thank you for clarifying the doubt, its helpful.

I would like to confirm, if the data is wrong then do we delete the data from temp interface table and the ask the feeders to re interface the data from scratch.

Regards,
Abbas.

Hi Group, I have a question on interface. For example a feeder has inputted the data into the temp/interim table, then we move the dat from interim/temp to apps interface table. Now I would like to know if data is stuck in the apps interface table due the validations defined. How can we proceed furt...

Hi Team
I need to write the code to transfer the transactions into the base tbale mtl_material_transactions from mtl_transactions_interface and that is loade form custom table.

If anyone has the package already written, please pass it to me.

Appreciate you help

Thanx
Abbas

My requirement is to develop a report(.RDF) where checks are printed at bottom page of the A4 size paper and Remittance or Voucher printing will start printing from top of the page and it will stop just before the check printing space.Check is printed and the voucher/remittance is carried over from ...

Hello Team, In AP Format Payments will print the checks and remittance will print the remittance advice. A printer has 4 trays one of the tray has check stationary and other three plain A4 size papers Here change is the A4 page is being used as the check stationary provided by bank. My requirement i...

Hello All, I have requirement to develop a report in AR. Requirement is one credit memo is created and 3 invoices are applied. example: Credit memo amount 1000 applied amount invoiceno amount remaining dateapplied 200 123 800 01-feb-2009 300 124 500 10-feb-2009 200 120 300 20-feb-2009 Parameters fro...

Hello Group,

I would like to get a query to know all the unallocated or partially allocated credit memos in AR.

Regards,
Abbas

Hello All, We can load the onhand quantities using mtl_transactions_interface. Now I have successfully uploaded data into mtl_transactions_interface table but when I run the "process transaction intreface" the data is not being populated to the base tables. Process transaction intrface tab...

Hi,

I have an existing organization and now I have created a new organization and I need to transfer the on hand quantity info to the new organization.
For this i have to write a procedure.
Has anyone done this before.
Pls share your experience.

Regards,
Abbas

HEllo All, My requirement is to get the reports data into form i.e. there is an ap check report and i would like to create a new form and call those check report fields into that form. I am writing the following code declare v_plist_id paramlist; pl_name varchar2(50) := 'rep_params'; begin v_plist_i...

Hello all,

I would like to get the code to call a report from forms.

How can i do that.

Also what are the setting that i have to do it on forms fields.

Abbas.

I have added the signature in report, and now I want to make it appear based on the condition.

Now I would like to know how can I use a value returned by a function.

Regards,
Abbas