Best Of
Re: Is JD Edwards able to automatically account for revenue that is associated with a cost rule?
From Oracle Support: thank you for your post User EJ7JI.
Let's address this issue under a Service Request (SR) please - the forum is better for simpler "How To" questions, but an SR allows us to look at customer-specific data, configuration, and to hold a web conference where needed. Please attach a document to your SR showing the relevant configuration and a worked example please.
With regards,
-Matt
Re: How to reduce over completion transaction quantity in Discrete Job
Hi User_7S8Z1 -
As VHK-Oracle stated earlier, it's best to raise an SR to have a Support Engineer to review the WIP job data and provide any datafix required. The SR should be created with product code 572 (Work in process). Thanks.
Re: You must supply an unique id for your Accounting Flexfield ((Null))
Hi Devesh Lohani,
I can't open the file, but one common cause of this is that the file has the segments of the flexfield (companyA, naturalaccountB, costcenterC) but the Transaction Source is set to expect the code combination ID instead of the segments.
If you are sending the code combination id , then try this sql to verify that it exists: select * from gl_code_combinations where code_combination_id = ### (where ### is the code combination id in your file). If it isn't found, then you need to identify the correct combination id to use and update the data in the interface. Retry the import.
If you want to send the segment values instead, then navigate to Setup > Transactions > Sources. In the form, query the source that you are using. Click on the Accounting Information tab. For Accounting Flexfield, change the selection from ID to Segment. Save. Retry the import. Conversely, if your file has the code combination id and this screen is set to Segment, change the screen to select ID.
One additional thing to consider is whether your system is set up to add tax lines? If it is, and you don't have AutoAccounting rules set for Tax, then it could get this error when trying to create the tax. check Setup > Transactions > AutoAccounting It would be useful to review all the rules here and ensure each has settings that work for your business.
Regards,
J
Re: Customer Master Conversion from source: Mentor ERP
Hello SaurabhSingha1236,
There are interface tables for the customer and for AR transactions. Use sql, or sql*loader or other tools to load the interface table. Then go into the application and run the import program. The import will validate the data and either create the customer/transaction or else provide you with exception messages so you know what to change.
Look into these tables, in a test instance first, of course: RA_customers_interface_all followed by going into the AR responsibility to Interfaces > Customer and run the import. Populate RA_interface_lines, RA_interface_distributions_all, RA_Interface_salescredits_all for the open transactions, followed by Interfaces > AutoInvoice or running Autoinvoice Master Program. If you have a very high volume of open transactions, you can increase the number of instances parameter so it will divvy up the transactions between multiple concurrent requests
Re: Finish goods put to default subinventory FG-SHIP, how to setup the put away rule?
Hi,
The put away rule can be set:
Object = Item , Parameter = Item Type, Operator = "=", Object = Constant character, Parameters = Finish Goods
Thank you,
Christine
Re: Finish goods put to default subinventory FG-SHIP, how to setup the put away rule?
HI,
Please review the following note and download the white paper available, which will give some examples on how both putaway and pick rules can be used for a particular Business requirement.
Oracle Warehouse Management Rules Engine Examples (Doc ID 232247.1)
Thanks,
Chris
Re: Mass update the 'Effective To' date for 'Skiplot Process' in Skiplot/Sampling Criteria Setup
Hi,
The skiplot processes cannot be deleted even if their associations have been previously deactivated (end-dated).
A datafix cannot be applied either in this situation because the skiplot code is still there in the associations, even if it is disabled. So, by deleting it, we will cause orphan record to exist in the associations table but in the history tables too if it has been actually used for past received/inspected lots.
However, once the associations have been deactivated, the skiplot process is no longer in use and deleting it is not actually required.
Regards,
Florin
Re: Absence Analytics tile in MSS only displays up to 100 rows
Dan:
Per the developers:
1. Identify the Pivot Grid Model
· Navigate to: Enterprise Components > Pivot Grid > Pivot Grid Models
· Search for the Pivot Grid Model used in Absence Analytics (e.g., ABSENCE_ANALYTICS or similar, depending on your configuration).
· Open the Pivot Grid Model.
2. Update Pivot Grid Data Source Settings
· Under the Pivot Grid Wizard, go to Step 5: Pivot Grid Display.
· Look for the "Maximum Rows to Return" field.
· By default, it is set to 100. You can increase this to your desired number, e.g., 500 or 1000.
· Save your changes.
3. Check Pivot Grid Viewer Settings
· When running the analytics via the Pivot Grid Viewer, there’s an option at runtime to set how many rows to display (e.g., dropdown at the bottom of the grid).
· Ensure users are aware they can adjust this in the viewer as well (up to the model's maximum)
4. Performance Considerations
Increasing the row limit can impact performance.
- It's good practice to test the rendering time and server load if raising limits significantly (especially beyond 500 rows).
- Consider adding filters to narrow down data before fetching large volumes.
Re: why redo and undo logs are required during flashback of database? aren't flashback logs enough?
it will not rollback SCN, it will rollback uncommitted transactions. so whichever transactions are started before scn 1000 and not committed, they will be rolled back. rest of the db will remain. in the end you will be at the scn 1000.
Re: Queries regarding Orchestration features in 9.2.9
Hi
You can see from the example used in Doc ID 2742423.1 there is an input variable addresnumber_in
This address number is received into the groovy service request through input AN8 which comes from orchestration input. So this is the manner in which orchestration input can be passed to the procedure called within groovy
The other document 2795726.1 about triggering orchestraiton from form has one of the options 'Define Inputs' which you can use to pass inputs to the called orchestration.
This is the manner in which you can pass the values.
Regards,
Prabhu