Search found 86 matches
- Wed Jul 08, 2009 2:22 am
- Forum: Purchasing & Inventory
- Topic: Receipts Interface
- Replies: 0
- Views: 722
Receipts Interface
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...
- Tue Jun 23, 2009 3:40 am
- Forum: Purchasing & Inventory
- Topic: Records stuck in rcv_transactions_interface
- Replies: 0
- Views: 1692
Records stuck in rcv_transactions_interface
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.
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.
- Mon Jun 15, 2009 9:13 am
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: Track Invoice (AP/AR) transferred to GL
- Replies: 2
- Views: 3247
Track Invoice (AP/AR) transferred to GL
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...
- Tue Jun 02, 2009 5:18 am
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: Interface Question
- Replies: 3
- Views: 1387
- Thu May 28, 2009 2:23 am
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: Interface Question
- Replies: 3
- Views: 1387
Interface Question
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...
- Thu Mar 19, 2009 9:15 am
- Forum: Purchasing & Inventory
- Topic: Interface COde
- Replies: 0
- Views: 774
Interface COde
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
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
- Thu Mar 12, 2009 8:33 am
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: AP Check Voucher/Remittance Report
- Replies: 1
- Views: 2178
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 ...
- Thu Mar 12, 2009 8:23 am
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: AP Check Voucher/Remittance Report
- Replies: 1
- Views: 2178
AP Check Voucher/Remittance Report
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...
- Wed Mar 04, 2009 10:56 am
- Forum: Oracle Forms & Reports
- Topic: AR Report To be Developed
- Replies: 1
- Views: 1543
AR Report To be Developed
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...
- Tue Feb 24, 2009 8:44 am
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: Unallocated Credit Memos
- Replies: 1
- Views: 972
Unallocated Credit Memos
Hello Group,
I would like to get a query to know all the unallocated or partially allocated credit memos in AR.
Regards,
Abbas
I would like to get a query to know all the unallocated or partially allocated credit memos in AR.
Regards,
Abbas
- Sat Feb 21, 2009 8:50 am
- Forum: Purchasing & Inventory
- Topic: Copy On Hand quantity details
- Replies: 2
- Views: 1376
- Wed Feb 18, 2009 11:49 am
- Forum: Purchasing & Inventory
- Topic: Copy On Hand quantity details
- Replies: 2
- Views: 1376
Copy On Hand quantity details
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
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
- Tue Feb 10, 2009 3:10 am
- Forum: Reports (Only Oracle Apps Reports)
- Topic: How to Call report from forms
- Replies: 2
- Views: 2456
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...
- Sun Feb 08, 2009 12:32 pm
- Forum: Reports (Only Oracle Apps Reports)
- Topic: How to Call report from forms
- Replies: 2
- Views: 2456
How to Call report from forms
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 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.
- Sat Jan 31, 2009 4:23 am
- Forum: Reports (Only Oracle Apps Reports)
- Topic: how to use value returned by function
- Replies: 0
- Views: 1198
how to use value returned by function
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
Now I would like to know how can I use a value returned by a function.
Regards,
Abbas