ERPstuff - Oracle EBS Community

Dear Venkatesh,

Please test it for yourself in the instance to get better clarity.

Regards,
Karthikeyan

Dear yimjosephine, The use of Hold Unmatched invoices option is not to place "Matching Holds" when an invoice is not matched with PO or receipt. Matching holds are not system holds, which means you can manually release the hold and proceed with the transaction. Where as system holds are di...

Dear Venkatesh, As a moderator, i would request you to follow the below guidelines before posting a topic: 1) Mention the Version 2) Explain steps what you did? 3) Read User Guide first 4) Post clearly your question, so that it will interest others to reply to your topic, else it will remain unatten...

Dear Venkatesh,

there is no such functionality available in Receivables or any other module apart from Payables.
Every Module design is different which may not be observed from the front end.

Regards,
Karthikeyan

Dear Venkatesh,

Autoinvoice setup is not mandatory if no invoices are imported.

Regards,
Karthikeyan

Dear Venkatesh,

Please refer to the Oracle Payables implementation Guide, the explanation provide there would definitely clear your doubts. Search for "Matching Payables Options" in the guide.

Regards,
Karthikeyan

Dear yimjosephine, This is a a System hold, which will be placed when the basic information required for validating an invoice is not entered. In your case, the invoice header amount will be 100$, the line level and Distribution level the amount entered will be 40$, therefore there is a difference o...

Dear Venkatesh, 11i does not allow you to change it. You can only run reports or fetch from back end directly. Please run "Account Analysis Report with subledger detail", this report will show the details of subledgers also. One can customize this report, as per thier needs Regards, Karthi...

Dear Venkatesh, the link between Legal Entity and Operating unit is very much available in Release 12. While setting up accounting options for your ledger, you should select/create the operating units which will be using your ledger. In this step, you have to specify your operating unit name, legal ...

Dear Yknev, PO_HEADER_ID is available in the AP_INVOICES_ALL, AP_INVOICE_LINES_ALL table. Based on the header_id, you can derive the PO number, there are many views available as well in AP tables. I am not technically proficient to fetch the information required, so i am directing you on the correct...

Dear Awais, Please check the below notes, which has an SQL query inside directing how to insert data in to customer interface tables. I guess the interface table names remains the same for Release 12 also ... How to insert a customer via Customer Interface [ID 176863.1] TCA Customer Interface & ...

Thanks for sharing the solution with us Ben. Topic is locked to avoid further discussions.

Regards,
Karthikeyan

Dear Awais, You have a standard Customer Interface provided by Oracle Receivables for uploading Customers. You have to check the relevant API in order to find out the values that are to be passed. Check the User Guide and Technical Reference Manual from Metalink to gather all required information. R...

Dear Yknev, Please Check AP_INVOICES_ALL table or AP_INVOICE_LINES_ALL or AP_INVOICE_DISTRIBUTIONS_ALL, one among these three tables, you can find the PO number details if the invoice is matched with the Purchase Order. Also from Purchasing Module, at the shipment screen / Distribution Screen, keep ...

Dear Benny, In Release 12, the payment is centralized from the Payment Manager, so i guess no workarounds are required, as it becomes a standard functionality of the product. In Release 11, the workaround must be thought off, since payment to invoices belonging to other operating units are not possi...